SQL
x
SELECT p.page_title
FROM page AS p
INNER JOIN revision_userindex AS r ON p.page_id = r.rev_page
INNER JOIN templatelinks ON p.page_id = templatelinks.tl_from
INNER JOIN linktarget ON templatelinks.tl_target_id = linktarget.lt_id
WHERE p.page_is_redirect = 0
AND p.page_namespace = 0
AND linktarget.lt_title NOT LIKE "لا_للأخطاء_الإملائية"
AND r.rev_timestamp < DATE_SUB(NOW(), INTERVAL 10 HOUR)
GROUP BY p.page_title
ORDER BY r.rev_timestamp DESC
LIMIT 5000
OFFSET 0;
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.