#find ideas associated with duplicate content_items
Idea.find_by_sql("SELECT id, title, content_item_id FROM ideas INNER JOIN (SELECT content_item_id AS content_id FROM (SELECT COUNT(id), content_item_id FROM ideas WHERE content_item_type = 'VideoContent' GROUP BY content_item_id) AS grouped_ideas WHERE `COUNT(id)` > 1) AS dup_content ON ideas.content_item_id = dup_content.content_id")

#find ideas without content
Idea.scoped(:conditions => {:content_item => nil})