large sql

{SELECT
`UnionAll1`.`Composer_Id` AS `C1`,
`UnionAll1`.`C2`,
`UnionAll1`.`Id` AS `C3`,
`UnionAll1`.`DateAdded` AS `C4`,
`UnionAll1`.`DateOfBirth` AS `C5`,
`UnionAll1`.`DateOfDeath` AS `C6`,
`UnionAll1`.`Order` AS `C7`,
`UnionAll1`.`Profile_Id` AS `C8`,
`UnionAll1`.`Id1` AS `C9`,
`UnionAll1`.`C1` AS `C10`,
`UnionAll1`.`Id2` AS `C11`,
`UnionAll1`.`StorageId` AS `C12`,
`UnionAll1`.`Composer_Id1` AS `C13`,
`UnionAll1`.`Language` AS `C14`,
`UnionAll1`.`CreatedUtc` AS `C15`,
`UnionAll1`.`IsArchived` AS `C16`,
`UnionAll1`.`C3` AS `C17`,
`UnionAll1`.`C4` AS `C18`,
`UnionAll1`.`C5` AS `C19`,
`UnionAll1`.`C6` AS `C20`
FROM ((SELECT
CASE WHEN (`Join2`.`Id` IS  NULL) THEN (NULL)  ELSE (1) END AS `C1`,
`Apply2`.`Composer_Id`,
`Apply2`.`C1` AS `C2`,
`Apply2`.`Id`,
`Apply2`.`DateAdded`,
`Apply2`.`DateOfBirth`,
`Apply2`.`DateOfDeath`,
`Apply2`.`Order`,
`Apply2`.`Profile_Id`,
`Apply2`.`Id1`,
`Join2`.`Id` AS `Id2`,
`Join2`.`StorageId`,
`Join2`.`Composer_Id` AS `Composer_Id1`,
`Join2`.`Language`,
`Join2`.`CreatedUtc`,
`Join2`.`IsArchived`,
NULL AS `C3`,
NULL AS `C4`,
NULL AS `C5`,
NULL AS `C6`
FROM (SELECT
`Project3`.`Composer_Id`,
`Project3`.`Id`,
`Project3`.`DateAdded`,
`Project3`.`DateOfBirth`,
`Project3`.`DateOfDeath`,
`Project3`.`Order`,
`Project3`.`Profile_Id`,
`Project3`.`C1`,
`Project3`.`Id1`
FROM (SELECT
`Apply1`.`Composer_Id`,
`Extent3`.`Id`,
`Extent3`.`DateAdded`,
`Extent3`.`DateOfBirth`,
`Extent3`.`DateOfDeath`,
`Extent3`.`Order`,
`Extent3`.`Profile_Id`,
1 AS `C1`,
`Apply1`.`Id` AS `Id1`
FROM (SELECT
`Distinct1`.`Composer_Id`,
(SELECT
`Extent2`.`Id`
FROM `ComposerName` AS `Extent2`
 WHERE `Distinct1`.`Composer_Id` = `Extent2`.`Composer_Id` LIMIT 1) AS `Id`,
(SELECT
`Extent2`.`Composer_Id`
FROM `ComposerName` AS `Extent2`
 WHERE `Distinct1`.`Composer_Id` = `Extent2`.`Composer_Id` LIMIT 1) AS `COMPOSER_ID1`
FROM (SELECT DISTINCT
`Extent1`.`Composer_Id`
FROM `ComposerName` AS `Extent1`) AS `Distinct1`) AS `Apply1` LEFT OUTER JOIN `Composer` AS `Extent3` ON `Apply1`.`COMPOSER_ID1` = `Extent3`.`Id`) AS `Project3`) AS `Apply2`) UNION ALL (SELECT
2 AS `C1`,
`Apply4`.`Composer_Id`,
`Apply4`.`C1` AS `C2`,
`Apply4`.`Id1` AS `Id`,
`Apply4`.`DateAdded`,
`Apply4`.`DateOfBirth`,
`Apply4`.`DateOfDeath`,
`Apply4`.`Order`,
`Apply4`.`Profile_Id`,
`Apply4`.`Id` AS `Id1`,
NULL AS `C3`,
NULL AS `C4`,
NULL AS `C5`,
NULL AS `C6`,
NULL AS `C7`,
NULL AS `C8`,
`Join4`.`Id` AS `Id2`,
`Join4`.`Composer_Id` AS `Composer_Id1`,
`Join4`.`Language`,
`Join4`.`FullName`
FROM (SELECT
`Project8`.`Composer_Id`,
`Project8`.`Id`,
`Project8`.`Id1`,
`Project8`.`DateAdded`,
`Project8`.`DateOfBirth`,
`Project8`.`DateOfDeath`,
`Project8`.`Order`,
`Project8`.`Profile_Id`,
`Project8`.`C1`
FROM (SELECT
`Apply3`.`Composer_Id`,
`Apply3`.`Id`,
`Extent8`.`Id` AS `Id1`,
`Extent8`.`DateAdded`,
`Extent8`.`DateOfBirth`,
`Extent8`.`DateOfDeath`,
`Extent8`.`Order`,
`Extent8`.`Profile_Id`,
1 AS `C1`
FROM (SELECT
`Distinct2`.`Composer_Id`,
(SELECT
`Extent7`.`Id`
FROM `ComposerName` AS `Extent7`
 WHERE `Distinct2`.`Composer_Id` = `Extent7`.`Composer_Id` LIMIT 1) AS `Id`,
(SELECT
`Extent7`.`Composer_Id`
FROM `ComposerName` AS `Extent7`
 WHERE `Distinct2`.`Composer_Id` = `Extent7`.`Composer_Id` LIMIT 1) AS `COMPOSER_ID1`
FROM (SELECT DISTINCT
`Extent6`.`Composer_Id`
FROM `ComposerName` AS `Extent6`) AS `Distinct2`) AS `Apply3` LEFT OUTER JOIN `Composer` AS `Extent8` ON `Apply3`.`COMPOSER_ID1` = `Extent8`.`Id`) AS `Project8`) AS `Apply4`)) AS `UnionAll1`
 ORDER BY
`UnionAll1`.`Composer_Id` ASC,
`UnionAll1`.`Id` ASC,
`UnionAll1`.`Id1` ASC,
`UnionAll1`.`C1` ASC}