Sorry, page is temporary unavailable.

Please try again later.

<<< Back to previous page

May 27, 2020 14:14:51 /catalog/plintus-napolnyj/plintus-dyuropolim/ Error: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 ') GROUP BY b.TITLE HAVING COUNT(*)>=1' at line 5
SELECT b.TITLE, b.ID FROM brands b LEFT JOIN products pr ON (pr.BRAND_ID = b.ID) LEFT JOIN categories c ON (pr.CATEGORY_ID = c.ID) WHERE pr.ACTIVE = 1 AND c.ID IN () GROUP BY b.TITLE HAVING COUNT(*)>=1