pmp edits (excluding bots) in the last 24 hrs

SQL

USE fawiki_p;
SELECT t.page_title, t.page_len, t.page_id
FROM page AS t
WHERE t.page_namespace  = 1
AND t.page_is_redirect = 0
AND t.page_len > 0

AND t.page_title NOT LIKE "قنات_%"


AND EXISTS (
  SELECT null
  FROM page AS p
  WHERE p.page_namespace = 0
  AND p.page_title = t.page_title
  AND p.page_is_redirect = 1
)

AND t.page_id IN (
  SELECT page_id
  FROM page JOIN templatelinks ON page_id = tl_from
  WHERE tl_from_namespace = 1
  AND tl_title = 'ویکی‌پروژه_نسخه_آفلاین'
  AND tl_namespace = 10
#  AND page_len < 500
  )
  
ORDER BY t.page_len DESC;

SQL

Checking query status...