Películas de Misterio de los 2010s Reino Unido

2015

2018

2018

2012

2017

2018

2014

2013

2013

2015

2018

2018

2014

2014

2017

2019

2013

2015

2013

2017

2015

2018

2014

2018

2018

2015

2019

2015

2018

2019
SQL Statement failed on preparation: /* URL: /peliculas/misterio/2010s/reino-unido/ */ 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'
2015
2018
2018
2012
2017
2018
2014
2013
2013
2015
2018
2018
2014
2014
2017
2019
2013
2015
2013
2017
2015
2018
2014
2018
2018
2015
2019
2015
2018
2019