Search by comment hash

SQL

SELECT actor_name, rev_id, rev_timestamp
FROM actor_revision AS actor
INNER JOIN revision_userindex AS revision ON actor.actor_id = revision.rev_actor
INNER JOIN comment_revision AS comment ON revision.rev_comment_id = comment.comment_id
WHERE
TRUE
AND actor_user IS NULL
-- enwiki:
-- AND comment_text RLIKE '^\\[\\[WP:AES\\|←\\]\\]Created page with ["\'](?:{{(?:[Uu]ser ?page|[Uu]sertalkpage|[Tt]alkpage|[Tt]alk ?header)}}| *)["\']$'
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)
LIMIT 1
SQL

Checking query status...
