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