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 ')' at line 5
select MAX(p.products_price) as price_max,MIN(p.products_price) as price_min
from products p
left join products_to_categories p2c on p.products_id=p2c.products_id
where p.products_status>0
and p2c.categories_id IN ()
