SELECT
a.*
FROM
starnet_wifi_lingering a,
(
SELECT
NAME,
MAX(date_time) max_time
FROM
starnet_wifi_lingering
WHERE
DATE_TIME < '2018-06-05 10:00:00'
AND DATA_TYPE = 1
GROUP BY
`NAME`
) AS b
WHERE
a.`NAME` = b.`NAME`
AND a.DATE_TIME = b.max_time
ORDER BY
a.DATE_TIME
a.*
FROM
starnet_wifi_lingering a,
(
SELECT
NAME,
MAX(date_time) max_time
FROM
starnet_wifi_lingering
WHERE
DATE_TIME < '2018-06-05 10:00:00'
AND DATA_TYPE = 1
GROUP BY
`NAME`
) AS b
WHERE
a.`NAME` = b.`NAME`
AND a.DATE_TIME = b.max_time
ORDER BY
a.DATE_TIME