Untitled query #64355

This query is marked as a draft This query has been published by Nmine13.
SQL

USE enwiki_p;

select user.user_id, count(revision.rev_id) as lifetime_rev_count
from revision
join actor on revision.rev_actor = actor.actor_id
join user on actor.actor_user = user.user_id
where user_id in ("43612250", "43802944", "43094275", "43801460", "7274040", "27808550", "43618795", "43813984", "7403827", "21094560", "43767084", "42293051", "1988240", "43782930", "43798720", "19092329", "23685609", "41348841", "15347562", "39445389", "42086008", "43790869", "39818221", "35172197", "21185738", "32340458", "43790632", "43441815", "41828784", "43172600", "43814978", "20611691", "43803621", "43813614", "43803744", "3461395", "33682615", "43805724", "4546160", "43782120", "43782167", "3765810", "43547266", "43475265", "43779903", "43783404", "43793757", "43558983", "40824097", "35223802", "43786123", "43808940", "43765761", "41380928", "41439150", "39509091", "43778436", "19171402", "40716540", "43216554", "43808861", "1124632", "43789623", "43790325", "43805236", "43548579", "43810725", "12766334", "17734598", "40843367", "43793096", "43809066", "43603015", "43780563", "470362", "43789691", "43796359", "43806778", "43809243", "39138731", "43804254", "43576800", "43800859", "43806744", "43791396", "36111613", "5704777", "42914374", "43674370", "43780444", "15182381", "43786064", "20832140", "30914858", "7851475", "19954945", "39932026", "43221849", "43702484", "43716121", "43789145", "43801837", "43802763", "43809494", "40307312", "43810749", "38627406", "20818275", "42081344", "25293102", "43786774", "43814163", "571477", "38070455", "43780570", "43069234", "41251492", "29818703", "35160657", "43780727", "29032402", "43106939", "39268689", "43799469", "43813652", "43779247", "43784717", "349847", "43715436", "43758650", "43800005", "29290905", "39120513", "6052754", "107051", "40429064", "43680987", "285980", "43794902", "43782369", "37637332", "37059909", "43799305", "9239595", "3496179", "39719197", "35138466", "43791979", "43794887", "43792781", "41535030", "6604558", "223194", "43594979", "28809222", "5444311", "630530", "25582578", "40788572", "40924271", "43787211", "43785526", "43798525", "43799102", "20923700", "41567254", "43794263", "18527051", "37787840", "42159646", "138144", "41114333", "42080664", "39805620", "43602057", "43803464", "43788809", "1248138", "6941241", "43808178", "43793802", "33548244", "43796895", "8549979", "43542298", "17453150", "17744994", "43790072", "43788766", "2175", "28058285", "43657525", "6098679", "41990509", "43814830", "9373800", "43785013", "12582255", "5606976", "43815150", "43685948", "40637013", "43799627", "43800404", "43790842", "9868430", "16953213", "42898217", "1753191", "35548276", "43778429", "42813968", "31096180", "4759276", "37403692", "39168677", "41140670", "19917679", "43763026", "15364713", "43815015", "43814230", "36277776", "43397717", "9969665", "43784623", "43788405", "43735102", "789901", "26877826", "43653531", "20135712", "43809557", "27188288", "38307175", "43805896", "1848494", "42649759", "43707404", "42337781", "43712465", "43797907", "41025026", "43786085", "43793603", "37295978", "40871040", "43681567", "43793739", "43811602", "43603864", "43778779", "39525034", "43759172", "43800356", "42953695", "43809472", "42558850", "41044431", "36865624", "43799564", "43742404", "8209352", "32407357", "910572", "16765442", "41776821", "22882804", "42573737", "26003709", "43335960", "18669986", "1422477", "1493851", "29050547", "43783388", "5658345", "43811709", "42886565", "38199250", "43787456", "10525444", "41708907", "43793270", "7417869", "43800117", "42099195", "43782771", "40282890", "42281966", "36890623", "14181666", "37506931", "43810465", "15621779", "43799441", "43807244", "13474561", "30827942", "43794867", "698799", "43788762", "43812336", "43779121", "43805021", "43812592", "20015159", "43462252", "43784039", "43810487", "43812960", "287314", "3386197", "34723971", "14656739", "38850930", "7194329", "43361150", "26917081", "7314511", "40730815", "27385623", "40974544", "43806526", "9624899", "277086", "29976619", "37406905", "38747060", "42058822", "42367241", "43308400", "43414559", "43780341", "43801799", "43796112", "24764668", "26956232", "43799600", "43696394", "43801821", "43804693", "28274973", "43814442", "43782843", "43800290", "43785534", "43543211", "43783439", "43753654", "43795657", "18879726", "43810605", "27510199", "38761758", "43784486", "43779124", "43770769", "13408434", "43804247", "17334752", "43665874", "43792832", "40702161", "43808355", "15934788", "43260561", "4799859", "43608102", "43809427", "43813587", "32084967", "40173740", "43784637", "169662", "43805526", "27976891", "38448994", "16408044", "35951765", "43780920", "43801063", "17258522", "41742306", "41646142", "32521649", "8164021", "9639875", "42959298", "43786124", "43776205", "43801519", "33189385", "43069378", "43605484", "43591966", "43785287", "37888770", "43800114", "35353433", "886011", "2109085", "612021", "43808858", "43147841", "43791292", "414998", "7918952", "36882736", "43802547", "43797629", "43784686", "16381782", "43295436", "4207917", "43558426", "23529074", "16655916", "40890890", "81432", "43601059", "43794566", "43809949", "2300502", "43468883", "43474419", "713100", "17575532", "43258448", "43785199", "43804040", "43781575", "21054272", "43787857", "43798109", "43680644", "43787736", "38924942", "43804237", "41811702", "41971698", "1071140", "43800210", "43778096", "43809015", "43803220", "43786502", "43789723", "43790671", "19740960", "241098", "43710863", "43807209", "43766312", "43718446", "42176256", "43731013", "43790896", "42277898", "42959623", "43668404", "43788070", "22967753", "43805347", "18839253", "43792535", "43814892", "43800346", "700439", "45057", "40506264", "448102", "775297", "1069275", "42317675", "43723517", "43333723", "43788655", "43300087", "43787569", "36427068", "18719251", "43798584", "43814778", "342579", "43814858", "41907803", "43809714", "43787359", "26804", "6845718", "43720765", "31281597", "29696863", "43784781", "43786042", "43791064", "43794484", "43788089", "15887908", "43461315", "24159343", "26780281", "43781953", "39860883", "8254036", "21302502", "43794321", "43728400", "43372348", "43795028", "34752031", "43795257", "20984510", "42919831", "43468913", "43810340", "54890", "42346142", "43197412", "43289764", "43787641", "43795176", "19470301", "39494089", "4442796", "43773323", "43797811", "43802838", "43108384", "31421505", "43795145", "43801748", "29728740", "43670262", "43805396", "16047291", "9905177", "40248530", "43791070", "43812085", "43360711", "43789864", "456578", "9636319", "11317981", "43788944", "43807901", "43811409", "25747704", "28226807", "39771752", "43783043", "43785175", "37572002", "43792309", "28047958", "32427484", "43787104", "43801008", "43811378", "43090085", "129927", "43784654", "43746801", "43305303", "17090815", "22821566", "40143267", "43803701", "43781149", "43790191", "43790847", "42952381", "18639910", "43769948", "43793351", "43808998", "43799115", "33269965", "43793367", "41131203", "43801059", "43811424", "43801605", "4630255", "31328225", "43788844", "2770191", "43796248", "24316741", "5928522", "43782287", "43667987", "31381772", "43786628", "43350916", "43784836", "38657595", "21527109", "43791641", "43786650", "42987161", "43812458", "7748496", "43786262", "30463770", "33080934", "43797465", "43814513", "43787613", "543434", "43716428", "43777334", "43801123", "43789652", "41116554", "38799327", "13513680", "42457101", "16838157", "43804913", "43812956", "43811067", "40117741", "27224160", "42984285", "43670555", "13345232", "36274913", "43798453", "41088661", "43789046", "43810485", "26736392", "37309617", "43810589", "43781399", "43736121", "3208984", "42896618", "43800549", "43812176", "11153201", "27964437", "13294494", "24267489", "43594955", "11446312", "43531698", "34103679", "1622012", "43596146", "43794380", "43798248", "32217629", "28084166", "43813366", "42163224", "4371738", "43810287", "18471558", "17898251", "43625816", "42283031", "42981286", "43086542", "43794950", "43782635", "43542710", "43641223", "43803523", "43598724", "43799798", "43422911", "13714369", "43806829", "43814119", "43798736", "7321903", "41585330", "43797494", "1841617", "20366239", "37770903", "33314082", "43521340", "43796055", "10025848", "43784367", "39346091", "1455958", "43163343", "43781773", "42467833", "38481684", "43165432", "31487432", "14648459", "43781630", "25763988", "29357030", "43810076", "43803957", "43811432", "227059", "43602165", "43788159", "30743163", "16805376", "18329283", "43788176", "43797599", "43813299", "43791372", "28868347", "42531690", "43779644", "17369702", "43808122", "23900805", "39450538", "43808760", "31111023", "42114367", "35346603", "18752691", "737140", "36176760", "43804854", "41542577", "43807832", "40366811", "43780702", "38108245", "43785850", "26815824", "40777569", "43778665", "43792682", "8339014", "43167072", "25434004", "43803681", "40684241", "43784576", "43796849", "41961353", "43780648", "41028753", "42202680", "43780831", "43408549", "43794372", "320236", "24972128", "40857735", "34682250", "43690861", "14423028", "39948088", "43223884", "43750605", "20656739", "15763484", "30273166", "40285128", "15267187", "10643283", "593397", "1752894", "26919308", "42728882", "43706032", "43794160", "43715929", "43798312", "39920430", "43784231", "39534394", "43792108", "35545408", "43811473", "41005790", "43790043", "30243957", "1241708", "43784044", "21146210", "12629969", "43799254", "43810714", "40654018", "10000681", "43186019", "43638999", "43721850", "43808900", "43643206", "28162084", "43726424", "43810334", "9719583", "43798201", "43656639", "11272173", "5737433", "29646348", "30366284", "42377324", "43439050", "43738746", "43754594", "43783622", "43458015", "83491", "39956992", "9158944", "43103191", "43805134", "9135573", "11803554", "22312524", "43590916", "35646429", "25900423", "16541788", "25530780", "10694847", "5230734", "34250", "43803181", "40051386", "43802374", "42401252", "43784794", "43564493", "43799759", "36997891", "43795847", "1742484", "43681208", "36279824", "40912093", "42951661")
group by 1
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
