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


Ошибка в SQL запросе: SELECT DISTINCT p.id, CONCAT(c.parent_url,c.url) AS category_url, c.unit AS category_unit, p.unit AS product_unit, p.url AS product_url, p.*, pv.product_id AS variant_exist, rate, (p.price_course + p.price_course * (IFNULL(rate,0))) AS `price_course`, IF(p.count <0, 1000000, IF(varcount, IF(p.count 0, -10, p.cat_id) AS cat_id,IFNULL((SELECT pv.price_course FROM mg_product_variant AS pv WHERE pv.product_id = p.id AND count != 0 ORDER BY pv.price_course ASC LIMIT 1), p.price_course) AS `price_course_sort` FROM `kiril14_product` p LEFT JOIN `kiril14_category` c ON c.id = p.cat_id LEFT JOIN `kiril14_product_variant` pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, SUM(IF(pv.count <0, 1000000, pv.count)) AS varcount FROM `kiril14_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE p.id IN ('137','152','160','161','162','322','320','319','169','166','399','400','401','402','403') LIMIT 0, 15
Table 'kiril14_shop.mg_product_variant' doesn't exist


/home/k/kiril14/shop.key-st.ru/public_html/mg-core/lib/navigator.php (line 65)


/home/k/kiril14/shop.key-st.ru/public_html/mg-core/models/catalog.php (line 368)


/home/k/kiril14/shop.key-st.ru/public_html/mg-core/controllers/index.php (line 94)


/home/k/kiril14/shop.key-st.ru/public_html/mg-core/lib/moguta.php(0) : eval()'d code(1) : eval()'d code(49) : eval()'d code (line 11)


/home/k/kiril14/shop.key-st.ru/public_html/mg-core/lib/moguta.php(0) : eval()'d code(1) : eval()'d code (line 49)


/home/k/kiril14/shop.key-st.ru/public_html/mg-core/lib/moguta.php(0) : eval()'d code (line 1)


/home/k/kiril14/shop.key-st.ru/public_html/mg-core/lib/moguta.php (line 0)


/home/k/kiril14/shop.key-st.ru/public_html/mg-core/mg-start.php (line 0)


/home/k/kiril14/shop.key-st.ru/public_html/index.php (line 85)