SOLVED: Issue on DB join element with dropdown filter

[dimoss]

Hi,

I am using Gamma 3 / J!4.2.9.
I have an issue on a DB join element in a MySQL view which i use it as a dropdown filter wuth the following settings:

I used none because I want the filter to show the options in descending rder based on the clause I have in the DB Join element:

ORDER BY {thistable}.tournament_id DESC

The error I get when the list loads is:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}.tournament_id DESC' at line 3

I can't understand why I get this error in order to fix it.
Any help is appreciated.

P.S. If I change the order by to 'Label' or 'Value' works but it overrides the code i have.

 

[dimoss]

I fixed the issue changing {thistable} with the name of the joined DB table.
Still don't know why {thistable} produced an error.

 

[troester]

Seems it doesn't replace {thistable} (which may be no the joined DB table name but an alias like xy_0).

 

[dimoss]

Seems it doesn't replace {thistable} (which may be no the joined DB table name but an alias like xy_0).

I checked in another website on F3 / J3 and produced same error.