SQL_ERROR: Table 'production_tanks.v19100_tanks' doesn't exist
SELECT tank_type, tank_nation
FROM production_tanks.v19100_tanks
JOIN production_tanks.v19100_ord_nations ON ( production_tanks.v19100_tanks.tank_nation = production_tanks.v19100_ord_nations.nation_id )
JOIN production_tanks.v19100_ord_types ON ( production_tanks.v19100_tanks.tank_type = production_tanks.v19100_ord_types.type_id )
GROUP BY tank_type, tank_nation
ORDER BY production_tanks.v19100_ord_types.ord, production_tanks.v19100_ord_nations.ord