source:
trunk/Mars/hawc/processing/summary-star.sql
| Last change on this file was 20031, checked in by , 5 years ago | |
|---|---|
| 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.
