top transport category contributors in ukwiki

SQL

use ukwiki_p;
select actor_name, count(*) as revisions
from revison_userindex
join actor on actor_id = rev_actor
where rev_page in (
  3089,3090,3091,3093,3116,3657,6082,6275,6525,7372,7435,7489,7525,7526,7631,8541,9295,9774,10075,10089,10419,10444,10880,10945,11134,
  11136,11679,11694,11754,12037,12043,12231,12274,12342,12520,12603,12604,12996,13034,13332,13366,13377,13558,14113,14301,14327,14555,
  14969,15048,15391,15394,15399,15402,15429,15444,15458,15915,16212,17359,17401,17688,17809,17815,17816,18860,18880,19212,19404,19407,
  19424,19426,20060,20148,20213,20666,20864,20961,21036,21158,21699,22595,22598,22658,22696,22746,22868,23221,23286,24181,24669,24862)
group by rev_actor
having revisions > 500
order by revisons desc
SQL

Checking query status...
