SELECT * FROM dex_product where pactivate = '1' and phide ='0' and (porder_end='0000-00-00' or porder_end > now() ) and (pnameth like '%%∏ucer=%%' or pnameen like '%%∏ucer=%%' or ptag like '%%∏ucer=%%' or pid like '%%∏ucer=%%' or pbarcode like '%%∏ucer=%%') and pmenu='4' and pcategory='⊂category=⊂category=' and pmenu='4' and pcharacter='∏ucer=' order by pid DESC