Benutzer:Peterlustig/Test
SELECT CONCAT('|-| ',cur_title,' || ', LENGTH(cur_text),' Bytes || ')
FROM cur
WHERE cur_is_redirect = 0
AND cur_namespace = 0
AND LENGTH(cur_text) < 210
AND cur_title NOT LIKE '%/Zahl'
AND cur_title NOT LIKE '%/0-9'
AND cur_title NOT LIKE 'Liste_%'
AND cur_title NOT LIKE 'Fotoglossar/%'
AND cur_text NOT LIKE '%Begriffsklaerung%'
AND cur_text NOT LIKE '%Begriffsklärung%'
AND cur_text NOT LIKE '%BegriffsklÀrung%'
AND cur_text NOT LIKE '%URV%'
AND cur_text NOT LIKE '%Falschschreibung%'
AND cur_text NOT LIKE '{{Wiktionary%'
ORDER BY LENGTH(cur_text) ASC, cur_timestamp ASC
LIMIT 300;
ergibt:
+----------------------------------------------------------------------+
| CONCAT('|-| ',cur_title,' || ', LENGTH(cur_text),' Bytes || ') |
+----------------------------------------------------------------------+
| |-| Jen || 0 Bytes || |
| |-| Marburger_Convent || 0 Bytes || |
| |-| Carlos_Gardel || 0 Bytes || |
| |-| Kannstadt || 0 Bytes || |
| |-| Foerdergemeinschaft_Graf_von_Lahnstein || 0 Bytes || |
| |-| Cherry_Gehring || 0 Bytes || |
| |-| Martin_Ansel || 0 Bytes || |
| |-| Martin_Stöck || 0 Bytes || |
| |-| Chassiten || 4 Bytes || |
| |-| Robert_Delaunay || 11 Bytes || |
| |-| Hans_Reiser || 20 Bytes || |
| |-| Sol_Le_Witt || 23 Bytes || |
| |-| Minimal_Art || 25 Bytes || |
| |-| Oude_Rijn || 25 Bytes || |
| |-| Finismus || 26 Bytes || |
| |-| Apfeltasche || 27 Bytes || |
| |-| León_(Guanajuato) || 29 Bytes || |
| |-| Cabaret_voltaire || 29 Bytes || |
| |-| Bouncing_Souls || 30 Bytes || |
| |-| Nominaleinkommen || 44 Bytes || |
| |-| Federico_da_Montefeltro || 48 Bytes || |
| |-| PrÀrogative || 48 Bytes || |
| |-| MUN || 51 Bytes || |
| |-| Bakteriostatisch || 54 Bytes || |
| |-| CorelDraw || 57 Bytes || |
| |-| Millieu || 60 Bytes || |
| |-| MSM || 64 Bytes || |
| |-| PTC || 65 Bytes || |
| |-| Ecclesia || 65 Bytes || |
| |-| Königskobra || 72 Bytes || |
| |-| Budgetrecht || 76 Bytes || |
| |-| Martialisch || 76 Bytes || |
| |-| Alpha-Methylnaphtalin || 82 Bytes || |
| |-| Autosemantik || 82 Bytes || |
| |-| HDL_(Medizin) || 83 Bytes || |
| |-| Papabile || 84 Bytes || |
| |-| Jamestown_(St._Helena) || 85 Bytes || |
| |-| Gesellschafts-Charakter || 86 Bytes || |
| |-| Neuf_Preux || 87 Bytes || |
| |-| Dudelfunk || 90 Bytes || |
| |-| KryosphÀre || 91 Bytes || |
| |-| Saria || 91 Bytes || |
| |-| Waldbau || 93 Bytes || |
| |-| Goes || 95 Bytes || |
| |-| Schaffnerin || 98 Bytes || |
| |-| Beinlinge || 100 Bytes || |
| |-| DFF || 103 Bytes || |
| |-| Eirak || 104 Bytes || |
| |-| Eli || 105 Bytes || |
| |-| Ageism || 106 Bytes || |
| |-| Contract_Electronic_Manufacturer || 106 Bytes || |
| |-| Elefantitis || 107 Bytes || |
| |-| Serverkonzept || 108 Bytes || |
| |-| Whack || 108 Bytes || |
| |-| Trift || 109 Bytes || |
| |-| Shakespeare-Sonette || 109 Bytes || |
| |-| Ziegel || 110 Bytes || |
| |-| Rennweg || 110 Bytes || |
| |-| Schwertknauf || 110 Bytes || |
| |-| Babuschka || 110 Bytes || |
| |-| Zweischneidig || 111 Bytes || |
| |-| Fontana_della_Barcaccia || 113 Bytes || |
| |-| Augenment || 114 Bytes || |
| |-| Jammerhaken || 115 Bytes || |
| |-| Alfen || 116 Bytes || |
| |-| SkrÀlinger || 116 Bytes || |
| |-| Theodore_Maiman || 119 Bytes || |
| |-| Karyogamie || 119 Bytes || |
| |-| Inspiral_Carpets || 120 Bytes || |
| |-| Freshman || 120 Bytes || |
| |-| Simmel || 120 Bytes || |
| |-| Citroën_C5 || 120 Bytes || |
| |-| Sophomore || 121 Bytes || |
| |-| Eriekanal || 121 Bytes || |
| |-| Studiotechnik || 122 Bytes || |
| |-| Albright || 122 Bytes || |
| |-| LÀngsee || 122 Bytes || |
| |-| Aphonie || 123 Bytes || |
| |-| Subliminal || 123 Bytes || |
| |-| NÃŒstern || 123 Bytes || |
| |-| Felicitas_(Vorname) || 125 Bytes || |
| |-| Postsynaptisch || 126 Bytes || |
| |-| Stabwerk || 127 Bytes || |
| |-| Portal_American_Football/Archiv_Artikelliste || 128 Bytes || |
| |-| Molybdat || 128 Bytes || |
| |-| RAM-DAC || 130 Bytes || |
| |-| Hybridrechner || 131 Bytes || |
| |-| Nettorealeinkommen || 132 Bytes || |
| |-| Aufpflanzen || 132 Bytes || |
| |-| Kaldorf || 136 Bytes || |
| |-| Republikanische_Garde || 136 Bytes || |
| |-| Bab_Al_Mandab || 137 Bytes || |
| |-| Moquegua_(Stadt) || 137 Bytes || |
| |-| Fortschrittliche_BÃŒrgerpartei_in_Liechtenstein || 138 Bytes || |
| |-| Wonderwall || 139 Bytes || |
| |-| Infras || 139 Bytes || |
| |-| Leobendorf || 140 Bytes || |
| |-| Seeoner_See || 141 Bytes || |
| |-| Obergrenzebach || 143 Bytes || |
| |-| Scratching || 143 Bytes || |
| |-| Portal_SÃŒdtirol/Review || 143 Bytes || |
| |-| Ilam || 145 Bytes || |
| |-| IMS || 145 Bytes || |
| |-| Xuzhou || 145 Bytes || |
| |-| Brouche || 146 Bytes || |
| |-| Alpenslawen || 147 Bytes || |
| |-| World_Association_of_Kickboxing_Organization || 147 Bytes || |
| |-| Ruhrhalbinsel_(Essen) || 148 Bytes || |
| |-| Bel_Ami || 148 Bytes || |
| |-| Erstsemestler || 148 Bytes || |
| |-| Niederbieber || 150 Bytes || |
| |-| Salzhausen || 150 Bytes || |
| |-| Linqing || 150 Bytes || |
| |-| Gautschbrief || 151 Bytes || |
| |-| Tigon || 152 Bytes || |
| |-| Mimas_(Mythologie) || 152 Bytes || |
| |-| Salzwoog || 152 Bytes || |
| |-| Carlyle_Group || 152 Bytes || |
| |-| Index_(Semiotik) || 153 Bytes || |
| |-| Lianyungang || 153 Bytes || |
| |-| Haltitunturi || 153 Bytes || |
| |-| Yichang || 155 Bytes || |
| |-| Jining_(Shandong) || 155 Bytes || |
| |-| 23_Skidoo || 156 Bytes || |
| |-| Mischkristall || 157 Bytes || |
| |-| Road_Town || 157 Bytes || |
| |-| Penki || 158 Bytes || |
| |-| Narfi || 158 Bytes || |
| |-| Rift || 159 Bytes || |
| |-| Kolonialregierung || 161 Bytes || |
| |-| Karnofsky || 161 Bytes || |
| |-| VSA-100 || 162 Bytes || |
| |-| NÀchstebreck || 163 Bytes || |
| |-| Annahme_(Recht) || 163 Bytes || |
| |-| Katechumene || 164 Bytes || |
| |-| Schellekattel || 164 Bytes || |
| |-| Brohmer_Berge || 165 Bytes || |
| |-| Wolframat || 165 Bytes || |
| |-| Etalon || 165 Bytes || |
| |-| Lulubi || 166 Bytes || |
| |-| Ãlpumpe || 167 Bytes || |
| |-| Herrgottswinkel || 169 Bytes || |
| |-| Regulationsprotein || 170 Bytes || |
| |-| Navet || 170 Bytes || |
| |-| Tai'an || 170 Bytes || |
| |-| Hamburger_Hochbahn_AG || 171 Bytes || |
| |-| Bandalier || 171 Bytes || |
| |-| George_Town || 171 Bytes || |
| |-| Erbfeind || 172 Bytes || |
| |-| Ãsterreichische_Rundfunksender_GmbH || 172 Bytes || |
| |-| Transitfrequenz || 174 Bytes || |
| |-| Sun_Yee_On || 174 Bytes || |
| |-| Good_Clean_Fun || 174 Bytes || |
| |-| Tigerenten_Club || 175 Bytes || |
| |-| Sankt_Augustin-Menden || 175 Bytes || |
| |-| Luohe || 175 Bytes || |
| |-| Ramush_Haradinaj || 176 Bytes || |
| |-| BÃŒhlertalbahn || 176 Bytes || |
| |-| Komplize || 177 Bytes || |
| |-| Binsenweisheit || 177 Bytes || |
| |-| Nominatform || 177 Bytes || |
| |-| Obligatorische_Krankenpflegeversicherung || 178 Bytes || |
| |-| Kredentialismus || 178 Bytes || |
| |-| Artaios || 179 Bytes || |
| |-| KokoÄak || 179 Bytes || |
| |-| Belastung_(Psychologie) || 179 Bytes || |
| |-| Strapse || 181 Bytes || |
| |-| YACC || 181 Bytes || |
| |-| Coltrane || 181 Bytes || |
| |-| Neubrandenburg-Katharinenviertel || 181 Bytes || |
| |-| Milawanda || 182 Bytes || |
| |-| Anyang || 182 Bytes || |
| |-| Andrés_RodrÃguez || 182 Bytes || |
| |-| Eprocurement || 182 Bytes || |
| |-| Zweierkette || 183 Bytes || |
| |-| Kodak_FlashPix || 183 Bytes || |
| |-| Stahlgewitter_(Band) || 183 Bytes || |
| |-| Portal_SÌdtirol/NaturdenkmÀler || 183 Bytes || |
| |-| Tensegrity_(Castaneda) || 183 Bytes || |
| |-| Mark_Tavassol || 184 Bytes || |
| |-| Antiport || 184 Bytes || |
| |-| Verformung || 185 Bytes || |
| |-| Buchweizen_(Gattung) || 185 Bytes || |
| |-| Nanchong || 185 Bytes || |
| |-| Elicitor || 186 Bytes || |
| |-| Choroplethenkarte || 186 Bytes || |
| |-| Riesenmagnetowiderstand || 186 Bytes || |
| |-| Yalca || 187 Bytes || |
| |-| Harold_Whaley_Brown || 187 Bytes || |
| |-| Wambra || 188 Bytes || |
| |-| Kalundura || 188 Bytes || |
| |-| Bashkim_Fino || 188 Bytes || |
| |-| Erasable_Digital_Optical_Disc || 189 Bytes || |
| |-| Gottfried_Haberler || 189 Bytes || |
| |-| Challiho || 190 Bytes || |
| |-| Reetsberg || 190 Bytes || |
| |-| Dimap || 190 Bytes || |
| |-| Reprografie || 191 Bytes || |
| |-| Decere || 191 Bytes || |
| |-| BrillenhÀmatom || 191 Bytes || |
| |-| Andreasnacht || 191 Bytes || |
| |-| Santa_Pudenziana || 191 Bytes || |
| |-| Massenheim || 191 Bytes || |
| |-| Die_Götter_und_Ich || 192 Bytes || |
| |-| Zugöse || 193 Bytes || |
| |-| PÃnzio || 193 Bytes || |
| |-| Weberli || 193 Bytes || |
| |-| Anstrich || 193 Bytes || |
| |-| Max_Halbe || 193 Bytes || |
| |-| Fatos_Nano || 193 Bytes || |
| |-| Estimated_Time_of_Sailing || 194 Bytes || |
| |-| Maschinenfabrik_Geipel || 194 Bytes || |
| |-| Cordonata || 194 Bytes || |
| |-| Mournoraki || 194 Bytes || |
| |-| Ideosynkrasie || 194 Bytes || |
| |-| Hans-Jörg_Thomaskamp || 195 Bytes || |
| |-| Interpolation_(Literaturwissenschaft) || 195 Bytes || |
| |-| Heidbrink || 196 Bytes || |
| |-| Pala || 196 Bytes || |
| |-| Kevin_Rafferty || 196 Bytes || |
| |-| Vsat || 196 Bytes || |
| |-| Patriarchalvikar || 197 Bytes || |
| |-| Guo_Xu || 197 Bytes || |
| |-| TransitgebÃŒhr || 197 Bytes || |
| |-| Zacken_(Taunus) || 197 Bytes || |
| |-| Azevo || 197 Bytes || |
| |-| Elementarteilchentheorie || 197 Bytes || |
| |-| Theodor_Hosemann || 197 Bytes || |
| |-| So2-Ãquivalent || 197 Bytes || |
| |-| Jiayugan || 197 Bytes || |
| |-| Portal_Literatur/Vorschlag_zur_Kategorisierung || 198 Bytes || |
| |-| Sorval || 198 Bytes || |
| |-| Cerejo || 198 Bytes || |
| |-| The_Valley || 198 Bytes || |
| |-| Sekonic || 199 Bytes || |
| |-| Battos_III._von_Kyrene || 199 Bytes || |
| |-| BRT_(Dateiformat) || 199 Bytes || |
| |-| Heidenoldendorf || 199 Bytes || |
| |-| Legierungselement || 199 Bytes || |
| |-| Fat_Mike || 199 Bytes || |
| |-| Stiftzahn || 199 Bytes || |
| |-| Frederick_Scott_Archer || 199 Bytes || |
| |-| Verwaltungsgemeinschaft_Beierfeld-GrÃŒnhain || 200 Bytes || |
| |-| Produktpalette || 200 Bytes || |
| |-| Kegelstift || 200 Bytes || |
| |-| Emissionskredit || 200 Bytes || |
| |-| Strahltriebwerke_der_AchsenmÀchte || 200 Bytes || |
| |-| Druckbogen || 200 Bytes || |
| |-| Demons_&_Wizards || 200 Bytes || |
| |-| Béla_III._(Ungarn) || 200 Bytes || |
| |-| Bouncen || 200 Bytes || |
| |-| Schwebstoff || 200 Bytes || |
| |-| Messerschmitt_Me_264 || 200 Bytes || |
| |-| Wieleten || 201 Bytes || |
| |-| Weltrotkreuztag || 201 Bytes || |
| |-| Staffellinie || 201 Bytes || |
| |-| Valbom || 201 Bytes || |
| |-| Lamegal || 201 Bytes || |
| |-| Avancieren || 201 Bytes || |
| |-| Gitterwerk || 201 Bytes || |
| |-| Immaterieller_Vermögensgegenstand || 201 Bytes || |
| |-| SO2-Ãquivalent || 201 Bytes || |
| |-| Auslandsdienst || 202 Bytes || |
| |-| VerbandpÀckchen || 202 Bytes || |
| |-| Opposition_(Daumen) || 202 Bytes || |
| |-| NSO-Komponenten || 202 Bytes || |
| |-| Pomares || 202 Bytes || |
| |-| Bogalhal || 202 Bytes || |
| |-| Roy_F._Harrod || 202 Bytes || |
| |-| Texter || 202 Bytes || |
| |-| Yangzhou || 202 Bytes || |
| |-| Femmes_vocales || 203 Bytes || |
| |-| RÃŒckenflug || 203 Bytes || |
| |-| Vertriebspartner || 203 Bytes || |
| |-| Schlier_(Gestein) || 203 Bytes || |
| |-| Protokooperation || 203 Bytes || |
| |-| Rumelien || 203 Bytes || |
| |-| Rethen_bei_Braunschweig || 203 Bytes || |
| |-| Dichtungskeil || 203 Bytes || |
| |-| Der_Seekadett || 203 Bytes || |
| |-| Ervedosa || 203 Bytes || |
| |-| Lameiras || 203 Bytes || |
| |-| Manigoto || 203 Bytes || |
| |-| Kenai || 203 Bytes || |
| |-| Ãlectricité_de_France || 203 Bytes || |
| |-| Marcus_Garvey || 203 Bytes || |
| |-| RÀuchern_(BegriffsklÀrung) || 204 Bytes || |
| |-| Wohlfahrtsökonomik || 204 Bytes || |
| |-| Materialografie || 204 Bytes || |
| |-| Myopathie || 204 Bytes || |
| |-| Miriam_Krause || 204 Bytes || |
| |-| Spannungsfall || 204 Bytes || |
| |-| Páramo || 204 Bytes || |
| |-| Koralle-Verlag || 204 Bytes || |
| |-| Rosh_Shawish || 204 Bytes || |
| |-| Nivales_Klima || 204 Bytes || |
| |-| Txt || 204 Bytes || |
| |-| Choliambus || 204 Bytes || |
| |-| Berufsgruppe || 204 Bytes || |
| |-| Wiener_(Bier) || 204 Bytes || |
+----------------------------------------------------------------------+
300 rows in set (37 min 30.52 sec)