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

This is an old revision of the document!


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.1431798827.txt.gz · Last modified: 2015-05-16 19:53 by 82.66.247.92