Films Comedy 2000s UK

2005

2002

2004

2002

2000

2001

2006

2000

2006

2008

2004

2007

2006

2006

2006

2001

2008

2000

2006

2007

2005

2008

2007

2004

2009

2005

2005

2009

2003

2008

2007
- UK
- USA


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