{SELECT
[UnionAll1].[movie_ID] AS [C1],
[UnionAll1].[movie_ID1] AS [C2],
[UnionAll1].[short_title] AS [C3],
[UnionAll1].[YEAR] AS [C4],
[UnionAll1].[runtime] AS [C5],
[UnionAll1].[avg_rating] AS [C6],
[UnionAll1].[tv_rating] AS [C7],
[UnionAll1].[web_page] AS [C8],
[UnionAll1].[current_season] AS [C9],
[UnionAll1].[is_movie] AS [C10],
[UnionAll1].[maturity_rating] AS [C11],
[UnionAll1].[boxart_ID] AS [C12],
[UnionAll1].[movie_ID2] AS [C13],
[UnionAll1].[boxart_38] AS [C14],
[UnionAll1].[boxart_64] AS [C15],
[UnionAll1].[boxart_110] AS [C16],
[UnionAll1].[boxart_124] AS [C17],
[UnionAll1].[boxart_150] AS [C18],
[UnionAll1].[boxart_166] AS [C19],
[UnionAll1].[boxart_88] AS [C20],
[UnionAll1].[boxart_197] AS [C21],
[UnionAll1].[boxart_176] AS [C22],
[UnionAll1].[boxart_284] AS [C23],
[UnionAll1].[boxart_210] AS [C24],
[UnionAll1].[movie_ID3] AS [C25],
[UnionAll1].[movie_ID4] AS [C26],
[UnionAll1].[ombd_ID] AS [C27],
[UnionAll1].[movie_ID5] AS [C28],
[UnionAll1].[title] AS [C29],
[UnionAll1].[year1] AS [C30],
[UnionAll1].[i_Rating] AS [C31],
[UnionAll1].[i_Votes] AS [C32],
[UnionAll1].[i_ID] AS [C33],
[UnionAll1].[t_Meter] AS [C34],
[UnionAll1].[t_Image] AS [C35],
[UnionAll1].[t_Rating] AS [C36],
[UnionAll1].[t_Reviews] AS [C37],
[UnionAll1].[t_Fresh] AS [C38],
[UnionAll1].[t_Rotten] AS [C39],
[UnionAll1].[t_Consensus] AS [C40],
[UnionAll1].[t_UserMeter] AS [C41],
[UnionAll1].[t_UserRating] AS [C42],
[UnionAll1].[t_UserReviews] AS [C43],
[UnionAll1].[C1] AS [C44],
[UnionAll1].[genre_string] AS [C45],
[UnionAll1].[C2] AS [C46]
FROM  (SELECT
    CASE WHEN ([Join5].[movie_ID] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1],
    [Extent1].[movie_ID] AS [movie_ID],
    [Extent1].[movie_ID] AS [movie_ID1],
    [Extent1].[short_title] AS [short_title],
    [Extent1].[YEAR] AS [YEAR],
    [Extent1].[runtime] AS [runtime],
    [Extent1].[avg_rating] AS [avg_rating],
    [Extent1].[tv_rating] AS [tv_rating],
    [Extent1].[web_page] AS [web_page],
    [Extent1].[current_season] AS [current_season],
    [Extent1].[is_movie] AS [is_movie],
    [Extent1].[maturity_rating] AS [maturity_rating],
    [Extent3].[boxart_ID] AS [boxart_ID],
    [Extent3].[movie_ID] AS [movie_ID2],
    [Extent3].[boxart_38] AS [boxart_38],
    [Extent3].[boxart_64] AS [boxart_64],
    [Extent3].[boxart_110] AS [boxart_110],
    [Extent3].[boxart_124] AS [boxart_124],
    [Extent3].[boxart_150] AS [boxart_150],
    [Extent3].[boxart_166] AS [boxart_166],
    [Extent3].[boxart_88] AS [boxart_88],
    [Extent3].[boxart_197] AS [boxart_197],
    [Extent3].[boxart_176] AS [boxart_176],
    [Extent3].[boxart_284] AS [boxart_284],
    [Extent3].[boxart_210] AS [boxart_210],
    [Distinct1].[movie_ID] AS [movie_ID3],
    [Distinct1].[movie_ID] AS [movie_ID4],
    [Extent2].[ombd_ID] AS [ombd_ID],
    [Extent2].[movie_ID] AS [movie_ID5],
    [Extent2].[title] AS [title],
    [Extent2].[YEAR] AS [year1],
    [Extent2].[i_Rating] AS [i_Rating],
    [Extent2].[i_Votes] AS [i_Votes],
    [Extent2].[i_ID] AS [i_ID],
    [Extent2].[t_Meter] AS [t_Meter],
    [Extent2].[t_Image] AS [t_Image],
    [Extent2].[t_Rating] AS [t_Rating],
    [Extent2].[t_Reviews] AS [t_Reviews],
    [Extent2].[t_Fresh] AS [t_Fresh],
    [Extent2].[t_Rotten] AS [t_Rotten],
    [Extent2].[t_Consensus] AS [t_Consensus],
    [Extent2].[t_UserMeter] AS [t_UserMeter],
    [Extent2].[t_UserRating] AS [t_UserRating],
    [Extent2].[t_UserReviews] AS [t_UserReviews],
    [Join5].[genre_string] AS [genre_string],
    CAST(NULL AS INT) AS [C2]
    FROM     [dbo].[Movies] AS [Extent1]
    LEFT OUTER JOIN [dbo].[OmdbEntries] AS [Extent2] ON [Extent1].[movie_ID] = [Extent2].[movie_ID]
    INNER JOIN [dbo].[BoxArts] AS [Extent3] ON [Extent1].[movie_ID] = [Extent3].[movie_ID]
    INNER JOIN  (SELECT DISTINCT
        [Extent4].[movie_ID] AS [movie_ID]
        FROM  [dbo].[MovieToGenres] AS [Extent4]
        INNER JOIN [dbo].[Genres] AS [Extent5] ON [Extent4].[genre_ID] = [Extent5].[genre_ID] ) AS [Distinct1] ON [Distinct1].[movie_ID] = [Extent1].[movie_ID]
    LEFT OUTER JOIN  (SELECT [Extent6].[movie_ID] AS [movie_ID], [Extent7].[genre_string] AS [genre_string]
        FROM  [dbo].[MovieToGenres] AS [Extent6]
        INNER JOIN [dbo].[Genres] AS [Extent7] ON [Extent6].[genre_ID] = [Extent7].[genre_ID] ) AS [Join5] ON [Distinct1].[movie_ID] = [Join5].[movie_ID]
UNION ALL
    SELECT
    2 AS [C1],
    [Extent8].[movie_ID] AS [movie_ID],
    [Extent8].[movie_ID] AS [movie_ID1],
    [Extent8].[short_title] AS [short_title],
    [Extent8].[YEAR] AS [YEAR],
    [Extent8].[runtime] AS [runtime],
    [Extent8].[avg_rating] AS [avg_rating],
    [Extent8].[tv_rating] AS [tv_rating],
    [Extent8].[web_page] AS [web_page],
    [Extent8].[current_season] AS [current_season],
    [Extent8].[is_movie] AS [is_movie],
    [Extent8].[maturity_rating] AS [maturity_rating],
    [Extent10].[boxart_ID] AS [boxart_ID],
    [Extent10].[movie_ID] AS [movie_ID2],
    [Extent10].[boxart_38] AS [boxart_38],
    [Extent10].[boxart_64] AS [boxart_64],
    [Extent10].[boxart_110] AS [boxart_110],
    [Extent10].[boxart_124] AS [boxart_124],
    [Extent10].[boxart_150] AS [boxart_150],
    [Extent10].[boxart_166] AS [boxart_166],
    [Extent10].[boxart_88] AS [boxart_88],
    [Extent10].[boxart_197] AS [boxart_197],
    [Extent10].[boxart_176] AS [boxart_176],
    [Extent10].[boxart_284] AS [boxart_284],
    [Extent10].[boxart_210] AS [boxart_210],
    [Distinct2].[movie_ID] AS [movie_ID3],
    [Distinct2].[movie_ID] AS [movie_ID4],
    [Extent9].[ombd_ID] AS [ombd_ID],
    [Extent9].[movie_ID] AS [movie_ID5],
    [Extent9].[title] AS [title],
    [Extent9].[YEAR] AS [year1],
    [Extent9].[i_Rating] AS [i_Rating],
    [Extent9].[i_Votes] AS [i_Votes],
    [Extent9].[i_ID] AS [i_ID],
    [Extent9].[t_Meter] AS [t_Meter],
    [Extent9].[t_Image] AS [t_Image],
    [Extent9].[t_Rating] AS [t_Rating],
    [Extent9].[t_Reviews] AS [t_Reviews],
    [Extent9].[t_Fresh] AS [t_Fresh],
    [Extent9].[t_Rotten] AS [t_Rotten],
    [Extent9].[t_Consensus] AS [t_Consensus],
    [Extent9].[t_UserMeter] AS [t_UserMeter],
    [Extent9].[t_UserRating] AS [t_UserRating],
    [Extent9].[t_UserReviews] AS [t_UserReviews],
    CAST(NULL AS VARCHAR(1)) AS [C2],
    [Extent13].[genre_ID] AS [genre_ID]
    FROM     [dbo].[Movies] AS [Extent8]
    LEFT OUTER JOIN [dbo].[OmdbEntries] AS [Extent9] ON [Extent8].[movie_ID] = [Extent9].[movie_ID]
    INNER JOIN [dbo].[BoxArts] AS [Extent10] ON [Extent8].[movie_ID] = [Extent10].[movie_ID]
    INNER JOIN  (SELECT DISTINCT
        [Extent11].[movie_ID] AS [movie_ID]
        FROM  [dbo].[MovieToGenres] AS [Extent11]
        INNER JOIN [dbo].[Genres] AS [Extent12] ON [Extent11].[genre_ID] = [Extent12].[genre_ID] ) AS [Distinct2] ON [Distinct2].[movie_ID] = [Extent8].[movie_ID]
    INNER JOIN [dbo].[MovieToGenres] AS [Extent13] ON [Extent13].[movie_ID] = [Extent8].[movie_ID]) AS [UnionAll1]
ORDER BY [UnionAll1].[movie_ID1] ASC, [UnionAll1].[boxart_ID] ASC, [UnionAll1].[movie_ID4] ASC, [UnionAll1].[ombd_ID] ASC, [UnionAll1].[C1] ASC}