joshsmith · October 6, 2010 08:27
diff --git a/interests_count.sql b/interests_count.sql
 SELECT interests.iid, interests.title, COUNT(*)
 FROM users_interests
 JOIN interests ON interests.iid = users_interests.iid
 WHERE users_interests.preference = 'dislike'
 GROUP BY interests.iid
 ORDER BY COUNT(*) DESC
 LIMIT 10;
	SELECT interests.iid, interests.title, COUNT(*)
	FROM users_interests
	JOIN interests ON interests.iid = users_interests.iid
	WHERE users_interests.preference = 'dislike'
	GROUP BY interests.iid
	ORDER BY COUNT(*) DESC
	LIMIT 10;