Czech Wikipedia articles last edited more than 10 years ago

Fork of Czech Wikipedia articles edited in the last year by Blahma

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

SQL

SELECT page_title, rev_timestamp, pp_propname FROM page JOIN revision ON page_latest = rev_id LEFT JOIN page_props ON page_id = pp_page AND pp_propname = 'disambiguation' WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_timestamp < '20120615100500' ORDER BY rev_timestamp

AخA
 
SELECT page_title, rev_timestamp, pp_propname FROM page JOIN revision ON page_latest = rev_id LEFT JOIN page_props ON page_id = pp_page AND pp_propname = 'disambiguation' WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_timestamp < '20120615100500' ORDER BY rev_timestamp

SQL

Checking query status...