{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}