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 = '224545'
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))

Peter Rabbit
Toggle Menu
EN ES

Peter Rabbit

Animation | 1 hr. 34 min. | February 9th, 2018 | PG

Peter's feud with Mr. McGregor escalates to greater heights than ever before as they rival for the affections of the warm-hearted animal lover who lives next door.

Peter Rabbit Poster
castJames Corden
Rose Byrne
Daisy Ridley
Elizabeth Debicki
Domhnall Gleeson
Margot Robbie
directorWill Gluck written byRob Lieber, Will Gluck movie websitehttp://www.sonypictures.com/movies/peterrabbit/
Coming Soon