SQL Statement failed on preparation: /* URL: /films/adventure/ireland/ */ 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.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.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.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'
Films adventure Ireland
Movie'n'co
Films

Films Adventure Ireland

Vídeos eCartelera
Tráiler en español de 'La hermanastra fea'

By genre

By decade

By country

Between Land and Sea

2016

Between Land and Sea
Maze

2017

Maze
My Father's Dragon

2022

My Father's Dragon
My Freaky Family

2024

My Freaky Family
Sgt. Stubby: An Unlikely Hero

2018

Sgt. Stubby: An Unlikely Hero
The Secret of Kells

2009

The Secret of Kells
The Young Offenders

2016

The Young Offenders
Unbreakable: The Mark Pollock Story

2014

Unbreakable: The Mark Pollock Story
Wolfwalkers

2020

Wolfwalkers
Box Office
  • UK
  • USA