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