Your query doesn't contain FROM, see the query from our previous message please.

Regards,
ARI Soft

Super works
I forgot FROM
Thanks for the help

Hello,
I grouped the id field, I need to show more fields from the smallest numbers.
Code:

SELECT
C.id,
C.user_id,
C.tc1,
C.tc2,
C.tc4,
C.tc5,
CAT.avatar,
B.username,
@curRank := @curRank + 1 AS Pozice
FROM
#__chronoengine_chronoforms_datatable_treningove_casy C INNER JOIN
#__jsn_users CAT ON C.user_id = CAT.id INNER JOIN
#__users B ON C.user_id = B.id
, (SELECT @curRank := 0) r
GROUP BY C.user_id
ORDER BY C.tc5 ASC

Hello,

Could you explain in more details what do you want to show? When "GROUP BY" is used, only one record is selected according to "GROUP BY" filter. In your case only one record for each user will be selected, ORDER BY is applied by database after "GROUP BY" selection and it doesn't affect on "GROUP BY" selection.

Regards,
ARI Soft

Thanks for the reply
I need GROUP BY 1 record of each user.
I need to record with the lowest value in the table Nejlepší Cas;as
according to the image above

You can try to use this solution.

Regards,
ARI Soft