Tuesday, November 24, 2009

massive rails find




a = Recording.find :all, :joins => "INNER JOIN annotations ON annotations.recording_id = recordings.id", :select => "record\
ings.*, count(annotations.id) annotations_count", :group => "annotations.recording_id HAVING annotations_count > 1"

From : Find users with at least 'n' items