Untitled query #69759

SQL

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

Checking query status...
