php - Invalid parameter number Laravel

Question

I am trying to pass some parameters to my Laravel query Builder but it returns Invalid parameter number Error

$tapuser = "";
if (@Session::get('user_admin_sub') > 0) {
    $params['user_admin_sub'] = intval(Session::get('user_admin_sub'));
    $tapuser = "and notes.user_id = :user_admin_sub";
}
$params['start'] = $request->start;
$params['end'] = $request->end;
$params['userId'] = Auth::id();
$data = [];

$confirmation_call = DB::select("select count(*) as nbr from orders, notes 
    where orders.id = notes.order_id 
    and orders.user_id=:userId and notes.note like '%CC: %'
    and notes.user_id=:userId 
    and (notes.created_at BETWEEN :start AND :end) $tapuser", $params);

question from:https://stackoverflow.com/questions/66051004/invalid-parameter-number-laravel

Answer 1

Waitting for answers