Untitled query #4274

SQL

USE arwiki_p; 
SELECT
        MAX(rev_timestamp) AS lastedit, COUNT(rev_id) AS editcount, page_title
FROM revision where lastedit < 20181108235959,
        (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 1 FROM page_props WHERE pp_page=page_id AND pp_propname = 'توضيح' )
             )
               
        AND rev_id=page_latest ORDER BY lastedit ASC LIMIT 500 ) as InnerQuery
WHERE rev_page=page_id GROUP BY page_id ORDER BY lastedit ASC;
SQL

Checking query status...
