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