user:grosse:pluginrepo
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
user:grosse:pluginrepo [2015-05-16 19:17] – 82.66.247.92 | user:grosse:pluginrepo [2015-05-16 19:53] – 82.66.247.92 | ||
---|---|---|---|
Line 1: | Line 1: | ||
<code bash> | <code bash> | ||
- | <code sql> | + | <code bash> |
+ | |||
+ | <code sql> | ||
+ | from popularity | ||
+ | where `key` = ' | ||
+ | group by value;</ | ||
+ | |||
+ | <code sql> | ||
+ | from popularity | ||
+ | where `key` = ' | ||
+ | and `value` like ' | ||
+ | and `dt` between 1429205349 and 1431797350;</ | ||
+ | |||
+ | |||
+ | <code sql> | ||
+ | select value, | ||
+ | from popularity | ||
+ | where `key`=' | ||
+ | and `dt` between 1429205349 and 1431797350 | ||
+ | and `uid` in ( | ||
+ | select uid | ||
+ | from popularity | ||
+ | where `key` = ' | ||
+ | and `value` like ' | ||
+ | and `dt` between 1429205349 and 1431797350) | ||
+ | group by value;</ | ||
+ | |||
+ | https:// |
user/grosse/pluginrepo.txt · Last modified: 2015-05-18 09:56 by 79.198.219.23