SQL Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and prd_st = 1' at line 1
SELECT *, lv1.cate_id as cid, lv2.cate_id as c2id from product p left join product_brand b on p.prd_brand = b.cate_id left join product_cate lv2 on p.prd_cate = lv2.cate_id left join product_cate lv1 on lv2.cate_pid = lv1.cate_id where lv1.cate_id = and prd_st = 1