https://bugzilla.wikimedia.org/show_bug.cgi?id=59324
--- Comment #3 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: Betacommand <phoenixoverr...@gmail.com> Date: Sat, 26 Dec 2009 04:03:03 ------------------------------------------------------------------------------- SELECT u.user_name, COUNT(l.log_id) AS antall FROM logging l LEFT JOIN user u ON (l.log_user = u.user_id) WHERE log_type = 'patrol' AND log_timestamp > '20091125000000' AND log_params LIKE '%0' GROUP BY u.user_name ORDER BY antall 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