Die Dowo Karten wirken farblich eher zurückhaltend, aber durch die Spotlackierung werden Teile der Motive besonders hervorgehoben.

Die Dowo Karten wirken farblich eher zurückhaltend, aber durch die Spotlackierung werden Teile der Motive besonders hervorgehoben. mehr erfahren »
Fenster schließen

Die Dowo Karten wirken farblich eher zurückhaltend, aber durch die Spotlackierung werden Teile der Motive besonders hervorgehoben.

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(71) } [":customerGroupIds"]=> array(1) { [0]=> int(1) } }
Filter schließen
  •  
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(71) } [":customerGroupIds"]=> array(1) { [0]=> int(1) } }