Error!Catched error 40642000: SQLSTATE[42000]: Syntax error or access violation: 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 ua_product.id
ORDER BY `stock` DESC, `code` ASC, `pric' at line 34
in /home/vpkpodsh/public_html/library/pdo.php on line 45.
Query: 'select ua_product.id,
ua_product.img,
ua_product.youtube,
ua_product.url,
ua_product.name,
ua_product.price,
ua_product.text,
ua_product.size,
ua_product.size2,
ua_product.height,
ua_product.stock,
ua_product.kind,
ua_product.characteristics,
ua_catalog.name as catalog,
ua_catalog.url as cat_url,
ua_catalog.name_one,
favorites.product_id as fav_id,
d.title as brend_name
,CASE price
WHEN 0 THEN 100000
ELSE price
END AS price_sort
from ua_product
LEFT JOIN ua_catalog
ON ua_catalog.id=ua_product.cat_id
LEFT JOIN favorites
ON favorites.product_id = ua_product.id AND favorites.session_id = 'd8idohq5hrj3hrqftgituhug94'
LEFT JOIN ua_brend d
ON d.id=ua_product.brend_id
WHERE
ua_product.id!='0' and
ua_product.name!=''
AND ua_product.brend_id =
GROUP BY ua_product.id
ORDER BY `stock` DESC, `code` ASC, `price_sort` DESC, `name` asc, id desc'.