# 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':  <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,3775630]" -O 3775630_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775640]" -O 3775640_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775650]" -O 3775650_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775580]" -O 3775580_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775560]" -O 3775560_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775610]" -O 3775610_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775550]" -O 3775550_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775620]" -O 3775620_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775680]" -O 3775680_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775590]" -O 3775590_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775570]" -O 3775570_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775070]" -O 3775070_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775090]" -O 3775090_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775180]" -O 3775180_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3774950]" -O 3774950_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775170]" -O 3775170_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775000]" -O 3775000_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3774940]" -O 3774940_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775040]" -O 3775040_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3774980]" -O 3774980_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775130]" -O 3775130_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775100]" -O 3775100_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3774960]" -O 3774960_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775060]" -O 3775060_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775160]" -O 3775160_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775200]" -O 3775200_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775010]" -O 3775010_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775120]" -O 3775120_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775050]" -O 3775050_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3775190]" -O 3775190_s1d.fits
#-- end of data table ----------------------------------------------------------
# 30 lines were successfully retrieved