VSA - SQL Query Results

Submitted query: SELECT v.sourceID,s.l, s.b,s.ra,s.dec,d.mjd,d.aperMag3,d.aperMag3Err,d.ppErrBits,d.seqNum,ss.hmksPnt,v.ksMeanMag,v.ksMagRms,b.flag FROM vvvSourceXDetectionBestMatch AS b, vvvSource AS s,vvvSourceXSynopticSource AS x, vvvSynopticSource AS ss, vvvPsfDoPhotZYJHKsMergeLog AS l,vvvDetection AS d, vvvVariability as v, (SELECT l.frameSetID,sl.synFrameSetID, sl.meanMjdObs,sl.mergeDuration FROM vvvSynopticMergeLog AS sl, vvvMergeLog AS l WHERE dbo.fGreatCircleDist(l.ra,l.dec,sl.ra,sl.dec)<1) AS ML WHERE (s.priOrSec=0 OR s.priOrSec=s.frameSetID) AND x.masterObjID=s.sourceID AND x.distanceMins<0.033 AND x.distanceMins IN (SELECT MIN(distanceMins) FROM vvvSourceXSynopticSource WHERE masterObjID=x.masterObjID) AND ss.synopticID=x.slaveObjID AND ML.frameSetID=s.frameSetID AND ML.synFrameSetID=ss.synFrameSetID and ss.hmksPnt>2. and v.sourceID=s.sourceID and v.ksnGoodObs>4 AND  (l.fieldName='b333' OR  l.fieldName='b334' OR  l.fieldName='b335' OR  l.fieldName='b319' OR  l.fieldName='b320' OR  l.fieldName='b321' OR  l.fieldName='b305' OR  l.fieldName='b306' OR  l.fieldName='b307')

Start: Tue Dec 29 21:12:59 GMT 2020 End: Tue Dec 29 21:36:19 GMT 2020

Database: VVVDR4

(Query returned at least (i.e. before it was halted) 57144000 result rows, only the first 100 rows are shown in the displayed table.)

NB The number of rows written to the output file reached the maximum allowed 28572000

(Query returned at least (i.e. before it was halted) 57144000 result rows, only the first 100 rows are shown in the displayed table.)

NB The number of rows written to the output file reached the maximum allowed 28572000

Download Results File , your results in a gzipped CSV ASCII file (Contains 28572000 rows, 431.4 MB)