# 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)
# Object:                          HD042618
# Order by:                        ra,seq
# Description of each column
# $link[objname]: ------ Designation of the object
# $j2000: -------------- J2000 coordinates
# $link['S']: ---------- Link to Simbad database
# $link['E']: ---------- <NA>
# seq: ----------------- Sequence number
# $link[slen]: --------- Length of the series
# date: ---------------- Calendar date of observation
# mode: ---------------- Observation mode: High resolution or High efficiency
# fiber_b: ------------- Use of the second fiber (DARK, WAVE or SKY)
# exptime: ------------- exposure time
# sn26: ---------------- Signal/noise in order 26
# $link[view_spec]: ---- <NA>
# $link[view_head]: ---- <NA>
# $link[get_spec]: ----- <NA>
# $link[get_e2ds]: ----- <NA>
# $link[customize]: ---- <NA>
# $link[search_ccf]: --- <NA>
#-------------------- ---------------- --- --- --------------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
#$link[objname]       $j2000           $li $li seq     $lin date            mode            fibe exptim sn2 $link[vie $link[vie $link[ge $link[ge $link[cus $link[sear
#                                      nk[ nk[         k[sl                                 r_b  e      6   w_spec]   w_head]   t_spec]  t_e2ds]  tomize]   ch_ccf]   
#                                      'S' 'E'         en]                                                                                                            
#                                      ]   ]                                                                                                                          
#-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
HD042618              J061200.6+064659 S   E    300450    1 2007-02-01 HR WAVE  900.0 217 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    301260    1 2007-02-02 HR WAVE  900.0 249 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    302030    1 2007-02-03 HR WAVE  900.0 268 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    302790    1 2007-02-04 HR WAVE  900.0 219 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    303440    1 2007-02-05 HR WAVE  900.0 191 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    304550    1 2007-02-07 HR WAVE  437.0 135 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    305550    1 2007-02-09 HR WAVE  900.0 215 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    307620    1 2007-02-12 HR WAVE  582.7  91 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    311530    1 2007-02-16 HR WAVE  900.0 181 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    551000    1 2008-01-31 HR WAVE  900.0 195 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    552640    1 2008-02-04 HR WAVE  900.0 169 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    553270    1 2008-02-05 HR WAVE  900.0 234 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    554020    1 2008-02-06 HR WAVE  900.0 130 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    555640    1 2008-02-08 HR WAVE  900.0 210 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    556340    1 2008-02-09 HR WAVE  900.0 151 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    557060    1 2008-02-10 HR WAVE  900.0 191 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    697520    1 2008-10-04 HR WAVE  900.0 203 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    701730    1 2008-10-13 HR WAVE  900.0 175 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    710670    1 2008-10-26 HR WAVE  900.0 236 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    929450    1 2010-03-14 HR WAVE  800.0 139 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E    931460    1 2010-03-17 HR WAVE  900.0 203 view_spec view_head get_spec get_e2ds customize search_CCF
HD042618              J061200.6+064659 S   E   2088700    1 2017-01-15 HR SKY   120.0  50 view_spec view_head get_spec get_e2ds customize search_CCF
#-- end of data table ----------------------------------------------------------
# 22 lines were successfully retrieved