skip to main content

gaia early data release 3 documentation

9.4 ADQL queries

9.4.7 High proper motion stars: angular distance and magnitude difference histograms

select round(angular_distance) as mas, count(*) as n
from edr3.dr2_neighbourhood as xm
join gaiadr2.gaia_source as gaia2
  on xm.dr2_source_id = gaia2.source_id
where dr2_source_id = dr3_source_id
  and gaia2.random_index < 10000000
group by mas
order by mas