What I learned about ADQL queries at the Gaia sprint; WD binaries

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.