Your SQL command was:
select top 10
S.ra as sdss_ra, S.dec as sdss_dec, W.ra as wise_ra, W.dec as wise_dec,
S.psfmag_r as r, W.w1mpro as w1
from wise_xmatch as X
join wise_allsky as W on X.wise_cntr = W.cntr
join photoTag as S on X.sdss_objid = S.objid
where S.nchild = 0
Your query output (max 500,000 rows):
sdss_ra | sdss_dec | wise_ra | wise_dec | r | w1 |
0.526499701264626 | -2.22949094703266 | 0.5262677 | -2.2294602 | 21.91396 | 16.116 |
0.581636579621318 | -2.11525348139977 | 0.5817215 | -2.1153625 | -9999 | 16.143 |
0.625465875042664 | -2.2441124246381 | 0.6255857 | -2.2440051 | 22.45875 | 16.008 |
0.672919178730595 | -2.205965494723 | 0.6728694 | -2.2059352 | 19.64749 | 16.017 |
0.673968570333784 | -2.13180445036159 | 0.6739067 | -2.1317454 | 20.54199 | 15.955 |
0.633707051305365 | -2.22914664832519 | 0.6335599 | -2.2290225 | 23.50803 | 16.11 |
0.481941267121641 | -2.01060103361343 | 0.4818752 | -2.010688 | 23.14297 | 16.15 |
0.486020863546599 | -2.04838895883865 | 0.4860306 | -2.048307 | 23.13661 | 15.989 |
0.645045856861941 | -2.04799718484032 | 0.6450728 | -2.0479718 | 19.93334 | 16.026 |
0.669170946573558 | -2.15543701328844 | 0.6691615 | -2.1555063 | 21.41809 | 16.034 |