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