Sheng Jiong wrote:
Hi, everybody. Some sysops in Chinese Wikipedia want to know how to check the number of artiles that are *edited* in a *day* through sql query. Anyone has any idea?
Try this:
SELECT COUNT(DISTINCT rc_title) FROM recentchanges WHERE rc_namespace=0 AND rc_timestamp LIKE '20030623%'
Change '20030623' to the desired date you want to check; note that the recentchanges tables usually only stores the last few days' worth (recent, no? ;)
If you want to also count non-article pages, change to:
SELECT COUNT(DISTINCT rc_namespace,rc_title) FROM recentchanges WHERE rc_timestamp LIKE '20030623%'
It should be possible to rig it up to check exactly the last 24 hours or whatever, but since we don't use the standard date/time column type it's a little tricky to do ad-hoc.
-- brion vibber (brion @ pobox.com)