|
Last change
on this file since 20033 was 20031, checked in by tbretz, 4 years ago |
|
Included telescope id and the create query to the raw data extraction.
|
|
File size:
330 bytes
|
| Line | |
|---|
| 1 | #!/usr/bin/env -S rootifysql
|
|---|
| 2 | SELECT
|
|---|
| 3 | Telescope,
|
|---|
| 4 | NIGHT,
|
|---|
| 5 | RUNID,
|
|---|
| 6 | (TSTARTI+TSTARTF) AS ObsStart,
|
|---|
| 7 | RUNTYPE,
|
|---|
| 8 | Imed,
|
|---|
| 9 | Patch,
|
|---|
| 10 | Amplitude,
|
|---|
| 11 | Baseline
|
|---|
| 12 | FROM
|
|---|
| 13 | `Callisto` Callisto
|
|---|
| 14 | LEFT JOIN
|
|---|
| 15 | RawData USING(Telescope, NIGHT, RUNID)
|
|---|
| 16 | LEFT JOIN
|
|---|
| 17 | AuxData USING(Telescope, NIGHT, RUNID)
|
|---|
| 18 | ORDER BY
|
|---|
| 19 | Telesscope, NIGHT, RUNID
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
