Topseller
SELECT SQL_CALC_FOUND_ROWS product.id as __product_id, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber FROM s_articles product INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id
AND variant.active = 1
AND product.active = 1 INNER JOIN s_core_tax tax ON tax.id = product.taxID INNER JOIN s_articles_categories_ro productCategory4 ON productCategory4.articleID = product.id
AND productCategory4.categoryID IN (:category4) LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id
AND avoidCustomerGroup.customerGroupId IN (:customerGroupIds) LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id WHERE avoidCustomerGroup.articleID IS NULL GROUP BY product.id ORDER BY topSeller.sales DESC, topSeller.article_id DESC LIMIT 8array(2) {
[":category4"]=>
array(1) {
[0]=>
int(10)
}
[":customerGroupIds"]=>
array(1) {
[0]=>
int(1)
}
}
NEU
NEU
NEU
NEU
NEU
Zuletzt angesehen