user:grosse:pluginrepo
This is an old revision of the document!
xzcat b.xz | mysql
SELECT uid,dt,VALUE,COUNT(*) FROM popularity WHERE `key` = 'php_version' AND `value` LIKE '5.3.%' GROUP BY VALUE;
SELECT uid FROM popularity WHERE `key` = 'php_version' AND `value` LIKE '5.3.%' AND `dt` BETWEEN 1429205349 AND 1431797350;
SELECT VALUE,COUNT(*) FROM popularity WHERE `key`='version' AND `dt` BETWEEN 1429205349 AND 1431797350 AND `uid` IN ( SELECT uid FROM popularity WHERE `key` = 'php_version' AND `value` LIKE '5.3.%' AND `dt` BETWEEN 1429205349 AND 1431797350) GROUP BY VALUE;
https://github.com/splitbrain/dokuwiki-plugin-pluginrepo/blob/master/helper/popularity.php#L26
user/grosse/pluginrepo.1431798795.txt.gz · Last modified: 2015-05-16 19:53 by 82.66.247.92