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 revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
user:grosse:pluginrepo [2015-05-16 19:17] 82.66.247.92user:grosse:pluginrepo [2015-05-16 19:53] 82.66.247.92
Line 1: Line 1:
 <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.txt · Last modified: 2015-05-18 09:56 by 79.198.219.23

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki