Public feed
#890774
$widgets = Doctrine_Query::create()
->select('w.*, p.*, COUNT(p.partid) count')
->from('Widget w')
->leftJoin('w.Parts p')
->groupBy('w.widgetid')
->orderBy('count')
->execute();$widgets = Doctrine_Query::create()
->select('w.*, p.*, COUNT(p.partid) count')
->from('Widget w')
->leftJoin('w.Parts p')
->groupBy('w.widgetid')
->orderBy('count')
->execute();