https://bugzilla.wikimedia.org/show_bug.cgi?id=68867
--- Comment #3 from Sam Reed (reedy) <[email protected]> --- mysql:wikiadmin@db1038 [oai]> select oa_agent, count(oa_agent) from oaiaudit where oa_client = 0 group by oa_agent; +-----------------------------------------------------------------------------------------------+-----------------+ | oa_agent | count(oa_agent) | +-----------------------------------------------------------------------------------------------+-----------------+ | MediaWiki OAI Harvester 0.2 (http://www.mediawiki.org/) (client id: nttr.co.jp; experimental) | 5228 | +-----------------------------------------------------------------------------------------------+-----------------+ 1 row in set (0.58 sec) mysql:wikiadmin@db1038 [oai]> select oa_agent, count(oa_agent) from oaiaudit group by oa_agent; +-----------------------------------------------------------------------------------------------+-----------------+ | oa_agent | count(oa_agent) | +-----------------------------------------------------------------------------------------------+-----------------+ | DBpedia Sync - http://dbpedia.org - [email protected] | 250216 | | Java/1.6.0_38 | 1061315 | | MediaWiki OAI Harvester 0.2 (http://www.mediawiki.org/) | 37351 | | MediaWiki OAI Harvester 0.2 (http://www.mediawiki.org/) (client id: nttr.co.jp; experimental) | 5228 | +-----------------------------------------------------------------------------------------------+-----------------+ 4 rows in set (9.06 sec) mysql:wikiadmin@db1038 [oai]> select oa_client, ou_name, count(oa_client) from oaiaudit left join oaiuser on oa_client = ou_id group by oa_client; +-----------+--------------+------------------+ | oa_client | ou_name | count(oa_client) | +-----------+--------------+------------------+ | 0 | NULL | 5228 | | 6 | lsearch2 | 1061348 | | 12 | fresheye.com | 37351 | | 13 | dbpedia | 250217 | +-----------+--------------+------------------+ 4 rows in set (1.48 sec) mysql:wikiadmin@db1038 [oai]> -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
