diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-12-30 12:31:08 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-12-30 12:31:08 +0100 |
| commit | e35a5070493a4d2ce27dacf1d52d5952b5b46237 (patch) | |
| tree | d54695f4757653e514df816c3aa65b06a14cc05d /recommend/data/get.sql | |
| parent | bdad37dd3f350a1ef059811ec4c0a02e3933d2d6 (diff) | |
| download | analyzer-develop.tar.gz analyzer-develop.zip | |
delete code unrelated to trueskillrelease/2.23.0release/2.22.0develop
Diffstat (limited to 'recommend/data/get.sql')
| -rw-r--r-- | recommend/data/get.sql | 16 |
1 files changed, 0 insertions, 16 deletions
diff --git a/recommend/data/get.sql b/recommend/data/get.sql deleted file mode 100644 index 2213ab1..0000000 --- a/recommend/data/get.sql +++ /dev/null @@ -1,16 +0,0 @@ -SELECT -hero.name, -role.name, -(SELECT name from item WHERE id=(SELECT SUBSTRING_INDEX(items, ',', 1))) AS item_1, -(SELECT name from item WHERE id=(SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(items, ',', 2), ',', -1))) AS item_2, -(SELECT name from item WHERE id=(SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(items, ',', 3), ',', -1))) AS item_3, -(SELECT name from item WHERE id=(SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(items, ',', 4), ',', -1))) AS item_4, -(SELECT name from item WHERE id=(SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(items, ',', 5), ',', -1))) AS item_5, -(SELECT name from item WHERE id=(SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(items, ',', 6), ',', -1))) AS item_6, -COUNT(*) AS cnt -FROM participant -JOIN participant_stats ON participant_stats.participant_api_id=participant.api_id -JOIN role ON participant.role_id=role.id -JOIN hero ON participant.hero_id=hero.id -GROUP BY hero.name, role.name, item_1, item_2, item_3, item_4, item_5, item_6 -ORDER BY cnt DESC |