GAN nominations with high edit timestamp deltas

SQL

/* 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
*/

SQL

Checking query status...