Untitled query #68205

SQL

SELECT
  page_title,
  STR_TO_DATE(LEFT(MIN(rev_timestamp), 8), '%Y%m%d'),
  COUNT(ll_lang)
FROM page
JOIN category
  ON page_title = cat_title
JOIN revision
  ON rev_page = page_id
  AND rev_parent_id = 0
LEFT JOIN categorylinks
  ON page_title = cl_to
LEFT JOIN templatelinks
  ON tl_from = page_id
LEFT JOIN linktarget
  ON tl_target_id = lt_id
  AND lt_title IN (
    'رده_خالی',
    'رده_بهتر',
    'رده_ابهام‌زدایی',
    'رده_ردیابی‌کردن',
    'رده_ردیابی_کردن',
    'رده_ردیابی'
  )
LEFT JOIN langlinks
  ON page_id = ll_from
WHERE
  page_namespace = 14
  AND page_is_redirect = 0
  AND cl_to IS NULL
  AND tl_target_id IS NULL
GROUP BY
  page_title,
  rev_timestamp
ORDER BY
 COUNT(ll_lang),
 page_title
LIMIT 5000
SQL

Checking query status...
