#userTable file: xac
#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:35:23 GMT 2020 End: Tue Nov 17 20:39:57 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 | 4492234426649234304 | +261.5246986 | +11.3545923 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 2 | 5980296417006914944 | +258.4124807 | -32.1103628 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 3 | 4492397115713658880 | +264.5931162 | +10.2127755 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 4 | 2020560011422865536 | +296.7914192 | +24.3654909 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 5 | 5980295695434345472 | +258.3302215 | -32.1917458 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 6 | 2020557026443793408 | +296.4684868 | +24.3602896 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 7 | 4492312487676855680 | +261.5764371 | +11.6227440 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 8 | 2020592554388033024 | +297.2644453 | +24.3470766 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 9 | 2020568777465164800 | +297.4694843 | +24.0461318 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 10 | 2020589870037957632 | +297.3226238 | +24.3286796 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 11 | 2020567123887162880 | +296.6759564 | +24.5290074 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 12 | 438718922037341440 | +42.8833283 | +49.4772059 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 13 | 5980294909471195008 | +258.4601418 | -32.2024064 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 14 | 5619119216735478400 | +113.1907692 | -22.0992120 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 15 | 5619113414243007872 | +113.2092129 | -22.2184131 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 16 | 5619087056023244416 | +113.2135915 | -22.5305350 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 17 | 5619110489361548160 | +113.0080837 | -22.2568571 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 18 | 5619083315110322688 | +114.6467481 | -21.4893094 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 19 | 5619089529924384512 | +113.1399378 | -22.5498676 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 20 | 4068157013814584576 | +266.4092249 | -24.0618591 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 21 | 4068158633057906816 | +265.1470157 | -25.1895178 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 22 | 4068156159150523136 | +266.4860482 | -24.0662796 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 23 | 213065326033605632 | +79.5845718 | +48.5792984 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 24 | 213060446950815104 | +79.5156351 | +48.4429538 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 25 | 213077523739290752 | +77.4910665 | +47.4596252 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 26 | 4432395464810048000 | +248.3945172 | +1.9813349 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 27 | 4068157396098446464 | +266.4846347 | -24.0142086 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 28 | 213069204386777216 | +79.8629655 | +48.6371522 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 29 | 4387164717542718592 | +259.5775225 | +1.8459819 | 0 | +0.0000000E000 | 0 | +0.0000000E000 | +0.0000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 | +0.000000E000 |
| 30 | 5923831757528219136 | +256.7603594 | -53.5355206 | 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.6 MB) |