SELECT id FROM groups WHERE about_me LIKE "%#z-rock%" AND id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY title ASC, num_followers DESC
0.00046
SELECT id FROM groups WHERE (groupname LIKE "%#z-rock%" OR title LIKE "%#z-rock%") 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="#z-rock" OR title="#z-rock") AND id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY title ASC, num_followers DESC