# 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
# 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':  <NA>
#--------------
#'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,3368220]" -O 3368220_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,3367650]" -O 3367650_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367530]" -O 3367530_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367130]" -O 3367130_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367270]" -O 3367270_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,3366880]" -O 3366880_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367430]" -O 3367430_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3367210]" -O 3367210_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,3367150]" -O 3367150_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
#-- end of data table ----------------------------------------------------------
# 30 lines were successfully retrieved