Películas de Romance, página 4 de los 2010s, página 4 EE.UU., página 4

2018

2014

2016

2017

2012

2015

2019

2010

2010

2015

2018

2019

2012

2014

2014

2015

2012
SQL Statement failed on preparation: /* URL: /peliculas/romance/2010s/eeuu/4/ */ 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'
2018
2014
2016
2017
2012
2015
2019
2010
2010
2015
2018
2019
2012
2014
2014
2015
2012