Your SQL command was:
SELECT TOP 10 t.thingid, t.ndetect, d.objid, p.psfMag_r,
p.psfMagerr_r
FROM thingIndex AS t
JOIN detectionindex AS d ON t.thingid = d.thingid
JOIN Star AS p ON d.objid = p.objid
WHERE t.ndetect > 1
Your query output (max 500,000 rows):
thingid | ndetect | objid | psfMag_r | psfMagerr_r |
96181 | 2 | 1237672793431408761 | 21.26337 | 0.2396695 |
168456 | 2 | 1237672794505216493 | 22.29232 | 0.1935736 |
50798 | 2 | 1237672793968541999 | 22.04815 | 0.1351681 |
108943 | 2 | 1237672793968345870 | 22.71287 | 0.4163643 |
108945 | 2 | 1237672793968345796 | 22.00555 | 0.1495176 |
108944 | 2 | 1237672793968345129 | 21.78302 | 0.1609726 |
151783 | 2 | 1237672793968280310 | 23.18461 | 0.3052832 |
151778 | 2 | 1237672793968279744 | 20.19022 | 0.04032411 |
60373 | 2 | 1237672793431539781 | 17.52066 | 0.01926431 |
96179 | 2 | 1237672793431408881 | 19.53478 | 0.02583369 |