SELECT photos.* FROM photos, tags, taggings LEFT OUTER JOIN moderations m ON photos.id = m.moderatable_item_id AND m.moderatable_item_type = 'Photo' WHERE photos.id = taggings.taggable_id AND taggings.taggable_type = 'Photo' AND taggings.tag_id = tags.id AND (tags.name='kittens') AND m.state='accepted' GROUP BY photos.id ORDER BY created_at DESC  LIMIT 5