according to the picture

tc1 and tc4 fields are selected in "SELECT" query where "GROUP BY" is used. It selects one record per user according to "GROUP BY" condition. If an aggregate function is not used for a field in "SELECT" query, any value can be selected from record for a user. For example if you want to select MAX value for tc1 field, use MAX aggregate function. It will look like MAX(tc1) as max instead of tc1

Regards,
ARI Soft

Hello
Thanks for the advice I used min (TC1) and min (TC4)
still shows wrong.
Sending code please check what I'm doing wrong.
Thanks

code:
SELECT Datum,Kára,min,tc2,avatar,username,@curRank := @curRank + 1 AS Rank
FROM
(SELECT min(a.tc1) AS Datum, min(a.tc4) AS Kára, min(a.tc5) AS min, a.tc2, b.avatar, c.username, @curRank := @curRank + 0 AS Rank
FROM
sbhgl_chronoengine_chronoforms_datatable_treningove_casy a INNER JOIN
sbhgl_jsn_users b ON a.user_id=b.id INNER JOIN
sbhgl_users c ON a.user_id=c.id, (SELECT @curRank := 0) r
WHERE a.tc2 LIKE 'Motokáry Modrice'
GROUP BY a.user_id
ORDER BY min ASC) T

This problem with DB field types. It is stored as string instead of date time (for example for tc1 column).

Regards,
ARI Soft