SELECT A.* FROM NEW_PROD_LIST A JOIN NEW_PROD_CATE B ON A.CATE = B.IDX JOIN NEW_MENU_CATE C ON B.MENU_IDX = C.IDX WHERE 1=1 AND A.DEL_CHK = 'n' AND A.STATUS = '1' AND (A.NAME LIKE '%자가관리%' OR A.SUB_NAME LIKE '%자가관리%' OR A.SEARCH_KEYWORD LIKE '%자가관리%' OR A.MEDEL_NO LIKE '%자가관리%')
