Fill Gaps in Statistical Time Series - Date by the hour

mysql.php

$requests = DB::table('advert_requests as ar')
    ->select(DB::raw("date_format(ar.created_at, '%Y-%m-%d %H' ) AS grouped_hour, count(*) AS requests"))
    ->join('placements as p', 'p.id', '=', 'ar.placement_id')
    ->where('ar.created_at', '>=', $from)
    ->where('p.site_id', $site_id)
    ->groupBy('grouped_hour')
    ->get();

You can't build the SQL query like this because the WITH ... needs to proceed everything. staudenmeier/laravel-cte is good. I've implemented CTEs in my PG driver the same way like he did.

We can do a session again some time. Send me a DM on Twitter if you want to.