SELECT id FROM groups WHERE about_me LIKE "%#teamfortress%" AND id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY title ASC, num_followers DESC
0.00048
SELECT id FROM groups WHERE (groupname LIKE "%#teamfortress%" OR title LIKE "%#teamfortress%") AND id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY title ASC, num_followers DESC
0.00042
SELECT id FROM groups WHERE (groupname="#teamfortress" OR title="#teamfortress") AND id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY title ASC, num_followers DESC