Películas de Fantasía, página 5 de los 2000s, página 5

2009

2002

2006

2004

2005

2005

2009

2002

2004

2007

2007

2006

2009

2009

2005

2005

2005

2009

2007

2006

2009

2005

2004

2009
SQL Statement failed on preparation: /* URL: /peliculas/fantasia/2000s/5/ */ 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'
2009
2002
2006
2004
2005
2005
2009
2002
2004
2007
2007
2006
2009
2009
2005
2005
2005
2009
2007
2006
2009
2005
2004
2009