DECLARE @site INT SET @site = '780'
DECLARE @date VARCHAR(10) SET @date = '2019-08-24'
DECLARE @house INT SET @house = '0'
DECLARE @movie INT SET @movie = '164756'
DECLARE @language VARCHAR(10) SET @language = 'english'
DECLARE @choice INT SET @choice = '0'
WITH site_movies (movie_id, min_date) AS (SELECT @movie AS movie_id, null)
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
,
CAST(
(
SELECT DISTINCT CASE
WHEN RTRIM(s.comment) <> '' AND RTRIM(s.comment) IS NOT NULL
THEN RTRIM(s.comment)+';'
ELSE ''
END
FROM websites..sitehouses sh WITH(NOLOCK)
INNER JOIN cinema..screens s WITH(NOLOCK) ON s.house_id = sh.house_id AND s.movie_id IN (m.movie_id, m.parent_id)
WHERE sh.siteid = @site
FOR XML PATH('')
) AS VARCHAR(MAX)
) AS attributes

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))

Toy Story 4
Toggle Menu
EN ES

Toy Story 4

Animation | 1 hr. 40 min. | June 21st, 2019 | G

Woody has always been confident about his place in the world, but when Bonnie adds a reluctant new toy called "Forky" to her room, a road trip adventure alongside old and new friends will show Woody how big the world can be for a toy.

Toy Story 4 Poster
castTom Hanks
Tim Allen
directorJosh Cooley movie websitehttp://movies.disney.com/toy-story-4
Advance Tickets