DECLARE @site INT SET @site = '805'
DECLARE @date VARCHAR(10) SET @date = '2019-08-23'
DECLARE @house INT SET @house = '0'
DECLARE @movie INT SET @movie = '267458'
DECLARE @language VARCHAR(10) SET @language = 'spanish'
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))

Dora y la ciudad perdida
Toggle Menu
EN ES

Dora y la ciudad perdida

Family | 1 hr. 42 min. | August 9th, 2019 | PG

Después de haber pasado la mayor parte de su vida explorando la jungla con sus padres, nada podía preparar a Dora (Isabela Moner) para su aventura más peligrosa: la escuela secundaria. Siempre una exploradora, Dora rápidamente se encuentra liderando a Boots (su mejor amigo, un mono), Diego (Jeff Wahlberg), un misterioso habitante de la jungla (Eugenio Derbez), y un grupo de adolescentes destartalados en una aventura para salvar a sus padres (Eva Longoria, Michael Peña) y resolver el increíble misterio detrás de una ciudad perdida de oro.

Dora y la ciudad perdida Poster
emitirIsabela Moner
Eugenio Derbez
Micke Moreno
Nicholas Coombe
Madeleine Madden
Adriana Barraza
Temuera Morrison
Eva Longoria
Michael Pena
directorJames Bobin escrito porNicholas Stoller and Matthew Robinson sitio web de la películahttp://www.paramount.com/movies/dora-and-lost-city-gold
Exhibiendo