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