Benutzer:Peterlustig/Personenartikell
aus Wikipedia, der freien Enzyklopädie
mysql dewiki_p -B -e "
SELECT CONCAT('|-|', '[[',page.page_title,']] || ')
FROM page, (SELECT categorylinks.cl_from AS kat_id, Count(*) AS Anzahl
FROM categorylinks, (SELECT cl_from
FROM categorylinks
WHERE cl_to IN ('Mann', 'Frau')) AS ArtikelID
WHERE
categorylinks.cl_from = ArtikelID.cl_from
GROUP BY categorylinks.cl_from HAVING Count(*) < 2) AS KategorieID
WHERE
page.page_id = KategorieID.kat_id
LIMIT 5000;
"
