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