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 '%high%' and LOWER(pk.product_key_keyword) like '%quality%' and LOWER(pk.product_key_keyword) like '%chloro%' and LOWER(pk.product_key_keyword) like '%dimethylphenol%'  or pk.product_key_keyword ='high quality 4 chloro 3 5 dimethylphenol') ORDER BY `p`.`product_sort` asc, `p`.`product_id` desc LIMIT 30