Films Family 2000s Spain

2007

2006

2006

2009

2004

2003

2006

2008
- UK
- USA


SQL Statement failed on preparation: /* URL: /films/family/2000s/spain/ */ 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.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.EN ASC
LIMIT 12'
2007
2006
2006
2009
2004
2003
2006
2008