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