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
user:grosse:pluginrepo [2015-05-16 19:17]
82.66.247.92
user:grosse:pluginrepo [2015-05-18 09:56] (current)
79.198.219.23
Line 1: Line 1:
 +[[plugin:​popularity]]
 +[[plugin:​repository]]
 +[[:​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(*) ​ <code sql>​select uid,​dt,​value,​count(*) ​
Line 5: Line 11:
 where `key` = '​php_version'​ and `value` like '​5.3.%' ​ where `key` = '​php_version'​ and `value` like '​5.3.%' ​
 group by value;</​code>​ 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.1431796676.txt.gz ยท Last modified: 2015-05-16 19:17 by 82.66.247.92