USE dewiki_p;

SELECT CONCAT('# [[:', pl.pl_title, ']] <small>(', COUNT(pl.pl_from), ' Links)</small>')

FROM pagelinks pl

INNER JOIN page p ON (p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace)

INNER JOIN categorylinks cl ON (cl.cl_from = p.page_id)

WHERE cl.cl_to = 'Begriffsklärung'

AND p.page_namespace = 0

AND cl.cl_timestamp >= DATE(NOW()) - INTERVAL 5 DAY

WHERE pl.pl_namespace = 0

AND pl.pl_from_namespace = 0

HAVING COUNT(pl.pl_from) >= 5

GROUP BY pl.pl_title

ORDER BY COUNT(pl.pl_from) DESC