--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: Hoo man <>
Date: Fri, 06 Jul 2012 14:38:36

Detecting if a user was new at a given time isn't trivial, so I left that out
for now. Please notice, that IPs are counted as users as well.  

    SELECT /* SLOW_OK */ COUNT(*) AS edit_count, COUNT(DISTINCT rev_user_text)
AS user_count, LEFT(rev_timestamp, 6) AS month FROM page INNER JOIN revision ON
rev_page = page_id WHERE page_namespace = 4 AND page_title LIKE
'Pagine_da_cancellare/%' AND LEFT(rev_timestamp, 6) > 201000 GROUP BY
LEFT(rev_timestamp, 6);

Result: (plain text)

You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to