Differences

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

--- user:grosse:pluginrepo [2015-05-16 19:31] – 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>mysql pluginrepo</code>
 <code sql>select uid,dt,value,count(*)
@@ Line 5: / Line 11: @@
 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
-;</code>
+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