The worst query atm

the-worst-query-atm

SELECT item.item0 FROM
(SELECT item0 FROM situationalItems WHERE type = 1 
 AND build IN (SELECT id FROM build WHERE champion = ? AND mode = ? AND role = ? AND position = ?) UNION ALL
 SELECT item1 FROM situationalItems WHERE type = 1 
 AND build IN (SELECT id FROM build WHERE champion = ? AND mode = ? AND role = ? AND position = ?) UNION ALL
 SELECT item2 FROM situationalItems WHERE type = 1 
 AND build IN (SELECT id FROM build WHERE champion = ? AND mode = ? AND role = ? AND position = ?)) 
 AS item GROUP BY item.item0 ORDER BY COUNT(*) DESC LIMIT 3

Holy shit !