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 c.active=1' at line 2<br>SELECT c.id, c.cid, c.name, c.rassrochka, c.alias, c.reserv, c.price, c.order_delay, c.active, c.order, c.beznal, c.credit, c.currency, (SELECT name FROM catalog_images as ci WHERE ci.goods_id=c.id ORDER BY ci.id LIMIT 1) as image
        FROM catalog as c WHERE id IN () AND c.active=1