Advertisement
TankorSmash

SQL query slow remote, quick local

Mar 18th, 2013
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement