Всего выполнено запросов: 35 шт. за 0.0217 сек. Закрыть


Ошибка в SQL запросе: SELECT DISTINCT p.id, CONCAT(c.parent_url,c.url) as category_url, p.url as product_url, p.*, pv.product_id as variant_exist FROM `mg_product` p LEFT JOIN `mg_category` c ON c.id = p.cat_id LEFT JOIN `mg_product_variant` pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, SUM( pv.count ) AS varcount FROM `mg_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE p.activity = 1 WHERE p.activity = 1 AND c.id IN () or FIND_IN_SET (,p.`inside_cat`) ORDER BY id DESC
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 'WHERE p.activity = 1 AND c.id IN () or FIND_IN_SET (,p.`inside_cat`) ORDER BY id' at line 15


/var/www/_nsprus/mg-core/lib/navigator.php (line 99)


/var/www/_nsprus/mg-core/lib/navigator.php (line 50)


/var/www/_nsprus/mg-core/models/catalog.php (line 174)


/var/www/_nsprus/mg-core/controllers/catalog.php (line 56)


/var/www/_nsprus/mg-core/lib/moguta.php (line 35)


/var/www/_nsprus/mg-core/mg-start.php (line 55)


/var/www/_nsprus/index.php (line 114)