Schau dir bitte das einmal an ob das Ergebnis so ist wie du das haben möchtest.
[CODE]
SELECT h.*
FROM (
SELECT max(changed_id) AS changed_id
FROM logdaten
GROUP BY user_id
) l
LEFT JOIN logdaten h
ON h.changed_id = l.changed_id
ORDER BY
h.user_id;
[/CODE]
Beispiel:
[CODE]
mysql> SELECT * FROM logdaten;
+------------+---------+-----------+-------------------+---------+-------------+
| changed_id | user_id | status_id | changed_timestamp | comment | insert_from |
+------------+---------+-----------+-------------------+---------+-------------+
| 1 | 20 | 4 | 1498025053 | NULL | NULL |
| 2 | 21 | 4 | 1498025083 | NULL | NULL |
| 3 | 21 | 3 | 1498027025 | NULL | NULL |
| 4 | 21 | 4 | 1498030348 | NULL | NULL |
| 5 | 21 | 3 | 1498030407 | NULL | NULL |
| 6 | 21 | 1 | 1498030556 | NULL | NULL |
+------------+---------+-----------+-------------------+---------+-------------+
6 rows in set (0,00 sec)
mysql>
mysql>
mysql> SELECT h.*
-> FROM (
-> SELECT max(changed_id) AS changed_id
-> FROM logdaten
-> GROUP BY user_id
-> ) l
-> LEFT JOIN logdaten h
-> ON h.changed_id = l.changed_id
-> ORDER BY
-> h.user_id;
+------------+---------+-----------+-------------------+---------+-------------+
| changed_id | user_id | status_id | changed_timestamp | comment | insert_from |
+------------+---------+-----------+-------------------+---------+-------------+
| 1 | 20 | 4 | 1498025053 | NULL | NULL |
| 6 | 21 | 1 | 1498030556 | NULL | NULL |
+------------+---------+-----------+-------------------+---------+-------------+
2 rows in set (0,00 sec)
mysql>
[/CODE]
