Hi, that sounds like pagination with conditions: http://groups.google.ch/group/cake-php/msg/09277228f45365ac
If I understood you correctly: if you want an average rating you have to read first all your datasets and loop though the array and create an average value of the ratings. So paging won't help there. Anja -----Ursprüngliche Nachricht----- Von: cake-php@googlegroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von mwcbrent Gesendet: Dienstag, 4. November 2008 05:21 An: CakePHP Betreff: Pagination with HasMany and SQL Aggregation I'm not sure that this is possible but if it is, it would put Cake into a special place in my heart. I have 2 related models Articles and Ratings. Articles hasMany Ratings A Rating has a User ID an Article ID and a Rating #. In order to get an articles rating I need to query all ratings by the Article ID and average them out. How would I paginate all Articles ordered by Rating? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---