>> Photo.find_by_sql("SELECT DISTINCT `photos`.id FROM `photos` LEFT OUTER JOIN `category_entry_links` cel0 ON cel0.photo_id = photos.id LEFT OUTER JOIN `category_entries` ce0 ON ce0.id = cel0.category_entry_id LEFT OUTER JOIN `categories` cat0 ON cat0.id = ce0.category_id WHERE (cat0.number = 3 AND ce0.id = '3');")
=> [#<Photo id: 2615047>, #<Photo id: 2615052>, #<Photo id: 2615057>, #<Photo id: 2615062>, #<Photo id: 2615067>, #<Photo id: 2615072>, #<Photo id: 2615077>, #<Photo id: 2615082>, #<Photo id: 2615087>, #<Photo id: 2615092>, #<Photo id: 2615097>, #<Photo id: 2615102>, #<Photo id: 2615107>, #<Photo id: 2615112>, #<Photo id: 2615117>, #<Photo id: 2615122>, #<Photo id: 2615127>, #<Photo id: 2615132>, #<Photo id: 2615137>, #<Photo id: 2615142>, #<Photo id: 2615147>, #<Photo id: 2615152>, #<Photo id: 2615157>, #<Photo id: 2615162>, #<Photo id: 2615167>, #<Photo id: 2615172>, #<Photo id: 2615177>, #<Photo id: 2615182>, #<Photo id: 2615187>]
>> Photo.count_by_sql("SELECT DISTINCT `photos`.id FROM `photos` LEFT OUTER JOIN `category_entry_links` cel0 ON cel0.photo_id = photos.id LEFT OUTER JOIN `category_entries` ce0 ON ce0.id = cel0.category_entry_id LEFT OUTER JOIN `categories` cat0 ON cat0.id = ce0.category_id WHERE (cat0.number = 3 AND ce0.id = '3' AND cel0.id IS NOT NULL);")
=> 2615047