Q3: Homonyme - Quarry

SQL

USE dewiktionary_p;
SELECT p1.page_title,
count(cl_to),
min(cl_to),
max(cl_to)
FROM page p1
JOIN categorylinks
on cl_from = p1.page_id
and cl_to in ('Substantiv_m_(Deutsch)', 'Substantiv_f_(Deutsch)', 'Substantiv_n_(Deutsch)')
#Following does not work - why not?
#and cl_to regexp '^Substantiv_[mfn]_\(Deutsch\)$'
WHERE p1.page_namespace=0
#and p1.page_title = 'See'
and p1.page_title regexp '^[[:alpha:]][[:lower:]]{4,}$'
and p1.page_id not in
( SELECT page_id from page p2
   join categorylinks cl2
   on cl2.cl_from = p2.page_id
   where p2.page_namespace=0
 and cl2.cl_to in ('Eigenname_(Deutsch)', 'Substantiv_zwei_Genera_(Deutsch)', 'Singularetantum_(Deutsch)') )
#and p1.page_title = 'Falle'
group by p1.page_title
having count(cl_to) >= 2
limit 200
;
SQL

Checking query status...
