An Error Was Encountered

Unable to execute SELECT statement [SELECT SQL_CALC_FOUND_ROWS DISTINCT shop_products.id, shop_products.user_id, shop_products.external_id, shop_products.url, shop_products.active, shop_products.hit, shop_products.hot, shop_products.action, shop_products.archive, shop_products.brand_id, shop_products.category_id, shop_products.related_products, shop_products.old_price, shop_products.created, shop_products.updated, shop_products.views, shop_products.added_to_cart_count, shop_products.enable_comments, shop_products.tpl, shop_products_i18n.id, shop_products_i18n.locale, shop_products_i18n.name, shop_products_i18n.short_description, shop_products_i18n.full_description, shop_products_i18n.meta_title, shop_products_i18n.meta_description, shop_products_i18n.meta_keywords, IF(sum(shop_product_variants.stock) > 0, 1, 0) AS allstock FROM shop_products INNER JOIN shop_products_i18n ON (shop_products.id=shop_products_i18n.id AND shop_products_i18n.locale = :p1) INNER JOIN shop_product_variants ON (shop_products.id=shop_product_variants.product_id) INNER JOIN shop_category ON (shop_products.category_id=shop_category.id) WHERE shop_products.active=:p2 AND shop_products.archive=:p3 AND shop_products.brand_id=:p4 AND shop_category.active = :p5 AND shop_products.category_id=:p6 GROUP BY shop_products.id ORDER BY allstock DESC,shop_product_variants.price ASC LIMIT 12]

Сообщить администратору