Automatisch erzeugte Suchabfragen

Jede Abfrage wird in das SDSS-SQL-Suchformular kopiert.

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.02) AND (s.z<=0.025) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.025) AND (s.z<=0.03) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.03) AND (s.z<=0.035) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.035) AND (s.z<=0.04) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.04) AND (s.z<=0.045) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.045) AND (s.z<=0.05) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.05) AND (s.z<=0.055) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.055) AND (s.z<=0.06) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.06) AND (s.z<=0.065) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.065) AND (s.z<=0.07) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.07) AND (s.z<=0.075) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.075) AND (s.z<=0.08) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.08) AND (s.z<=0.085) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.085) AND (s.z<=0.09) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.09) AND (s.z<=0.095) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.095) AND (s.z<=0.1) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.1) AND (s.z<=0.105) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.105) AND (s.z<=0.11) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.11) AND (s.z<=0.115) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.115) AND (s.z<=0.12) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.12) AND (s.z<=0.125) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.125) AND (s.z<=0.13) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.13) AND (s.z<=0.135) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.135) AND (s.z<=0.14) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.14) AND (s.z<=0.145) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.145) AND (s.z<=0.15) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.15) AND (s.z<=0.155) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.155) AND (s.z<=0.16) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.16) AND (s.z<=0.165) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.165) AND (s.z<=0.17) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.17) AND (s.z<=0.175) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.175) AND (s.z<=0.18) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.18) AND (s.z<=0.185) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.185) AND (s.z<=0.19) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.19) AND (s.z<=0.195) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.195) AND (s.z<=0.2) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.2) AND (s.z<=0.205) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.205) AND (s.z<=0.21) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.21) AND (s.z<=0.215) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.215) AND (s.z<=0.22) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.22) AND (s.z<=0.225) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.225) AND (s.z<=0.23) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.23) AND (s.z<=0.235) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.235) AND (s.z<=0.24) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.24) AND (s.z<=0.245) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.245) AND (s.z<=0.25) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.25) AND (s.z<=0.255) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.255) AND (s.z<=0.26) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.26) AND (s.z<=0.265) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.265) AND (s.z<=0.27) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.27) AND (s.z<=0.275) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.275) AND (s.z<=0.28) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.28) AND (s.z<=0.285) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.285) AND (s.z<=0.29) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

SELECT TOP 10
p.objID,s.z,p.petroMag_r
FROM BESTDR7..SpecObj AS s
JOIN BESTDR7..Galaxy AS p ON s.bestObjID = p.objID
WHERE (p.primTarget & (dbo.fPrimTarget('TARGET_GALAXY')) > 0) AND (s.z>0.29) AND (s.z<=0.295) AND (zWarning = 0)
ORDER BY p.petroMag_r ASC

Zurück zur Online-Material-Seite