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