SELECT id FROM users WHERE active=1 AND about_me LIKE "%#Ливърпул%" ORDER BY username ASC, num_followers DESC
0.00769
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#Ливърпул($|\,)" ORDER BY username ASC
0.01053
SELECT id FROM users WHERE active=1 AND (username LIKE "%#Ливърпул%" OR fullname LIKE "%#Ливърпул%" OR position LIKE "%#Ливърпул%") ORDER BY username ASC
0.00963
SELECT id FROM users WHERE active=1 AND (username="#Ливърпул" OR fullname="#Ливърпул" OR position="#Ливърпул") ORDER BY username ASC