Films Family 2000s

2000

2009

2007

2009

2006

2008

2008

2002

2008

2006

2005

2007

2008

2009

2006

2006

2007

2003

2006

2000

2001
- UK
- USA


SQL Statement failed on preparation: /* URL: /films/family/2000s/ */ 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'
2000
2009
2007
2009
2006
2008
2008
2002
2008
2006
2005
2007
2008
2009
2006
2006
2007
2003
2006
2000
2001