hOtRush

$results = DB::select( DB::raw("SELECT products.title, products.price, x.sales  
 
FROM products 
        
      INNER JOIN 
            (
            SELECT product_id, 
            
            MAX(sales) AS sales 
            
            FROM offers 
            
              GROUP BY product_id 
            
            ) x
            
      ON x.product_id = products.id 
            
        
ORDER BY x.sales DESC LIMIT 20") );

$builder = $builder->whereHas('resource', function ($query) use ($filter) {
    $method = $filter['operation'] === 'in' ? 'whereIn' : 'where';
    $query->$method($filter['name'], $filter['value']);
});

Еще пробовал phpmailer, но там какая-то ошибка и не работает почта гугла и мэйла