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