Question : cakephp group by count
Answered by : difficult-dolphin-dgsu0i14q44r
$query = $articles->find();
$query->select([ 'count' => $query->func()->count('view_count'), 'published_date' => 'DATE(created)'
])
->group('published_date')
->having(['count >' => 3]);Source : https://book.cakephp.org/3/en/orm/query-builder.html | Last Update : Wed, 14 Jul 21