MySQL Error!
MySQL error in file: /engine/modules/catalog/goods.php at line 1071
Error Number: 1064
The Error returned was:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\'1\' )
AND ( `brand_id` IN (103) )
AND ( g.id IN (318) )...' at line 12
SQL query:
SELECT b.name AS `brand_name`, g.id, g.articulus, g.name, g.date, g.brand_id, g.image, g.sef_name, g.type
FROM `catalog_goods` g
LEFT JOIN catalog_brands b ON (b.id = g.brand_id)
LEFT JOIN `catalog_goods_vendors` gv ON (g.id = gv.good_id)
WHERE g.subsection_id = 7
AND g.status = '1'
AND g.type < '2'
AND (g.city_id IN (0,1,2))
AND g.id = -1
AND ( g.id in (-1) )
AND ( g.urgent = \'1\' )
AND ( `brand_id` IN (103) )
AND ( g.id IN (318) )
GROUP BY 1,2,3,4,5
ORDER BY `views` DESC, `urgent` ASC, `id` ASC
LIMIT 0, 15