$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']);
});
set_time_limit(600);
Artisan::call('youtrack:sync', [], $buffer);
Model::where(function ($query) {
$query->where('user_id', 1)
->or_where('friend_id', 1);
})
->where(function ($query) {
$query->where('user_id', 2)
->orWhere('friend_id', 2);
})
->get();