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