SELECT id FROM users WHERE active=1 AND about_me LIKE "%#leagueoflegends%" ORDER BY username ASC, num_followers DESC
0.01173
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#leagueoflegends($|\,)" ORDER BY username ASC
0.01541
SELECT id FROM users WHERE active=1 AND (username LIKE "%#leagueoflegends%" OR fullname LIKE "%#leagueoflegends%" OR position LIKE "%#leagueoflegends%") ORDER BY username ASC
0.01112
SELECT id FROM users WHERE active=1 AND (username="#leagueoflegends" OR fullname="#leagueoflegends" OR position="#leagueoflegends") ORDER BY username ASC