From e35a5070493a4d2ce27dacf1d52d5952b5b46237 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Sat, 30 Dec 2017 12:31:08 +0100
Subject: delete code unrelated to trueskill

---
 recommend/data/get.sql | 16 ----------------
 1 file changed, 16 deletions(-)
 delete mode 100644 recommend/data/get.sql

(limited to 'recommend/data/get.sql')

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
-- 
cgit v1.3.1

