Hello
thanks for the help.
I still needed help with arranging table Rank.
according to the image
code
SELECT user_id , tc1 , tc4 , MIN( tc5 ) , tc2, @curRank := @curRank + 1 AS Rank
FROM
#__chronoengine_chronoforms_datatable_treningove_casy,(SELECT @curRank := 0) r
WHERE `tc2` LIKE 'Motokáry Modrice'
ORDER BY tc5 ASC
GROUP BY user_id

please, give me an advice

Try the following query:

SELECT user_id , tc1 , tc4 , MIN( tc5 ) , tc2, @curRank := @curRank + 1 AS Rank
FROM
#__chronoengine_chronoforms_datatable_treningove_casy,(SELECT @curRank := 0) r
WHERE `tc2` LIKE 'Motokáry Modrice'
GROUP BY user_id
ORDER BY MIN(tc5) ASC

Regards,
ARI Soft

Hello thanks
still ranks by ID

When I type ORDER BY min (a.tc5)
error appears: the image

once again send the entire code:

SELECT a.tc1, a.tc4, min(a.tc5), a.tc2, b.avatar, c.username, @curRank := @curRank + 1 AS Rank
FROM
#__chronoengine_chronoforms_datatable_treningove_casy a INNER JOIN
#__jsn_users b ON a.user_id=b.id INNER JOIN
#__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 a.tc5 ASC

Could you send an SQL dump of tables which is used in your query by email so we can investigate the problem on our test server?

Regards,
ARI Soft