[Bug 59289] DBQ-33 Salli contributions on it.wiki

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59289

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Bryan Tong Minh 
Date: Wed, 30 Jul 2008 10:29:03
---

Only one row in set:

#[[Reggio_di_Calabria]]
(http://it.wikipedia.org/w/index.php?title=Reggio_di_Calabria&action=history
Cron - 6364)

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


[Bug 59289] DBQ-33 Salli contributions on it.wiki

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59289

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Pietrodn 
Date: Sat, 02 Aug 2008 14:45:48
---

Done. I posted the results on
http://it.wikipedia.org/wiki/Utente:Incola/Edit_Salli

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


[Bug 59289] DBQ-33 Salli contributions on it.wiki

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59289

Bugzilla Bug Importer (valhallasw)  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
 ---

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: (none)
CC list: bryan.tongm...@gmail.com, power...@gmail.com

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


[Bug 59289] DBQ-33 Salli contributions on it.wiki

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59289

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Incola 
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