This is because you are using Model::query and not declaring your tables as cake would expect hence the arrays are returned with different keys that you are used to when returning data with Model::find (singular camelcased versions of your table names).
Now I can see you are running subqueries so you probably have a good reason for using Model::query (I have not tried running sub-queries using Model::find myself) but whenever reverting to using Model::query you need to make the decision to define all of your tables as cake expects or to change your controller/view logic to look for data in your non cake-like data arrays. HTH Paul. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using "remove me" as the subject.