VSA - SQL Query Results

Submitted query: SELECT DISTINCT m.frameType, m.filterID, k.obsName FROM vmcDetection as d, Multiframe as m, MultiframeEsoKeys as k 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 GROUP BY d.multiframeID, d.mjd, d.extNum, m.dateObs, m.frameType, m.filterID, k.obsName ORDER BY k.obsName

Start: Thu Jan 21 14:47:07 GMT 2021 End: Thu Jan 21 15:01:04 GMT 2021

Database: VMCv20191212

(Query returned 209 result rows, only the first 30 rows are shown in the displayed table.)

  frameType filterID obsName
1 tilestack 5 Bridge-CK1_vmc_survey_bridge10p4_1_2_8
2 tilestack 5 Bridge-TK1_vmc_survey_bridge10p4_1_2_8
3 tilestack 5 Bridge-TK10_vmc_survey_bridge10p4_1_2_8
4 tilestack 5 Bridge-TK11_vmc_survey_bridge10p4_1_2_8
5 tilestack 5 epoch10_LMC_7_5_1_1_1
6 tilestack 5 epoch11_LMC_7_5_1_1_1
7 tilestack 5 epoch12_LMC_7_5_1_1_1
8 tilestack 5 epoch13_LMC_7_5_1_1_1
9 tilestack 5 epoch15_LMC_7_5_1_1_1
10 tilestack 5 epoch19_LMC_7_5
11 tilestack 5 epoch20_LMC_7_5
12 tilestack 5 epoch21_LMC_7_2
13 tilestack 5 epoch6_LMC_7_5_1_1_1
14 tilestack 5 epoch7_LMC_7_5_1_1_1
15 tilestack 5 epoch8_LMC_7_5_1_1_1
16 tilestack 5 epoch9_LMC_7_5_1_1_1
17 tilestack 5 LMC-CK1_vmc_P90_lmc1_1_7_7
18 tilestack 5 LMC-CK1_vmc_P92_lmc.xml_1_10_6
19 tilestack 5 LMC-CK1_vmc_P92_lmc.xml_1_4_4
20 tiledeepstack 5 LMC-CK1_vmc_P92_lmc.xml_1_4_4
21 tilestack 5 LMC-CK1_vmc_P92_lmc.xml_1_4_9
22 tilestack 5 LMC-CK1_vmc_P92_lmc.xml_1_9_9
23 tilestack 5 LMC-CK1_vmc_P92_lmc_1_4_5
24 tilestack 5 LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_3
25 stack 5 LMC-CK1_vmc_survey_lmc11p11S_RED_1_4_6
26 stack 5 LMC-CK1_vmc_survey_lmc11p11S_RED_1_5_5
27 stack 5 LMC-CK1_vmc_survey_lmc11p11S_RED_1_6_4
28 tilestack 5 LMC-CK1_vmc_survey_lmc11p11S_RED_1_7_5
29 tilestack 5 LMC-CK1_vmc_survey_lmc11p11S_RED_1_8_8
30 tilestack 5 LMC-CK1_vmc_survey_lmc11p11S_RED_1_9_3

(Query returned 209 result rows, only the first 30 rows are shown in the displayed table.)

Download Results File , your results in a CSV ASCII file (Contains 209 rows, 28.1 KB)