string(12362) "SELECT product.id as __product_id, product.supplierID as __product_supplierID, product.name as __product_name, product.description as __product_description, product.description_long as __product_description_long, product.shippingtime as __product_shippingtime, product.datum as __product_datum, product.active as __product_active, product.taxID as __product_taxID, product.pseudosales as __product_pseudosales, product.topseller as __product_topseller, product.metaTitle as __product_metaTitle, product.keywords as __product_keywords, product.changetime as __product_changetime, product.pricegroupID as __product_pricegroupID, product.pricegroupActive as __product_pricegroupActive, product.filtergroupID as __product_filtergroupID, product.crossbundlelook as __product_crossbundlelook, product.notification as __product_notification, product.template as __product_template, product.mode as __product_mode, product.main_detail_id as __product_main_detail_id, product.available_from as __product_available_from, product.available_to as __product_available_to, product.configurator_set_id as __product_configurator_set_id, productAttribute.id as __productAttribute_id, productAttribute.articleID as __productAttribute_articleID, productAttribute.articledetailsID as __productAttribute_articledetailsID, productAttribute.attr1 as __productAttribute_attr1, productAttribute.attr2 as __productAttribute_attr2, productAttribute.attr3 as __productAttribute_attr3, productAttribute.attr4 as __productAttribute_attr4, productAttribute.attr5 as __productAttribute_attr5, productAttribute.attr6 as __productAttribute_attr6, productAttribute.attr7 as __productAttribute_attr7, productAttribute.attr8 as __productAttribute_attr8, productAttribute.attr9 as __productAttribute_attr9, productAttribute.attr10 as __productAttribute_attr10, productAttribute.attr11 as __productAttribute_attr11, productAttribute.attr12 as __productAttribute_attr12, productAttribute.attr13 as __productAttribute_attr13, productAttribute.attr14 as __productAttribute_attr14, productAttribute.attr15 as __productAttribute_attr15, productAttribute.attr16 as __productAttribute_attr16, productAttribute.attr17 as __productAttribute_attr17, productAttribute.attr18 as __productAttribute_attr18, productAttribute.attr19 as __productAttribute_attr19, productAttribute.attr20 as __productAttribute_attr20, productAttribute.swag_enterprise_search_suggestion_keywords as __productAttribute_swag_enterprise_search_suggestion_keywords, productAttribute.swag_enterprise_search_exclude as __productAttribute_swag_enterprise_search_exclude, productAttribute.wempe_hide_rolex_in_header as __productAttribute_wempe_hide_rolex_in_header, productAttribute.wempe_online_available as __productAttribute_wempe_online_available, productAttribute.wempe_gender_type as __productAttribute_wempe_gender_type, productAttribute.wempe_cockpit_short_description as __productAttribute_wempe_cockpit_short_description, productAttribute.wempe_product_group_id as __productAttribute_wempe_product_group_id, productAttribute.wempe_product_status as __productAttribute_wempe_product_status, productAttribute.wempe_care_instructions as __productAttribute_wempe_care_instructions, productAttribute.wempe_expert_text as __productAttribute_wempe_expert_text, productAttribute.wempe_expert_number as __productAttribute_wempe_expert_number, productAttribute.wempe_google_condition as __productAttribute_wempe_google_condition, productAttribute.wempe_shortable as __productAttribute_wempe_shortable, productAttribute.wempe_google_product_category as __productAttribute_wempe_google_product_category, productAttribute.wempe_google_shipping as __productAttribute_wempe_google_shipping, productAttribute.wempe_google_use_by_date as __productAttribute_wempe_google_use_by_date, productAttribute.wempe_google_special_offer_price as __productAttribute_wempe_google_special_offer_price, productAttribute.wempe_google_special_offer_period as __productAttribute_wempe_google_special_offer_period, productAttribute.wempe_request as __productAttribute_wempe_request, productAttribute.wempe_trade_show as __productAttribute_wempe_trade_show, productAttribute.wempe_jewels_supplier_reference as __productAttribute_wempe_jewels_supplier_reference, productAttribute.wempe_expert_author as __productAttribute_wempe_expert_author, productAttribute.wempe_expert_profession as __productAttribute_wempe_expert_profession, productAttribute.wempe_generated_search_keywords as __productAttribute_wempe_generated_search_keywords, productAttribute.wempe_special_features as __productAttribute_wempe_special_features, productAttribute.wempe_hide_patek_in_header as __productAttribute_wempe_hide_patek_in_header, productAttribute.wempe_rolex_ranking as __productAttribute_wempe_rolex_ranking, productAttribute.wempe_offline_only as __productAttribute_wempe_offline_only, productAttribute.wempe_flag1_text as __productAttribute_wempe_flag1_text, productAttribute.wempe_flag1_start_date as __productAttribute_wempe_flag1_start_date, productAttribute.wempe_flag1_end_date as __productAttribute_wempe_flag1_end_date, productAttribute.wempe_flag2_text as __productAttribute_wempe_flag2_text, productAttribute.wempe_flag2_start_date as __productAttribute_wempe_flag2_start_date, productAttribute.wempe_flag2_end_date as __productAttribute_wempe_flag2_end_date, productAttribute.wempe_rolex_feature1_asset as __productAttribute_wempe_rolex_feature1_asset, productAttribute.wempe_rolex_feature1_text as __productAttribute_wempe_rolex_feature1_text, productAttribute.wempe_rolex_feature1_title as __productAttribute_wempe_rolex_feature1_title, productAttribute.wempe_rolex_feature2_asset as __productAttribute_wempe_rolex_feature2_asset, productAttribute.wempe_rolex_feature2_text as __productAttribute_wempe_rolex_feature2_text, productAttribute.wempe_rolex_feature2_title as __productAttribute_wempe_rolex_feature2_title, productAttribute.wempe_rolex_feature3_asset as __productAttribute_wempe_rolex_feature3_asset, productAttribute.wempe_rolex_feature3_text as __productAttribute_wempe_rolex_feature3_text, productAttribute.wempe_rolex_feature3_title as __productAttribute_wempe_rolex_feature3_title, productAttribute.wempe_display_product_in_shop as __productAttribute_wempe_display_product_in_shop, productAttribute.wempe_show_phonebutton as __productAttribute_wempe_show_phonebutton, productAttribute.mopt_avalara_taxcode as __productAttribute_mopt_avalara_taxcode, productAttribute.mopt_avalara_hscode as __productAttribute_mopt_avalara_hscode, productAttribute.wempe_no_eos as __productAttribute_wempe_no_eos, productAttribute.wempe_rolex_howto_video_link as __productAttribute_wempe_rolex_howto_video_link, productAttribute.wempe_rolex_howto_set_text as __productAttribute_wempe_rolex_howto_set_text, productAttribute.wempe_availability_notification_off as __productAttribute_wempe_availability_notification_off, productAttribute.wempe_engravable as __productAttribute_wempe_engravable, productAttribute.wempe_rolex_brochure_link as __productAttribute_wempe_rolex_brochure_link, topSeller.sales as __topSeller_sales, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, variant.suppliernumber as __variant_suppliernumber, variant.kind as __variant_kind, variant.additionaltext as __variant_additionaltext, variant.sales as __variant_sales, variant.active as __variant_active, variant.instock as __variant_instock, variant.stockmin as __variant_stockmin, variant.weight as __variant_weight, variant.position as __variant_position, variant.width as __variant_width, variant.height as __variant_height, variant.length as __variant_length, variant.ean as __variant_ean, variant.unitID as __variant_unitID, variant.releasedate as __variant_releasedate, variant.shippingfree as __variant_shippingfree, variant.shippingtime as __variant_shippingtime, variant.laststock as __product_laststock, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description, manufacturer.id as __manufacturer_id, manufacturer.name as __manufacturer_name, manufacturer.img as __manufacturer_img, manufacturer.link as __manufacturer_link, manufacturer.description as __manufacturer_description, manufacturer.meta_title as __manufacturer_meta_title, manufacturer.meta_description as __manufacturer_meta_description, manufacturer.meta_keywords as __manufacturer_meta_keywords, manufacturerAttribute.id as __manufacturerAttribute_id, manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, manufacturerAttribute.swag_enterprise_search_suggestion_keywords as __manufacturerAttribute_swag_enterprise_search_suggestion_keywords, manufacturerAttribute.swag_enterprise_search_exclude as __manufacturerAttribute_swag_enterprise_search_exclude, manufacturerAttribute.wempe_manufacturer_prio as __manufacturerAttribute_wempe_manufacturer_prio, manufacturerAttribute.wempe_manufacturer_link as __manufacturerAttribute_wempe_manufacturer_link, manufacturerAttribute.wempe_richemont_newsletter as __manufacturerAttribute_wempe_richemont_newsletter, manufacturerAttribute.wempe_website_link as __manufacturerAttribute_wempe_website_link, manufacturerAttribute.wempe_imprint_link as __manufacturerAttribute_wempe_imprint_link, manufacturerAttribute.wempe_privacy_link as __manufacturerAttribute_wempe_privacy_link, manufacturerAttribute.wempe_manufacturer_pulldown_excluded_shops as __manufacturerAttribute_wempe_manufacturer_pulldown_excluded_shops, manufacturerAttribute.wempe_manufacturer_chat_exclude as __manufacturerAttribute_wempe_manufacturer_chat_exclude, esd.id as __esd_id, esd.articleID as __esd_articleID, esd.articledetailsID as __esd_articledetailsID, esd.file as __esd_file, esd.serials as __esd_serials, esd.notification as __esd_notification, esd.maxdownloads as __esd_maxdownloads, esd.datum as __esd_datum, esdAttribute.id as __esdAttribute_id, esdAttribute.esdID as __esdAttribute_esdID, (SELECT 1 FROM s_articles_esd variantEsd WHERE variantEsd.articleID = product.id LIMIT 1) as __product_has_esd, (SELECT GROUP_CONCAT(customerGroups.customergroupId SEPARATOR '|') FROM s_articles_avoid_customergroups customerGroups WHERE customerGroups.articleID = product.id) as __product_blocked_customer_groups, (SELECT COUNT(availableVariant.id) FROM s_articles_details availableVariant WHERE (availableVariant.articleID = product.id) AND (availableVariant.active = 1) AND ((availableVariant.laststock * availableVariant.instock) >= (availableVariant.laststock * availableVariant.minpurchase))) as __product_has_available_variants, (SELECT COUNT(DISTINCT ROUND(prices.price, 2)) as priceCount FROM s_articles_prices prices INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID and priceVariant.active = 1 WHERE (prices.from = 1) AND (prices.pricegroup = :fallback) AND (prices.articleID = product.id)) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id INNER JOIN s_core_tax tax ON tax.id = product.taxID LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id WHERE (variant.ordernumber IN (:numbers)) AND (productAttribute.wempe_display_product_in_shop = 1)"