Untitled query #59776

SQL

SELECT
  page_title,
  rev_timestamp
  COUNT(ll_lang)
FROM page
JOIN category
  ON page_title = cat_title
JOIN revision
  ON rev_page = page_id
  AND rev_parent = 0
LEFT JOIN categorylinks
  ON page_title = cl_to
LEFT JOIN templatelinks
  ON tl_from = page_id
  AND tl_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_title IS NULL
GROUP BY
  page_title,
  rev_timestmap
ORDER BY
 COUNT(ll_lang),
 page_title
LIMIT 5000
SQL

Checking query status...
