Untitled query #2980

This query is marked as a draft This query has been published by వైజాసత్య.
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 ('104')
              AND page.page_title REGEXP
'10879telugukaavy034400mbp|
2030020025431 - chitra leikhanamu|
Aandhra deishamu videisha yaatrikulu|
Aandhra saahitya parishhatpattrika, sanputam 24, sanchika 5, 1934|
Aandhrapatrika sanvatsaraadi sanchika 1910|
Aandhrasarvasvamu sachitra maasapatrika sanputamu 1sanchika1jan1924|
Abhinaya darpanamu|
Adhunikarajyanga025633mbp|
Agni kriida|
Andhraveerulupar025903mbp|
Andhraveerulupar025958mbp|
Andrulasangikach025988mbp|
klinu jiivita charitramu|
Bhaarati sanputamu 3 sanchika 8 aug 1926|
Bhaarati sanputamu 8 sanchika 1 jan 1931|
Bharatiyanagarik018597mbp|
Bhaskarasatakamu00bhassher|
Chanpuramayanam018866mbp|
GanapathiMuniCharitraSamgraham|
Ganavidyavinodini|
GodavarisimaJanapadaKalaluKridaluVedukalu|
Grandaalayasarvasvamu sanputi 7sanchika 1jul1928|
Grandhaalayasarvasvamu, sanputi 9, sanchika 4 january 1935|
Grihalaxmi, sanputi 7, sanchika 1|
Hatha Yoga Pradeepika|
Kameshwaraishata020621mbp|
Kasiyatracharitr020670mbp|
Kathalu gaathalu modati bhaagamu|
Kinnera, sanputam 2, sanchika 7, july 1950|
Kokkookamu|
Maanavaseiva, sanputamu Iii, sanchika 1, may 1913|
Madhavanidanamu|
MaharshulaCharitraluVol6|
Mollaramayanam2|
Naajeevitayatrat021599mbp|
Naatyakala maasapatrika, sanputi 1, sanchika 2, april 1935|
Nanakucharitra021651mbp|
NavarasaTarangini|
NelooreJillaGramaNamaluBhashaSamajikaParishilana|
Parishodhana sanputi1 sanchika3 Aug-sep 1954|
RameshwaraMahatyamu|
Shrii raamakrxshhna prabha janavari 1952|
SriAndhrakaviTharangeniSamput6|
TeluguJaateeyamuluPartI|
VarnasramaDarmamulu|
telugukaavy034400mbp|
chitra leikhanamu|
Aandhra deishamu videisha yaatrikulu|
Aandhra saahitya parishhatpattrika, sanputam 24, sanchika 5, 1934|
Aandhrapatrika sanvatsaraadi sanchika 1910|
Aandhrasarvasvamu sachitra maasapatrika sanputamu 1sanchika1jan1924|
Abhinaya darpanamu|
Adhunikarajyanga025633mbp|
Agni kriida|
Andhraveerulupar025903mbp|
Andhraveerulupar025958mbp|
Andrulasangikach025988mbp|
Bhaarati sanputamu 3 sanchika 8 aug 1926|
Bhaarati sanputamu 8 sanchika 1 jan 1931| 
Bharatiyanagarik018597mbp|
Bhaskarasatakamu00bhassher|
Chanpuramayanam018866mbp|
GanapathiMuniCharitraSamgraham|
Ganavidyavinodini|
GodavarisimaJanapadaKalaluKridaluVedukalu|
Grandaalayasarvasvamu sanputi 7sanchika 1jul1928|
Grandhaalayasarvasvamu, sanputi 9, sanchika 4 january 1935|
Grihalaxmi, sanputi 7, sanchika 1|
Hatha Yoga Pradeepika|
Kameshwaraishata020621mbp|
Kasiyatracharitr020670mbp|
Kathalu gaathalu modati bhaagamu|
Kinnera, sanputam 2, sanchika 7, july 1950|
Kokkookamu|
Maanavaseiva, sanputamu Iii, sanchika 1, may 1913|
Madhavanidanamu|
MaharshulaCharitraluVol6|
Mollaramayanam2|
Naajeevitayatrat021599mbp|
Naatyakala maasapatrika, sanputi 1, sanchika 2, april 1935|
Nanakucharitra021651mbp|
NavarasaTarangini|
NelooreJillaGramaNamaluBhashaSamajikaParishilana|
Parishodhana sanputi1 sanchika3 Aug-sep 1954|
RameshwaraMahatyamu|
Shrii raamakrxshhna prabha janavari 1952|
SriAndhrakaviTharangeniSamput6|
TeluguJaateeyamuluPartI|
VarnasramaDarmamulu'






                                    
                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.
SQL

Checking query status...
