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