SELECT bal_torneo.id, grupo as nombre_grupo, bal_fase.nombre as nombre_fase , bal_torneo.id_tipo_torneo, bal_torneo.visible_resultados_clasificacion as mostrar_resultados FROM bal_categoria, bal_torneo, bal_competicion, bal_fase WHERE bal_torneo.id_competicion=bal_competicion.id and bal_torneo.id_fase=bal_fase.id and bal_categoria.id=bal_torneo.id_categoria and bal_torneo.id_categoria='34' and bal_competicion.id='8' and bal_torneo.mostrar=1 and bal_torneo.id_temporada='1617' and bal_torneo.id_federacion_ambito in (1) and (bal_categoria.seleccion=0) ORDER BY abs(orden_campeonato_torneos)