-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 'Geflügeltes_Wort%'
and cl_to not like 'Grußformel%'
and cl_to not like 'Hilfsverb%'
and cl_to not like '+pronomen%'
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...
