SHARE
TWEET

Untitled

a guest Mar 14th, 2013 37 Never
  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}
RAW Paste Data
Top