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(135) } [":customerGroupIds"]=> array(1) { [0]=> int(1) } }
Filter schließen
  •  
  •  
  •  
  •  
1 von 3
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
NEU
1 von 3
Zuletzt angesehen
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 productCategory ON productCategory.articleID = product.id AND productCategory.categoryID IN (:category) LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id AND avoidCustomerGroup.customerGroupId IN (:customerGroupIds) INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id WHERE avoidCustomerGroup.articleID IS NULL GROUP BY product.id ORDER BY product.datum DESC, product.changetime DESC, product.id DESC LIMIT 24array(2) { [":category"]=> array(1) { [0]=> int(135) } [":customerGroupIds"]=> array(1) { [0]=> int(1) } }