Hello
I sent sql dump the tables on email

The extension doesn't support ability to use temporary variables in query when "Server side pagination" is enabled. Your query will work if set "Server side pagination" parameter to "No" in module settings.

Regards,
ARI Soft

Hello,
thanks for the reply.
When I give to the server side pagination NO
the results do not appear as shown in Figure
does not function min (a.tc5) but a.tc5, but obtained results smallest

Add alias for min(a.tc5) column. It will look like:

SELECT a.tc1, a.tc4, min(a.tc5) AS min, 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

Regards,
ARI Soft

Super longer works,
but still ranks by a.id, I need to min (a.tc5)

Try the following query:

SELECT tc1,tc4,min,tc2,avatar,username,@curRank := @curRank + 1 AS Rank
FROM
(SELECT a.tc1, a.tc4, min(a.tc5) AS min, a.tc2, b.avatar, c.username, @curRank := @curRank + 1 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
WHERE a.tc2 LIKE 'Motokáry Modrice'
GROUP BY a.user_id
ORDER BY min ASC) T, (SELECT @curRank := 0) r

Regards,
ARI Soft