enthält kurze Artikel in Kategorie:Musiktheorie
SQL-Abfrage
SELECT CONCAT('|-| [[',cur_title,']] || ', LENGTH(cur_text),' Bytes || ')
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='Musiktheorie'
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 1.9.2005 ausgeführt.
| Artikel | Länge | Bearbeitungshinweis |
|---|---|---|
| Notentext | 236 Bytes | |
| Diskantschlüssel | 240 Bytes | |
| Villanella | 260 Bytes | |
| Abgeleiteter_Akkord | 265 Bytes | |
| Staccatissimo | 265 Bytes | |
| Tiefalterieren | 272 Bytes | |
| Tricinium | 292 Bytes | |
| Repercussio | 297 Bytes | |
| Heptachord | 313 Bytes | |
| Srutis | 318 Bytes | |
| Sixte_ajoutée | 326 Bytes | |
| Espressivo | 329 Bytes | |
| Rhythmussektion | 330 Bytes | |
| Taktstrich | 341 Bytes | |
| Phrasierungsbogen | 344 Bytes | |
| Klangkomposition | 369 Bytes | |
| Achtel | 383 Bytes | |
| Gleichtönig | 395 Bytes | |
| Undezime | 395 Bytes | |
| Duodezime | 400 Bytes | |
| Wechseltönig | 402 Bytes | |
| Diminution | 418 Bytes | |
| Ditonus | 428 Bytes | |
| Dezime_(Musik) | 436 Bytes | |
| Engführung | 445 Bytes | |
| Kopfsatz | 449 Bytes | |
| Terzverwandtschaft | 452 Bytes | |
| Ausweichung | 459 Bytes | |
| Apotome | 462 Bytes | |
| Alap | 467 Bytes | |
| Sonatine | 469 Bytes | |
| Melodik | 469 Bytes | |
| Vierklang | 474 Bytes | |
| Krebs_(Musik) | 474 Bytes | |
| Freie_Leittönigkeit | 479 Bytes | |
| Zählzeit | 492 Bytes | |
| Satz_(Komposition) | 500 Bytes |