SELECT id FROM users WHERE active=1 AND about_me LIKE "%#Лудогорец%" ORDER BY username ASC, num_followers DESC
0.00777
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#Лудогорец($|\,)" ORDER BY username ASC
0.01069
SELECT id FROM users WHERE active=1 AND (username LIKE "%#Лудогорец%" OR fullname LIKE "%#Лудогорец%" OR position LIKE "%#Лудогорец%") ORDER BY username ASC
0.00949
SELECT id FROM users WHERE active=1 AND (username="#Лудогорец" OR fullname="#Лудогорец" OR position="#Лудогорец") ORDER BY username ASC