SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`required_options`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`sku`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`cim_neu`, `e`.`cim_rostfrei`, `e`.`cim_ce_ped`, `e`.`cim_ce_atex`, `e`.`cim_iso_5211`, `e`.`cim_din_baulaenge`, `e`.`cim_dvgw_gas`, `e`.`cim_dvgw_wasser`, `e`.`cim_tuev`, `e`.`cim_ta_luft`, `e`.`cim_anti_statik`, `e`.`cim_fire_safe`, `e`.`ci_external_sku`, `e`.`cic_arm___abmessungen`, `e`.`cic_arm___abmessungen_value`, `e`.`cic_arm___anschluss`, `e`.`cic_arm___anschluss_value`, `e`.`cic_arm___anschlussmaterial`, `e`.`cic_arm___anschlussmaterial_value`, `e`.`cic_arm___ausfueh`, `e`.`cic_arm___ausfueh_value`, `e`.`cic_arm___ausfuehrung_schlauch`, `e`.`cic_arm___ausfuehrung_schlauch_value`, `e`.`cic_arm___ausfuehrung_verschra`, `e`.`cic_arm___ausfuehrung_verschra_value`, `e`.`cic_arm___balg`, `e`.`cic_arm___balg_value`, `e`.`cic_arm___betaetigung`, `e`.`cic_arm___betaetigung_value`, `e`.`cic_arm___dg_dichtung`, `e`.`cic_arm___dg_dichtung_value`, `e`.`cic_arm___dg_funktion`, `e`.`cic_arm___dg_funktion_value`, `e`.`cic_arm___dg_optionen`, `e`.`cic_arm___dg_optionen_value`, `e`.`cic_arm___dichtung`, `e`.`cic_arm___dichtung_value`, `e`.`cic_arm___doppeltwirkend`, `e`.`cic_arm___doppeltwirkend_value`, `e`.`cic_arm___drehmoment`, `e`.`cic_arm___drehmoment_value`, `e`.`cic_arm___drehmoment_ed`, `e`.`cic_arm___drehmoment_ed_value`, `e`.`cic_arm___ed_optionen`, `e`.`cic_arm___ed_optionen_value`, `e`.`cic_arm___einfachwirkend`, `e`.`cic_arm___einfachwirkend_value`, `e`.`cic_arm___farbe`, `e`.`cic_arm___farbe_value`, `e`.`cic_arm___fluegel`, `e`.`cic_arm___fluegel_value`, `e`.`cic_arm___funktion`, `e`.`cic_arm___funktion_value`, `e`.`cic_arm___fuer_baureihe`, `e`.`cic_arm___fuer_baureihe_value`, `e`.`cic_arm___gehaeuse`, `e`.`cic_arm___gehaeuse_value`, `e`.`cic_arm___getriebe`, `e`.`cic_arm___getriebe_value`, `e`.`cic_arm___gewinde`, `e`.`cic_arm___gewinde_value`, `e`.`cic_arm___gewinde_red`, `e`.`cic_arm___gewinde_red_value`, `e`.`cic_arm___groessen`, `e`.`cic_arm___groessen_value`, `e`.`cic_arm___groessen__2`, `e`.`cic_arm___groessen__2_value`, `e`.`cic_arm___klappenscheibe`, `e`.`cic_arm___klappenscheibe_value`, `e`.`cic_arm___ko_zubehoer`, `e`.`cic_arm___ko_zubehoer_value`, `e`.`cic_arm___kugel`, `e`.`cic_arm___kugel_value`, `e`.`cic_arm___kugelwerkstoff`, `e`.`cic_arm___kugelwerkstoff_value`, `e`.`cic_arm___kv_wert`, `e`.`cic_arm___kv_wert_value`, `e`.`cic_arm___laenge`, `e`.`cic_arm___laenge_value`, `e`.`cic_arm___mano_medienberuehrte`, `e`.`cic_arm___mano_medienberuehrte_value`, `e`.`cic_arm___manometeranschlu__`, `e`.`cic_arm___manometeranschlu___value`, `e`.`cic_arm___manometer_anschluss`, `e`.`cic_arm___manometer_anschluss_value`, `e`.`cic_arm___manometer_anzeigeber`, `e`.`cic_arm___manometer_anzeigeber_value`, `e`.`cic_arm___manometer_deckscheib`, `e`.`cic_arm___manometer_deckscheib_value`, `e`.`cic_arm___manometerdurchmesser`, `e`.`cic_arm___manometerdurchmesser_value`, `e`.`cic_arm___manometer_fuellung`, `e`.`cic_arm___manometer_fuellung_value`, `e`.`cic_arm___manometer_gehaeuse`, `e`.`cic_arm___manometer_gehaeuse_value`, `e`.`cic_arm___manschette`, `e`.`cic_arm___manschette_value`, `e`.`cic_arm___material`, `e`.`cic_arm___material_value`, `e`.`cic_arm___medium`, `e`.`cic_arm___medium_value`, `e`.`cic_arm___montagezubehoer`, `e`.`cic_arm___montagezubehoer_value`, `e`.`cic_arm___ne_optionen`, `e`.`cic_arm___ne_optionen_value`, `e`.`cic_arm___reduzierungen`, `e`.`cic_arm___reduzierungen_value`, `e`.`cic_arm___rohr`, `e`.`cic_arm___rohr_value`, `e`.`cic_arm___saugkoerbe`, `e`.`cic_arm___saugkoerbe_value`, `e`.`cic_arm___schlauchdurchmesser`, `e`.`cic_arm___schlauchdurchmesser_value`, `e`.`cic_arm___sieb`, `e`.`cic_arm___sieb_value`, `e`.`cic_arm___spannung`, `e`.`cic_arm___spannung_value`, `e`.`cic_arm___stellkraft`, `e`.`cic_arm___stellkraft_value`, `e`.`cic_arm___steuerventil`, `e`.`cic_arm___steuerventil_value`, `e`.`cic_arm___steuerzylinder`, `e`.`cic_arm___steuerzylinder_value`, `e`.`cic_arm___tuellendurchmesser`, `e`.`cic_arm___tuellendurchmesser_value`, `e`.`cic_arm___typ`, `e`.`cic_arm___typ_value`, `e`.`cic_arm___uv_optionen`, `e`.`cic_arm___uv_optionen_value`, `e`.`cic_arm___verteiler`, `e`.`cic_arm___verteiler_value`, `e`.`cic_arm___werkstoff`, `e`.`cic_arm___werkstoff_value`, `e`.`cic_arm___zubehoer`, `e`.`cic_arm___zubehoer_value`, `e`.`cic_arm___zulassungen_abnahmen`, `e`.`cic_arm___zulassungen_abnahmen_value`, `e`.`cic_arm___anschlu__`, `e`.`cic_arm___anschlu___value`, `e`.`cic_arm___optionen`, `e`.`cic_arm___optionen_value`, `e`.`cic_arm___schieberblatt`, `e`.`cic_arm___schieberblatt_value`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `links`.`link_id` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `catalog_product_entity_int` AS `arm_attr_table` ON e.entity_id = arm_attr_table.entity_id AND arm_attr_table.attribute_id = 1338 AND arm_attr_table.store_id = 0 LEFT JOIN `eav_attribute_option` AS `arm_attr_sort_table` ON arm_attr_sort_table.attribute_id = 1338 AND arm_attr_sort_table.option_id = arm_attr_table.value LEFT JOIN `catalog_product_entity` AS `wdg_attr_table` ON e.entity_id = wdg_attr_table.entity_id AND wdg_attr_table.attribute_id = AND wdg_attr_table.store_id = 0 LEFT JOIN `eav_attribute_option` AS `wdg_attr_sort_table` ON wdg_attr_sort_table.attribute_id = AND wdg_attr_sort_table.option_id = wdg_attr_table.value LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 6 AND links.product_id = '27652' LEFT JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id WHERE (links.product_id = 27652) OR (e.entity_id = 27652) ORDER BY `arm_attr_sort_table`.`sort_order` ASC, `wdg_attr_sort_table`.`sort_order` ASC