Aktueller Deal
Hier gibt es heute keinen Deal.
Bitte schau in einer anderen Stadt nach und registriere Dich für unseren Newsletter oben rechts, damit Du keinen KidsDeal für Deine Stadt verpasst.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, IF(_table_City.value_id>0, _table_City.value, _table_City_default.value) AS `City`, IF(_table_Status.value_id>0, _table_Status.value, _table_Status_default.value) AS `Status` FROM `magentocatalog_product_entity` AS `e`
INNER JOIN `magentocatalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.category_id='7' AND cat_index.is_parent=1
INNER JOIN `magentocatalog_product_entity_varchar` AS `_table_City_default` ON (_table_City_default.entity_id = e.entity_id) AND (_table_City_default.attribute_id='562') AND _table_City_default.store_id=0
LEFT JOIN `magentocatalog_product_entity_varchar` AS `_table_City` ON (_table_City.entity_id = e.entity_id) AND (_table_City.attribute_id='562') AND (_table_City.store_id='1')
INNER JOIN `magentocatalog_product_entity_int` AS `_table_Status_default` ON (_table_Status_default.entity_id = e.entity_id) AND (_table_Status_default.attribute_id='84') AND _table_Status_default.store_id=0
LEFT JOIN `magentocatalog_product_entity_int` AS `_table_Status` ON (_table_Status.entity_id = e.entity_id) AND (_table_Status.attribute_id='84') AND (_table_Status.store_id='1') WHERE (find_in_set('24',IF(_table_City.value_id>0, _table_City.value, _table_City_default.value))) AND ((IF(_table_Status.value_id>0, _table_Status.value, _table_Status_default.value) = '1'))
Folge uns
Neue Kunden gewinnen
Kein Angebot verpassen
Dein Vorschlag
Unser Versprechen
Kinderleicht bezahlen




