Creators of drafts accepted by UPE Luciapop

SQL

SELECT page_title, actor_name AS page_creator, COUNT(*)
FROM revision_userindex
JOIN page ON page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
WHERE rev_id IN (
939674212, 961384218, 976799691, 983053443, 986947224, 990091093, 990979586, 1000947099, 1000949099, 1002263633, 1003826612, 1010046019, 1010451898, 1010715144, 1011430659, 1013293516, 1014395551, 1015018727, 1015048193, 1015629410, 1015634844, 1016070405, 1016544557, 1017157111, 1018259555, 1019386183, 1019480532, 1019493104, 1019577668, 1019589289, 1019701619, 1019752503, 1019778575, 1019967539, 1019987851, 1034715988, 1038603825, 1039524228, 1040772027, 1041881981, 1043076408, 1043559326
)
AND page_creator <> 'FloridaArmy' # not a sock
GROUP BY page_creator
ORDER BY COUNT(*) DESC
SQL

Checking query status...
