|
Last change
on this file since 20105 was 20031, checked in by tbretz, 5 years ago |
|
Included telescope id and the create query to the raw data extraction.
|
|
File size:
259 bytes
|
| Line | |
|---|
| 1 | #!/usr/bin/env -S rootifysql
|
|---|
| 2 | SELECT
|
|---|
| 3 | (TSTARTI+TSTARTF) AS ObsStart,
|
|---|
| 4 | Star.*,
|
|---|
| 5 | log10(Size) AS lgSize,
|
|---|
| 6 | log10(Width*Length*PI()) AS lgArea
|
|---|
| 7 | FROM
|
|---|
| 8 | `Star` Star
|
|---|
| 9 | LEFT JOIN
|
|---|
| 10 | RawData USING(Telescope, NIGHT, RUNID)
|
|---|
| 11 | ORDER BY
|
|---|
| 12 | Telescope,
|
|---|
| 13 | NIGHT,
|
|---|
| 14 | RUNID
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
