#userTable file: xaf
#userTable rows: 100000
#userTable columns: col1,col2,col3
Submitted query: select u.*,c.*,s.sourceID,s.ra,s.dec,s.jAperMag3,s.jAperMag3Err,s.hAperMag3,s.hAperMag3Err,s.ksAperMag3,s.ksAperMag3Err from #usertable as u outer apply htm.dbo.fGetNearestVHSSourceEQ(u.col2,u.col3,2.0/60.0) as c left outer join vhssource as s on c.sourceId=s.sourceID
Start: Tue Nov 17 20:40:44 GMT 2020 End: Tue Nov 17 20:56:58 GMT 2020
Database: VHSDR6
(Query returned 100000 result rows, only the first 30 rows are shown in the displayed table.)
| col1 | col2 | col3 | sourceID | distance | sourceID | ra | dec | jAperMag3 | jAperMag3Err | hAperMag3 | hAperMag3Err | ksAperMag3 | ksAperMag3Err | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 5573443274630564096 | +95.9473216 | -40.1432561 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 2 | 4145218558316719488 | +270.3241513 | -15.8299631 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 3 | 4145201893786983424 | +270.8637252 | -15.6366654 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 4 | 4145189730447354112 | +271.1363335 | -15.7649679 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 5 | 4145197255230279936 | +271.0049939 | -15.6918012 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 6 | 4145219279829238400 | +270.3978314 | -15.7598747 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 7 | 4145213163794077568 | +270.3106731 | -15.9274975 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 8 | 4145199419881925888 | +270.8404273 | -15.6988559 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 9 | 4145191620230511360 | +271.1061741 | -15.6810927 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 10 | 4145196293151970688 | +270.9554845 | -15.7732295 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 11 | 4145216084372703232 | +270.2553181 | -15.9320438 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 12 | 4145204470822980224 | +271.0627455 | -15.6246621 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 13 | 4145197392663957504 | +270.9114242 | -15.7271984 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 14 | 1897624136009531392 | +327.7803858 | +30.7650390 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 15 | 4145196568022998272 | +270.9354763 | -15.7558857 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 16 | 4070159812927312000 | +268.5368106 | -22.8242611 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 17 | 4145197942412720512 | +270.9542551 | -15.7025025 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 18 | 4145189799163498496 | +271.1777061 | -15.7570102 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 19 | 5835367010508585216 | +242.3440855 | -57.1921027 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 20 | 4145202855915641728 | +271.0632361 | -15.6889075 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 21 | 4145191448424531712 | +271.1793346 | -15.6772299 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 22 | 4145204195897227776 | +270.9962485 | -15.6482975 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 23 | 4070158747704077312 | +268.6513673 | -22.7893431 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 24 | 4145200794330219392 | +270.9098929 | -15.6711218 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 25 | 4145219039310639360 | +270.3774761 | -15.8003205 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 26 | 4145197873700188160 | +270.9709969 | -15.7002470 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 27 | 4145201584604232704 | +270.9183430 | -15.6291101 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 28 | 4145196602386332672 | +270.9438310 | -15.7451651 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 29 | 4145190451998801280 | +271.1635599 | -15.7244087 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 30 | 2165768496322312704 | +318.0359993 | +49.1548554 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
(Query returned 100000 result rows, only the first 30 rows are shown in the displayed table.)
| Download Results File , your results in a gzipped CSV ASCII file (Contains 100000 rows, 3.4 MB) |