It's better when it's simple

User Tools

Site Tools



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 19:34]
user:grosse:pluginrepo [2015-05-18 09:54]
Line 1: Line 1:
 <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 17: Line 22:
 from popularity from popularity
 where `key`='​version'​ where `key`='​version'​
 +and `dt` between 1429205349 and 1431797350
 and `uid` in ( and `uid` in (
 select uid select uid
Line 24: Line 30:
 and `dt` between 1429205349 and 1431797350) and `dt` between 1429205349 and 1431797350)
 group by value;</​code>​ group by value;</​code>​
user/grosse/pluginrepo.txt ยท Last modified: 2015-05-18 09:56 by