SELECT `pk`.*, `p`.*, `p`.`product_name` AS `product_name_en` FROM `b2b_product_key` AS `pk`
 LEFT JOIN `b2b_product` AS `p` ON p.product_id=pk.product_product_id WHERE (p.product_trush=0) AND (NOT EXISTS (
            SELECT 1 FROM b2b_product_category pc
            WHERE pc.product_id = p.product_id AND pc.category_id = 36
        )) AND ( LOWER(pk.product_key_keyword) like '%chloramphenicol%' and LOWER(pk.product_key_keyword) like '%usp%' and LOWER(pk.product_key_keyword) like '%bp%' and LOWER(pk.product_key_keyword) like '%pharmaceutical%' and LOWER(pk.product_key_keyword) like '%grade%'  or pk.product_key_keyword ='chloramphenicol usp bp pharmaceutical grade') ORDER BY `p`.`product_sort` asc, `p`.`product_id` desc LIMIT 30