-s ohne Genitiv etc.

SQL

USE dewiktionary_p;
SELECT distinct(cl_to)
from page 
join categorylinks
on cl_from = page_id
where page_namespace = 0
and cl_to like '%(Deutsch)'
and cl_to not like 'Wiktionary%'
and cl_to not like 'Entlehnung%'
and cl_to not like 'Grundformeintrag%'
and cl_to not like 'Rückläufige\_Wörterliste%'
and cl_to not like 'Einträge\_mit\_Endreim%'
and cl_to not like 'Deklinierte\_Form%'
and cl_to not like 'Konjugierte\_Form%'
and cl_to not like 'Alte\_Schreibweise%'
and cl_to not like 'Adjektiv\_%\_%'
and cl_to not like 'Substantiv\_%\_%'
and cl_to not like 'Verb\_%\_%'
and cl_to not like 'Toponym\_%\_%'
and cl_to not like 'Vorname\_%\_%'
and cl_to not like 'Geflügeltes\_Wort%'
and cl_to not like 'Grußformel%'
and cl_to not like 'Redewendung%'
and cl_to not like 'Hilfsverb%'
and cl_to not like '%_pronomen%'
and cl_to not like '%_adverb'
and cl_to not like '%_partikel'
and cl_to not like 'Schein%'
and cl_to not like 'Schlesisch%'
and cl_to not like 'Singularetantum%'
and cl_to not like 'Sprichwort%'
and cl_to not like '%Wortschatz%'
and cl_to not like 'Übersetzung%'

order by cl_to;
SQL

Checking query status...
