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 |
199637 | 2 | 1237651696544841947 | 20.61461 | 0.06853645 |
199639 | 2 | 1237651696544841950 | 18.15241 | 0.02065099 |
199640 | 2 | 1237651696544841952 | 17.44724 | 0.01999469 |
199641 | 2 | 1237651696544841954 | 16.85497 | 0.0197663 |
199642 | 2 | 1237651696544841957 | 16.01311 | 0.01962542 |
199643 | 2 | 1237651696544841958 | 19.91161 | 0.0337092 |
199645 | 2 | 1237651696544841962 | 17.63971 | 0.0201575 |
199646 | 2 | 1237651696544841963 | 20.77272 | 0.05944775 |
199634 | 2 | 1237651696544841936 | 18.72672 | 0.0243339 |
199632 | 2 | 1237651696544841932 | 16.48086 | 0.0196879 |