page_title_secondset

SQL

USE enwiki_p;
SELECT page.page_title, revision.rev_user
FROM page, revision
WHERE page.page_id = revision.rev_page
AND page.page_is_new = 1
AND revision.rev_user in (30552490,
30628388,
30627472,
27736593,
30636375,
30730235,
30505715,
29494175,
20398547,
30569594,
26210850,
24212172,
30591529,
30496771,
30733440,
30566110,
30568927,
25550326,
30545649,
30568478,
30360303,
30567820,
30192303,
18816987,
30550512,
23414253,
30512493,
30461280,
111996,
30563093)
AND revision.rev_timestamp > DATE_FORMAT('2017-03-01 04:00:00','%Y%m%d%H%i%s')
AND revision.rev_timestamp <= DATE_FORMAT('2017-04-01 03:59:59','%Y%m%d%H%i%s');
SQL

Checking query status...
