Submitted query: SELECT DISTINCT m.dateObs, m.frameType, m.filterID, k.obsName, m.mjdEnd, md.mjdMean FROM vmcDetection as d, Multiframe as m, MultiframeEsoKeys as k, MultiframeDetector as md WHERE d.mjd<0 AND d.ra BETWEEN 60 AND 120 AND m.filterID=5 AND m.multiframeID=d.multiframeID AND k.multiframeID=d.multiframeID AND md.multiframeID=d.multiframeID GROUP BY d.multiframeID, d.mjd, d.extNum, m.dateObs, m.frameType, m.mjdEnd, m.filterID, k.obsName,md.mjdMean ORDER BY k.obsName
Start: Fri Jan 22 09:46:25 GMT 2021 End: Fri Jan 22 10:22:37 GMT 2021
Database: VMCv20191212
(Query returned 455 result rows, only the first 30 rows are shown in the displayed table.)
| dateObs | frameType | filterID | obsName | mjdEnd | mjdMean | |
|---|---|---|---|---|---|---|
| 1 | 2011-09-04 08:10:20.1 | tilestack | 5 | Bridge-CK1_vmc_survey_bridge10p4_1_2_8 | +55808.3644869 | -9.9999950E008 |
| 2 | 2011-09-05 07:55:06.5 | tilestack | 5 | Bridge-TK1_vmc_survey_bridge10p4_1_2_8 | +55809.3698561 | -9.9999950E008 |
| 3 | 2012-09-17 08:27:34.3 | tilestack | 5 | Bridge-TK10_vmc_survey_bridge10p4_1_2_8 | +56187.3871224 | -9.9999950E008 |
| 4 | 2012-10-29 04:26:50.3 | tilestack | 5 | Bridge-TK11_vmc_survey_bridge10p4_1_2_8 | +56229.2248008 | -9.9999950E008 |
| 5 | 2018-01-22 01:57:43.2 | tilestack | 5 | epoch10_LMC_7_5_1_1_1 | +58140.1312782 | -9.9999950E008 |
| 6 | 2018-01-25 01:06:26.0 | tilestack | 5 | epoch11_LMC_7_5_1_1_1 | +58143.0955754 | -9.9999950E008 |
| 7 | 2018-01-25 03:38:25.4 | tilestack | 5 | epoch12_LMC_7_5_1_1_1 | +58143.2013756 | -9.9999950E008 |
| 8 | 2018-01-26 01:42:24.8 | tilestack | 5 | epoch13_LMC_7_5_1_1_1 | +58144.1207664 | -9.9999950E008 |
| 9 | 2018-01-29 04:06:10.8 | tilestack | 5 | epoch15_LMC_7_5_1_1_1 | +58147.2208684 | -9.9999950E008 |
| 10 | 2018-02-04 01:16:20.6 | tilestack | 5 | epoch19_LMC_7_5 | +58153.1292169 | -9.9999950E008 |
| 11 | 2018-02-05 03:29:51.1 | tilestack | 5 | epoch20_LMC_7_5 | +58154.1953681 | -9.9999950E008 |
| 12 | 2018-02-07 01:23:11.9 | tilestack | 5 | epoch21_LMC_7_2 | +58156.1076759 | -9.9999950E008 |
| 13 | 2018-01-18 01:38:44.6 | tilestack | 5 | epoch6_LMC_7_5_1_1_1 | +58136.1181240 | -9.9999950E008 |
| 14 | 2018-01-19 02:51:52.5 | tilestack | 5 | epoch7_LMC_7_5_1_1_1 | +58137.1692911 | -9.9999950E008 |
| 15 | 2018-01-20 01:55:35.0 | tilestack | 5 | epoch8_LMC_7_5_1_1_1 | +58138.1299883 | -9.9999950E008 |
| 16 | 2018-01-21 01:52:28.5 | tilestack | 5 | epoch9_LMC_7_5_1_1_1 | +58139.1280890 | -9.9999950E008 |
| 17 | 2013-02-23 01:55:33.5 | tilestack | 5 | LMC-CK1_vmc_P90_lmc1_1_7_7 | +56346.1028979 | -9.9999950E008 |
| 18 | 2017-10-17 07:30:57.1 | tilestack | 5 | LMC-CK1_vmc_P92_lmc.xml_1_10_6 | +58043.3364689 | -9.9999950E008 |
| 19 | 2014-11-08 07:12:56.9 | tilestack | 5 | LMC-CK1_vmc_P92_lmc.xml_1_4_4 | +56969.3238279 | -9.9999950E008 |
| 20 | 2014-11-08 07:35:37.7 | tiledeepstack | 5 | LMC-CK1_vmc_P92_lmc.xml_1_4_4 | +56982.3282712 | -9.9999950E008 |
| 21 | 2017-11-30 06:47:25.3 | tilestack | 5 | LMC-CK1_vmc_P92_lmc.xml_1_4_9 | +58087.3060120 | -9.9999950E008 |
| 22 | 2017-04-04 01:06:12.0 | tilestack | 5 | LMC-CK1_vmc_P92_lmc.xml_1_9_9 | +57847.0689706 | -9.9999950E008 |
| 23 | 2013-10-15 08:35:33.8 | tilestack | 5 | LMC-CK1_vmc_P92_lmc_1_4_5 | +56580.3815279 | -9.9999950E008 |
| 24 | 2009-12-22 06:33:48.3 | tilestack | 5 | LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_3 | +55187.2951275 | -9.9999950E008 |
| 25 | 2010-12-11 08:30:59.9 | stack | 5 | LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_6 | +55541.3583767 | +55541.3566226 |
| 26 | 2010-12-11 08:19:32.0 | stack | 5 | LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_6 | +55541.3504436 | +55541.3486749 |
| 27 | 2010-12-11 08:25:16.3 | stack | 5 | LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_6 | +55541.3544556 | +55541.3526654 |
| 28 | 2010-12-11 08:13:55.8 | stack | 5 | LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_6 | +55541.3464964 | +55541.3447519 |
| 29 | 2010-12-11 08:02:39.9 | stack | 5 | LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_6 | +55541.3386359 | +55541.3369078 |
| 30 | 2010-12-11 08:08:17.2 | stack | 5 | LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_6 | +55541.3425670 | +55541.3408220 |
(Query returned 455 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 455 rows, 10 KB) |