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 '%china%' and LOWER(pk.product_key_keyword) like '%hydroxypropyl%' and LOWER(pk.product_key_keyword) like '%beta%' and LOWER(pk.product_key_keyword) like '%cyclodextrin%' and LOWER(pk.product_key_keyword) like '%hpbcd%' and LOWER(pk.product_key_keyword) like '%suppliers%'  or pk.product_key_keyword ='china 2 hydroxypropyl beta cyclodextrin hpbcd suppliers') ORDER BY `p`.`product_sort` asc, `p`.`product_id` desc LIMIT 30