Morgan F. ran some tutorial with me on ADQL etc..
the idea is to find WD wide binary candidates that commove with TGAS
stars within 300 pc. Go to TOPCAT; preload a table of TGAS stars within
300 pc; activate that table and then go to TAP queries; select GAVO; select gps1;
Then:
SELECT
TOP 10000 *
FROM gps1.main AS db
JOIN TAP_UPLOAD.t2 AS tc
ON 1= CONTAINS(POINT('ICRS', db.ra, db.dec),
CIRCLE('ICRS', tc.ra, tc.dec, (10.3*tc.parallax/3600.)))
WHERE db.e_pmra * 3.6e6 < 5. AND db.e_pmde * 3.6e6 < 5.
AND
SQRT( (power(tc.pmra-db.pmra*3.6e6 , 2) + power(tc.pmdec-db.pmde*3.6e6 , 2)) /
(power(db.e_pmra* 3.6e6,2)+power(db.e_pmde* 3.6e6,2)) ) < 5
Morgan's version of that query yielded nice results.
