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

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Incola <diegmo...@gmail.com>
Date: Wed, 30 Jul 2008 11:10:03
-------------------------------------------------------------------------------

Sorry, the query wasn't correct. I've forgotten GROUP BY.  
In fact this user has a lot of contributions. That is the correct query:

    SELECT CONCAT( "#[[", title, "]]
([http://it.wikipedia.org/w/index.php?title=";, title, "&action=history Cron] -
", number, ")" )
    FROM (
    SELECT page_title AS title, count( * ) AS number
    FROM page
    JOIN revision ON page_id = rev_page
    WHERE page_namespace = '0'
    AND rev_user_text LIKE "Salli"
    GROUP BY page_title
    ) AS pages
    ORDER BY number DESC ;

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