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='200038' and bal_competicion.id='200413' and bal_torneo.mostrar=1 and bal_torneo.id_temporada='1819' and bal_torneo.id_federacion_ambito in (19) and (bal_categoria.seleccion=0) ORDER BY abs(orden_campeonato_torneos)