Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {SELECT
- Distinct2.t_Meter AS t_Meter
- FROM ( SELECT DISTINCT
- Extent2.t_Meter AS t_Meter
- FROM dbo.Movies AS Extent1
- INNER 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
- WHERE 1 = 1
- ) AS Distinct2
- ORDER BY Distinct2.t_Meter ASC}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement