# 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:                          HD142860
# 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]                                                                                                            
#                                      ]   ]                                                                                                                          
#-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
HD142860              J155627.2+153942 S   E    381250    2 2007-06-05 HR WAVE   60.0   7 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    381270    2 2007-06-05 HR WAVE   60.0  14 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    381290    2 2007-06-05 HR WAVE  180.0  16 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    381310    2 2007-06-05 HR WAVE  180.0 358 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    381380    2 2007-06-05 HR WAVE   48.0 176 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    382130    2 2007-06-07 HR WAVE   60.0 182 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    384960    2 2007-06-12 HR WAVE   60.0 225 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    625010    2 2008-05-13 HR WAVE  900.0 168 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    626080    1 2008-05-15 HR WAVE  180.0 154 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    626090    1 2008-05-15 HR WAVE  240.0 144 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    627260    1 2008-05-20 HR WAVE  300.0 313 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    627270    1 2008-05-20 HR WAVE  200.0 287 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    634300    2 2008-06-24 HR WAVE   30.0 147 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E    813520    2 2009-07-20 HR WAVE   60.0 155 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E   1140730    2 2011-04-11 HR DARK  120.0 119 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E   1141240    2 2011-04-12 HR WAVE  120.0  88 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E   1141800    2 2011-04-13 HR DARK  300.0  93 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E   1144460    2 2011-04-18 HR WAVE   90.0 247 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E   1145950    2 2011-04-20 HR WAVE   88.0 112 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E   1526020    2 2013-01-25 HR WAVE   60.0 199 view_spec view_head get_spec get_e2ds customize search_CCF
HD142860              J155627.2+153942 S   E   1531820    2 2013-02-04 HR WAVE   90.0 255 view_spec view_head get_spec get_e2ds customize search_CCF
#-- end of data table ----------------------------------------------------------
# 21 lines were successfully retrieved