背景盖亚是欧洲航天局（ESA）的一项任务，旨在精确测量超过十亿颗恒星的位置、距离和星等。内容使用以下ADQL查询从[Gaia Archive][1]获取数据，如下所示：SELECt G.source_id，TY.id as tycho2_id，G.parallax，G.paralax_error，G.phot_G_mean_mag，G.phop_rp_mean_mag，G.phot_bp_mean_mang，G.phos_G_mean_flux_error，G.ra，G.dec，G.ra_error，G.dec_error、G.l，G.b，G.pmra，G.pmdec，AWBN.angular_distance AS allwise_ang_dist，GSBN.angual_distance AS gsc23_ang_dist，PPBN.anglar_distance AS ppmxl_ang_dists，TMBN.angular _distance AStmass_ang_dists、TYBN.angular_istance AS tycho2_ang_distr，AW.w1mpro AS allwise.w1，AW.w2mpro AS allwise_w2，AW.w3mpro AS allwide_w3，AW.w4mpro AS allwise_w4，GS.v_mag AS gsc23_v.mag，GS.b_mag AS gsc23_b_mag，PP.b1mag AS ppmxl_b1mag，PP.b2mag AS ppml_b2mag，PP.r1mag AS ppmxl_r1mag，PP.imag AS ppmxl-imag，TM.j_m AS tmass_j_m，TM.h_m AS tmass_h_m，TM.ks_m AS tmass_xks_m，TY.bt_mag AS tycho2_bt_mag，TY.vt_mag AS tycho2_vt_mag FROM gaiadr2.gaia_source G INNER JOIN gaiadr2.allwise_best_neighbour AWBN ON AWBN。source_id=G.source_id INNER JOIN gaiadr2.gsc23_best_neigh bour GSBN ON GSBN。sourceid=G.sourceid INNER JOIN gaiadr2.ppmxl_best_neightbour PPBN ON PPBN。sourceuid=G.ource_id INNE JOIN gaiad2.tmass_best_neighbour TMBN ON TMBNgaiadr2.tycho2_best_neighbour TYBN ON TYBN。source_id=G.source_id INNER JOIN gaiadr1.allwise_original_valid AW ON AW。designation=AWBN.original_ext_source_id INNE JOIN gaiaddr1.gsc23_original_有效GS ON GS。gsc23_identifier=GSBN.origonal_ext_ssource_id IN JOIN gaiabr1.ppmxl_original_invalid PP ON PP.ppmxl_oid=PPBN.ppmxl_oid INNER JOIN gaiadr1.mass_original_效TM ONTM.designation=TMBN.original_ext_source_id INNER JOIN public.tycho2 TY ON TY。id=TYBN.origginal_ext_ssource_id，其中G.parallax>=2.0，G.parallax_error<=0.035，G.phot_G_mean_mag<=13.5，G.paralax_error不为空，G.phop_rp_mean_mag不为空且G.phot_bp_mean_mang不为空并且G.phot_G_mean_flux_error不空且AW.w1mpro不为空AW.w2mpro不为空，AW.w3mpro不为NULL，AW.w4mpro不为NULL，GS.v_mag不为空、GS.b_mag不空，PP.b1mag不为空且PP.b2mag不为NULL且PP.r1mag不空且PP.imag不为空而TM.j_m不为NULL且TM.h_m不空且TM.ks_m不为空并且TY.bt_mag不空而TY.vt_mag也不为空AWBN.angular_distance<=0.15，GSBN.angual_distance<=0.25，PPBN.angular_istance<=0.015，TMBN.angular _distance==0.15，TYBN.angula _distance<1，AWBN.best_neighbor_multiplicity=1，GSBN.best_Neighbor_multiplicity=1，PPBN.best.neighbor-multiplicility=1，TMBN.best_ineighbor.multipliclity=1，TYBN.number_of_nneighbor=1注释-有数据中存在多个重复的source_id。-幅值在数据库之间存在位置偏差。