user:grosse:pluginrepo
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext 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: | ||
| + | [[plugin: | ||
| + | [[: | ||
| + | |||
| <code bash> | <code bash> | ||
| + | |||
| + | <code bash> | ||
| <code sql> | <code sql> | ||
| Line 5: | Line 11: | ||
| where `key` = ' | where `key` = ' | ||
| group by value;</ | 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.1431796676.txt.gz · Last modified: 2015-05-16 19:17 by 82.66.247.92