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