mbDESIGN SF2 9,0x19" 5x112 ET42.0 75.0 5RZ7 Champagner matt | mbDESIGN Felgen Shop

73348 SELECT a.id AS groupId, a.name AS groupName, a.description AS groupDescription, a.pflicht, a.multiple_choice AS groupMultiple, b.id AS articleId, b.ordernumber AS articleNumber, b.optionname, b.quantity AS articleQuantity, b.standard, b.einheit FROM atsd_article_accessory_direct_buy_groups AS a JOIN atsd_article_accessory_direct_buy_articles AS b ON a.id = b.accessory_group_id JOIN s_articles_details AS d ON d.ordernumber = b.ordernumber AND d.active =1 WHERE a.article_id = :articleId UNION SELECT 9999 AS groupId, '0 Zubehörkit' AS groupName, 'Zubehör zur Radmontage, teilweise Serienradbefestigung.' AS groupDescription, 1 AS pflicht, 0 AS groupMultiple, p2.articleId, p2.products_model AS articleNumber, p2.products_oberflaeche AS optionname, 1 AS articleQuantity, IF(p.products_farbcode IN('B1','BP1','B3','B2','B4','G1') AND p2.products_farbcode = 'S','0','1') AS standard, 'Kit' AS einheit FROM wheel_assistant_wheels AS waw JOIN wheel_assistant_cars AS wac ON wac.id = waw.car JOIN s_articles_attributes AS p ON waw.wheel = p.products_groupid JOIN s_articles_attributes AS p2 ON p2.products_model = waw.accessorie OR p2.products_model = CONCAT(waw.accessorie,IF(p.products_farbcode IN('B1','BP1','B3','B2','B4','G1'),'-B','')) WHERE p.articleID = :articleId AND wac.autoid = :autoId GROUP BY articleNumber ORDER BY groupName ASC