Search b43 (user space, recent)

SQL

SELECT actor_name, MAX(rc_timestamp)
FROM actor_recentchanges AS actor
INNER JOIN revision_userindex AS revision ON actor.actor_id = revision.rev_actor
INNER JOIN page ON revision.rev_page = page.page_id
INNER JOIN comment_revision AS comment ON revision.rev_comment_id = comment.comment_id
INNER JOIN user ON actor.actor_user = user.user_id
INNER JOIN recentchanges_userindex AS recentchanges ON rc_actor = actor_id
WHERE
TRUE
AND rev_timestamp >= '20150101000000'
AND actor_user IS NOT NULL
AND LENGTH(actor_name) >= 6
AND LENGTH(actor_name) <= 14
AND actor_name RLIKE '^[A-Z][a-z]+[0-9]{0,2}$'
AND page_namespace IN (2, 3)
AND page_title = actor_name
AND comment_hash IN (-1000085741, 1000932235, -1099679802, 1147121366, -1149949326, -1163877775, -1167607568, -1170240075, -1219719307, 1245743401, -1254564781, -1300771247, 1308460700, -1314614575, -1354803430, -1358969694, 1374686992, 1437640022, 1459738263, 146063992, 1467009351, -1567524471, -1576118707, -1627196776, -1639426721, 1664531428, -1697735365, 1713615636, 1824418275, -1835636373, -1917994654, 1920811342, 1975712522, -199598730, -2088904980, -238903250, -270760101, 352947703, -354575633, -541722663, 582549379, 647646772, -651461032, 651488359, 677596021, -705670092, 729178928, 736709876, 746371437, 774943852, 835715234, 869832460, 98654523)
GROUP BY actor_name
ORDER BY MAX(rc_timestamp)
SQL

Checking query status...
