SHOW:
|
|
- or go back to the newest paste.
1 | {SELECT | |
2 | UnionAll1.movie_ID AS C1, | |
3 | UnionAll1.movie_ID1 AS C2, | |
4 | UnionAll1.short_title AS C3, | |
5 | UnionAll1.year AS C4, | |
6 | UnionAll1.runtime AS C5, | |
7 | UnionAll1.avg_rating AS C6, | |
8 | UnionAll1.tv_rating AS C7, | |
9 | UnionAll1.web_page AS C8, | |
10 | UnionAll1.current_season AS C9, | |
11 | UnionAll1.is_movie AS C10, | |
12 | UnionAll1.maturity_rating AS C11, | |
13 | UnionAll1.boxart_ID AS C12, | |
14 | UnionAll1.movie_ID2 AS C13, | |
15 | UnionAll1.boxart_38 AS C14, | |
16 | UnionAll1.boxart_64 AS C15, | |
17 | UnionAll1.boxart_110 AS C16, | |
18 | UnionAll1.boxart_124 AS C17, | |
19 | UnionAll1.boxart_150 AS C18, | |
20 | UnionAll1.boxart_166 AS C19, | |
21 | UnionAll1.boxart_88 AS C20, | |
22 | UnionAll1.boxart_197 AS C21, | |
23 | UnionAll1.boxart_176 AS C22, | |
24 | UnionAll1.boxart_284 AS C23, | |
25 | UnionAll1.boxart_210 AS C24, | |
26 | UnionAll1.movie_ID3 AS C25, | |
27 | UnionAll1.movie_ID4 AS C26, | |
28 | UnionAll1.ombd_ID AS C27, | |
29 | UnionAll1.movie_ID5 AS C28, | |
30 | UnionAll1.title AS C29, | |
31 | UnionAll1.year1 AS C30, | |
32 | UnionAll1.i_Rating AS C31, | |
33 | UnionAll1.i_Votes AS C32, | |
34 | UnionAll1.i_ID AS C33, | |
35 | UnionAll1.t_Meter AS C34, | |
36 | UnionAll1.t_Image AS C35, | |
37 | UnionAll1.t_Rating AS C36, | |
38 | UnionAll1.t_Reviews AS C37, | |
39 | UnionAll1.t_Fresh AS C38, | |
40 | UnionAll1.t_Rotten AS C39, | |
41 | UnionAll1.t_Consensus AS C40, | |
42 | UnionAll1.t_UserMeter AS C41, | |
43 | UnionAll1.t_UserRating AS C42, | |
44 | UnionAll1.t_UserReviews AS C43, | |
45 | UnionAll1.C1 AS C44, | |
46 | UnionAll1.genre_string AS C45, | |
47 | UnionAll1.C2 AS C46 | |
48 | FROM (SELECT | |
49 | CASE WHEN (Join5.movie_ID IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS C1, | |
50 | Extent1.movie_ID AS movie_ID, | |
51 | Extent1.movie_ID AS movie_ID1, | |
52 | Extent1.short_title AS short_title, | |
53 | Extent1.year AS year, | |
54 | Extent1.runtime AS runtime, | |
55 | Extent1.avg_rating AS avg_rating, | |
56 | Extent1.tv_rating AS tv_rating, | |
57 | Extent1.web_page AS web_page, | |
58 | Extent1.current_season AS current_season, | |
59 | Extent1.is_movie AS is_movie, | |
60 | Extent1.maturity_rating AS maturity_rating, | |
61 | Extent3.boxart_ID AS boxart_ID, | |
62 | Extent3.movie_ID AS movie_ID2, | |
63 | Extent3.boxart_38 AS boxart_38, | |
64 | Extent3.boxart_64 AS boxart_64, | |
65 | Extent3.boxart_110 AS boxart_110, | |
66 | Extent3.boxart_124 AS boxart_124, | |
67 | Extent3.boxart_150 AS boxart_150, | |
68 | Extent3.boxart_166 AS boxart_166, | |
69 | Extent3.boxart_88 AS boxart_88, | |
70 | Extent3.boxart_197 AS boxart_197, | |
71 | Extent3.boxart_176 AS boxart_176, | |
72 | Extent3.boxart_284 AS boxart_284, | |
73 | Extent3.boxart_210 AS boxart_210, | |
74 | Distinct1.movie_ID AS movie_ID3, | |
75 | Distinct1.movie_ID AS movie_ID4, | |
76 | Extent2.ombd_ID AS ombd_ID, | |
77 | Extent2.movie_ID AS movie_ID5, | |
78 | Extent2.title AS title, | |
79 | Extent2.year AS year1, | |
80 | Extent2.i_Rating AS i_Rating, | |
81 | Extent2.i_Votes AS i_Votes, | |
82 | Extent2.i_ID AS i_ID, | |
83 | Extent2.t_Meter AS t_Meter, | |
84 | Extent2.t_Image AS t_Image, | |
85 | Extent2.t_Rating AS t_Rating, | |
86 | Extent2.t_Reviews AS t_Reviews, | |
87 | Extent2.t_Fresh AS t_Fresh, | |
88 | Extent2.t_Rotten AS t_Rotten, | |
89 | Extent2.t_Consensus AS t_Consensus, | |
90 | Extent2.t_UserMeter AS t_UserMeter, | |
91 | Extent2.t_UserRating AS t_UserRating, | |
92 | Extent2.t_UserReviews AS t_UserReviews, | |
93 | Join5.genre_string AS genre_string, | |
94 | CAST(NULL AS int) AS C2 | |
95 | FROM dbo.Movies AS Extent1 | |
96 | LEFT OUTER JOIN dbo.OmdbEntries AS Extent2 ON Extent1.movie_ID = Extent2.movie_ID | |
97 | INNER JOIN dbo.BoxArts AS Extent3 ON Extent1.movie_ID = Extent3.movie_ID | |
98 | INNER JOIN (SELECT DISTINCT | |
99 | Extent4.movie_ID AS movie_ID | |
100 | FROM dbo.MovieToGenres AS Extent4 | |
101 | INNER JOIN dbo.Genres AS Extent5 ON Extent4.genre_ID = Extent5.genre_ID ) AS Distinct1 ON Distinct1.movie_ID = Extent1.movie_ID | |
102 | LEFT OUTER JOIN (SELECT Extent6.movie_ID AS movie_ID, Extent7.genre_string AS genre_string | |
103 | FROM dbo.MovieToGenres AS Extent6 | |
104 | INNER JOIN dbo.Genres AS Extent7 ON Extent6.genre_ID = Extent7.genre_ID ) AS Join5 ON Distinct1.movie_ID = Join5.movie_ID | |
105 | WHERE Extent2.t_Meter >= @p__linq__0 | |
106 | UNION ALL | |
107 | SELECT | |
108 | 2 AS C1, | |
109 | Extent8.movie_ID AS movie_ID, | |
110 | Extent8.movie_ID AS movie_ID1, | |
111 | Extent8.short_title AS short_title, | |
112 | Extent8.year AS year, | |
113 | Extent8.runtime AS runtime, | |
114 | Extent8.avg_rating AS avg_rating, | |
115 | Extent8.tv_rating AS tv_rating, | |
116 | Extent8.web_page AS web_page, | |
117 | Extent8.current_season AS current_season, | |
118 | Extent8.is_movie AS is_movie, | |
119 | Extent8.maturity_rating AS maturity_rating, | |
120 | Extent10.boxart_ID AS boxart_ID, | |
121 | Extent10.movie_ID AS movie_ID2, | |
122 | Extent10.boxart_38 AS boxart_38, | |
123 | Extent10.boxart_64 AS boxart_64, | |
124 | Extent10.boxart_110 AS boxart_110, | |
125 | Extent10.boxart_124 AS boxart_124, | |
126 | Extent10.boxart_150 AS boxart_150, | |
127 | Extent10.boxart_166 AS boxart_166, | |
128 | Extent10.boxart_88 AS boxart_88, | |
129 | Extent10.boxart_197 AS boxart_197, | |
130 | Extent10.boxart_176 AS boxart_176, | |
131 | Extent10.boxart_284 AS boxart_284, | |
132 | Extent10.boxart_210 AS boxart_210, | |
133 | Distinct2.movie_ID AS movie_ID3, | |
134 | Distinct2.movie_ID AS movie_ID4, | |
135 | Extent9.ombd_ID AS ombd_ID, | |
136 | Extent9.movie_ID AS movie_ID5, | |
137 | Extent9.title AS title, | |
138 | Extent9.year AS year1, | |
139 | Extent9.i_Rating AS i_Rating, | |
140 | Extent9.i_Votes AS i_Votes, | |
141 | Extent9.i_ID AS i_ID, | |
142 | Extent9.t_Meter AS t_Meter, | |
143 | Extent9.t_Image AS t_Image, | |
144 | Extent9.t_Rating AS t_Rating, | |
145 | Extent9.t_Reviews AS t_Reviews, | |
146 | Extent9.t_Fresh AS t_Fresh, | |
147 | Extent9.t_Rotten AS t_Rotten, | |
148 | Extent9.t_Consensus AS t_Consensus, | |
149 | Extent9.t_UserMeter AS t_UserMeter, | |
150 | Extent9.t_UserRating AS t_UserRating, | |
151 | Extent9.t_UserReviews AS t_UserReviews, | |
152 | CAST(NULL AS varchar(1)) AS C2, | |
153 | Extent13.genre_ID AS genre_ID | |
154 | FROM dbo.Movies AS Extent8 | |
155 | LEFT OUTER JOIN dbo.OmdbEntries AS Extent9 ON Extent8.movie_ID = Extent9.movie_ID | |
156 | INNER JOIN dbo.BoxArts AS Extent10 ON Extent8.movie_ID = Extent10.movie_ID | |
157 | INNER JOIN (SELECT DISTINCT | |
158 | Extent11.movie_ID AS movie_ID | |
159 | FROM dbo.MovieToGenres AS Extent11 | |
160 | - | INNER JOIN dbo.MovieToGenres AS Extent13 ON Extent13.movie_ID = Extent8.movie_ID) AS UnionAll1 |
160 | + | |
161 | INNER JOIN dbo.MovieToGenres AS Extent13 ON Extent13.movie_ID = Extent8.movie_ID | |
162 | WHERE Extent9.t_Meter >= @p__linq__0) AS UnionAll1 | |
163 | ORDER BY UnionAll1.movie_ID1 ASC, UnionAll1.boxart_ID ASC, UnionAll1.movie_ID4 ASC, UnionAll1.ombd_ID ASC, UnionAll1.C1 ASC} |