DokuWiki

It's better when it's simple

User Tools

Site Tools


Sidebar

Translations of this page?:

Learn about DokuWiki

Advanced Use

Corporate Use

Our Community


Follow us on Facebook, Twitter and other social networks.

Our Privacy Policy

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