-s ohne Genitiv etc.

SQL

USE dewiktionary_p;
SELECT page_title,
cl_to
from page 
join categorylinks
on cl_from = page_id
where page_namespace = 0
and page_title like '%s'
and page_title not like '%\_%'
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%'
and cl_to not like 'Konjugierte%'
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 'Eigenname\_%\_%'
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 'Merkspruch%'
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 '%_adjektiv%'
and cl_to not like 'Schein%'
and cl_to not like 'Schlesisch%'
and cl_to not like '%etantum%'
and cl_to not like 'Sprichwort%'
and cl_to not like '%Wortschatz%'
and cl_to not like 'Übersetzung%'
and cl_to not like 'Wartung%'
and cl_to not like '%Deklination%'
#limit 20
order by page_title, cl_to;
SQL

Checking query status...
