# Query Description # Type of request: Extract data from a table # Name of the selected table: sophies # Description of the table: Spectra (series truncated to the first observation) # Restrict with the SQL clause: view_head IS NOT NULL # Display the fields: ['wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,'||seq||']" -O '||seq||'_s1d.fits'] # Order by: date desc # Description of each column # 'wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,'||seq||']" -O '||seq||'_s1d.fits': #-------------- #'wget "http:// #atlas.obs-hp.f #r/sophie/sophi #e.cgi?c=i&a=mi #me:application #/fits&o=sophie #:[s1d,'||seq|| #']" -O '||seq| #|'_s1d.fits' #-------------- wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3414740]" -O 3414740_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3414170]" -O 3414170_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3413630]" -O 3413630_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3412750]" -O 3412750_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3412130]" -O 3412130_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3411610]" -O 3411610_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3410860]" -O 3410860_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3409240]" -O 3409240_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3408580]" -O 3408580_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3408010]" -O 3408010_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3407400]" -O 3407400_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3406790]" -O 3406790_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3406290]" -O 3406290_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3405340]" -O 3405340_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3404840]" -O 3404840_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3404190]" -O 3404190_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3403370]" -O 3403370_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367590]" -O 3367590_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367070]" -O 3367070_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3366910]" -O 3366910_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367690]" -O 3367690_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3366880]" -O 3366880_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367170]" -O 3367170_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3366990]" -O 3366990_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367290]" -O 3367290_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367350]" -O 3367350_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3366970]" -O 3366970_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367490]" -O 3367490_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367410]" -O 3367410_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367050]" -O 3367050_s1d.fits #-- end of data table ---------------------------------------------------------- # 30 lines were successfully retrieved