Películas de Thriller, página 3 de los 2010s, página 3 EE.UU., página 3

2016

2019

2016

2017

2016

2013

2015

2017

2017

2015

2011

2016

2013

2017

2014

2010

2018

2013

2017

2014

2017

2017

2014

2018

2012
- México
- USA


SQL Statement failed on preparation: /* URL: /peliculas/thriller/2010s/eeuu/3/ */ SELECT
C.*,
T1.Num AS Num,
C.URLES as URLMostrar, C.Nombre AS Nombre
FROM NxPaises C
INNER JOIN (
SELECT IDPais, COUNT(IDPais) AS Num
FROM (
SELECT P.IDPais FROM NxPeliculas P USE INDEX (idx_p_g_anno_pais) WHERE P.STATUS=1 AND P.IDGenero = ? AND P.Anno BETWEEN ? AND ? AND P.ID IS NOT NULL UNION ALL SELECT P.IDPais FROM NxPeliculas P USE INDEX (idx_p_g2_anno_pais) WHERE P.STATUS=1 AND P.IDGenero2 = ? AND P.Anno BETWEEN ? AND ? AND P.ID IS NOT NULL UNION ALL SELECT P.IDPais FROM NxPeliculas P USE INDEX (idx_p_g3_anno_pais) WHERE P.STATUS=1 AND P.IDGenero3 = ? AND P.Anno BETWEEN ? AND ? AND P.ID IS NOT NULL
) AS FilteredPeliculas
GROUP BY IDPais
) AS T1 ON C.ID = T1.IDPais
ORDER BY Num DESC, C.Nombre ASC
LIMIT 12'
2016
2019
2016
2017
2016
2013
2015
2017
2017
2015
2011
2016
2013
2017
2014
2010
2018
2013
2017
2014
2017
2017
2014
2018
2012