56 | | SELECT md5sum, reference, dtpropid, surveyid, release_date, start_date, date_obs, dtpi, ra, dec, telescope, instrument, filter, exposure, obstype, obsmode, proctype, prodtype, seeing, depth, dtacqnam, reference AS archive_file, filesize, noao_id FROM voi.siap WHERE (proctype = 'Raw') AND (telescope = 'ct4m' AND instrument = 'decam') AND release_date < '2014-09-17'; |
| 56 | SELECT md5sum, reference, dtpropid, surveyid, release_date, start_date, |
| 57 | date_obs, dtpi, ra, dec, telescope, instrument, filter, exposure, |
| 58 | obstype, obsmode, proctype, prodtype, seeing, depth, dtacqnam, |
| 59 | reference AS archive_file, filesize, noao_id |
| 60 | FROM voi.siap |
| 61 | WHERE dtacqnam LIKE '%0014____.fits.fz' |
| 62 | AND proctype = 'Raw' |
| 63 | AND telescope = 'ct4m' |
| 64 | AND instrument = 'decam' |
| 65 | AND release_date < '2015-02-01' |
| 66 | LIMIT 10000; |