MySQL Groupwise Maximum

A common problem, it seems is getting the most recent field/record along with every parent or related record in a dataset.

Most Recent Record

So let us break it down and do it just for the table containing the maximum’s we want:

SELECT
  user_id, MAX(created_at)
FROM
  orders
GROUP BY
  user_id

I tried this, but unfortunately I got an error from mysql:

Lost connection to MySQL during query

Sources