SQL Statement failed on preparation: /* URL: /peliculas/1960s/eeuu/2/ */ 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.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.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.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' Películas en la década de los 1960s de EE.UU. - Página 2
