DokuWiki

It's better when it's simple

User Tools

Site Tools


user:grosse:pluginrepo

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
user:grosse:pluginrepo [2015-05-16 18:45]
82.66.247.92
user:grosse:pluginrepo [2015-05-18 09:54]
79.198.219.23
Line 1: Line 1:
 +[[plugin:​popularity]]
 +[[popularity]]
 +
 <code bash>​xzcat b.xz | mysql</​code>​ <code bash>​xzcat b.xz | mysql</​code>​
 +
 +<code bash>​mysql pluginrepo</​code>​
 +
 +<code sql>​select uid,​dt,​value,​count(*) ​
 +from popularity ​
 +where `key` = '​php_version'​ and `value` like '​5.3.%' ​
 +group by value;</​code>​
 +
 +<code sql>​select uid
 +from popularity ​
 +where `key` = '​php_version'​
 +and `value` like '​5.3.%' ​
 +and `dt` between 1429205349 and 1431797350;</​code>​
 +
 +
 +<code sql>
 +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;</​code>​
 +
 +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