Ist jetzt schwer nachvollziehbar, denn bei welöchen Artikel soll ich schauen. Mal ist instock größer laststock, mal ist es umgekehrt. Aber ich habe hier auch ein utopisches Query was Fehler erzeugt:
... 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.dreisc_seo_url as__ productAttribute_dreisc_seo_url, productAttribute.dreisc_seo_title as __productAttribute_dreisc_seo_title, productAttribute.dreisc_seo_title_replace as__ productAttribute_dreisc_seo_title_replace, productAttribute.dreisc_seo_breadcrumb as __productAttribute_dreisc_seo_breadcrumb, productAttribute.dreisc_canonical_link as__ productAttribute_dreisc_canonical_link, productAttribute.dreisc_robots_tag as __productAttribute_dreisc_robots_tag, productAttribute.dreisc_facebook_description as__ productAttribute_dreisc_facebook_description, productAttribute.dreisc_twitter_description as __productAttribute_dreisc_twitter_description, productAttribute.dreisc_facebook_image as__ productAttribute_dreisc_facebook_image, productAttribute.dreisc_twitter_image as __productAttribute_dreisc_twitter_image, productAttribute.nimbits_extrabadge_text1 as__ productAttribute_nimbits_extrabadge_text1, productAttribute.nimbits_extrabadge_color1 as __productAttribute_nimbits_extrabadge_color1, productAttribute.nimbits_extrabadge_text2 as__ productAttribute_nimbits_extrabadge_text2, productAttribute.nimbits_extrabadge_color2 as __productAttribute_nimbits_extrabadge_color2, productAttribute.nimbits_extrabadge_text3 as__ productAttribute_nimbits_extrabadge_text3, productAttribute.nimbits_extrabadge_color3 as __productAttribute_nimbits_extrabadge_color3, productAttribute.nimbits_extrabadge_image1 as__ productAttribute_nimbits_extrabadge_image1, productAttribute.nimbits_extrabadge_image2 as __productAttribute_nimbits_extrabadge_image2, productAttribute.nimbits_extrabadge_image3 as__ productAttribute_nimbits_extrabadge_image3, productAttribute.dk_order_one as __productAttribute_dk_order_one, 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.shops_seo_manager_title as __manufacturerAttribute_shops_seo_manager_title, manufacturerAttribute.shops_seo_manager_canonical as__ manufacturerAttribute_shops_seo_manager_canonical, manufacturerAttribute.shops_seo_manager_url as __manufacturerAttribute_shops_seo_manager_url, manufacturerAttribute.shops_seo_manager_robots as__ manufacturerAttribute_shops_seo_manager_robots, manufacturerAttribute.shops_seo_manager_facebook as __manufacturerAttribute_shops_seo_manager_facebook, manufacturerAttribute.shops_seo_manager_twitter as__ manufacturerAttribute_shops_seo_manager_twitter, 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 = ?) AND (prices.articleID = product.id)) as__product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id, (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 = ?) AND (prices.articleID = product.id)) as__product_custom_price_count 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 (?, ?, ?, ?, ?)) AND (variant.active = 1) AND (product.active = 1)' with params ("EK", "GK", "ZD-FFP3", "ZD-FFP2", "ZD-700000", "ZD-700010", "ZD-700090"):
Am Ende steht:
WHERE (variant.ordernumber IN (?, ?, ?, ?, ?)) AND (variant.active = 1) AND (product.active = 1)' with params ("EK", "GK", "ZD-FFP3", "ZD-FFP2", "ZD-700000", "ZD-700010", "ZD-700090"):
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?) AND (prices.articleID = product.id)) as __product_fallback_price_count, manuf' at line 1
Könnte das die Ursache sein?
