/* WIP: timestamp deltas not calculated yet */

USE enwiki_p;

SELECT page_title

FROM page

WHERE

    page_namespace = 1

    /* Slow, huh: AND NOT page_is_redirect */

    AND page_title LIKE "%/GA_"

LIMIT 100

/* .52 seconds for 100 rows

38.09 seconds for 10000 rows */

/* USE enwiki_p;

SELECT 

  rev_timestamp, 

  page_title

FROM revision

INNER JOIN page ON page_id = rev_page

WHERE

  page_namespace = 1

  AND page_title LIKE "%/GA_"

GROUP BY rev_page

LIMIT 100 */

/* Necessary for now. I have no idea why this is so slow; probably the "LIKE" comparison. */

/* Grouped by page:

6.22 seconds for 100 rows 

13.09 seconds for 1000 rows

68.93 seconds for 10000 rows

*/