[Bug-gnubg] Problem with example SQL query

[Philippe Michel]

In the Analyse/Show records/Query widget, there is an example of SQL query 
on the gnubg match database.

Apparently it works as expected with sqlite, but fails if I use an 
external mysql database. GNUbg's output isn't clear, but running the query 
in a proper interface gives :

MariaDB [gnubg]> select s.session_id, s.length, p1.name, p2.name from player 
p1, player p2 join session s on s.player_id0 = p1.player_id and s.player_id1 = 
p2.player_id;
ERROR 1054 (42S22): Unknown column 'p1.player_id' in 'on clause'

Is the above statement somehow non-standard SQL that happens to work with 
sqlite ?