Fatal error: Uncaught Exception: 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 'join glasses gl on gl.id = p.glass
left join colors cl on cl.id = p.color
' at line 8 query:
SELECT
p.*,
gl.name glass_name,
cl.name color_name
FROM products p
inner join categories c on p.category = c.id and
c.parent =
left join glasses gl on gl.id = p.glass
left join colors cl on cl.id = p.color
WHERE
p.enabled = 1
order by p.sort in /var/www/u1083246/data/www/dveriteka.ru/inc/MysqliDb.php:2004
Stack trace:
#0 /var/www/u1083246/data/www/dveriteka.ru/inc/MysqliDb.php(563): MysqliDb->_prepareQuery()
#1 /var/www/u1083246/data/www/dveriteka.ru/catalog.php(14): MysqliDb->rawQuery('\n\t\t\tSELECT \n\t\t\t...')
#2 {main}
thrown in /var/www/u1083246/data/www/dveriteka.ru/inc/MysqliDb.php on line 2004