Fehler: Designer-Artikel.<
/Table 'DB325036.article_variante_shop' doesn't exist

---

SELECT a.article_id, ase.variante_id AS ase_variante_id, a.factory_id, a.factory_serie, a.designer_id, a.shop_news, a.shop_top , REPLACE(ase.htmldesc, CONCAT(', ', f.factory_desc), '') AS article_desc , a.text_details_shop, a.article_desc_short, f.factory_desc, f.factory_file, d.designer_desc, d.designer_file, a.article_image, if(a.item_teaser<>'' AND ase.variante_id=0, CONCAT(' '), '') AS show_item_teaser, ase.file_url, ase.image_url, MAX(a.shopprice_min) AS shopprice_min, /* Alt: variante_price */ REPLACE(ase.shopprice_campaign, '.', ',') AS shopprice_campaign, /* Alt: campaign_price */ ase.shopprice_count, /* Alt: AS countVariant, */ ase.shopprice_from, /* Alt: AS variante_price_text_abgeschaltet */ ase.shopprice_show, a.htmltext, f.factory_desc, f.website, f.webshop_url FROM article_stranger AS ast JOIN designer AS d ON ast.stranger_id_value=d.designer_id JOIN article AS a ON ast.article_id=a.article_id JOIN article_search AS ase ON a.article_id=ase.article_id LEFT JOIN article_variante_shop AS av ON ase.variante_id=av.article_id LEFT JOIN factory AS f ON a.factory_id=f.factory_id LEFT JOIN category_subcategory AS cs ON ast.stranger_id_value=cs.subcategory_id WHERE (ast.stranger_id_name='designer_id' AND ast.stranger_id_value='10268') GROUP BY ase.article_id,ase.variante_id ORDER BY IF(a.sort_designer<1, 99, a.sort_designer), av.variante_pos, a.article_desc