sysop 2020 temp

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

USE plwiki_p;

(
SELECT 'revision', 7, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7 AND revactor_timestamp < 20160103210248
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7 AND ar_timestamp < 20160103210248
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 8, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 8 AND revactor_timestamp < 20060305233308
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 8, ar_namespace, count(*) FROM archive
WHERE ar_actor = 8 AND ar_timestamp < 20060305233308
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 20, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 20 AND revactor_timestamp < 20110403185020
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 20, ar_namespace, count(*) FROM archive
WHERE ar_actor = 20 AND ar_timestamp < 20110403185020
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 24, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 24 AND revactor_timestamp < 20160929105619
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 24, ar_namespace, count(*) FROM archive
WHERE ar_actor = 24 AND ar_timestamp < 20160929105619
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 45, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 45 AND revactor_timestamp < 20081012213745
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 45, ar_namespace, count(*) FROM archive
WHERE ar_actor = 45 AND ar_timestamp < 20081012213745
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 85, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 85 AND revactor_timestamp < 20160313081258
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 85, ar_namespace, count(*) FROM archive
WHERE ar_actor = 85 AND ar_timestamp < 20160313081258
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 211, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 211 AND revactor_timestamp < 20120502190648
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 211, ar_namespace, count(*) FROM archive
WHERE ar_actor = 211 AND ar_timestamp < 20120502190648
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 229, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 229 AND revactor_timestamp < 20081019204324
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 229, ar_namespace, count(*) FROM archive
WHERE ar_actor = 229 AND ar_timestamp < 20081019204324
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 231, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 231 AND revactor_timestamp < 20140929215352
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 231, ar_namespace, count(*) FROM archive
WHERE ar_actor = 231 AND ar_timestamp < 20140929215352
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 244, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 244 AND revactor_timestamp < 20090619075957
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 244, ar_namespace, count(*) FROM archive
WHERE ar_actor = 244 AND ar_timestamp < 20090619075957
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 273, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 273 AND revactor_timestamp < 20100712202444
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 273, ar_namespace, count(*) FROM archive
WHERE ar_actor = 273 AND ar_timestamp < 20100712202444
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 299, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 299 AND revactor_timestamp < 20070412104205
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 299, ar_namespace, count(*) FROM archive
WHERE ar_actor = 299 AND ar_timestamp < 20070412104205
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 342, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 342 AND revactor_timestamp < 20080413194612
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 342, ar_namespace, count(*) FROM archive
WHERE ar_actor = 342 AND ar_timestamp < 20080413194612
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 364, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 364 AND revactor_timestamp < 20110301145845
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 364, ar_namespace, count(*) FROM archive
WHERE ar_actor = 364 AND ar_timestamp < 20110301145845
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 370, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 370 AND revactor_timestamp < 20070312145925
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 370, ar_namespace, count(*) FROM archive
WHERE ar_actor = 370 AND ar_timestamp < 20070312145925
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 379, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 379 AND revactor_timestamp < 20110131110918
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 379, ar_namespace, count(*) FROM archive
WHERE ar_actor = 379 AND ar_timestamp < 20110131110918
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 388, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 388 AND revactor_timestamp < 20170203212810
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 388, ar_namespace, count(*) FROM archive
WHERE ar_actor = 388 AND ar_timestamp < 20170203212810
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 416, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 416 AND revactor_timestamp < 20120705110300
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 416, ar_namespace, count(*) FROM archive
WHERE ar_actor = 416 AND ar_timestamp < 20120705110300
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 434, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 434 AND revactor_timestamp < 20120205201340
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 434, ar_namespace, count(*) FROM archive
WHERE ar_actor = 434 AND ar_timestamp < 20120205201340
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 510, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 510 AND revactor_timestamp < 20171025182809
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 510, ar_namespace, count(*) FROM archive
WHERE ar_actor = 510 AND ar_timestamp < 20171025182809
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 513, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 513 AND revactor_timestamp < 20140313215739
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 513, ar_namespace, count(*) FROM archive
WHERE ar_actor = 513 AND ar_timestamp < 20140313215739
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 516, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 516 AND revactor_timestamp < 20130127213604
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 516, ar_namespace, count(*) FROM archive
WHERE ar_actor = 516 AND ar_timestamp < 20130127213604
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 528, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 528 AND revactor_timestamp < 20120211102758
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 528, ar_namespace, count(*) FROM archive
WHERE ar_actor = 528 AND ar_timestamp < 20120211102758
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 533, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 533 AND revactor_timestamp < 20051126212238
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 533, ar_namespace, count(*) FROM archive
WHERE ar_actor = 533 AND ar_timestamp < 20051126212238
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 561, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 561 AND revactor_timestamp < 20190322170454
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 561, ar_namespace, count(*) FROM archive
WHERE ar_actor = 561 AND ar_timestamp < 20190322170454
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 580, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 580 AND revactor_timestamp < 20160301200624
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 580, ar_namespace, count(*) FROM archive
WHERE ar_actor = 580 AND ar_timestamp < 20160301200624
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 622, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 622 AND revactor_timestamp < 20060601201251
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 622, ar_namespace, count(*) FROM archive
WHERE ar_actor = 622 AND ar_timestamp < 20060601201251
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 630, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 630 AND revactor_timestamp < 20151122092406
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 630, ar_namespace, count(*) FROM archive
WHERE ar_actor = 630 AND ar_timestamp < 20151122092406
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 642, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 642 AND revactor_timestamp < 20150913060634
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 642, ar_namespace, count(*) FROM archive
WHERE ar_actor = 642 AND ar_timestamp < 20150913060634
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 664, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 664 AND revactor_timestamp < 20170523231646
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 664, ar_namespace, count(*) FROM archive
WHERE ar_actor = 664 AND ar_timestamp < 20170523231646
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 668, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 668 AND revactor_timestamp < 20100114202724
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 668, ar_namespace, count(*) FROM archive
WHERE ar_actor = 668 AND ar_timestamp < 20100114202724
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 677, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 677 AND revactor_timestamp < 20070213200652
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 677, ar_namespace, count(*) FROM archive
WHERE ar_actor = 677 AND ar_timestamp < 20070213200652
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 727, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 727 AND revactor_timestamp < 20091026213517
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 727, ar_namespace, count(*) FROM archive
WHERE ar_actor = 727 AND ar_timestamp < 20091026213517
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 751, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 751 AND revactor_timestamp < 20110312230652
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 751, ar_namespace, count(*) FROM archive
WHERE ar_actor = 751 AND ar_timestamp < 20110312230652
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 807, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 807 AND revactor_timestamp < 20171024191630
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 807, ar_namespace, count(*) FROM archive
WHERE ar_actor = 807 AND ar_timestamp < 20171024191630
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 808, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 808 AND revactor_timestamp < 20100904000749
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 808, ar_namespace, count(*) FROM archive
WHERE ar_actor = 808 AND ar_timestamp < 20100904000749
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 830, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 830 AND revactor_timestamp < 20180130221956
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 830, ar_namespace, count(*) FROM archive
WHERE ar_actor = 830 AND ar_timestamp < 20180130221956
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 864, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 864 AND revactor_timestamp < 20110704170219
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 864, ar_namespace, count(*) FROM archive
WHERE ar_actor = 864 AND ar_timestamp < 20110704170219
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 881, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 881 AND revactor_timestamp < 20081013205019
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 881, ar_namespace, count(*) FROM archive
WHERE ar_actor = 881 AND ar_timestamp < 20081013205019
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 900, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 900 AND revactor_timestamp < 20160913153712
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 900, ar_namespace, count(*) FROM archive
WHERE ar_actor = 900 AND ar_timestamp < 20160913153712
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 902, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 902 AND revactor_timestamp < 20061226223816
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 902, ar_namespace, count(*) FROM archive
WHERE ar_actor = 902 AND ar_timestamp < 20061226223816
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 907, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 907 AND revactor_timestamp < 20080103181508
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 907, ar_namespace, count(*) FROM archive
WHERE ar_actor = 907 AND ar_timestamp < 20080103181508
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1007, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1007 AND revactor_timestamp < 20050105190537
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1007, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1007 AND ar_timestamp < 20050105190537
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1027, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1027 AND revactor_timestamp < 20061209132456
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1027, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1027 AND ar_timestamp < 20061209132456
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1045, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1045 AND revactor_timestamp < 20031215230828
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1045, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1045 AND ar_timestamp < 20031215230828
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1058, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1058 AND revactor_timestamp < 20170203212752
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1058, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1058 AND ar_timestamp < 20170203212752
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1099, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1099 AND revactor_timestamp < 20150310190542
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1099, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1099 AND ar_timestamp < 20150310190542
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1145, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1145 AND revactor_timestamp < 20041223122143
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1145, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1145 AND ar_timestamp < 20041223122143
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1156, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1156 AND revactor_timestamp < 20130106013022
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1156, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1156 AND ar_timestamp < 20130106013022
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1197, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1197 AND revactor_timestamp < 20090224223921
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1197, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1197 AND ar_timestamp < 20090224223921
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1314, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1314 AND revactor_timestamp < 20081028143816
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1314, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1314 AND ar_timestamp < 20081028143816
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1321, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1321 AND revactor_timestamp < 20171031192248
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1321, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1321 AND ar_timestamp < 20171031192248
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1355, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1355 AND revactor_timestamp < 20041228110450
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1355, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1355 AND ar_timestamp < 20041228110450
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1391, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1391 AND revactor_timestamp < 20180313141354
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1391, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1391 AND ar_timestamp < 20180313141354
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1434, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1434 AND revactor_timestamp < 20130914122404
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1434, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1434 AND ar_timestamp < 20130914122404
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1462, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1462 AND revactor_timestamp < 20140914115900
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1462, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1462 AND ar_timestamp < 20140914115900
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1480, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1480 AND revactor_timestamp < 20110127164609
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1480, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1480 AND ar_timestamp < 20110127164609
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1486, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1486 AND revactor_timestamp < 20110531194933
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1486, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1486 AND ar_timestamp < 20110531194933
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1508, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1508 AND revactor_timestamp < 20050111065551
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1508, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1508 AND ar_timestamp < 20050111065551
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1548, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1548 AND revactor_timestamp < 20120721201453
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1548, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1548 AND ar_timestamp < 20120721201453
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1550, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1550 AND revactor_timestamp < 20120505081408
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1550, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1550 AND ar_timestamp < 20120505081408
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1613, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1613 AND revactor_timestamp < 20041228003922
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1613, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1613 AND ar_timestamp < 20041228003922
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1668, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1668 AND revactor_timestamp < 20090921220322
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1668, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1668 AND ar_timestamp < 20090921220322
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1674, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1674 AND revactor_timestamp < 20061118231254
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1674, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1674 AND ar_timestamp < 20061118231254
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 1711, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 1711 AND revactor_timestamp < 20080119142001
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 1711, ar_namespace, count(*) FROM archive
WHERE ar_actor = 1711 AND ar_timestamp < 20080119142001
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2080, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2080 AND revactor_timestamp < 20080521233917
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2080, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2080 AND ar_timestamp < 20080521233917
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2131, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2131 AND revactor_timestamp < 20050128134028
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2131, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2131 AND ar_timestamp < 20050128134028
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2218, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2218 AND revactor_timestamp < 20140806134239
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2218, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2218 AND ar_timestamp < 20140806134239
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2270, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2270 AND revactor_timestamp < 20100930160230
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2270, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2270 AND ar_timestamp < 20100930160230
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2363, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2363 AND revactor_timestamp < 20040527201036
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2363, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2363 AND ar_timestamp < 20040527201036
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2392, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2392 AND revactor_timestamp < 20041228222416
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2392, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2392 AND ar_timestamp < 20041228222416
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2417, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2417 AND revactor_timestamp < 20090219183713
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2417, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2417 AND ar_timestamp < 20090219183713
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2461, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2461 AND revactor_timestamp < 20140112212641
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2461, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2461 AND ar_timestamp < 20140112212641
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2640, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2640 AND revactor_timestamp < 20130914122605
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2640, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2640 AND ar_timestamp < 20130914122605
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2644, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2644 AND revactor_timestamp < 20190925185329
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2644, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2644 AND ar_timestamp < 20190925185329
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 2943, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 2943 AND revactor_timestamp < 20070911184920
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 2943, ar_namespace, count(*) FROM archive
WHERE ar_actor = 2943 AND ar_timestamp < 20070911184920
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3068, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3068 AND revactor_timestamp < 20101120220435
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3068, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3068 AND ar_timestamp < 20101120220435
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3095, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3095 AND revactor_timestamp < 20070311193833
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3095, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3095 AND ar_timestamp < 20070311193833
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3186, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3186 AND revactor_timestamp < 20071026170351
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3186, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3186 AND ar_timestamp < 20071026170351
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3304, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3304 AND revactor_timestamp < 20051112205908
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3304, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3304 AND ar_timestamp < 20051112205908
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3529, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3529 AND revactor_timestamp < 20121223232020
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3529, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3529 AND ar_timestamp < 20121223232020
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3531, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3531 AND revactor_timestamp < 20100621213152
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3531, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3531 AND ar_timestamp < 20100621213152
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3577, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3577 AND revactor_timestamp < 20090902094130
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3577, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3577 AND ar_timestamp < 20090902094130
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3935, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3935 AND revactor_timestamp < 20041230213138
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3935, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3935 AND ar_timestamp < 20041230213138
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3940, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3940 AND revactor_timestamp < 20050205231706
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3940, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3940 AND ar_timestamp < 20050205231706
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3944, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3944 AND revactor_timestamp < 20041223071706
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3944, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3944 AND ar_timestamp < 20041223071706
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3975, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3975 AND revactor_timestamp < 20081010200612
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3975, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3975 AND ar_timestamp < 20081010200612
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3989, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3989 AND revactor_timestamp < 20140409213618
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3989, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3989 AND ar_timestamp < 20140409213618
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 3990, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 3990 AND revactor_timestamp < 20080212111621
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 3990, ar_namespace, count(*) FROM archive
WHERE ar_actor = 3990 AND ar_timestamp < 20080212111621
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 4198, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 4198 AND revactor_timestamp < 20080227224338
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 4198, ar_namespace, count(*) FROM archive
WHERE ar_actor = 4198 AND ar_timestamp < 20080227224338
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 4257, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 4257 AND revactor_timestamp < 20170215195753
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 4257, ar_namespace, count(*) FROM archive
WHERE ar_actor = 4257 AND ar_timestamp < 20170215195753
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 4611, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 4611 AND revactor_timestamp < 20060703193147
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 4611, ar_namespace, count(*) FROM archive
WHERE ar_actor = 4611 AND ar_timestamp < 20060703193147
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 4769, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 4769 AND revactor_timestamp < 20050515185514
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 4769, ar_namespace, count(*) FROM archive
WHERE ar_actor = 4769 AND ar_timestamp < 20050515185514
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 4898, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 4898 AND revactor_timestamp < 20070402145553
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 4898, ar_namespace, count(*) FROM archive
WHERE ar_actor = 4898 AND ar_timestamp < 20070402145553
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5179, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5179 AND revactor_timestamp < 20060202210314
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5179, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5179 AND ar_timestamp < 20060202210314
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5249, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5249 AND revactor_timestamp < 20051201100242
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5249, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5249 AND ar_timestamp < 20051201100242
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5265, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5265 AND revactor_timestamp < 20180914161910
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5265, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5265 AND ar_timestamp < 20180914161910
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5304, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5304 AND revactor_timestamp < 20060907125029
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5304, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5304 AND ar_timestamp < 20060907125029
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5315, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5315 AND revactor_timestamp < 20050612220036
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5315, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5315 AND ar_timestamp < 20050612220036
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5316, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5316 AND revactor_timestamp < 20080809194256
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5316, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5316 AND ar_timestamp < 20080809194256
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5318, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5318 AND revactor_timestamp < 20070512155706
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5318, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5318 AND ar_timestamp < 20070512155706
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5319, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5319 AND revactor_timestamp < 20100510150500
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5319, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5319 AND ar_timestamp < 20100510150500
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5321, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5321 AND revactor_timestamp < 20090515194309
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5321, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5321 AND ar_timestamp < 20090515194309
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5381, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5381 AND revactor_timestamp < 20070827202056
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5381, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5381 AND ar_timestamp < 20070827202056
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5507, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5507 AND revactor_timestamp < 20100221235453
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5507, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5507 AND ar_timestamp < 20100221235453
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5544, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5544 AND revactor_timestamp < 20061018172317
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5544, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5544 AND ar_timestamp < 20061018172317
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5565, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5565 AND revactor_timestamp < 20100912222204
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5565, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5565 AND ar_timestamp < 20100912222204
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5629, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5629 AND revactor_timestamp < 20050204215646
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5629, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5629 AND ar_timestamp < 20050204215646
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 5861, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 5861 AND revactor_timestamp < 20100611184512
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 5861, ar_namespace, count(*) FROM archive
WHERE ar_actor = 5861 AND ar_timestamp < 20100611184512
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 6049, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 6049 AND revactor_timestamp < 20041223162815
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 6049, ar_namespace, count(*) FROM archive
WHERE ar_actor = 6049 AND ar_timestamp < 20041223162815
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 6298, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 6298 AND revactor_timestamp < 20070814203017
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 6298, ar_namespace, count(*) FROM archive
WHERE ar_actor = 6298 AND ar_timestamp < 20070814203017
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 6299, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 6299 AND revactor_timestamp < 20060213223054
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 6299, ar_namespace, count(*) FROM archive
WHERE ar_actor = 6299 AND ar_timestamp < 20060213223054
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 6749, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 6749 AND revactor_timestamp < 20060815202458
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 6749, ar_namespace, count(*) FROM archive
WHERE ar_actor = 6749 AND ar_timestamp < 20060815202458
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 6944, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 6944 AND revactor_timestamp < 20060129151957
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 6944, ar_namespace, count(*) FROM archive
WHERE ar_actor = 6944 AND ar_timestamp < 20060129151957
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7085, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7085 AND revactor_timestamp < 20091013114406
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7085, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7085 AND ar_timestamp < 20091013114406
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7168, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7168 AND revactor_timestamp < 20060802132443
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7168, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7168 AND ar_timestamp < 20060802132443
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7346, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7346 AND revactor_timestamp < 20110104231446
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7346, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7346 AND ar_timestamp < 20110104231446
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7391, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7391 AND revactor_timestamp < 20040922090057
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7391, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7391 AND ar_timestamp < 20040922090057
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7579, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7579 AND revactor_timestamp < 20060501132638
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7579, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7579 AND ar_timestamp < 20060501132638
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7590, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7590 AND revactor_timestamp < 20090922072421
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7590, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7590 AND ar_timestamp < 20090922072421
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7592, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7592 AND revactor_timestamp < 20110211162458
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7592, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7592 AND ar_timestamp < 20110211162458
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7605, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7605 AND revactor_timestamp < 20080520210630
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7605, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7605 AND ar_timestamp < 20080520210630
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7750, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7750 AND revactor_timestamp < 20050414191413
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7750, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7750 AND ar_timestamp < 20050414191413
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 7774, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 7774 AND revactor_timestamp < 20070115125135
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 7774, ar_namespace, count(*) FROM archive
WHERE ar_actor = 7774 AND ar_timestamp < 20070115125135
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 8193, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 8193 AND revactor_timestamp < 20060306165959
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 8193, ar_namespace, count(*) FROM archive
WHERE ar_actor = 8193 AND ar_timestamp < 20060306165959
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 8557, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 8557 AND revactor_timestamp < 20071126142728
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 8557, ar_namespace, count(*) FROM archive
WHERE ar_actor = 8557 AND ar_timestamp < 20071126142728
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 8656, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 8656 AND revactor_timestamp < 20090413235345
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 8656, ar_namespace, count(*) FROM archive
WHERE ar_actor = 8656 AND ar_timestamp < 20090413235345
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 8659, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 8659 AND revactor_timestamp < 20081015190250
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 8659, ar_namespace, count(*) FROM archive
WHERE ar_actor = 8659 AND ar_timestamp < 20081015190250
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 8892, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 8892 AND revactor_timestamp < 20151214114509
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 8892, ar_namespace, count(*) FROM archive
WHERE ar_actor = 8892 AND ar_timestamp < 20151214114509
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 9331, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 9331 AND revactor_timestamp < 20050101031900
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 9331, ar_namespace, count(*) FROM archive
WHERE ar_actor = 9331 AND ar_timestamp < 20050101031900
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 9657, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 9657 AND revactor_timestamp < 20130201201333
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 9657, ar_namespace, count(*) FROM archive
WHERE ar_actor = 9657 AND ar_timestamp < 20130201201333
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 10826, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 10826 AND revactor_timestamp < 20070602145616
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 10826, ar_namespace, count(*) FROM archive
WHERE ar_actor = 10826 AND ar_timestamp < 20070602145616
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 10951, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 10951 AND revactor_timestamp < 20040527195523
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 10951, ar_namespace, count(*) FROM archive
WHERE ar_actor = 10951 AND ar_timestamp < 20040527195523
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 11405, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 11405 AND revactor_timestamp < 20090104212846
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 11405, ar_namespace, count(*) FROM archive
WHERE ar_actor = 11405 AND ar_timestamp < 20090104212846
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 11852, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 11852 AND revactor_timestamp < 20071027194225
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 11852, ar_namespace, count(*) FROM archive
WHERE ar_actor = 11852 AND ar_timestamp < 20071027194225
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 12852, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 12852 AND revactor_timestamp < 20080413192646
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 12852, ar_namespace, count(*) FROM archive
WHERE ar_actor = 12852 AND ar_timestamp < 20080413192646
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 13144, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 13144 AND revactor_timestamp < 20070411085851
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 13144, ar_namespace, count(*) FROM archive
WHERE ar_actor = 13144 AND ar_timestamp < 20070411085851
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 13145, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 13145 AND revactor_timestamp < 20081031112037
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 13145, ar_namespace, count(*) FROM archive
WHERE ar_actor = 13145 AND ar_timestamp < 20081031112037
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 13167, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 13167 AND revactor_timestamp < 20070205002018
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 13167, ar_namespace, count(*) FROM archive
WHERE ar_actor = 13167 AND ar_timestamp < 20070205002018
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 13169, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 13169 AND revactor_timestamp < 20061226191247
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 13169, ar_namespace, count(*) FROM archive
WHERE ar_actor = 13169 AND ar_timestamp < 20061226191247
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 13175, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 13175 AND revactor_timestamp < 20060622132136
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 13175, ar_namespace, count(*) FROM archive
WHERE ar_actor = 13175 AND ar_timestamp < 20060622132136
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 13225, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 13225 AND revactor_timestamp < 20070628154115
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 13225, ar_namespace, count(*) FROM archive
WHERE ar_actor = 13225 AND ar_timestamp < 20070628154115
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 13228, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 13228 AND revactor_timestamp < 20100104201345
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 13228, ar_namespace, count(*) FROM archive
WHERE ar_actor = 13228 AND ar_timestamp < 20100104201345
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 13738, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 13738 AND revactor_timestamp < 20060308161755
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 13738, ar_namespace, count(*) FROM archive
WHERE ar_actor = 13738 AND ar_timestamp < 20060308161755
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 14639, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 14639 AND revactor_timestamp < 20041223090118
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 14639, ar_namespace, count(*) FROM archive
WHERE ar_actor = 14639 AND ar_timestamp < 20041223090118
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 14717, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 14717 AND revactor_timestamp < 20070222083511
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 14717, ar_namespace, count(*) FROM archive
WHERE ar_actor = 14717 AND ar_timestamp < 20070222083511
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 17333, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 17333 AND revactor_timestamp < 20061016191315
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 17333, ar_namespace, count(*) FROM archive
WHERE ar_actor = 17333 AND ar_timestamp < 20061016191315
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 17719, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 17719 AND revactor_timestamp < 20070705172353
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 17719, ar_namespace, count(*) FROM archive
WHERE ar_actor = 17719 AND ar_timestamp < 20070705172353
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 19237, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 19237 AND revactor_timestamp < 20040121181742
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 19237, ar_namespace, count(*) FROM archive
WHERE ar_actor = 19237 AND ar_timestamp < 20040121181742
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 20477, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 20477 AND revactor_timestamp < 20080511231102
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 20477, ar_namespace, count(*) FROM archive
WHERE ar_actor = 20477 AND ar_timestamp < 20080511231102
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 21773, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 21773 AND revactor_timestamp < 20051228000220
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 21773, ar_namespace, count(*) FROM archive
WHERE ar_actor = 21773 AND ar_timestamp < 20051228000220
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 21967, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 21967 AND revactor_timestamp < 20080222211341
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 21967, ar_namespace, count(*) FROM archive
WHERE ar_actor = 21967 AND ar_timestamp < 20080222211341
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 22798, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 22798 AND revactor_timestamp < 20090819125553
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 22798, ar_namespace, count(*) FROM archive
WHERE ar_actor = 22798 AND ar_timestamp < 20090819125553
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 23812, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 23812 AND revactor_timestamp < 20041209222332
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 23812, ar_namespace, count(*) FROM archive
WHERE ar_actor = 23812 AND ar_timestamp < 20041209222332
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 24249, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 24249 AND revactor_timestamp < 20050103163407
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 24249, ar_namespace, count(*) FROM archive
WHERE ar_actor = 24249 AND ar_timestamp < 20050103163407
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 24250, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 24250 AND revactor_timestamp < 20041231121144
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 24250, ar_namespace, count(*) FROM archive
WHERE ar_actor = 24250 AND ar_timestamp < 20041231121144
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 24363, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 24363 AND revactor_timestamp < 20060507120948
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 24363, ar_namespace, count(*) FROM archive
WHERE ar_actor = 24363 AND ar_timestamp < 20060507120948
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 24944, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 24944 AND revactor_timestamp < 20061025141346
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 24944, ar_namespace, count(*) FROM archive
WHERE ar_actor = 24944 AND ar_timestamp < 20061025141346
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 25973, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 25973 AND revactor_timestamp < 20070508221737
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 25973, ar_namespace, count(*) FROM archive
WHERE ar_actor = 25973 AND ar_timestamp < 20070508221737
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 25984, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 25984 AND revactor_timestamp < 20051213214604
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 25984, ar_namespace, count(*) FROM archive
WHERE ar_actor = 25984 AND ar_timestamp < 20051213214604
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 26872, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 26872 AND revactor_timestamp < 20051204175546
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 26872, ar_namespace, count(*) FROM archive
WHERE ar_actor = 26872 AND ar_timestamp < 20051204175546
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 27795, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 27795 AND revactor_timestamp < 20060110112954
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 27795, ar_namespace, count(*) FROM archive
WHERE ar_actor = 27795 AND ar_timestamp < 20060110112954
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 27872, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 27872 AND revactor_timestamp < 20130714083933
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 27872, ar_namespace, count(*) FROM archive
WHERE ar_actor = 27872 AND ar_timestamp < 20130714083933
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 28664, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 28664 AND revactor_timestamp < 20051212182917
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 28664, ar_namespace, count(*) FROM archive
WHERE ar_actor = 28664 AND ar_timestamp < 20051212182917
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 29786, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 29786 AND revactor_timestamp < 20090709213300
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 29786, ar_namespace, count(*) FROM archive
WHERE ar_actor = 29786 AND ar_timestamp < 20090709213300
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 29924, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 29924 AND revactor_timestamp < 20090811213658
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 29924, ar_namespace, count(*) FROM archive
WHERE ar_actor = 29924 AND ar_timestamp < 20090811213658
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 29947, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 29947 AND revactor_timestamp < 20050105043944
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 29947, ar_namespace, count(*) FROM archive
WHERE ar_actor = 29947 AND ar_timestamp < 20050105043944
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 30032, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 30032 AND revactor_timestamp < 20080321231025
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 30032, ar_namespace, count(*) FROM archive
WHERE ar_actor = 30032 AND ar_timestamp < 20080321231025
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 32513, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 32513 AND revactor_timestamp < 20060308082804
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 32513, ar_namespace, count(*) FROM archive
WHERE ar_actor = 32513 AND ar_timestamp < 20060308082804
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 33679, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 33679 AND revactor_timestamp < 20050406141630
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 33679, ar_namespace, count(*) FROM archive
WHERE ar_actor = 33679 AND ar_timestamp < 20050406141630
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 34397, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 34397 AND revactor_timestamp < 20070409163014
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 34397, ar_namespace, count(*) FROM archive
WHERE ar_actor = 34397 AND ar_timestamp < 20070409163014
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 34525, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 34525 AND revactor_timestamp < 20060410161217
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 34525, ar_namespace, count(*) FROM archive
WHERE ar_actor = 34525 AND ar_timestamp < 20060410161217
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 34724, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 34724 AND revactor_timestamp < 20050623112949
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 34724, ar_namespace, count(*) FROM archive
WHERE ar_actor = 34724 AND ar_timestamp < 20050623112949
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 35535, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 35535 AND revactor_timestamp < 20110312230655
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 35535, ar_namespace, count(*) FROM archive
WHERE ar_actor = 35535 AND ar_timestamp < 20110312230655
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 38078, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 38078 AND revactor_timestamp < 20080414005820
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 38078, ar_namespace, count(*) FROM archive
WHERE ar_actor = 38078 AND ar_timestamp < 20080414005820
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 38088, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 38088 AND revactor_timestamp < 20060122133756
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 38088, ar_namespace, count(*) FROM archive
WHERE ar_actor = 38088 AND ar_timestamp < 20060122133756
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 38184, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 38184 AND revactor_timestamp < 20060815191823
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 38184, ar_namespace, count(*) FROM archive
WHERE ar_actor = 38184 AND ar_timestamp < 20060815191823
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 38790, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 38790 AND revactor_timestamp < 20101120140836
GROUP BY page_namespace
)
UNION
(
SELECT 'archive', 38790, ar_namespace, count(*) FROM archive
WHERE ar_actor = 38790 AND ar_timestamp < 20101120140836
GROUP BY ar_namespace
)
UNION
(
SELECT 'revision', 38796, page_namespace, count(*) FROM revision_actor_temp LEFT JOIN page on revactor_page = page_id
WHERE revactor_actor = 38796 AND revactor_timestamp < 20080411123312
GROUP BY page_nam
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
