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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Tue, 27 Sep 2011 21:36:48
-------------------------------------------------------------------------------

Well, the topic of this project is more about running queries on WMF databases
than on writing SQL queries, but here we go:

    SELECT COUNT(*) FROM revision WHERE rev_user_text = 'User name' AND
rev_timestamp < TimestampOfTheTimeWeCountQueriesUpTo;

Please notice that Mediawiki uses it's own timestamp format.

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