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

Vencedor
Toggle Menu
EN ES

Vencedor

Drama | 1 hr. 59 min. | August 23rd, 2019 | PG

John Harrison cree saber exactamente quién es: un respetado entrenador de básquetbol con un equipo rumbo al campeonato estatal. Pero cuando varios de sus jugadores se tienen que mudar porque cierra la fábrica mas grande de la ciudad, la vida del entrenador Harrison cambia de la noche a la mañana.

La directora de la escuela lo insta a hacerse entrenador de un deporte que no le gusta, y eso lo deja frustrado y comienza a preguntarse quién es realmente.

John, su familia, y su equipo se enfrentarán a un futuro incierto... Hasta que se cruza con una estudiante con sus propias luchas internas.

Vencedor Poster
emitirAlex Kendrick
Shari Rigby
Priscilla Shirer
Cameron Arnett
Denise Armstrong
Aryn Wright-Thompson
directorAlex Kendrick escrito porAlex Kendrick, Stephen Kendrick sitio web de la películahttp://www.sonypictures.com/movies/overcomer/
Exhibiendo