Try a formatted string for your last line where you are generating result go from:

result = cursor.execute(eightspdSQL + "AND speed=?", [speed]) + "ORDER BY brand ASC")

TO

result = cursor.execute(f"{eightspdSQL} AND speed={speed} ORDER BY brand ASC")