select *, (SELECT item_file_url FROM TBL_FILE WHERE item_file_seq = A.seq and item_file_num = '1' and delete_yn='N' limit 1) as item_file_url, (SELECT item_file_type FROM TBL_FILE WHERE item_file_seq = A.seq and item_file_num = '1' and delete_yn='N' limit 1) as item_file_type from TBL_ITEM A where cate_seq in ( select depth1_cate_seq from TBL_ACTIVE_MENU where depth1_cate_seq = '22' union all select depth2_cate_seq from TBL_ACTIVE_MENU a where depth1_cate_seq = '22' union all select seq from TBL_CATEGORY where cate_parent_code in (select cate_code from TBL_CATEGORY where seq in (select depth2_cate_seq from TBL_ACTIVE_MENU a where depth1_cate_seq = '22'))) and use_yn = 'Y' order by A.item_regdate desc limit 15,15