@Webweave. That's the article I was struggling with. I'll drink a few more cups of coffee and have another look.
I'll use your select field tip in the meantime. On Jan 18, 3:46 pm, Webweave <[email protected]> wrote: > Easiest way I've found is just to include a select field in the query > like: > > $data = $this->find("all", array( > "fields"=>array( > "Tag.id", > "Tag.name", > "(select COUNT(Article.id) from > articles Article where Article.tag_id = Tag.id and Article.published = > 1) AS tag_count" > ))); > > Here's an example of using the > finderQuery:http://groups.google.com/group/cake-php/msg/c10840be78a34df0 > > On Jan 17, 12:55 am, RichardAtHome <[email protected]> wrote: > > > Given the following Model relations: > > > article <-- HABTM (articles_tags) --> tag > > > How do I fetch back a list of Tags with the count of associated > > Articles? > > > I've tried (in the Tag Model): > > > $data = $this->find("all", array( > > "fields"=>array( > > "Tag.id", > > "Tag.name", > > "COUNT(Article.id) AS tag_count" > > ), > > "conditions"=>array( > > "Article.published" => 1 > > ), > > "group" => "Tag.id" > > )); > > > But that doesn't generate the HABTM join in the SQL: > > > SQL Error: 1054: Unknown column 'Article.id' in 'field list' > > SELECT `Tag`.`id`, `Tag`.`name`, COUNT(`Article`.`id`) AS tag_count > > FROM `tags` AS `Tag` WHERE `Article`.`published` = 1 GROUP BY > > `Tag`.`id` > > > Thanks in advance :-) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
