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

SQL

AخA
 
USE arwiki_p; 
SELECT
        MAX(rev_timestamp) AS lastedit, COUNT(rev_id) AS editcount, page_title
FROM revision ,
        (SELECT rev_timestamp as lastedit,page_id,page_title FROM page,revision
        WHERE   page_id IN
          
                (SELECT page_id FROM page WHERE page_namespace = 0 AND page_is_redirect = 0 AND
                 NOT EXISTS ( SELECT page_title FROM page WHERE page_title LIKE '%توضيح%' )
             )
               
        AND rev_id=page_latest ORDER BY lastedit ASC LIMIT 10 ) as InnerQuery
WHERE rev_page=page_id and lastedit < 20181108235959 GROUP BY page_id ORDER BY lastedit ASC;
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...