SELECT zAperMag3, yAperMag3, jAperMag3, hAperMag3, k_1AperMag3, zmyPnt, ymjPnt, jmhPnt, hmk_1Pnt
FROM gcsSource
WHERE mergedClass=-1 AND (priOrSec<=0 OR priOrSec=frameSetID) AND zppErrBits<256 AND yppErrBits<256 AND jppErrBits<256 AND hppErrBits<256 AND k_1ppErrBits<256 AND zXi BETWEEN -1.0 AND +1.0 AND zEta BETWEEN -1.0 AND +1.0 AND yXi BETWEEN -1.0 AND +1.0 AND yEta BETWEEN -1.0 AND +1.0 AND jXi BETWEEN -1.0 AND +1.0 AND jEta BETWEEN -1.0 AND +1.0 AND hXi BETWEEN -1.0 AND +1.0 AND hEta BETWEEN -1.0 AND +1.0 AND k_1Xi BETWEEN -1.0 AND +1.0 AND k_1Eta BETWEEN -1.0 AND +1.0


For the Z-J vs Z plot, the colour Z-J (not listed in gcsSource) was derived from the observed magnitudes. Since default values might compensate each other and their difference result zero, another query filtered out non-measured magnitudes. Such a query was submitted separately from the above one, so that the existence of default values in the Z or J bands did not place restrictions on other colour-colour and colour-magnitude plots.

SELECT zAperMag3, (zAperMag3-jAperMag3) as zmjPnt
FROM gcsSource
WHERE mergedClass=-1 AND (priOrSec<=0 OR priOrSec=frameSetID) AND zppErrBits<256 AND jppErrBits<256 AND zXi BETWEEN -1.0 AND +1.0 AND zEta BETWEEN -1.0 AND +1.0 AND jXi BETWEEN -1.0 AND +1.0 AND jEta BETWEEN -1.0 AND +1.0 AND zAperMag3>-9999.9 AND jAperMag3>-9999.9