Cakephp group by count

$query = $articles->find();
$query->select([
    'count' => $query->func()->count('view_count'),
    'published_date' => 'DATE(created)'
])
->group('published_date')
->having(['count >' => 3]);

Source: book.cakephp.org

Similar codes

0 vote122 views1 answer
How to index column in laravel
PHP
0 vote120 views1 answer
Disable update notification for individual plugins
PHP
0 vote121 views1 answer
How to start on row 2 spreadsheet inserting to database using php
PHP
0 vote115 views1 answer
How to install php-fpm
PHP
3 votes124 views2 answers
Laravel add values to request
PHP
2 votes140 views1 answer
Web scraping php
PHP
2 votes121 views1 answer
Laravel model quard
PHP
1 vote121 views2 answers
Macos install php 7.4
PHP
12 votes170 views6 answers
Laravel api routes
PHP
0 vote112 views1 answer
Laravel subtract date
PHP