Untitled query #68205

SQL

SELECT
  CONCAT('الگو:', lt_title),
  COUNT(*),
  GROUP_CONCAT(
    CONCAT ('[[',p2.page_namespace,':',p2.page_title,']]')
    SEPARATOR "، "
  )
FROM templatelinks
JOIN linktarget
  ON tl_target_id = lt_id
JOIN logging
  ON lt_namespace = log_namespace
  AND lt_title = log_title
  AND log_type = "delete"
JOIN page AS p2
  ON tl_from = p2.page_id
LEFT JOIN page AS p1
  ON p1.page_namespace = lt_namespace
  AND p1.page_title = lt_title
WHERE
  p1.page_id IS NULL
  AND tl_namespace = 10
GROUP BY lt_title
ORDER BY COUNT(*) DESC
LIMIT 1000
SQL

Checking query status...
