Passende Teile für Ihr Fahrzeug
Marke
Felgenmarke
A-Klasse
- Home
- Mercedes-Benz
- PKW
- A-Klasse
Wir können keine Produkte entsprechend dieser Auswahl finden
Produkte pro Seite anzeigen
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (778183, 778182, 778181, 778074, 777926, 777916, 777830, 777796, 777794, 777791, 777790, 777769, 777768, 777759, 777624, 777623, 777396, 777376, 777370, 777319)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 118, 121, 128, 154, 187, 203, 204, 205)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (778183, 778182, 778181, 778074, 777926, 777916, 777830, 777796, 777794, 777791, 777790, 777769, 777768, 777759, 777624, 777623, 777396, 777376, 777370, 777319)) AND (t_d.attribute_id IN (76, 176, 189, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (778183, 778182, 778181, 778074, 777926, 777916, 777830, 777796, 777794, 777791, 777790, 777769, 777768, 777759, 777624, 777623, 777396, 777376, 777370, 777319)) AND (t_d.attribute_id IN (78, 117, 292)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (778183, 778182, 778181, 778074, 777926, 777916, 777830, 777796, 777794, 777791, 777790, 777769, 777768, 777759, 777624, 777623, 777396, 777376, 777370, 777319)) AND (t_d.attribute_id IN (79, 80, 94, 95)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (778183, 778182, 778181, 778074, 777926, 777916, 777830, 777796, 777794, 777791, 777790, 777769, 777768, 777759, 777624, 777623, 777396, 777376, 777370, 777319)) AND (t_d.attribute_id IN (97, 123, 126, 129, 130, 132, 133, 134, 186, 291, 349, 366, 367)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))