SQL
AخA
# recent bewerkte artikelen die niet genomineerd zijn en ouder dan 24 uur
SELECT DISTINCT page_id, page_title, rev_timestamp
FROM recentchanges, page, revision
WHERE
page_id=rc_cur_id AND
page_namespace=0 AND
page_is_redirect=0 AND
NOT EXISTS (
SELECT *
FROM page_props
WHERE page_id=pp_page AND pp_propname='disambiguation'
) AND
NOT EXISTS (
SELECT *
FROM categorylinks
WHERE page_id=cl_from AND cl_to REGEXP '^Wikipedia:(Verwijderbaar/[0-9]{2}|Nog_niet_gereed|Nuweg)$'
) AND
page_id=rev_page AND
rev_parent_id=0 /*AND
UNIX_TIMESTAMP(NOW()-STR_TO_DATE(rev_timestamp,'%Y%m%d%H%i%s'))>86400
ORDER BY rev_timestamp*/
LIMIT 50
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.