SDSS Query Results

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
199752	2	1237651696544842350	20.83425	0.05966558
199751	2	1237651696544842348	20.78308	0.05732953
168456	2	1237672794505216493	22.29232	0.1935736
167812	2	1237672795579154587	18.93867	0.0211447
167811	2	1237672795579155178	22.84609	0.2576254
151783	2	1237672793968280310	23.18461	0.3052832
151778	2	1237672793968279744	20.19022	0.04032411
108945	2	1237672793968345796	22.00555	0.1495176
108944	2	1237672793968345129	21.78302	0.1609726
108943	2	1237672793968345870	22.71287	0.4163643

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):

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