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 tewikisource_p; SELECT anon_1.rev_user_text AS anon_1_rev_user_text, sum(anon_1.byte_change) AS net_sum, sum(abs(anon_1.byte_change)) AS absolute_sum, sum(CASE WHEN (anon_1.byte_change > 0) THEN anon_1.byte_change ELSE 0 END ) AS positive_only_sum, sum(CASE WHEN (anon_1.byte_change < 0) THEN anon_1.byte_change ELSE 0 END ) AS negative_only_sum FROM (SELECT revision.rev_user AS rev_user, revision.rev_user_text AS rev_user_text, ( cast(revision.rev_len as signed) - cast(coalesce(anon_2.rev_len, 0) as signed) ) AS byte_change FROM revision INNER JOIN page ON page.page_id = revision.rev_page LEFT OUTER JOIN (SELECT revision.rev_id AS rev_id, revision.rev_len AS rev_len FROM revision ) AS anon_2 ON revision.rev_parent_id = anon_2.rev_id WHERE page.page_namespace IN ('0') AND page.page_title contains ( “10879telugukaavy034400mbp.pdf”, “2030020025431_-_chitra_leikhanamu.pdf”, “Aandhra_deishamu_videisha_yaatrikulu.pdf”, “Aandhra_saahitya_parishhatpattrika,_sanputam_24,_sanchika_5,_1934.pdf“, “Aandhrapatrika_sanvatsaraadi_sanchika_1910.pdf“, “Aandhrasarvasvamu_sachitra_maasapatrika_sanputamu_1sanchika1jan1924.pdf”, “Abhinaya_darpanamu.pdf”, “Adhunikarajyanga025633mbp.pdf”, “Agni_kriida.pdf”, “Andhraveerulupar025903mbp.pdf”, “Andhraveerulupar025958mbp.pdf”, “Andrulasangikach025988mbp.pdf”, “Bhaarati_sanputamu_3_sanchika_8_aug_1926.pdf”, “Bhaarati_sanputamu_8_sanchika_1_jan_1931.pdf”, “Bharatiyanagarik018597mbp.pdf”, “Bhaskarasatakamu00bhassher.pdf”, “Chanpuramayanam018866mbp.pdf”, “GanapathiMuniCharitraSamgraham.djvu”, “Ganavidyavinodini.pdf”, “GodavarisimaJanapadaKalaluKridaluVedukalu.djvu”, “Grandaalayasarvasvamu_sanputi_7sanchika_1jul1928.pdf”, “Grandhaalayasarvasvamu,_sanputi_9,_sanchika_4_january_1935.pdf”, “Grihalaxmi,_sanputi_7,_sanchika_1.pdf”, “Hatha_Yoga_Pradeepika.pdf”, “Kameshwaraishata020621mbp.pdf”, “Kasiyatracharitr020670mbp.pdf”, “Kathalu_gaathalu_modati_bhaagamu.pdf”, “Kinnera,_sanputam_2,_sanchika_7,_july_1950.pdf”, “Kokkookamu.pdf”, “Maanavaseiva,_sanputamu_Iii,_sanchika_1,_may_1913.pdf”, “Madhavanidanamu.pdf”, “MaharshulaCharitraluVol6.djvu”, “Mollaramayanam2.djvu”, “Naajeevitayatrat021599mbp.pdf”, “Naatyakala_maasapatrika,_sanputi_1,_sanchika_2,_april_1935.pdf”, “Nanakucharitra021651mbp.pdf”, “NavarasaTarangini.djvu”, “NelooreJillaGramaNamaluBhashaSamajikaParishilana.djvu”, “Parishodhana_sanputi1_sanchika3_Aug-sep_1954.pdf”, “RameshwaraMahatyamu.djvu”, “Shrii_raamakrxshhna_prabha_janavari_1952.pdf”, “SriAndhrakaviTharangeniSamput6.djvu”, “TeluguJaateeyamuluPartI.djvu”, “VarnasramaDarmamulu.pdf”, “10879telugukaavy034400mbp.pdf”, “2030020025431_-_chitra_leikhanamu.pdf”, “Aandhra_deishamu_videisha_yaatrikulu.pdf”, “Aandhra_saahitya_parishhatpattrika,_sanputam_24,_sanchika_5,_1934.pdf”, “Aandhrapatrika_sanvatsaraadi_sanchika_1910.pdf”, “Aandhrasarvasvamu_sachitra_maasapatrika_sanputamu_1sanchika1jan1924.pdf”, “Abhinaya_darpanamu.pdf”, “Adhunikarajyanga025633mbp.pdf”, “Agni_kriida.pdf”, “Andhraveerulupar025903mbp.pdf”, “Andhraveerulupar025958mbp.pdf”, “Andrulasangikach025988mbp.pdf”, “Bhaarati_sanputamu_3_sanchika_8_aug_1926.pdf”, “Bhaarati_sanputamu_8_sanchika_1_jan_1931.pdf”, “Bharatiyanagarik018597mbp.pdf”, “Bhaskarasatakamu00bhassher.pdf”, “Chanpuramayanam018866mbp.pdf”, “GanapathiMuniCharitraSamgraham.djvu”, “Ganavidyavinodini.pdf”, “GodavarisimaJanapadaKalaluKridaluVedukalu.djvu”, “Grandaalayasarvasvamu_sanputi_7sanchika_1jul1928.pdf”, “Grandhaalayasarvasvamu,_sanputi_9,_sanchika_4_january_1935.pdf”, “Grihalaxmi,_sanputi_7,_sanchika_1.pdf”, “Hatha_Yoga_Pradeepika.pdf”, “Kameshwaraishata020621mbp.pdf”, “Kasiyatracharitr020670mbp.pdf”, “Kathalu_gaathalu_modati_bhaagamu.pdf”, “Kinnera,_sanputam_2,_sanchika_7,_july_1950.pdf”, “Kokkookamu.pdf”, “Maanavaseiva,_sanputamu_Iii,_sanchika_1,_may_1913.pdf“, “Madhavanidanamu.pdf“, “MaharshulaCharitraluVol6.djvu“, “Mollaramayanam2.djvu“, “Naajeevitayatrat021599mbp.pdf“, “Naatyakala_maasapatrika,_sanputi_1,_sanchika_2,_april_1935.pdf“, “Nanakucharitra021651mbp.pdf“, “NavarasaTarangini.djvu“, “NelooreJillaGramaNamaluBhashaSamajikaParishilana.djvu“, “Parishodhana_sanputi1_sanchika3_Aug-sep_1954.pdf“, “RameshwaraMahatyamu.djvu“, “Shrii_raamakrxshhna_prabha_janavari_1952.pdf“, “SriAndhrakaviTharangeniSamput6.djvu“, “TeluguJaateeyamuluPartI.djvu“, “VarnasramaDarmamulu.pdf“ ) AND revision.rev_timestamp > 20140801000000 AND revision.rev_timestamp < 20150401000000 ) AS anon_1 GROUP BY anon_1.rev_user_text;
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...