mysqli query order by before group by code example
Example: mysqli query order by before group by
//it is vary difficult to find a query that uses Order By before Group By
//so, below is the query when you want to first order the results in Asc (min) or Desc (max) order, and then Group by
$raw_query = 'SELECT p1.* FROM table1 p1
INNER JOIN ( SELECT max(firstValue) MaxAnyId, secondValue
FROM table1
WHERE user_id=162
AND status_id=70
GROUP BY secondValue
) p2
ON p1.secondValue = p2.secondValue
AND p1.firstValue = p2.MaxLogId
WHERE p1.user_id=162
AND p1.status_id=70
order by p1.firstValue desc';
//for Laravel ->
$q = \DB::select($raw_query);