I have similar issue with MySql 5.7 and create a issue report here : https://github.com/FusionAuth/fusionauth-issues/issues/2658
Apparently it seem there is typing error in Sql query that miss the table name but use the alias only and hence the error.