user:grosse:pluginrepo
popularity repository popularity
xzcat b.xz | mysql
mysql pluginrepo
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.txt · Last modified: 2015-05-18 09:56 by 79.198.219.23