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_product_categories ON (shop_products.id=shop_product_categories.product_id) INNER JOIN shop_category ON (shop_products.category_id=shop_category.id) 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) LEFT JOIN shop_brands ON (shop_products.brand_id=shop_brands.id) WHERE shop_product_categories.category_id=:p2 AND shop_products.active=:p3 AND shop_products.archive=:p4 AND shop_category.active=:p5 AND shop_products.id IN (:p6,:p7,:p8,:p9,:p10,:p11,:p12,:p13,:p14,:p15,:p16,:p17,:p18,:p19,:p20,:p21,:p22,:p23,:p24,:p25,:p26,:p27,:p28,:p29,:p30,:p31,:p32,:p33,:p34,:p35,:p36,:p37,:p38,:p39,:p40,:p41,:p42,:p43,:p44,:p45,:p46,:p47,:p48,:p49,:p50,:p51,:p52,:p53,:p54,:p55,:p56,:p57,:p58,:p59,:p60,:p61,:p62,:p63,:p64,:p65,:p66,:p67,:p68,:p69,:p70,:p71,:p72,:p73,:p74,:p75,:p76,:p77,:p78,:p79,:p80,:p81,:p82,:p83,:p84,:p85,:p86,:p87,:p88,:p89,:p90,:p91,:p92,:p93,:p94,:p95,:p96,:p97,:p98,:p99,:p100,:p101,:p102,:p103,:p104,:p105,:p106,:p107,:p108,:p109,:p110,:p111,:p112,:p113,:p114,:p115,:p116,:p117,:p118,:p119,:p120,:p121,:p122,:p123,:p124,:p125) GROUP BY shop_products.id ORDER BY allstock DESC,shop_product_variants.price ASC,shop_products.id DESC LIMIT 12]

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