Hi, I have this SQL a need to transform to ORM. I I appreciate any approach
LOGS id - group_id - data 1 1 'Lorem ipsum 1' 2 1 'Lorem ipsum 2' 3 2 'Lorem ipsum 3' SQL return the latest record in your group: id - group_id - data 2 1 'Lorem ipsum 2' 3 2 'Lorem ipsum 3' SELECT logs.id,logs.group_id,logs.data FROM logs LEFT JOIN logs AS latest ON (logs.group_id = latest.group_id AND logs.id < latest.id) WHERE latest.id IS NULL ORDER BY logs.id DESC -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
