Marktplatz
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('27',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




