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 sql>​select uid,​dt,​value,​count(*) from popularity where `key` = '​php_version'​ and `value` like '​5.3.%'​ group by value;</​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.1431796656.txt.gz · Last modified: 2015-05-16 19:17 by 82.66.247.92