DECLARE @site INT SET @site = '805'
DECLARE @date VARCHAR(10) SET @date = '2019-08-23'
DECLARE @house INT SET @house = '48309'
DECLARE @movie INT SET @movie = '0'
DECLARE @language VARCHAR(10) SET @language = 'spanish'
DECLARE @choice INT SET @choice = '0'
WITH site_movies (movie_id, min_date) AS (
SELECT DISTINCT s.movie_id, MIN(s.showdate)
FROM websites..sitehouses sh WITH(NOLOCK)
INNER JOIN cinema..screens s WITH(NOLOCK) ON s.house_id = sh.house_id
INNER JOIN cinema..movies m WITH(NOLOCK) ON m.movie_id = s.movie_id AND m.parent_id NOT IN (
SELECT DISTINCT s2.movie_id
FROM websites..sitehouses sh2 WITH(NOLOCK)
INNER JOIN cinema..screens s2 WITH(NOLOCK) ON s2.house_id = sh2.house_id AND s2.showdate = @date
WHERE sh2.siteid = @site AND sh.house_id = @house
)
LEFT OUTER JOIN websites..comingsoon cs WITH(NOLOCK) ON cs.siteid = sh.siteid AND cs.movie_id = m.movie_id
WHERE sh.siteid = @site AND ISNULL(cs.release, m.release) > @date AND sh.house_id = @house
GROUP BY s.movie_id
HAVING MIN(s.showdate) > @date
)
SELECT
ISNULL(parent.movie_id, m.movie_id) AS row_key,
m.movie_id,
CASE
WHEN @language = 'spanish'
THEN ISNULL(cs.title, ISNULL(ISNULL(parent.name_spa, m.name_spa), ISNULL(parent.name, m.name)))
ELSE ISNULL(cs.title, ISNULL(parent.name, m.name))
END AS [name],
ISNULL(parent.hiphotos, m.hiphotos) AS hiphotos,
ISNULL(cs.release, ISNULL(parent.release, m.release)) AS release,
cs.posterimage,
cs.custom_text,
ISNULL(cs.csmpaa, ISNULL(parent.mpaa, m.mpaa)) AS mpaa,
ISNULL(cs.advisory, m.advisory) AS advisory,
m.genre, m.genre2, m.genre3,
m.actor1, m.actor2, m.actor3, m.actor4, m.actor5, m.actor6, m.actor7, m.actor8, m.actor9, m.actor10, cs.csactors,
ISNULL(cs.csruntime, ISNULL(parent.runtime, m.runtime)) AS runtime,
CASE WHEN cs.synopsis_type = 'Custom' THEN cs.custom_synopsis ELSE RTRIM(r.capsule) END AS capsule,
ISNULL(cs.csdirector, m.director) AS director,
ISNULL(cs.csproducer,m.producer) AS producer,
m.writer,
ISNULL(parent.flv_high, m.flv_high) AS flv_high,
cs.cstrailer,
ISNULL(cs.url, ISNULL(parent.url, m.url)) AS website,
p.still,
st.fxp_still,
c.slider_image

FROM site_movies sm
INNER JOIN cinema..movies m WITH(NOLOCK)
ON m.movie_id = sm.movie_id

LEFT OUTER JOIN cinema..movies parent WITH(NOLOCK)
ON parent.movie_id = m.parent_id
LEFT OUTER JOIN websites..comingsoon cs WITH(NOLOCK)
ON cs.siteid = @site AND cs.movie_id = m.movie_id

LEFT OUTER JOIN cinema..reviews r WITH(NOLOCK)
ON r.movie_id = CASE WHEN m.parent_id IS NOT NULL AND m.parent_id <> 0 THEN m.parent_id ELSE m.movie_id END AND r.sid = CASE
WHEN cs.synopsis_type = 'none' OR cs.synopsis_type = '' OR cs.synopsis_type IS NULL
THEN CASE WHEN @language = 'spanish' THEN 'SPSYN' ELSE 'SYSYN' END
ELSE cs.synopsis_type
END
OUTER APPLY (
SELECT TOP 1 ip_filename AS still FROM cinema..intlphotos WITH(NOLOCK) WHERE movie_id = m.movie_id AND ip_filename NOT LIKE '%1.jpg' AND ip_country = 'USA' AND ip_resolution = 'R'
) p
OUTER APPLY (
SELECT TOP 1 file_name AS fxp_still FROM websites..stills WITH(NOLOCK) WHERE movie_id = CASE WHEN m.parent_id IS NOT NULL AND m.parent_id <> 0 THEN m.parent_id ELSE m.movie_id END AND siteid = @site
) st
OUTER APPLY (
SELECT TOP 1 largeimage AS slider_image FROM websites..carousel WITH(NOLOCK) WHERE movie_id = m.movie_id AND siteid = @site
) c
ORDER BY sm.min_date, ISNULL(cs.release, ISNULL(parent.release, m.release)) ASC, ISNULL(cs.title, ISNULL(parent.name, m.name))

North Las Vegas
Toggle Menu
EN ES

North Las Vegas

2195 North Las Vegas Boulevard
North Las Vegas, NV 89030

Get Directions

MPX | Dolby Atmos | RealD 3D | DBOX | Proyección de laser | Reclinadores de Lujo | Coca-Cola Freestyle | Centro de juego de Energí

3D Theater View
Exhibiendo