| | 44 | {{{ |
| | 45 | # QUERY_ID EXTVER OBSCODE STAGE |
| | 46 | lctest1 2 566 diff |
| | 47 | # ROWNUM RA1_DEG DEC1_DEG RA2_DEG DEC2_DEG MAG FILTER MJD-OBS |
| | 48 | 1 161.59932 58.25591 161.59000 58.25700 19 z 55304 |
| | 49 | 2 161.59932 58.25591 161.59000 58.25700 19 g 55305 |
| | 50 | 3 161.59932 58.25591 161.59000 58.25700 19 r 55305 |
| | 51 | 4 161.59932 58.25591 161.59000 58.25700 19 g 55320 |
| | 52 | 5 161.59932 58.25591 161.59000 58.25700 19 r 55320 |
| | 53 | }}} |
| | 54 | |
| | 55 | The server should be able to reject faulty rows (that match no exposure), so a brute force method to generate a multi-filter lightcurve could be done using this kind of query: |
| | 56 | |
| | 57 | {{{ |
| | 58 | # QUERY_ID EXTVER OBSCODE STAGE |
| | 59 | lctest2 2 566 diff |
| | 60 | # ROWNUM RA1_DEG DEC1_DEG RA2_DEG DEC2_DEG MAG FILTER MJD-OBS |
| | 61 | 1 161.59932 58.25591 161.59000 58.25700 19 g 55304 |
| | 62 | 2 161.59932 58.25591 161.59000 58.25700 19 r 55304 |
| | 63 | 3 161.59932 58.25591 161.59000 58.25700 19 i 55304 |
| | 64 | 4 161.59932 58.25591 161.59000 58.25700 19 z 55304 |
| | 65 | 5 161.59932 58.25591 161.59000 58.25700 19 y 55304 |
| | 66 | 6 161.59932 58.25591 161.59000 58.25700 19 g 55305 |
| | 67 | 7 161.59932 58.25591 161.59000 58.25700 19 r 55305 |
| | 68 | 8 161.59932 58.25591 161.59000 58.25700 19 i 55305 |
| | 69 | 9 161.59932 58.25591 161.59000 58.25700 19 z 55305 |
| | 70 | 10 161.59932 58.25591 161.59000 58.25700 19 y 55305 |
| | 71 | 11 161.59932 58.25591 161.59000 58.25700 19 g 55306 |
| | 72 | 12 161.59932 58.25591 161.59000 58.25700 19 r 55306 |
| | 73 | 13 161.59932 58.25591 161.59000 58.25700 19 i 55306 |
| | 74 | 14 161.59932 58.25591 161.59000 58.25700 19 z 55306 |
| | 75 | 15 161.59932 58.25591 161.59000 58.25700 19 y 55306 |
| | 76 | 16 161.59932 58.25591 161.59000 58.25700 19 g 55307 |
| | 77 | 17 161.59932 58.25591 161.59000 58.25700 19 r 55307 |
| | 78 | 18 161.59932 58.25591 161.59000 58.25700 19 i 55307 |
| | 79 | 19 161.59932 58.25591 161.59000 58.25700 19 z 55307 |
| | 80 | 20 161.59932 58.25591 161.59000 58.25700 19 y 55307 |
| | 81 | }}} |
| | 82 | |