A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY `UP`.`fechaFin` DESC' at line 56

SELECT `TPFU`.`idtabla_pos_finales_up`, `TPFU`.`idJugador`, `TPFU`.`idUnidadProgramacion`, `TPFU`.`pos`, `TPFU`.`puntos`, `TPFU`.`puntos_CC`, `CIR`.`idCircuito` as idCircuito_CIR, `CIR`.`name` as name_CIR, `CIR`.`isPrivate` as isPrivate_CIR, `CIR`.`idDominio` as idDominio_CIR, `TPT`.`idTipo` as idTipo_TPT, `TPT`.`nombre` as nombre_TPT, `TPT`.`color` as color_TPT, `TPT`.`info` as info_TPT, `C`.`idCountry` as idCountry_C, `C`.`name` as name_C, `S`.`idState` as idState_S, `S`.`name` as name_S, `S`.`idCountry` as idCountry_S, `CIU`.`idCiudad` as idCiudad_CIU, `CIU`.`idState` as idState_CIU, `CIU`.`name` as name_CIU, `CIU`.`textoHorario` as textoHorario_CIU, `CIU`.`minSedeFavorita` as minSedeFavorita_CIU, `CIU`.`maxSedeVetada` as maxSedeVetada_CIU, `TORDU`.`idTorneoDuracion` as idTorneoDuracion_TORDU, `TORDU`.`duracion` as duracion_TORDU, `TORDU`.`orden` as orden_TORDU, `FD`.`idFormaDeDisputa` as idFormaDeDisputa_FD, `FD`.`name` as name_FD, `TRFR`.`idTorneoFormato` as idTorneoFormato_TRFR, `TRFR`.`formato` as formato_TRFR, `TRFR`.`texto` as texto_TRFR, `FD_1`.`idFormaDeDisputa` as idFormaDeDisputa_FD_1, `FD_1`.`name` as name_FD_1, `TP`.`idTipoPuntaje` as idTipoPuntaje_TP, `TP`.`nombre` as nombre_TP, `TP`.`idFormaDeDisputa` as idFormaDeDisputa_TP, `TP`.`idSystema` as idSystema_TP, `FD_2`.`idFormaDeDisputa` as idFormaDeDisputa_FD_2, `FD_2`.`name` as name_FD_2, `TP_1`.`idTipoPuntaje` as idTipoPuntaje_TP_1, `TP_1`.`nombre` as nombre_TP_1, `TP_1`.`idFormaDeDisputa` as idFormaDeDisputa_TP_1, `TP_1`.`idSystema` as idSystema_TP_1, `STP`.`idSubTipoPuntaje` as idSubTipoPuntaje_STP, `STP`.`idTipoPuntaje` as idTipoPuntaje_STP, `STP`.`nombre` as nombre_STP, `STP`.`pelotitas` as pelotitas_STP, `STP`.`EtiquetaPelotitas` as EtiquetaPelotitas_STP, `FD_3`.`idFormaDeDisputa` as idFormaDeDisputa_FD_3, `FD_3`.`name` as name_FD_3, `TP_2`.`idTipoPuntaje` as idTipoPuntaje_TP_2, `TP_2`.`nombre` as nombre_TP_2, `TP_2`.`idFormaDeDisputa` as idFormaDeDisputa_TP_2, `TP_2`.`idSystema` as idSystema_TP_2, `FD_4`.`idFormaDeDisputa` as idFormaDeDisputa_FD_4, `FD_4`.`name` as name_FD_4, `TP_3`.`idTipoPuntaje` as idTipoPuntaje_TP_3, `TP_3`.`nombre` as nombre_TP_3, `TP_3`.`idFormaDeDisputa` as idFormaDeDisputa_TP_3, `TP_3`.`idSystema` as idSystema_TP_3, `STP_1`.`idSubTipoPuntaje` as idSubTipoPuntaje_STP_1, `STP_1`.`idTipoPuntaje` as idTipoPuntaje_STP_1, `STP_1`.`nombre` as nombre_STP_1, `STP_1`.`pelotitas` as pelotitas_STP_1, `STP_1`.`EtiquetaPelotitas` as EtiquetaPelotitas_STP_1, `TR`.`idTorneo` as idTorneo_TR, `TR`.`name` as name_TR, `TR`.`fkTipoDeTorneo` as fkTipoDeTorneo_TR, `TR`.`fkLocalidad` as fkLocalidad_TR, `TR`.`fkTorneoDuracion` as fkTorneoDuracion_TR, `TR`.`superficie` as superficie_TR, `TR`.`fechaInscIni` as fechaInscIni_TR, `TR`.`horaInscIni` as horaInscIni_TR, `TR`.`fechaInscFin` as fechaInscFin_TR, `TR`.`horaInscFin` as horaInscFin_TR, `TR`.`fechaApertura` as fechaApertura_TR, `TR`.`idCircuito` as idCircuito_TR, `TR`.`costo` as costo_TR, `TR`.`bonus` as bonus_TR, `TR`.`idFormaDeDisputa` as idFormaDeDisputa_TR, `TR`.`fkTorneoFormato` as fkTorneoFormato_TR, `TR`.`cantJugadores` as cantJugadores_TR, `TR`.`bandera` as bandera_TR, `TR`.`mensajeJugador` as mensajeJugador_TR, `TR`.`idTipoPuntaje_CC` as idTipoPuntaje_CC_TR, `TR`.`idSubTipoPuntaje_CC` as idSubTipoPuntaje_CC_TR, `TR`.`idTipoPuntaje_SE` as idTipoPuntaje_SE_TR, `TR`.`idSubTipoPuntaje_SE` as idSubTipoPuntaje_SE_TR, `TR`.`isTorneoConDesenpatePorPuntos` as isTorneoConDesenpatePorPuntos_TR, `TR`.`esTorneoMaestros` as esTorneoMaestros_TR, `TD`.`idTipo` as idTipo_TD, `TD`.`name` as name_TD, `G`.`idGenero` as idGenero_G, `G`.`name` as name_G, `GE`.`idGrupoEtiqueta` as idGrupoEtiqueta_GE, `GE`.`name` as name_GE, `GE`.`muestroEnHome` as muestroEnHome_GE, `GE`.`isLimitedByAge` as isLimitedByAge_GE, `GE`.`orden` as orden_GE, `E`.`idEtiqueta` as idEtiqueta_E, `E`.`name` as name_E, `E`.`idGrupoEtiqueta` as idGrupoEtiqueta_E, `E`.`prioridad` as prioridad_E, `E`.`edadMinima` as edadMinima_E, `GE_1`.`idGrupoEtiqueta` as idGrupoEtiqueta_GE_1, `GE_1`.`name` as name_GE_1, `GE_1`.`muestroEnHome` as muestroEnHome_GE_1, `GE_1`.`isLimitedByAge` as isLimitedByAge_GE_1, `GE_1`.`orden` as orden_GE_1, `FD_5`.`idFormaDeDisputa` as idFormaDeDisputa_FD_5, `FD_5`.`name` as name_FD_5, `UP`.`idUnidadProgramacion` as idUnidadProgramacion_UP, `UP`.`idTorneo` as idTorneo_UP, `UP`.`idTipo` as idTipo_UP, `UP`.`idGenero` as idGenero_UP, `UP`.`idFormaDeDisputa` as idFormaDeDisputa_UP, `UP`.`idEtiqueta` as idEtiqueta_UP, `UP`.`idGrupoEtiqueta` as idGrupoEtiqueta_UP, `UP`.`fechaApertura` as fechaApertura_UP, `UP`.`fechaFin` as fechaFin_UP, `UP`.`fechaInscIni` as fechaInscIni_UP, `UP`.`fechaInscFin` as fechaInscFin_UP, `UP`.`horaInscIni` as horaInscIni_UP, `UP`.`horaInscFin` as horaInscFin_UP, `UP`.`cantJugadores` as cantJugadores_UP, `UP`.`idTipoPuntaje_CC` as idTipoPuntaje_CC_UP, `UP`.`idSubTipoPuntaje_CC` as idSubTipoPuntaje_CC_UP, `UP`.`idTipoPuntaje_SE` as idTipoPuntaje_SE_UP, `UP`.`idSubTipoPuntaje_SE` as idSubTipoPuntaje_SE_UP, `UP`.`finalizado` as finalizado_UP, `UP`.`costo` as costo_UP, `UP`.`costoDescontado` as costoDescontado_UP, `UP`.`mostrarEnFrontend` as mostrarEnFrontend_UP FROM (`tabla_pos_finales_up` TPFU) INNER JOIN `unidadprogramacion` UP ON (`TPFU`.`idUnidadProgramacion` = `UP`.`idUnidadProgramacion` AND `UP`.`isDeleted` = 'N') INNER JOIN `torneo` TR ON (`UP`.`idTorneo` = `TR`.`idTorneo` AND `TR`.`isDeleted` = 'N') INNER JOIN `circuito` CIR ON (`TR`.`idCircuito` = `CIR`.`idCircuito` AND `CIR`.`isDeleted` = 'N') LEFT JOIN `tipo_torneo` TPT ON (`TR`.`fkTipoDeTorneo` = `TPT`.`idTipo` AND `TPT`.`isDeleted` = 'N') LEFT JOIN `ciudad` CIU ON (`TR`.`fkLocalidad` = `CIU`.`idCiudad` AND `CIU`.`isDeleted` = 'N') LEFT JOIN `state` S ON (`CIU`.`idState` = `S`.`idState` AND `S`.`isDeleted` = 'N') LEFT JOIN `country` C ON (`S`.`idCountry` = `C`.`idCountry` AND `C`.`isDeleted` = 'N') LEFT JOIN `torneo_duracion` TORDU ON (`TR`.`fkTorneoDuracion` = `TORDU`.`idTorneoDuracion` ) LEFT JOIN `formadedisputa` FD ON (`TR`.`idFormaDeDisputa` = `FD`.`idFormaDeDisputa` AND `FD`.`isDeleted` = 'N') LEFT JOIN `torneo_formato` TRFR ON (`TR`.`fkTorneoFormato` = `TRFR`.`idTorneoFormato` ) LEFT JOIN `tipo_puntaje` TP ON (`TR`.`idTipoPuntaje_CC` = `TP`.`idTipoPuntaje` AND `TP`.`isDeleted` = 'N') LEFT JOIN `formadedisputa` FD_1 ON (`TP`.`idFormaDeDisputa` = `FD_1`.`idFormaDeDisputa` AND `FD_1`.`isDeleted` = 'N') LEFT JOIN `subtipos_puntaje` STP ON (`TR`.`idSubTipoPuntaje_CC` = `STP`.`idSubTipoPuntaje` AND `STP`.`isDeleted` = 'N') LEFT JOIN `tipo_puntaje` TP_1 ON (`STP`.`idTipoPuntaje` = `TP_1`.`idTipoPuntaje` AND `TP_1`.`isDeleted` = 'N') LEFT JOIN `formadedisputa` FD_2 ON (`TP_1`.`idFormaDeDisputa` = `FD_2`.`idFormaDeDisputa` AND `FD_2`.`isDeleted` = 'N') LEFT JOIN `tipo_puntaje` TP_2 ON (`TR`.`idTipoPuntaje_SE` = `TP_2`.`idTipoPuntaje` AND `TP_2`.`isDeleted` = 'N') LEFT JOIN `formadedisputa` FD_3 ON (`TP_2`.`idFormaDeDisputa` = `FD_3`.`idFormaDeDisputa` AND `FD_3`.`isDeleted` = 'N') LEFT JOIN `subtipos_puntaje` STP_1 ON (`TR`.`idSubTipoPuntaje_SE` = `STP_1`.`idSubTipoPuntaje` AND `STP_1`.`isDeleted` = 'N') LEFT JOIN `tipo_puntaje` TP_3 ON (`STP_1`.`idTipoPuntaje` = `TP_3`.`idTipoPuntaje` AND `TP_3`.`isDeleted` = 'N') LEFT JOIN `formadedisputa` FD_4 ON (`TP_3`.`idFormaDeDisputa` = `FD_4`.`idFormaDeDisputa` AND `FD_4`.`isDeleted` = 'N') INNER JOIN `tipo` TD ON (`UP`.`idTipo` = `TD`.`idTipo` AND `TD`.`isDeleted` = 'N') INNER JOIN `genero` G ON (`UP`.`idGenero` = `G`.`idGenero` AND `G`.`isDeleted` = 'N') INNER JOIN `etiqueta` E ON (`UP`.`idEtiqueta` = `E`.`idEtiqueta` AND `E`.`isDeleted` = 'N') INNER JOIN `grupoetiqueta` GE ON (`E`.`idGrupoEtiqueta` = `GE`.`idGrupoEtiqueta` AND `GE`.`isDeleted` = 'N') INNER JOIN `grupoetiqueta` GE_1 ON (`UP`.`idGrupoEtiqueta` = `GE_1`.`idGrupoEtiqueta` AND `GE_1`.`isDeleted` = 'N') LEFT JOIN `formadedisputa` FD_5 ON (`UP`.`idFormaDeDisputa` = `FD_5`.`idFormaDeDisputa` AND `FD_5`.`isDeleted` = 'N') WHERE `TPFU`.`idJugador` = 14331 AND `TPFU`.`idUnidadProgramacion` IN () ORDER BY `UP`.`fechaFin` DESC