Skip to content

Instantly share code, notes, and snippets.

@jakevdp

jakevdp/query.txt

Created August 1, 2016 14:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jakevdp/cb4d500911ea9fb93e07f3f870120708 to your computer and use it in GitHub Desktop.
Save jakevdp/cb4d500911ea9fb93e07f3f870120708 to your computer and use it in GitHub Desktop.
Download ZIP
Star/Galaxy SQL query
Raw
query.txt
SELECT TOP 10000
p.psfMag_r, p.fiberMag_r, p.fiber2Mag_r, p.petroMag_r,
p.deVMag_r, p.expMag_r, p.modelMag_r, p.cModelMag_r,
s.class
FROM PhotoObjAll AS p JOIN specObjAll s ON s.bestobjid = p.objid
WHERE p.mode = 1 AND s.sciencePrimary = 1 AND p.clean = 1 AND s.class != 'QSO'
ORDER BY p.objid ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment