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
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
199653	2	1237651696544842002	17.4127	0.0199706
167811	2	1237672795579155178	22.84609	0.2576254
167812	2	1237672795579154587	18.93867	0.0211447
199669	2	1237651696544842046	19.29588	0.02589091
199668	2	1237651696544842044	19.39495	0.0257236
199626	2	1237651696544841858	16.6929	0.01973098

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