This query is marked as a draft This query has been published by Elph.

SQL

x
 
USE arwiki_p;
SELECT mp.page_title AS t, rev_user_text,
       TIMESTAMP((SELECT rev_timestamp 
                  FROM   revision 
                  WHERE  rev_id = mp.page_latest))                     AS ts,
                  (SELECT COUNT(*) from revision where rev_page=mp.page_id) as ec
FROM   page as mp 
WHERE  mp.page_is_redirect = 0 
       AND mp.page_namespace = 0
       AND mp.page_title NOT LIKE "%(توضيح)%"
       AND mp.page_latest < (SELECT rev_id FROM   revision WHERE rev_timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 2 YEAR)  LIMIT  1)
JOIN revision ON rev_id = mp.page_latest
WHERE rev_user NOT IN (SELECT user_name FROM user_groups  INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')                                         
                          
 order by ts asc LIMIT 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...