SELECT COUNT(*) AS cnt FROM ck_product2 as p,ck_product_photos2 as pic WHERE p.proid=pic.ref_proid AND pic.photos_mark=1 AND p.ref_catepro_id= AND p.prod_status = 1
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 p.prod_status = 1' at line 1