SELECT jAperMag3, hAperMag3, k_1AperMag3, jmhPnt, hmk_1Pnt
FROM gpsJHKsource
WHERE sourceID%10=0 and mergedClass=-1 and (priOrSec<=0 or priOrSec=frameSetID) and jppErrBits<256 and hppErrBits<256 and k_1ppErrBits<256 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


Note the introduction of random sampling based on sourceID (because of the large size of the GPS data set).