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.