Films 2010s Switzerland

2018

2019

2013

2016

2011

2012

2017

2016

2013

2019

2018

2015

2013

2018

2018

2012

2013

2018

2016

2012

2019

2014

2017

2017

2013

2018

2013

2018

2016
- UK
- USA


SQL Statement failed on preparation: /* URL: /films/2010s/switzerland/ */ SELECT
C.*,
T1.Num AS Num,
C.URLEN as URLMostrar, C.EN AS Nombre, C.Nombre AS NombreES
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.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.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.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.EN ASC
LIMIT 12'
2018
2019
2013
2016
2011
2012
2017
2016
2013
2019
2018
2015
2013
2018
2018
2012
2013
2018
2016
2012
2019
2014
2017
2017
2013
2018
2013
2018
2016