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 '%���������%')