# 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,3581060]" -O 3581060_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3581130]" -O 3581130_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3581070]" -O 3581070_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3581080]" -O 3581080_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3581090]" -O 3581090_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3581100]" -O 3581100_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3581120]" -O 3581120_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3581140]" -O 3581140_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3581150]" -O 3581150_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580460]" -O 3580460_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580590]" -O 3580590_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580550]" -O 3580550_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580560]" -O 3580560_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580440]" -O 3580440_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580620]" -O 3580620_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580430]" -O 3580430_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580700]" -O 3580700_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580710]" -O 3580710_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580580]" -O 3580580_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580600]" -O 3580600_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580530]" -O 3580530_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580470]" -O 3580470_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580480]" -O 3580480_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580520]" -O 3580520_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580450]" -O 3580450_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580690]" -O 3580690_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580500]" -O 3580500_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580510]" -O 3580510_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580070]" -O 3580070_s1d.fits
wget "http://atlas.obs-hp.fr/sophie/sophie.cgi?c=i&a=mime:application/fits&o=sophie:[s1d,3580000]" -O 3580000_s1d.fits
#-- end of data table ----------------------------------------------------------
# 30 lines were successfully retrieved