OpenOffice.info

Ich denke, ich habe die Ursache gefunden.
Der Fehler tritt wahrscheinlich aufgrund der Länge der SQL-Anweisung auf.
Ein Versuch ohne Unterabfrage erzeugte den gleichen Fehler.

Ich habe das jetzt auf die ersten 100 Spalten begrenzt und siehe da, mein Makro läuft.
Den Rest werde ich dann über UPDATE-Anweisungen in die Tabelle einpflegen.

Was mir gerade so auffällt:
Könnte der Laufzeitfehler durch die Unterabfrage entstehen?

Sorry - Die SQL-Abfrage ist etwas länger geraten - steht aber alles in einer Zeile, also ohne Zeilenumbruch. (Der Fehler taucht nur in der zweiten SQL-Anweisung auf)
Ich hab auch schon verschiedene Datenbankanbindungen versucht.



' Deklaration der Datenbankobjekte
DIM DatabaseContext AS OBJECT
DIM Datenquelle AS OBJECT
DIM Verbindung AS OBJECT
DIM Authentifizierung AS OBJECT
DIM SQL_Anweisung AS OBJECT
DIM Abfrageergebnis AS OBJECT

DatabaseContext = CreateUnoService ( "com.sun.star.sdb.DatabaseContext" )
Datenquelle = DatabaseContext.getByName( "db" )
Verbindung = Datenquelle.getConnection("Benutzer","Passwort")
MsgBox " DB-Verbindung besteht"

SQL_Anweisung = Verbindung.createStatement()

' SQL-Anweisungen ausführen
DIM Sql AS STRING
SQL = "TRUNCATE `tmp1`;"
SQL_Anweisung.executeUpdate (Sql)
msgbox("Tabelle tmp1 wurde geleert")

SQL = "INSERT INTO `tmp1` (`Artnr`, `1`,`2`,`3`,`4`,`5`,`6`,`7`,`8`,`9`,`10`, `11`,`12`,`13`,`14`,`15`,`16`,`17`,`18`,`19`,`20`, `21`,`22`,`23`,`24`,`25`,`26`,`27`,`28`,`29`,`30`, `31`,`32`,`33`,`34`,`35`,`36`,`37`,`38`,`39`,`40`, `41`,`42`,`43`,`44`,`45`,`46`,`47`,`48`,`49`,`50`, `51`,`52`,`53`,`54`,`55`,`56`,`57`,`58`,`59`,`60`, `61`,`62`,`63`,`64`,`65`,`66`,`67`,`68`,`69`,`70`, `71`,`72`,`73`,`74`,`75`,`76`,`77`,`78`,`79`,`80`, `81`,`82`,`83`,`84`,`85`,`86`,`87`,`88`,`89`,`90`, `91`,`92`,`93`,`94`,`95`,`96`,`97`,`98`,`99`,`100`, `101`,`102`,`103`,`104`,`105`,`106`,`107`,`108`,`109`,`110`, `111`,`112`,`113`,`114`,`115`,`116`,`117`,`118`,`119`,`120`, `121`,`122`,`123`,`124`,`125`,`126`,`127`,`128`,`129`,`130`, `131`,`132`,`133`,`134`,`135`,`136`,`137`,`138`,`139`,`140`, `141`,`142`,`143`,`144`,`145`,`146`,`147`,`148`,`149`,`150`, `151`,`152`,`153`,`154`,`155`,`156`,`157`,`158`,`159`,`160`, `161`,`162`,`163`,`164`,`165`,`166`,`167`,`168`,`169`,`170`, `171`,`172`,`173`,`174`,`175`,`176`,`177`,`178`,`179`,`180`, `181`,`182`,`183`,`184`,`185`,`186`,`187`,`188`,`189`,`190`, `191`,`192`,`193`,`194`,`195`,`196`,`197`,`198`,`199`,`200`, `201`,`202`,`203`,`204`,`205`,`206`,`207`,`208`,`209`,`210`, `211`,`212`,`213`,`214`,`215`,`216`,`217`,`218`,`219`,`220`, `221`,`222`,`223`,`224`,`225`,`226`,`227`,`228`,`229`,`230`, `231`,`232`,`233`,`234`,`235`,`236`,`237`,`238`,`239`,`240`, `241`,`242`,`243`,`244`,`245`,`246`,`247`,`248`,`249`,`250`, `251`,`252`,`253`,`254`,`255`,`256`,`257`,`258`,`259`,`260`, `261`,`262`,`263`,`264`,`265`,`266`,`267`,`268`,`269`,`270`, `271`,`272`,`273`,`274`,`275`,`276`,`277`,`278`,`279`,`280`, `281`,`282`,`283`,`284`,`285`,`286`,`287`,`288`,`289`,`290`, `291`,`292`,`293`,`294`,`295`,`296`,`297`,`298`,`299`,`300`, `301`,`302`,`303`,`304`,`305`,`306`,`307`,`308`,`309`,`310`, `311`,`312`,`313`,`314`,`315`,`316`,`317`,`318`,`319`,`320`, `321`,`322`,`323`,`324`,`325`,`326`,`327`,`328`,`329`,`330`, `331`,`332`,`333`,`334`,`335`,`336`,`337`,`338`,`339`,`340`, `341`,`342`,`343`,`344`,`345`,`346`,`347`,`348`,`349`,`350`, `351`,`352`,`353`,`354`,`355`,`356`,`357`,`358`,`359`,`360`, `361`,`362`,`363`,`364`,`365`,`366`,`367`,`368`,`369`,`370`, `371`,`372`,`373`,`374`,`375`,`376`,`377`,`378`,`379`,`380`, `381`,`382`,`383`,`384`,`385`,`386`,`387`,`388`,`389`,`390`, `391`,`392`,`393`,`394`,`395`,`396`,`397`,`398`,`399`,`400`, `401`,`402`,`403`,`404`,`405`,`406`,`407`,`408`,`409`,`410`, `411`,`412`,`413`,`414`,`415`,`416`,`417`,`418`,`419`,`420`, `421`,`422`,`423`,`424`,`425`,`426`,`427`,`428`,`429`,`430`, `431`,`432`,`433`,`434`,`435`,`436`,`437`,`438`,`439`,`440`, `441`,`442`,`443`,`444`,`445`,`446`,`447`,`448`,`449`,`450`, `451`,`452`,`453`,`454`,`455`,`456`,`457`,`458`,`459`,`460`, `461`,`462`,`463`,`464`,`465`,`466`,`467`,`468`,`469`,`470`, `471`,`472`,`473`,`474`,`475`,`476`,`477`,`478`,`479`,`480`, `481`,`482`,`483`,`484`,`485`,`486`,`487`,`488`,`489`,`490`, `491`,`492`,`493`,`494`,`495`,`496`,`497`,`498`,`499`,`500`) SELECT SUBSTRING_INDEX( `Druckerliste`, ', ', 1 ) AS `Artnr`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 2 ) ), ',', 1 ) ) AS `1`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 3 ) ), ',', 1 ) ) AS `2`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 4 ) ), ',', 1 ) ) AS `3`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 5 ) ), ',', 1 ) ) AS `4`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 6 ) ), ',', 1 ) ) AS `5`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 7 ) ), ',', 1 ) ) AS `6`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 8 ) ), ',', 1 ) ) AS `7`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 9 ) ), ',', 1 ) ) AS `8`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 10 ) ), ',', 1 ) ) AS `9`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 11 ) ), ',', 1 ) ) AS `10`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 12 ) ), ',', 1 ) ) AS `11`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 13 ) ), ',', 1 ) ) AS `12`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 14 ) ), ',', 1 ) ) AS `13`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 15 ) ), ',', 1 ) ) AS `14`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 16 ) ), ',', 1 ) ) AS `15`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 17 ) ), ',', 1 ) ) AS `16`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 18 ) ), ',', 1 ) ) AS `17`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 19 ) ), ',', 1 ) ) AS `18`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 20 ) ), ',', 1 ) ) AS `19`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 21 ) ), ',', 1 ) ) AS `20`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 22 ) ), ',', 1 ) ) AS `21`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 23 ) ), ',', 1 ) ) AS `22`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 24 ) ), ',', 1 ) ) AS `23`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 25 ) ), ',', 1 ) ) AS `24`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 26 ) ), ',', 1 ) ) AS `25`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 27 ) ), ',', 1 ) ) AS `26`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 28 ) ), ',', 1 ) ) AS `27`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 29 ) ), ',', 1 ) ) AS `28`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 30 ) ), ',', 1 ) ) AS `29`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 31 ) ), ',', 1 ) ) AS `30`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 32 ) ), ',', 1 ) ) AS `31`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 33 ) ), ',', 1 ) ) AS `32`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 34 ) ), ',', 1 ) ) AS `33`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 35 ) ), ',', 1 ) ) AS `34`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 36 ) ), ',', 1 ) ) AS `35`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 37 ) ), ',', 1 ) ) AS `36`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 38 ) ), ',', 1 ) ) AS `37`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 39 ) ), ',', 1 ) ) AS `38`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 40 ) ), ',', 1 ) ) AS `39`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 41 ) ), ',', 1 ) ) AS `40`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 42 ) ), ',', 1 ) ) AS `41`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 43 ) ), ',', 1 ) ) AS `42`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 44 ) ), ',', 1 ) ) AS `43`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 45 ) ), ',', 1 ) ) AS `44`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 46 ) ), ',', 1 ) ) AS `45`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 47 ) ), ',', 1 ) ) AS `46`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 48 ) ), ',', 1 ) ) AS `47`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 49 ) ), ',', 1 ) ) AS `48`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 50 ) ), ',', 1 ) ) AS `49`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 51 ) ), ',', 1 ) ) AS `50`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 52 ) ), ',', 1 ) ) AS `51`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 53 ) ), ',', 1 ) ) AS `52`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 54 ) ), ',', 1 ) ) AS `53`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 55 ) ), ',', 1 ) ) AS `54`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 56 ) ), ',', 1 ) ) AS `55`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 57 ) ), ',', 1 ) ) AS `56`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 58 ) ), ',', 1 ) ) AS `57`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 59 ) ), ',', 1 ) ) AS `58`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 60 ) ), ',', 1 ) ) AS `59`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 61 ) ), ',', 1 ) ) AS `60`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 62 ) ), ',', 1 ) ) AS `61`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 63 ) ), ',', 1 ) ) AS `62`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 64 ) ), ',', 1 ) ) AS `63`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 65 ) ), ',', 1 ) ) AS `64`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 66 ) ), ',', 1 ) ) AS `65`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 67 ) ), ',', 1 ) ) AS `66`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 68 ) ), ',', 1 ) ) AS `67`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 69 ) ), ',', 1 ) ) AS `68`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 70 ) ), ',', 1 ) ) AS `69`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 71 ) ), ',', 1 ) ) AS `70`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 72 ) ), ',', 1 ) ) AS `71`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 73 ) ), ',', 1 ) ) AS `72`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 74 ) ), ',', 1 ) ) AS `73`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 75 ) ), ',', 1 ) ) AS `74`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 76 ) ), ',', 1 ) ) AS `75`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 77 ) ), ',', 1 ) ) AS `76`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 78 ) ), ',', 1 ) ) AS `77`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 79 ) ), ',', 1 ) ) AS `78`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 80 ) ), ',', 1 ) ) AS `79`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 81 ) ), ',', 1 ) ) AS `80`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 82 ) ), ',', 1 ) ) AS `81`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 83 ) ), ',', 1 ) ) AS `82`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 84 ) ), ',', 1 ) ) AS `83`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 85 ) ), ',', 1 ) ) AS `84`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 86 ) ), ',', 1 ) ) AS `85`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 87 ) ), ',', 1 ) ) AS `86`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 88 ) ), ',', 1 ) ) AS `87`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 89 ) ), ',', 1 ) ) AS `88`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 90 ) ), ',', 1 ) ) AS `89`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 91 ) ), ',', 1 ) ) AS `90`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 92 ) ), ',', 1 ) ) AS `91`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 93 ) ), ',', 1 ) ) AS `92`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 94 ) ), ',', 1 ) ) AS `93`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 95 ) ), ',', 1 ) ) AS `94`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 96 ) ), ',', 1 ) ) AS `95`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 97 ) ), ',', 1 ) ) AS `96`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 98 ) ), ',', 1 ) ) AS `97`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 99 ) ), ',', 1 ) ) AS `98`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 100 ) ), ',', 1 ) ) AS `99`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 101 ) ), ',', 1 ) ) AS `100`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 102 ) ), ',', 1 ) ) AS `101`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 103 ) ), ',', 1 ) ) AS `102`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 104 ) ), ',', 1 ) ) AS `103`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 105 ) ), ',', 1 ) ) AS `104`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 106 ) ), ',', 1 ) ) AS `105`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 107 ) ), ',', 1 ) ) AS `106`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 108 ) ), ',', 1 ) ) AS `107`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 109 ) ), ',', 1 ) ) AS `108`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 110 ) ), ',', 1 ) ) AS `109`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 111 ) ), ',', 1 ) ) AS `110`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 112 ) ), ',', 1 ) ) AS `111`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 113 ) ), ',', 1 ) ) AS `112`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 114 ) ), ',', 1 ) ) AS `113`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 115 ) ), ',', 1 ) ) AS `114`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 116 ) ), ',', 1 ) ) AS `115`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 117 ) ), ',', 1 ) ) AS `116`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 118 ) ), ',', 1 ) ) AS `117`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 119 ) ), ',', 1 ) ) AS `118`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 120 ) ), ',', 1 ) ) AS `119`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 121 ) ), ',', 1 ) ) AS `120`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 122 ) ), ',', 1 ) ) AS `121`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 123 ) ), ',', 1 ) ) AS `122`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 124 ) ), ',', 1 ) ) AS `123`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 125 ) ), ',', 1 ) ) AS `124`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 126 ) ), ',', 1 ) ) AS `125`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 127 ) ), ',', 1 ) ) AS `126`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 128 ) ), ',', 1 ) ) AS `127`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 129 ) ), ',', 1 ) ) AS `128`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 130 ) ), ',', 1 ) ) AS `129`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 131 ) ), ',', 1 ) ) AS `130`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 132 ) ), ',', 1 ) ) AS `131`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 133 ) ), ',', 1 ) ) AS `132`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 134 ) ), ',', 1 ) ) AS `133`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 135 ) ), ',', 1 ) ) AS `134`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 136 ) ), ',', 1 ) ) AS `135`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 137 ) ), ',', 1 ) ) AS `136`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 138 ) ), ',', 1 ) ) AS `137`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 139 ) ), ',', 1 ) ) AS `138`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 140 ) ), ',', 1 ) ) AS `139`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 141 ) ), ',', 1 ) ) AS `140`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 142 ) ), ',', 1 ) ) AS `141`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 143 ) ), ',', 1 ) ) AS `142`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 144 ) ), ',', 1 ) ) AS `143`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 145 ) ), ',', 1 ) ) AS `144`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 146 ) ), ',', 1 ) ) AS `145`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 147 ) ), ',', 1 ) ) AS `146`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 148 ) ), ',', 1 ) ) AS `147`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 149 ) ), ',', 1 ) ) AS `148`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 150 ) ), ',', 1 ) ) AS `149`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 151 ) ), ',', 1 ) ) AS `150`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 152 ) ), ',', 1 ) ) AS `151`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 153 ) ), ',', 1 ) ) AS `152`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 154 ) ), ',', 1 ) ) AS `153`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 155 ) ), ',', 1 ) ) AS `154`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 156 ) ), ',', 1 ) ) AS `155`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 157 ) ), ',', 1 ) ) AS `156`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 158 ) ), ',', 1 ) ) AS `157`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 159 ) ), ',', 1 ) ) AS `158`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 160 ) ), ',', 1 ) ) AS `159`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 161 ) ), ',', 1 ) ) AS `160`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 162 ) ), ',', 1 ) ) AS `161`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 163 ) ), ',', 1 ) ) AS `162`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 164 ) ), ',', 1 ) ) AS `163`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 165 ) ), ',', 1 ) ) AS `164`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 166 ) ), ',', 1 ) ) AS `165`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 167 ) ), ',', 1 ) ) AS `166`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 168 ) ), ',', 1 ) ) AS `167`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 169 ) ), ',', 1 ) ) AS `168`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 170 ) ), ',', 1 ) ) AS `169`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 171 ) ), ',', 1 ) ) AS `170`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 172 ) ), ',', 1 ) ) AS `171`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 173 ) ), ',', 1 ) ) AS `172`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 174 ) ), ',', 1 ) ) AS `173`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 175 ) ), ',', 1 ) ) AS `174`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 176 ) ), ',', 1 ) ) AS `175`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 177 ) ), ',', 1 ) ) AS `176`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 178 ) ), ',', 1 ) ) AS `177`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 179 ) ), ',', 1 ) ) AS `178`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 180 ) ), ',', 1 ) ) AS `179`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 181 ) ), ',', 1 ) ) AS `180`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 182 ) ), ',', 1 ) ) AS `181`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 183 ) ), ',', 1 ) ) AS `182`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 184 ) ), ',', 1 ) ) AS `183`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 185 ) ), ',', 1 ) ) AS `184`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 186 ) ), ',', 1 ) ) AS `185`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 187 ) ), ',', 1 ) ) AS `186`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 188 ) ), ',', 1 ) ) AS `187`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 189 ) ), ',', 1 ) ) AS `188`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 190 ) ), ',', 1 ) ) AS `189`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 191 ) ), ',', 1 ) ) AS `190`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 192 ) ), ',', 1 ) ) AS `191`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 193 ) ), ',', 1 ) ) AS `192`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 194 ) ), ',', 1 ) ) AS `193`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 195 ) ), ',', 1 ) ) AS `194`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 196 ) ), ',', 1 ) ) AS `195`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 197 ) ), ',', 1 ) ) AS `196`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 198 ) ), ',', 1 ) ) AS `197`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 199 ) ), ',', 1 ) ) AS `198`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 200 ) ), ',', 1 ) ) AS `199`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 201 ) ), ',', 1 ) ) AS `200`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 202 ) ), ',', 1 ) ) AS `201`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 203 ) ), ',', 1 ) ) AS `202`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 204 ) ), ',', 1 ) ) AS `203`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 205 ) ), ',', 1 ) ) AS `204`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 206 ) ), ',', 1 ) ) AS `205`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 207 ) ), ',', 1 ) ) AS `206`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 208 ) ), ',', 1 ) ) AS `207`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 209 ) ), ',', 1 ) ) AS `208`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 210 ) ), ',', 1 ) ) AS `209`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 211 ) ), ',', 1 ) ) AS `210`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 212 ) ), ',', 1 ) ) AS `211`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 213 ) ), ',', 1 ) ) AS `212`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 214 ) ), ',', 1 ) ) AS `213`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 215 ) ), ',', 1 ) ) AS `214`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 216 ) ), ',', 1 ) ) AS `215`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 217 ) ), ',', 1 ) ) AS `216`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 218 ) ), ',', 1 ) ) AS `217`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 219 ) ), ',', 1 ) ) AS `218`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 220 ) ), ',', 1 ) ) AS `219`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 221 ) ), ',', 1 ) ) AS `220`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 222 ) ), ',', 1 ) ) AS `221`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 223 ) ), ',', 1 ) ) AS `222`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 224 ) ), ',', 1 ) ) AS `223`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 225 ) ), ',', 1 ) ) AS `224`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 226 ) ), ',', 1 ) ) AS `225`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 227 ) ), ',', 1 ) ) AS `226`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 228 ) ), ',', 1 ) ) AS `227`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 229 ) ), ',', 1 ) ) AS `228`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 230 ) ), ',', 1 ) ) AS `229`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 231 ) ), ',', 1 ) ) AS `230`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 232 ) ), ',', 1 ) ) AS `231`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 233 ) ), ',', 1 ) ) AS `232`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 234 ) ), ',', 1 ) ) AS `233`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 235 ) ), ',', 1 ) ) AS `234`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 236 ) ), ',', 1 ) ) AS `235`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 237 ) ), ',', 1 ) ) AS `236`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 238 ) ), ',', 1 ) ) AS `237`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 239 ) ), ',', 1 ) ) AS `238`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 240 ) ), ',', 1 ) ) AS `239`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 241 ) ), ',', 1 ) ) AS `240`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 242 ) ), ',', 1 ) ) AS `241`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 243 ) ), ',', 1 ) ) AS `242`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 244 ) ), ',', 1 ) ) AS `243`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 245 ) ), ',', 1 ) ) AS `244`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 246 ) ), ',', 1 ) ) AS `245`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 247 ) ), ',', 1 ) ) AS `246`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 248 ) ), ',', 1 ) ) AS `247`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 249 ) ), ',', 1 ) ) AS `248`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 250 ) ), ',', 1 ) ) AS `249`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 251 ) ), ',', 1 ) ) AS `250`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 252 ) ), ',', 1 ) ) AS `251`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 253 ) ), ',', 1 ) ) AS `252`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 254 ) ), ',', 1 ) ) AS `253`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 255 ) ), ',', 1 ) ) AS `254`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 256 ) ), ',', 1 ) ) AS `255`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 257 ) ), ',', 1 ) ) AS `256`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 258 ) ), ',', 1 ) ) AS `257`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 259 ) ), ',', 1 ) ) AS `258`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 260 ) ), ',', 1 ) ) AS `259`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 261 ) ), ',', 1 ) ) AS `260`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 262 ) ), ',', 1 ) ) AS `261`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 263 ) ), ',', 1 ) ) AS `262`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 264 ) ), ',', 1 ) ) AS `263`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 265 ) ), ',', 1 ) ) AS `264`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 266 ) ), ',', 1 ) ) AS `265`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 267 ) ), ',', 1 ) ) AS `266`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 268 ) ), ',', 1 ) ) AS `267`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 269 ) ), ',', 1 ) ) AS `268`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 270 ) ), ',', 1 ) ) AS `269`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 271 ) ), ',', 1 ) ) AS `270`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 272 ) ), ',', 1 ) ) AS `271`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 273 ) ), ',', 1 ) ) AS `272`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 274 ) ), ',', 1 ) ) AS `273`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 275 ) ), ',', 1 ) ) AS `274`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 276 ) ), ',', 1 ) ) AS `275`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 277 ) ), ',', 1 ) ) AS `276`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 278 ) ), ',', 1 ) ) AS `277`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 279 ) ), ',', 1 ) ) AS `278`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 280 ) ), ',', 1 ) ) AS `279`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 281 ) ), ',', 1 ) ) AS `280`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 282 ) ), ',', 1 ) ) AS `281`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 283 ) ), ',', 1 ) ) AS `282`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 284 ) ), ',', 1 ) ) AS `283`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 285 ) ), ',', 1 ) ) AS `284`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 286 ) ), ',', 1 ) ) AS `285`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 287 ) ), ',', 1 ) ) AS `286`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 288 ) ), ',', 1 ) ) AS `287`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 289 ) ), ',', 1 ) ) AS `288`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 290 ) ), ',', 1 ) ) AS `289`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 291 ) ), ',', 1 ) ) AS `290`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 292 ) ), ',', 1 ) ) AS `291`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 293 ) ), ',', 1 ) ) AS `292`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 294 ) ), ',', 1 ) ) AS `293`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 295 ) ), ',', 1 ) ) AS `294`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 296 ) ), ',', 1 ) ) AS `295`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 297 ) ), ',', 1 ) ) AS `296`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 298 ) ), ',', 1 ) ) AS `297`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 299 ) ), ',', 1 ) ) AS `298`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 300 ) ), ',', 1 ) ) AS `299`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 301 ) ), ',', 1 ) ) AS `300`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 302 ) ), ',', 1 ) ) AS `301`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 303 ) ), ',', 1 ) ) AS `302`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 304 ) ), ',', 1 ) ) AS `303`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 305 ) ), ',', 1 ) ) AS `304`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 306 ) ), ',', 1 ) ) AS `305`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 307 ) ), ',', 1 ) ) AS `306`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 308 ) ), ',', 1 ) ) AS `307`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 309 ) ), ',', 1 ) ) AS `308`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 310 ) ), ',', 1 ) ) AS `309`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 311 ) ), ',', 1 ) ) AS `310`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 312 ) ), ',', 1 ) ) AS `311`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 313 ) ), ',', 1 ) ) AS `312`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 314 ) ), ',', 1 ) ) AS `313`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 315 ) ), ',', 1 ) ) AS `314`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 316 ) ), ',', 1 ) ) AS `315`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 317 ) ), ',', 1 ) ) AS `316`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 318 ) ), ',', 1 ) ) AS `317`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 319 ) ), ',', 1 ) ) AS `318`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 320 ) ), ',', 1 ) ) AS `319`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 321 ) ), ',', 1 ) ) AS `320`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 322 ) ), ',', 1 ) ) AS `321`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 323 ) ), ',', 1 ) ) AS `322`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 324 ) ), ',', 1 ) ) AS `323`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 325 ) ), ',', 1 ) ) AS `324`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 326 ) ), ',', 1 ) ) AS `325`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 327 ) ), ',', 1 ) ) AS `326`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 328 ) ), ',', 1 ) ) AS `327`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 329 ) ), ',', 1 ) ) AS `328`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 330 ) ), ',', 1 ) ) AS `329`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 331 ) ), ',', 1 ) ) AS `330`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 332 ) ), ',', 1 ) ) AS `331`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 333 ) ), ',', 1 ) ) AS `332`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 334 ) ), ',', 1 ) ) AS `333`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 335 ) ), ',', 1 ) ) AS `334`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 336 ) ), ',', 1 ) ) AS `335`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 337 ) ), ',', 1 ) ) AS `336`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 338 ) ), ',', 1 ) ) AS `337`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 339 ) ), ',', 1 ) ) AS `338`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 340 ) ), ',', 1 ) ) AS `339`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 341 ) ), ',', 1 ) ) AS `340`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 342 ) ), ',', 1 ) ) AS `341`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 343 ) ), ',', 1 ) ) AS `342`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 344 ) ), ',', 1 ) ) AS `343`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 345 ) ), ',', 1 ) ) AS `344`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 346 ) ), ',', 1 ) ) AS `345`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 347 ) ), ',', 1 ) ) AS `346`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 348 ) ), ',', 1 ) ) AS `347`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 349 ) ), ',', 1 ) ) AS `348`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 350 ) ), ',', 1 ) ) AS `349`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 351 ) ), ',', 1 ) ) AS `350`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 352 ) ), ',', 1 ) ) AS `351`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 353 ) ), ',', 1 ) ) AS `352`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 354 ) ), ',', 1 ) ) AS `353`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 355 ) ), ',', 1 ) ) AS `354`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 356 ) ), ',', 1 ) ) AS `355`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 357 ) ), ',', 1 ) ) AS `356`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 358 ) ), ',', 1 ) ) AS `357`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 359 ) ), ',', 1 ) ) AS `358`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 360 ) ), ',', 1 ) ) AS `359`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 361 ) ), ',', 1 ) ) AS `360`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 362 ) ), ',', 1 ) ) AS `361`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 363 ) ), ',', 1 ) ) AS `362`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 364 ) ), ',', 1 ) ) AS `363`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 365 ) ), ',', 1 ) ) AS `364`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 366 ) ), ',', 1 ) ) AS `365`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 367 ) ), ',', 1 ) ) AS `366`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 368 ) ), ',', 1 ) ) AS `367`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 369 ) ), ',', 1 ) ) AS `368`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 370 ) ), ',', 1 ) ) AS `369`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 371 ) ), ',', 1 ) ) AS `370`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 372 ) ), ',', 1 ) ) AS `371`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 373 ) ), ',', 1 ) ) AS `372`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 374 ) ), ',', 1 ) ) AS `373`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 375 ) ), ',', 1 ) ) AS `374`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 376 ) ), ',', 1 ) ) AS `375`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 377 ) ), ',', 1 ) ) AS `376`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 378 ) ), ',', 1 ) ) AS `377`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 379 ) ), ',', 1 ) ) AS `378`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 380 ) ), ',', 1 ) ) AS `379`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 381 ) ), ',', 1 ) ) AS `380`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 382 ) ), ',', 1 ) ) AS `381`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 383 ) ), ',', 1 ) ) AS `382`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 384 ) ), ',', 1 ) ) AS `383`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 385 ) ), ',', 1 ) ) AS `384`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 386 ) ), ',', 1 ) ) AS `385`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 387 ) ), ',', 1 ) ) AS `386`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 388 ) ), ',', 1 ) ) AS `387`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 389 ) ), ',', 1 ) ) AS `388`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 390 ) ), ',', 1 ) ) AS `389`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 391 ) ), ',', 1 ) ) AS `390`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 392 ) ), ',', 1 ) ) AS `391`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 393 ) ), ',', 1 ) ) AS `392`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 394 ) ), ',', 1 ) ) AS `393`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 395 ) ), ',', 1 ) ) AS `394`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 396 ) ), ',', 1 ) ) AS `395`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 397 ) ), ',', 1 ) ) AS `396`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 398 ) ), ',', 1 ) ) AS `397`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 399 ) ), ',', 1 ) ) AS `398`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 400 ) ), ',', 1 ) ) AS `399`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 401 ) ), ',', 1 ) ) AS `400`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 402 ) ), ',', 1 ) ) AS `401`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 403 ) ), ',', 1 ) ) AS `402`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 404 ) ), ',', 1 ) ) AS `403`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 405 ) ), ',', 1 ) ) AS `404`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 406 ) ), ',', 1 ) ) AS `405`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 407 ) ), ',', 1 ) ) AS `406`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 408 ) ), ',', 1 ) ) AS `407`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 409 ) ), ',', 1 ) ) AS `408`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 410 ) ), ',', 1 ) ) AS `409`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 411 ) ), ',', 1 ) ) AS `410`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 412 ) ), ',', 1 ) ) AS `411`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 413 ) ), ',', 1 ) ) AS `412`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 414 ) ), ',', 1 ) ) AS `413`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 415 ) ), ',', 1 ) ) AS `414`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 416 ) ), ',', 1 ) ) AS `415`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 417 ) ), ',', 1 ) ) AS `416`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 418 ) ), ',', 1 ) ) AS `417`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 419 ) ), ',', 1 ) ) AS `418`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 420 ) ), ',', 1 ) ) AS `419`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 421 ) ), ',', 1 ) ) AS `420`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 422 ) ), ',', 1 ) ) AS `421`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 423 ) ), ',', 1 ) ) AS `422`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 424 ) ), ',', 1 ) ) AS `423`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 425 ) ), ',', 1 ) ) AS `424`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 426 ) ), ',', 1 ) ) AS `425`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 427 ) ), ',', 1 ) ) AS `426`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 428 ) ), ',', 1 ) ) AS `427`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 429 ) ), ',', 1 ) ) AS `428`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 430 ) ), ',', 1 ) ) AS `429`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 431 ) ), ',', 1 ) ) AS `430`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 432 ) ), ',', 1 ) ) AS `431`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 433 ) ), ',', 1 ) ) AS `432`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 434 ) ), ',', 1 ) ) AS `433`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 435 ) ), ',', 1 ) ) AS `434`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 436 ) ), ',', 1 ) ) AS `435`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 437 ) ), ',', 1 ) ) AS `436`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 438 ) ), ',', 1 ) ) AS `437`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 439 ) ), ',', 1 ) ) AS `438`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 440 ) ), ',', 1 ) ) AS `439`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 441 ) ), ',', 1 ) ) AS `440`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 442 ) ), ',', 1 ) ) AS `441`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 443 ) ), ',', 1 ) ) AS `442`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 444 ) ), ',', 1 ) ) AS `443`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 445 ) ), ',', 1 ) ) AS `444`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 446 ) ), ',', 1 ) ) AS `445`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 447 ) ), ',', 1 ) ) AS `446`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 448 ) ), ',', 1 ) ) AS `447`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 449 ) ), ',', 1 ) ) AS `448`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 450 ) ), ',', 1 ) ) AS `449`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 451 ) ), ',', 1 ) ) AS `450`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 452 ) ), ',', 1 ) ) AS `451`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 453 ) ), ',', 1 ) ) AS `452`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 454 ) ), ',', 1 ) ) AS `453`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 455 ) ), ',', 1 ) ) AS `454`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 456 ) ), ',', 1 ) ) AS `455`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 457 ) ), ',', 1 ) ) AS `456`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 458 ) ), ',', 1 ) ) AS `457`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 459 ) ), ',', 1 ) ) AS `458`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 460 ) ), ',', 1 ) ) AS `459`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 461 ) ), ',', 1 ) ) AS `460`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 462 ) ), ',', 1 ) ) AS `461`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 463 ) ), ',', 1 ) ) AS `462`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 464 ) ), ',', 1 ) ) AS `463`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 465 ) ), ',', 1 ) ) AS `464`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 466 ) ), ',', 1 ) ) AS `465`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 467 ) ), ',', 1 ) ) AS `466`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 468 ) ), ',', 1 ) ) AS `467`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 469 ) ), ',', 1 ) ) AS `468`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 470 ) ), ',', 1 ) ) AS `469`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 471 ) ), ',', 1 ) ) AS `470`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 472 ) ), ',', 1 ) ) AS `471`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 473 ) ), ',', 1 ) ) AS `472`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 474 ) ), ',', 1 ) ) AS `473`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 475 ) ), ',', 1 ) ) AS `474`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 476 ) ), ',', 1 ) ) AS `475`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 477 ) ), ',', 1 ) ) AS `476`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 478 ) ), ',', 1 ) ) AS `477`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 479 ) ), ',', 1 ) ) AS `478`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 480 ) ), ',', 1 ) ) AS `479`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 481 ) ), ',', 1 ) ) AS `480`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 482 ) ), ',', 1 ) ) AS `481`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 483 ) ), ',', 1 ) ) AS `482`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 484 ) ), ',', 1 ) ) AS `483`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 485 ) ), ',', 1 ) ) AS `484`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 486 ) ), ',', 1 ) ) AS `485`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 487 ) ), ',', 1 ) ) AS `486`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 488 ) ), ',', 1 ) ) AS `487`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 489 ) ), ',', 1 ) ) AS `488`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 490 ) ), ',', 1 ) ) AS `489`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 491 ) ), ',', 1 ) ) AS `490`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 492 ) ), ',', 1 ) ) AS `491`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 493 ) ), ',', 1 ) ) AS `492`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 494 ) ), ',', 1 ) ) AS `493`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 495 ) ), ',', 1 ) ) AS `494`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 496 ) ), ',', 1 ) ) AS `495`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 497 ) ), ',', 1 ) ) AS `496`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 498 ) ), ',', 1 ) ) AS `497`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 499 ) ), ',', 1 ) ) AS `498`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 500 ) ), ',', 1 ) ) AS `499`, REVERSE( SUBSTRING_INDEX( REVERSE( SUBSTRING_INDEX( `Druckerliste`, ', ', 501 ) ), ',', 1 ) ) AS `500` FROM (SELECT DISTINCT CONCAT( `Artikelnummer`, ', ', REPLACE( `Druckerzuordnung`, '\n', ', ' ), ',' ) AS `Druckerliste` FROM { OJ `db`.`artikel_info` AS `artikel_info` LEFT OUTER JOIN `db`.`druckerzuordnung` AS `druckerzuordnung` ON `artikel_info`.`TSArtNr` = `druckerzuordnung`.`ATT1N` }) AS `qrydruckerliste`;"
SQL_Anweisung.executeUpdate (Sql)
msgbox("Tabelle tmp1 wurde neu befüllt")

Aloha

Poste mal Den überarbeiteten Code - "Query was empty" kann auch schon durch einen Fehler im Zusammensetzen des SQL-Strings innerhalb des Makros hervorgerufen werden.

Danke für den Link.
Hab meinen Code gleich entsprechend angepasst.

Leider tritt der Fehler noch immer auf

Ja, anstatt ".execute(sSQL)" ".executeUpdate (sSQL)" verwenden!Lies hier:http://www.ooowiki.de/BaseApi#Update-Anweisungen
Hilft's?

Hallo zusammen,
ich habe folgenden Code in meinem Makro:

Dim oStatement As Object, oDatenbankKontext As Object, oDatenquelle As Object
Dim oVerbindung As Object
Dim sSQL As String
oDatenbankKontext = CreateUnoService ( "com.sun.star.sdb.DatabaseContext" )
oDatenquelle = oDatenbankKontext.getByName( "Datenbankname" )
oVerbindung = oDatenquelle.getConnection("Benutzername","Passwort")
MsgBox " DB-Verbindung besteht"

oStatement = oVerbindung.createStatement()

sSQL = "sSQL = "INSERT INTO `tmp1` (`Artnr`, `1`,`2`......"
oStatement.execute(sSQL)

Beim Ausführen der SQL-Abfrage erhalte ich folgenden Fehler:
Basic Laufzeitfehler.
Es ist eine Exception aufgetreten
Type: com.sun.star.sdbc.SQLException
Message: Query was empty

Der Code der SQL-Abfrage ist im SQL-Browser von Base ausführbar und kann somit nicht falsch sein.

Hat jemand eine Idee, woran das liegen kann?