schleyfox (owner)

Revisions

gist: 44034 Download_button fork
public
Public Clone URL: git://gist.github.com/44034.git
Embed All Files: show embed
Ruby #
raw 
1
2
3
4
5

#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})