DokuWiki

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