Untitled query #6830

SQL

USE arwiki_p;

  select page_title,rev_user_text, rev_page, rev_timestamp AS ts, (SELECT COUNT(*) from revision where rev_page=page_id)
  from revision
  join page
  on rev_page = page_id
  where  page_namespace = 0 AND page_is_redirect = 0 AND page_title NOT LIKE "%(توضيح)%"
  AND rev_timestamp < (SELECT rev_id FROM   revision  WHERE  rev_timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 2 YEAR)
     AND rev_user NOT IN  (SELECT user_id FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
            AND rev_user_text NOT IN (SELECT pl_title FROM pagelinks  WHERE pl_from IN
                                (SELECT page_title FROM page WHERE page_namespace = 4 AND page_title LIKE  '%بوتات غير نشطة%')))    
 
ORDER BY ts ASC LIMIT 100;
SQL

Checking query status...
