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