USE EFTest3; SELECT `Project5`.`C2` AS `C1`, `Project5`.`C1` AS `C2`, `Project5`.`AmazonAccessKeyId`, `Project5`.`Name`, `Project5`.`NextAction`, `Project5`.`RepeatType`, `Project5`.`UserId`, `Project5`.`IsEnabled`, `Project5`.`StartDate`, `Project5`.`CreatorActionId`, `Project5`.`IsDeleted`, `Project5`.`C3`, `Project5`.`C4`, `Project5`.`C5`, `Project5`.`C6`, `Project5`.`C7`, `Project5`.`C8`, `Project5`.`C9`, `Project5`.`C10`, `Project5`.`C11`, `Project5`.`C12`, `Project5`.`C13`, `Project5`.`C14`, `Project5`.`C15`, `Project5`.`C16`, `Project5`.`C17`, `Project5`.`C18` FROM (SELECT `UnionAll2`.`C1`, `Extent4`.`AmazonAccessKeyId`, `Extent4`.`CreatorActionId`, `Extent4`.`IsDeleted`, `Extent4`.`IsEnabled`, `Extent4`.`Name`, `Extent4`.`NextAction`, `Extent4`.`RepeatType`, `Extent4`.`StartDate`, `Extent4`.`UserId`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN ('0X0X0X') WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN ('0X1X0X') ELSE ('0X2X0X') END AS `C2`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C2`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C3`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C3`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C4`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C4`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C5`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C5`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C6`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C6`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C7`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C7`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C8`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C8`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C9`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C9`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C10`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C10`) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) END AS `C11`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (NULL) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C11`) END AS `C12`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (NULL) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C12`) END AS `C13`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (NULL) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C13`) END AS `C14`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (NULL) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C14`) END AS `C15`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (NULL) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C15`) END AS `C16`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (NULL) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (`UnionAll2`.`C16`) END AS `C17`, CASE WHEN (`UnionAll2`.`C18` = cast(1 as decimal(0,0))) THEN (NULL) WHEN (`UnionAll2`.`C19` = cast(1 as decimal(0,0))) THEN (NULL) ELSE (`UnionAll2`.`C17`) END AS `C18` FROM ((SELECT `UnionAll1`.`ActionId` AS `C1`, `UnionAll1`.`ImageId` AS `C2`, `UnionAll1`.`InstanceCount` AS `C3`, `UnionAll1`.`InstanceType` AS `C4`, `UnionAll1`.`SpotPrice` AS `C5`, `UnionAll1`.`Days` AS `C6`, `UnionAll1`.`Hours` AS `C7`, `UnionAll1`.`IsTerminate` AS `C8`, `UnionAll1`.`Minutes` AS `C9`, `UnionAll1`.`Seconds` AS `C10`, `UnionAll1`.`C1` AS `C11`, `UnionAll1`.`C2` AS `C12`, `UnionAll1`.`C3` AS `C13`, `UnionAll1`.`C4` AS `C14`, `UnionAll1`.`C5` AS `C15`, `UnionAll1`.`C6` AS `C16`, `UnionAll1`.`C7` AS `C17`, `UnionAll1`.`C8` AS `C18`, `UnionAll1`.`C9` AS `C19` FROM ((SELECT `Extent1`.`ActionId`, `Extent1`.`ImageId`, `Extent1`.`InstanceCount`, `Extent1`.`InstanceType`, `Extent1`.`SpotPrice`, `Extent1`.`Days`, `Extent1`.`Hours`, `Extent1`.`IsTerminate`, `Extent1`.`Minutes`, `Extent1`.`Seconds`, NULL AS `C1`, NULL AS `C2`, NULL AS `C3`, NULL AS `C4`, NULL AS `C5`, NULL AS `C6`, NULL AS `C7`, cast(1 as decimal(0,0)) AS `C8`, cast(0 as decimal(0,0)) AS `C9` FROM `ec2s_requestspotinstanceactions` AS `Extent1`) UNION ALL (SELECT `Extent2`.`ActionId`, NULL AS `C1`, 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`, NULL AS `C14`, NULL AS `C15`, `Extent2`.`InstanceId`, cast(0 as decimal(0,0)) AS `C16`, cast(0 as decimal(0,0)) AS `C17` FROM `ec2s_stopinstanceactions` AS `Extent2`)) AS `UnionAll1`) UNION ALL (SELECT `Extent3`.`ActionId`, NULL AS `C1`, NULL AS `C2`, NULL AS `C3`, NULL AS `C4`, NULL AS `C5`, NULL AS `C6`, NULL AS `C7`, NULL AS `C8`, NULL AS `C9`, `Extent3`.`InstanceId`, `Extent3`.`Days`, `Extent3`.`Hours`, `Extent3`.`IsStop`, `Extent3`.`Minutes`, `Extent3`.`Seconds`, NULL AS `C10`, cast(0 as decimal(0,0)) AS `C11`, cast(1 as decimal(0,0)) AS `C12` FROM `ec2s_startinstanceactions` AS `Extent3`)) AS `UnionAll2` INNER JOIN `ec2s_actions` AS `Extent4` ON `UnionAll2`.`C1` = `Extent4`.`ActionId` WHERE (`Extent4`.`UserId` = 1) AND (`Extent4`.`CreatorActionId` IS NULL)) AS `Project5` ORDER BY `Name` ASC