SELECT DISTINCT i.id, i.childs, i.steuersatz, i.name_deu AS artikel_name, i.desc_deu AS `artikel_text`, i.name_deu AS artikel_name2, i.desc_deu AS `artikel_text2`, i.spalten2_check, i.haendler_id, i.pict01, i.pict02, i.pict03, i.pict04, i.pict05, i.pict06, i.pict07, i.pict08, i.pict09, i.pict10, i.pict11, i.pict12, i.pict13, i.pict14, i.pict15, i.pict16, i.pict17, i.staffelung, i.versand_preis, i.grundeinheit, i.grundeinheit_rechner, a.ge_netto, i.ge_netto_aktiv, i.widerruf, i.lieferfrist, i.is_foto, i.masse_check, i.masse_komma, i.masse_min, i.rechner_check, i.rechner_mode, i.motiv_uploadp_check, i.motiv_uploadt_check, i.artikelgruppe, i.vpe, i.vpm, i.marke, i.gewicht, i.configurator AS artikel_configurator, i.configurator_check, i.config_einheit_check, i.config_menge_check, i.timer_check, i.timer_end, i.timer_menge, i.timer_anzeige, i.timer_art_disable, i.show_object, i.fsk_check, i.foto_set, i.neu_check, i.mixer_artikel_check, i.naehrwerte_check, i.mixer_gewicht_check, i.mixer_gewicht, i.mixer_naehrwerte_check, i.spedition, a.id as art_id, a.parent_id, a.art_nr, a.netto, a.angebot, a.angebot_active, a.menge, a.startbild, a.filename, a.filetyp, a.merkmal1, a.merkmal2, a.wert1, a.wert2, a.gtin, a.mpn, a.matrix, a.ge_menge, m1.merkmal_deu as merkmal1_name, m2.merkmal_deu as merkmal2_name, w1.wert_deu as wert1_name, w2.wert_deu as wert2_name, c.name_deu AS cat_name FROM shop_articles as a LEFT JOIN shop_articles_info AS i ON i.id = a.parent_id LEFT JOIN shop_merkmale AS m1 ON a.merkmal1 = m1.id LEFT JOIN shop_merkmale AS m2 ON a.merkmal2 = m2.id LEFT JOIN shop_werte AS w1 ON a.wert1 = w1.id LEFT JOIN shop_werte AS w2 ON a.wert2 = w2.id LEFT JOIN shop_article_to_cats AS ac ON ac.parent_id = i.id LEFT JOIN shop_categories AS c ON ac.cat_id = c.id WHERE a.id = 204 AND ac.sort = 0 AND online = 'y' AND i.id = (SELECT parent_id FROM shop_articles WHERE id = 204) LIMIT 1
Error: Unknown column 'i.spedition' in 'field list'
Aufruf von articles_base.class.php Zeile 311