Derived tables in a join subquery cause error

When using a join with a derived table you get the error:

ERROR 1064 (42000): 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 'USE INDEX () join (select 1 AS `dummy`,count(test.vehicle.id) AS `total_vehicles' at line 1

We add USE INDEX() as part of MCOL-424 but we only need to do this for real tables, not derived.