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