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.56 KB  |  views: 37  |  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