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='200006' and bal_competicion.id='200904' and bal_torneo.mostrar=1 and bal_torneo.id_temporada='1920' and bal_torneo.id_federacion_ambito in (17,46,47,48) and (bal_categoria.seleccion=0) ORDER BY abs(orden_campeonato_torneos)