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

Scary Stories to Tell In The Dark
Toggle Menu
EN ES

Scary Stories to Tell In The Dark

Horror | 1 hr. 51 min. | August 9th, 2019 | PG-13

Inspired by one of the most terrifying book series of all time, SCARY STORIES TO TELL IN THE DARK follows a group of teens who must solve the mystery surrounding a wave of spectacularly horrific deaths in their small town.

dbox Tag
Scary Stories to Tell In The Dark Poster
castZoe Colletti
Michael Garza
Austin Abrams
Gabriel Rush
Austin Zajur
Natalie Ganzhorn
directorAndre Ovredal written byGuillermo Del Toro, Patrick Melton, Marcus Dunstan, Dan Hageman and Kevin Hageman movie websitehttp://www.scarystoriestotellinthedark.com/
Now Playing