Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Pavan santhosh.s
.
Toggle Highlighting
SQL
use tewiki_p; select rev_user_text, rev_page, rev_page_title from page SUM(rev_len) from revision where rev_id in ( "54582", "24030", "21918", "859", "72198", "261377", "65061", "9286", "106046", "75456", "48596", "112864", "54097", "2485", "6960", "226081", "16483", "142013", "166669", "6686", "78042", "53152", "76021", "76331", "136952", "802", "113370", "261667", "116606", "9319", "40355", "56016", "9457", "82249", "1496", "51040", "96580", "105009", "6471", "35602", "133255", "39083", "84960", "60611", "5357", "40017", "67728", "231545", "63088", "39249", "217920", "65599", "155205", "115380", "1509", "1867", "105812", "7543", "6969", "192852", "7827", "102365", "56014", "2482", "7836", "9108", "45240", "3400", "9770", "6790", "64367", "13455", "37171", "107877", "9424", "155638", "16980", "76112", "81695", "2764", "93452", "85543", "4257", "35741", "135817", "79968", "40524", "63072", "75419", "83662", "63810", "9227", "64952", "217523", "37976", "64977", "66757", "78063", "65452", "1374", "62485", "36295", "85180", "13910", "5395", "30265", "134912", "40967", "38455", "113247", "231683", "5273", "105228", "90230", "48476", "27632", "13841", "124179", "5284", "137238", "39240", "7364", "5276", "61058", "140714", "9252", "5283", "6479", "147115", "24849", "102335", "84949", "12162", "89805", "6108", "223490", "72922", "30600", "247435", "98212", "5871", "72882", "204777", "21535", "78753", "192919", "13457", "78403", "77105", "76693", "161208", "151388", "107468", "9783", "230493", "107294", "72056", "93647", "93711", "93534", "48409", "98662", "72069", "113095", "120822", "106918", "2443", "10206", "115302", "24247", "1865", "9150", "90062", "59991", "54846", "139774", "77314", "110817", "165305", "55392", "37275", "72281", "40527", "191542", "64914", "83661", "1193", "35432", "91332", "76494", "3659", "3195", "63407", "10300", "115919", "131909", "65781", "863", "39134", "108850", "50684", "74338", "63601", "38300", "31355", "1152", "13730", "181580", "40776", "155511", "73161", "2468", "223406", "84572", "38444", "7797", "6046", "229951", "168039", "102123", "111457", "5348", "91486", "122437", "40339", "105395", "73847", "38402", "157441", "6493", "1395", "63338" ) group by rev_user_text order by SUM(rev_len) desc;
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
.
Checking query status...