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
50798	2	1237672793968541999	22.04815	0.1351681
64227	2	1237672793968476587	21.83491	0.1176584
64226	2	1237672793968476345	19.87741	0.03297703
64223	2	1237672793968476329	19.17936	0.02742947
64222	2	1237672793968476316	17.93254	0.02526278
83272	2	1237672793968411078	20.92897	0.05889097
83270	2	1237672793968410718	18.74617	0.03148751
199772	2	1237651696544842382	19.76603	0.0298519
199768	2	1237651696544842376	20.9819	0.0670156
199762	2	1237651696544842368	20.0914	0.03569768

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