https://bugzilla.wikimedia.org/show_bug.cgi?id=59340

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: mauro742 <mauro...@gmail.com>
Date: Tue, 16 Mar 2010 22:14:23
-------------------------------------------------------------------------------

Results here: http://toolserver.org/~mauro742/DBQ/DBQ-88.txt

Query for a single week:

    select rev_user_text as user, count(*) as tot
      from page join revision on page_id = rev_page
      where page_namespace=0 and page_title = 'Catholic_Church'
        and rev_user <> 0
        and year(rev_timestamp) = 2010 and week(rev_timestamp) = 1
      group by rev_user, week(rev_timestamp)
      order by tot desc, user
      limit 10;

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to