SELECT id FROM groups WHERE about_me LIKE "%Team Fortress 2%" AND id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY title ASC, num_followers DESC
0.00043
SELECT id FROM groups WHERE (groupname LIKE "%Team Fortress 2%" OR title LIKE "%Team Fortress 2%") AND id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY title ASC, num_followers DESC
0.00040
SELECT id FROM groups WHERE (groupname="Team Fortress 2" OR title="Team Fortress 2") AND id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY title ASC, num_followers DESC