Benutzer:Mst/Kurze Artikel (Musikglossar)
aus Wikipedia, der freien Enzyklopädie
enthält kurze Artikel in Kategorie:Musikglossar
SQL-Abfrage
SELECT CONCAT('[[',cur_title,']]') AS Artikel,
CONCAT(LENGTH(cur_text),' Bytes') AS Laenge,
CONCAT(' ') AS Bearbeitungshinweis
FROM cur, categorylinks
WHERE cur_is_redirect = 0
AND cl_from=cur_id
AND cur_namespace = 0
AND LENGTH(cur_text) < 501
AND (cl_to='Musikglossar' OR cl_to='Sachlexikon Klassische Musik' OR cl_to='Stimmlage')
AND cur_title NOT REGEXP '/[A-Z]$'
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 '%{{Begriffskl__rung}}%'
AND cur_text NOT LIKE '%{{URV%'
AND cur_text NOT LIKE '%{{L__schen%'
AND cur_text NOT LIKE '%{{Zu_L__schen%'
AND cur_text NOT LIKE '%{{Vorlage:Zu_L__schen%'
AND cur_text NOT LIKE '%Falschschreibung%'
AND cur_text NOT LIKE '{{Wiktionary%'
ORDER BY LENGTH(cur_text) ASC, cur_timestamp ASC
LIMIT 100
Dump vom 13.07.2005, Abfrage am 2.9.2005 ausgeführt.
| Artikel | Laenge | Bearbeitungshinweis |
|---|---|---|
| Notentext | 236 Bytes | |
| Aftertouch | 268 Bytes | |
| Kantilene | 283 Bytes | |
| Colla_parte | 297 Bytes | |
| Fistelstimme | 301 Bytes | |
| Multiphonic | 387 Bytes | |
| Delay_(Musik) | 407 Bytes | |
| Timestretching | 410 Bytes | |
| Koloratur | 428 Bytes | |
| Altus_(Stimmlage) | 435 Bytes | |
| Cantus | 437 Bytes | |
| Vokalise | 456 Bytes | |
| Dal_Segno | 458 Bytes | |
| Col_legno | 461 Bytes | |
| Particell | 479 Bytes |
