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