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
199601	2	1237651696544841820	18.338	0.02102519
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
199647	2	1237651696544841965	18.40377	0.02108822

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