query = '''SELECT d.*, z.id, z.targetid, xu.id1, xu.id2, xu.distance, u.unwise_objid, u.fluxlbs_w1, u.fluxlbs_w2, u.fracflux_w1, u.fracflux_w2, u.mag_w1_vg, u.mag_w2_vg, u.nm_w1, u.nm_w2, u.qf_w1, u.qf_w2, u.rchi2_w1, u.rchi2_w2
FROM mydb://desi_star AS d
INNER JOIN desi_dr1.zpix AS z
ON z.targetid=d.targetid
INNER JOIN unwise_dr1.x1p5__object__desi_dr1__zpix AS xu
ON xu.id2=z.id
INNER JOIN unwise_dr1.object AS u
ON xu.id1=u.unwise_objid
WHERE xu.distance < 1'''
try:
qc.query(adql=query,async_=True,wait=True,poll=15,verbose=1, timeout=86400, \
out='vos://desixunwise_star.csv', fmt='csv')
except Exception as e:
print(e.message)