SELECT z.id AS db_id, a.id, a.sort, i.ab_check, i.gewicht, i.spedition, i.id as parent, i.steuersatz, i.name_deu AS art_name, i.desc_deu AS artikel_text, i.haendler_id, i.childs, i.image, i.lieferfrist, i.show_object, i.fsk_check, i.staffelung, i.versand_preis, i.childs, i.is_foto, i.marke, i.configurator, i.configurator_check, i. gewicht, i.spedition, i.config_einheit_check, i.config_menge_check, a.online, i.childs, i.rechner_check, i.mixer_artikel_check, i.timer_check, i.timer_end, i.timer_menge, i.timer_anzeige, i.timer_art_disable, i.neu_check, ab_check, i.sortierung, i.grundeinheit, i.ge_netto_aktiv, i.motiv_uploadp_check, i.motiv_uploadt_check, i.artikelgruppe, a.id as id, a.netto, a.angebot, a.angebot_active, a.menge, a.ge_netto, a.mpn, a.gtin, c.cat_pass, c.name_deu AS cat_name, a.merkmal1 AS mm1_val, a.merkmal2 AS mm2_val, a.wert1 AS w1_val, wert2 AS w2_val, m.merkmal_deu as merkmal1, w.wert_deu as wert1, mm.merkmal_deu as merkmal2, ww.wert_deu as wert2 FROM shop_articles_zubehoer AS z LEFT JOIN shop_articles AS a ON z.zubehoer_id = a.id LEFT JOIN shop_articles_info AS i ON a.parent_id = i.id LEFT JOIN shop_article_to_cats AS ac ON i.id = ac.parent_id LEFT JOIN shop_categories as c ON ac.cat_id = c.id LEFT JOIN shop_merkmale as m ON a.merkmal1 = m.id LEFT JOIN shop_werte as w ON a.wert1 = w.id LEFT JOIN shop_merkmale as mm ON a.merkmal2 = mm.id LEFT JOIN shop_werte as ww ON a.wert2 = ww.id WHERE z.parent_id = AND ac.sort = 0 AND a.online = 'y' Order by z.sort
Error: 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 ac.sort = 0 AND a.online = 'y' Order by z.sort' at line 29
Aufruf von zubehoermodul.module.php Zeile 92