Сakephp оформить запрос в finder

Построил запрос в контроллере, может кому пригодиться!

$connection = ConnectionManager::get('default');
$details = $connection
    ->newQuery()
    ->select(['Users.name', 'user_id', 'start' => 'work_period, MIN(datetime)', 'end' => 'MAX(datetime)', 'TIMEDIFF(MAX(datetime)', 'result' => 'MIN(datetime))'])
    ->from('(select user_id, datetime, @workperiod:=@workperiod+if(datetime>@prev+interval 15 minute,1,0) as work_period,@prev:=datetime from user_log, (select @prev:=NULL, @workperiod:=1) X order by datetime) A INNER JOIN users as Users ON Users.id = user_id')
    ->where(['datetime LIKE' => $date."%"])
    ->group(['work_period', 'user_id'])
    ->execute()
    ->fetchAll('assoc');