Films Adventure 1960s

1966

1968

1962

1962

1969

1961

1966

1964

1964

1963

1969

1969

1969

1960

1967

1967

1967

1960

1966

1960

1965

1961
- UK
- USA


SQL Statement failed on preparation: /* URL: /films/adventure/1960s/ */ 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'
1966
1968
1962
1962
1969
1961
1966
1964
1964
1963
1969
1969
1969
1960
1967
1967
1967
1960
1966
1960
1965
1961