# Query Description # Type of request: Extract data from a table # Name of the selected table: sophie # Description of the table: Spectra # Restrict with the SQL clause: view_head IS NOT NULL # SQL constraint on fields: get_spec 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,3390530]" -O 3390530_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3390500]" -O 3390500_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3390510]" -O 3390510_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3389970]" -O 3389970_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3390080]" -O 3390080_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3389900]" -O 3389900_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3389980]" -O 3389980_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3389890]" -O 3389890_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3390030]" -O 3390030_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3390010]" -O 3390010_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3389930]" -O 3389930_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3390090]" -O 3390090_s1d.fits wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3390110]" -O 3390110_s1d.fits #-- end of data table ---------------------------------------------------------- # 30 lines were successfully retrieved