An Error Was Encountered
Error Number: 1064
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.id!=372 order by rand() limit 3' at line 14
select c.id as sub_id, c.chinese_type, c.type as sub_cat, fs.species_name, fsu.surface as surface_name, fc.color, p.*, if(datediff(now(), p.add_time) <10, 'Y', 'N') as is_new from products p join category c on p.category_id=c.id left join floor_species fs on p.species_id=fs.species_id left join floor_color fc on p.color_id=fc.color_id left join floor_surface fsu on p.surface_id=fsu.surface_id where p.enabled=1 and p.sold_out='N' and p.id in (select distinct product_id from image) and c.id= and p.id!=372 order by rand() limit 3