SQL Parsing Error - UNION AND ORDER BY WITH JOIN

CREATE TABLE

	test ( id INT, type_id INT, PRIMARY KEY(id) );

INSERT INTO 

	test ( id, type_id )

VALUES 

	( 1, 1 ),

	( 2, 1 ),

	( 3, 2 ),

	( 4, 5 );

SELECT

	*

FROM

	test T

	JOIN (

		(

			SELECT 1 AS some_another_type_id

		)

		UNION ALL

		(

			SELECT 2 AS some_another_type_id

		)

		ORDER BY

			some_another_type_id DESC

	) AAA

WHERE

	T.type_id = 1;