This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Mar 14th, 2013  |  syntax: SQL  |  size: 0.65 KB  |  views: 31  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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}
clone this paste RAW Paste Data