SQL statement results in error message with MySQL/MariaDB

[roe-dl]

            _result = db_manager.getSql(
                    "SELECT SUM(radiation*interval)/60.0, "
                    "MIN(usUnits), MAX(usUnits) FROM %s "
                    "WHERE dateTime >? AND dateTime<=?"
                    % db_manager.table_name, timespan)

results in

Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine:         ****  weedb.DatabaseError: (1064, "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 ')/60.0, MIN(usUnits),MAX(usUnits) FROM archive WHERE dateTime>1612825200 AND ...' at line 1")

for MySQL/MariaDB.

[roe-dl]

According to Gary 'interval' is a reserved word in MySQL and therefore needs to be enclosed in backticks (not single quotes).

commit 69cc037