SELECT
`UnionAll2`.`C2` AS `C1`, 
`UnionAll2`.`C3` AS `C2`, 
`UnionAll2`.`C4` AS `C3`, 
`UnionAll2`.`C5` AS `C4`, 
`UnionAll2`.`C6` AS `C5`, 
`UnionAll2`.`C7` AS `C6`, 
`UnionAll2`.`C8` AS `C7`, 
`UnionAll2`.`C9` AS `C8`, 
`UnionAll2`.`C10` AS `C9`, 
`UnionAll2`.`C11` AS `C10`, 
`UnionAll2`.`C12` AS `C11`, 
`UnionAll2`.`C13` AS `C12`, 
`UnionAll2`.`C14` AS `C13`, 
`UnionAll2`.`C15` AS `C14`, 
`UnionAll2`.`C16` AS `C15`, 
`UnionAll2`.`C17` AS `C16`, 
`UnionAll2`.`C18` AS `C17`, 
`UnionAll2`.`C19` AS `C18`, 
`UnionAll2`.`C20` AS `C19`, 
`UnionAll2`.`C21` AS `C20`, 
`UnionAll2`.`C22` AS `C21`, 
`UnionAll2`.`C23` AS `C22`, 
`UnionAll2`.`C24` AS `C23`, 
`UnionAll2`.`C25` AS `C24`, 
`UnionAll2`.`C26` AS `C25`, 
`UnionAll2`.`C27` AS `C26`, 
`UnionAll2`.`C28` AS `C27`, 
`UnionAll2`.`C1` AS `C28`, 
`UnionAll2`.`C29`, 
`UnionAll2`.`C30`, 
`UnionAll2`.`C31`, 
`UnionAll2`.`C32`, 
`UnionAll2`.`C33`, 
`UnionAll2`.`C34`, 
`UnionAll2`.`C35`, 
`UnionAll2`.`C36`, 
`UnionAll2`.`C37`, 
`UnionAll2`.`C38`, 
`UnionAll2`.`C39`, 
`UnionAll2`.`C40`, 
`UnionAll2`.`C41`, 
`UnionAll2`.`C42`, 
`UnionAll2`.`C43`, 
`UnionAll2`.`C44`, 
`UnionAll2`.`C45`, 
`UnionAll2`.`C46`
FROM (SELECT
`UnionAll1`.`C1`, 
`UnionAll1`.`ID` AS `C2`, 
`UnionAll1`.`CategoryID` AS `C3`, 
`UnionAll1`.`ID1` AS `C4`, 
`UnionAll1`.`SongID` AS `C5`, 
`UnionAll1`.`ID2` AS `C6`, 
`UnionAll1`.`AlbumName` AS `C7`, 
`UnionAll1`.`DateAdded` AS `C8`, 
`UnionAll1`.`DateModified` AS `C9`, 
`UnionAll1`.`ID3` AS `C10`, 
`UnionAll1`.`LabelName` AS `C11`, 
`UnionAll1`.`Rating` AS `C12`, 
`UnionAll1`.`AudioRating` AS `C13`, 
`UnionAll1`.`SongName` AS `C14`, 
`UnionAll1`.`SubLabelName` AS `C15`, 
`UnionAll1`.`Year` AS `C16`, 
`UnionAll1`.`BPM` AS `C17`, 
`UnionAll1`.`Genre` AS `C18`, 
`UnionAll1`.`MMSerial` AS `C19`, 
`UnionAll1`.`LegacyDBID` AS `C20`, 
`UnionAll1`.`DateActive` AS `C21`, 
`UnionAll1`.`DateExpired` AS `C22`, 
`UnionAll1`.`DateVideoDeployed` AS `C23`, 
`UnionAll1`.`DateVideoRecalled` AS `C24`, 
`UnionAll1`.`CreatedBy` AS `C25`, 
`UnionAll1`.`OTSAlbumCopyright` AS `C26`, 
`UnionAll1`.`OTSAlbumName` AS `C27`, 
`UnionAll1`.`OTSYear` AS `C28`, 
`UnionAll1`.`ID4` AS `C29`, 
`UnionAll1`.`CategoryID1` AS `C30`, 
`UnionAll1`.`ID5` AS `C31`, 
`UnionAll1`.`SongID1` AS `C32`, 
`UnionAll1`.`CategoryName` AS `C33`, 
`UnionAll1`.`ID6` AS `C34`, 
`UnionAll1`.`C2` AS `C35`, 
`UnionAll1`.`C3` AS `C36`, 
`UnionAll1`.`C4` AS `C37`, 
`UnionAll1`.`C5` AS `C38`, 
`UnionAll1`.`C6` AS `C39`, 
`UnionAll1`.`C7` AS `C40`, 
`UnionAll1`.`C8` AS `C41`, 
`UnionAll1`.`C9` AS `C42`, 
`UnionAll1`.`C10` AS `C43`, 
`UnionAll1`.`C11` AS `C44`, 
`UnionAll1`.`C12` AS `C45`, 
`UnionAll1`.`C13` AS `C46`
FROM (SELECT
CASE WHEN (`Join2`.`ID` IS  NULL) THEN (NULL)  ELSE (1) END AS `C1`, 
`Extent1`.`ID`, 
`Extent1`.`CategoryID`, 
`Extent1`.`ID` AS `ID1`, 
`Extent1`.`SongID`, 
`Extent1`.`ID` AS `ID2`, 
`Extent2`.`AlbumName`, 
`Extent2`.`DateAdded`, 
`Extent2`.`DateModified`, 
`Extent2`.`ID` AS `ID3`, 
`Extent2`.`LabelName`, 
`Extent2`.`Rating`, 
`Extent2`.`AudioRating`, 
`Extent2`.`SongName`, 
`Extent2`.`SubLabelName`, 
`Extent2`.`Year`, 
`Extent2`.`BPM`, 
`Extent2`.`Genre`, 
`Extent2`.`MMSerial`, 
`Extent2`.`LegacyDBID`, 
`Extent2`.`DateActive`, 
`Extent2`.`DateExpired`, 
`Extent2`.`DateVideoDeployed`, 
`Extent2`.`DateVideoRecalled`, 
`Extent2`.`CreatedBy`, 
`Extent2`.`OTSAlbumCopyright`, 
`Extent2`.`OTSAlbumName`, 
`Extent2`.`OTSYear`, 
`Join2`.`ID` AS `ID4`, 
`Join2`.`CategoryID` AS `CategoryID1`, 
`Join2`.`ID` AS `ID5`, 
`Join2`.`SongID` AS `SongID1`, 
`Join2`.`CategoryName`, 
`Join2`.`ID1` AS `ID6`, 
NULL AS `C2`, 
NULL AS `C3`, 
NULL AS `C4`, 
NULL AS `C5`, 
NULL AS `C6`, 
NULL AS `C7`, 
NULL AS `C8`, 
NULL AS `C9`, 
NULL AS `C10`, 
NULL AS `C11`, 
NULL AS `C12`, 
NULL AS `C13`
FROM `SongsInCategories` AS `Extent1` INNER JOIN `Songs` AS `Extent2` ON `Extent1`.`SongID` = `Extent2`.`ID` LEFT OUTER JOIN (SELECT
`Extent3`.`ID`, 
`Extent3`.`SongID`, 
`Extent3`.`CategoryID`, 
`Extent4`.`ID` AS `ID1`, 
`Extent4`.`CategoryName`
FROM `SongsInCategories` AS `Extent3` INNER JOIN `SongCategories` AS `Extent4` ON `Extent3`.`CategoryID` = `Extent4`.`ID`) AS `Join2` ON `Extent1`.`SongID` = `Join2`.`SongID`
 WHERE `Extent1`.`CategoryID` = 211 UNION ALL SELECT
2 AS `C1`, 
`Extent5`.`ID`, 
`Extent5`.`CategoryID`, 
`Extent5`.`ID` AS `ID1`, 
`Extent5`.`SongID`, 
`Extent5`.`ID` AS `ID2`, 
`Extent6`.`AlbumName`, 
`Extent6`.`DateAdded`, 
`Extent6`.`DateModified`, 
`Extent6`.`ID` AS `ID3`, 
`Extent6`.`LabelName`, 
`Extent6`.`Rating`, 
`Extent6`.`AudioRating`, 
`Extent6`.`SongName`, 
`Extent6`.`SubLabelName`, 
`Extent6`.`Year`, 
`Extent6`.`BPM`, 
`Extent6`.`Genre`, 
`Extent6`.`MMSerial`, 
`Extent6`.`LegacyDBID`, 
`Extent6`.`DateActive`, 
`Extent6`.`DateExpired`, 
`Extent6`.`DateVideoDeployed`, 
`Extent6`.`DateVideoRecalled`, 
`Extent6`.`CreatedBy`, 
`Extent6`.`OTSAlbumCopyright`, 
`Extent6`.`OTSAlbumName`, 
`Extent6`.`OTSYear`, 
NULL AS `C2`, 
NULL AS `C3`, 
NULL AS `C4`, 
NULL AS `C5`, 
NULL AS `C6`, 
NULL AS `C7`, 
`Join5`.`ID` AS `ID4`, 
`Join5`.`ID` AS `ID5`, 
`Join5`.`SongArtistID`, 
`Join5`.`SongID` AS `SongID1`, 
`Join5`.`ArtistName`, 
`Join5`.`ID1` AS `ID6`, 
NULL AS `C8`, 
NULL AS `C9`, 
NULL AS `C10`, 
NULL AS `C11`, 
NULL AS `C12`, 
NULL AS `C13`
FROM `SongsInCategories` AS `Extent5` INNER JOIN `Songs` AS `Extent6` ON `Extent5`.`SongID` = `Extent6`.`ID` INNER JOIN (SELECT
`Extent7`.`ID`, 
`Extent7`.`SongArtistID`, 
`Extent7`.`SongID`, 
`Extent8`.`ID` AS `ID1`, 
`Extent8`.`ArtistName`
FROM `SongArtistsInSongs` AS `Extent7` INNER JOIN `SongArtists` AS `Extent8` ON `Extent7`.`SongArtistID` = `Extent8`.`ID`) AS `Join5` ON `Extent5`.`SongID` = `Join5`.`SongID`
 WHERE `Extent5`.`CategoryID` = 211) AS `UnionAll1` UNION ALL SELECT
3 AS `C1`, 
`Extent9`.`ID`, 
`Extent9`.`CategoryID`, 
`Extent9`.`ID` AS `ID1`, 
`Extent9`.`SongID`, 
`Extent9`.`ID` AS `ID2`, 
`Extent10`.`AlbumName`, 
`Extent10`.`DateAdded`, 
`Extent10`.`DateModified`, 
`Extent10`.`ID` AS `ID3`, 
`Extent10`.`LabelName`, 
`Extent10`.`Rating`, 
`Extent10`.`AudioRating`, 
`Extent10`.`SongName`, 
`Extent10`.`SubLabelName`, 
`Extent10`.`Year`, 
`Extent10`.`BPM`, 
`Extent10`.`Genre`, 
`Extent10`.`MMSerial`, 
`Extent10`.`LegacyDBID`, 
`Extent10`.`DateActive`, 
`Extent10`.`DateExpired`, 
`Extent10`.`DateVideoDeployed`, 
`Extent10`.`DateVideoRecalled`, 
`Extent10`.`CreatedBy`, 
`Extent10`.`OTSAlbumCopyright`, 
`Extent10`.`OTSAlbumName`, 
`Extent10`.`OTSYear`, 
NULL AS `C2`, 
NULL AS `C3`, 
NULL AS `C4`, 
NULL AS `C5`, 
NULL AS `C6`, 
NULL AS `C7`, 
NULL AS `C8`, 
NULL AS `C9`, 
NULL AS `C10`, 
NULL AS `C11`, 
NULL AS `C12`, 
NULL AS `C13`, 
`Join8`.`ID` AS `ID4`, 
`Join8`.`ID` AS `ID5`, 
`Join8`.`SongArtistID`, 
`Join8`.`SongID` AS `SongID1`, 
`Join8`.`ArtistName`, 
`Join8`.`ID1` AS `ID6`
FROM `SongsInCategories` AS `Extent9` INNER JOIN `Songs` AS `Extent10` ON `Extent9`.`SongID` = `Extent10`.`ID` INNER JOIN (SELECT
`Extent11`.`ID`, 
`Extent11`.`SongArtistID`, 
`Extent11`.`SongID`, 
`Extent12`.`ID` AS `ID1`, 
`Extent12`.`ArtistName`
FROM `SongArtistsFeaturedInSongs` AS `Extent11` INNER JOIN `SongArtists` AS `Extent12` ON `Extent11`.`SongArtistID` = `Extent12`.`ID`) AS `Join8` ON `Extent9`.`SongID` = `Join8`.`SongID`
 WHERE `Extent9`.`CategoryID` = 211) AS `UnionAll2`
 ORDER BY 
`UnionAll2`.`C4` ASC, 
`UnionAll2`.`C10` ASC, 
`UnionAll2`.`C1` ASC