Untitled query #69759

SQL

SELECT lt.lt_title AS title, COUNT(pl.pl_from) AS count
 FROM pagelinks pl
 INNER JOIN linktarget lt ON (pl.pl_target_id = lt.lt_id)
 INNER JOIN page p ON (p.page_title = lt.lt_title AND p.page_namespace = lt.lt_namespace)
 INNER JOIN categorylinks cl ON (cl.cl_from = p.page_id AND cl.cl_to = 'Begriffsklärung')
 WHERE lt.lt_namespace = 0
 AND pl.pl_from_namespace = 0
 AND cl.cl_timestamp >= DATE(NOW()) - INTERVAL 5 DAY
 GROUP BY lt.lt_title
 HAVING COUNT(pl.pl_from) >= 5
 ORDER BY COUNT(pl.pl_from) DESC
SQL

Checking query status...
