import time
from gavo import votable

svc = "http://dc.g-vo.org/tap"
print time.time()
res = votable.ADQLSyncJob(svc,
"""
SELECT
   *
   FROM twomass.data AS db
   JOIN fk6.part1 AS tc
   ON 1=CONTAINS(POINT('ICRS', db.raj2000, db.dej2000),
                 CIRCLE('ICRS', tc.RAj2000, tc.DEj2000, 5./3600.))
"""
  ).run()
data, metadata = votable.load(res.openResult())
list(data)
print time.time()
res = votable.ADQLSyncJob(svc,
"""
SELECT
   *
   FROM twomass.data AS db
   JOIN fk6.part1 AS tc
   ON 1=CONTAINS(POINT('ICRS', tc.raj2000, tc.dej2000),
                 CIRCLE('ICRS', db.RAj2000, db.DEj2000, 5./3600.))
"""
  ).run()
data, metadata = votable.load(res.openResult())
list(data)


print time.time()