Films Comedy, page 2 2000s, page 2 UK, page 2

2004

2007

2005

2009

2008

2000

2007

2006

2000

2006

2004

2006

2007

2007

2008

2007

2007

2006

2001

2003

2005

2008

2005

2008

2001

2002

2005

2005

2006

2000
- UK
- USA


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