page_title_frwiki

SQL

USE frwiki_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 (2704559,
2746326,
2747218,
2123118,
946960,
2746008,
2085460,
2420911,
2743415,
2489954,
2747022,
1941715,
510579,
2146910,
2750390,
2747023,
2725232,
2750034,
2746998,
2511388,
2746120,
2669433,
376353,
2743259,
1550244,
392508,
2747025,
2746006,
2367515,
2746302,
2747133,
2747026,
2440548,
2505279,
8954,
2747233,
1302579,
2746031,
2746005,
2725239,
2620790,
2750209,
2750849,
2740829,
17885,
9503,
2475709,
2746372,
2725231,
131,
2753154,
2613090,
2543815,
2746214,
2725227,
2476569,
2133121,
2475782,
2747222,
1935953,
2746271,
1675572,
2639108,
2746386,
2746337,
2133700,
2750251,
2746303,
2746259,
2746140,
59879,
2746349,
2746353,
1927201,
108951,
576727,
786842,
1818115,
2752935,
2662132,
1372207,
2747024,
2182410)
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...
