SHOW:
|
|
- or go back to the newest paste.
| 1 | - | {SELECT
|
| 1 | + | SELECT |
| 2 | [Distinct2].[t_Meter] AS [t_Meter] | |
| 3 | FROM ( SELECT DISTINCT | |
| 4 | [Extent2].[t_Meter] AS [t_Meter] | |
| 5 | FROM [dbo].[Movies] AS [Extent1] | |
| 6 | INNER JOIN [dbo].[OmdbEntries] AS [Extent2] ON [Extent1].[movie_ID] = [Extent2].[movie_ID] | |
| 7 | INNER JOIN [dbo].[BoxArts] AS [Extent3] ON [Extent1].[movie_ID] = [Extent3].[movie_ID] | |
| 8 | INNER JOIN (SELECT DISTINCT | |
| 9 | [Extent4].[movie_ID] AS [movie_ID] | |
| 10 | FROM [dbo].[MovieToGenres] AS [Extent4] | |
| 11 | INNER JOIN [dbo].[Genres] AS [Extent5] ON [Extent4].[genre_ID] = [Extent5].[genre_ID] ) AS [Distinct1] ON [Distinct1].[movie_ID] = [Extent1].[movie_ID] | |
| 12 | WHERE 1 = 1 | |
| 13 | ) AS [Distinct2] | |
| 14 | - | ORDER BY [Distinct2].[t_Meter] ASC} |
| 14 | + | ORDER BY [Distinct2].[t_Meter] ASC |
