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