# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiecc
# Description of the table:        Cross-correlation functions
# SQL constraint on fields:        [sseq =1405670]
# Order by:                        seq
# Description of each column
# seq: ----------------- Sequence number
# $link[objname]: ------ Designation of the object
# date: ---------------- Observation date
# $link[slen]: --------- Length of the series
# mask: ---------------- Name of the mask
# ccf_offline: --------- Offline CCF
# $field[rv]: ---------- Radial velocity
# fwhm: ---------------- FWHM of the correlation peak
# span: ---------------- Bissector span
# maxcpp: -------------- Maximum number of counts per pixel
# contrast: ------------ Contrast of the CCF
# lines: --------------- Number of lines used for the CCF
# $link['view_head']: -- See the header of the cross-correlation file
# $link['get_ccf']: ---- Download the cross-correlation function FITS file
# $link['view_ccf']: --- View the cross-correlation function
#-------------- ------- --------------- ---- -- --------------- ---------------- -------- ------- --------------- ------ --------------- ----------- --------- ----------
#seq    $link[o date            $lin ma c $field[rv]       fwhm     span    maxcpp  contra l $link['view $link['ge $link['vie
#       bjname]                 k[sl sk c                                           st     i _head']     t_ccf']   w_ccf']   
#                               en]     f                                                  n                                 
#                                       _                                                  e                                 
#                                       o                                                  s                                 
#                                       f                                                                                    
#                                       f                                                                                    
#                                       l                                                                                    
#                                       i                                                                                    
#                                       n                                                                                    
#                                       e                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
1405690 HD172167 2012-08-02   19 F0 0 -39.564  0.3240     1.679   0.244      61   1.77 3477 view_head   get_ccf   view_ccf  
1405700 HD172167 2012-08-02   19 F0 0 -29.434  4.7596    28.711   0.000      60   0.50 3477 view_head   get_ccf   view_ccf  
1405710 HD172167 2012-08-02   19 F0 0 -10.728  0.2578     2.094  -0.024      60   2.44 3477 view_head   get_ccf   view_ccf  
1405720 HD172167 2012-08-02   19 F0 0 -29.144  0.5067     3.146   0.650      61   1.55 3477 view_head   get_ccf   view_ccf  
1405730 HD172167 2012-08-02   19 F0 0 -12.651  0.6035     6.042   0.223      61   1.83 3477 view_head   get_ccf   view_ccf  
1405740 HD172167 2012-08-02   19 F0 0 -31.487  0.3076     3.215   0.610      60   2.61 3477 view_head   get_ccf   view_ccf  
1405750 HD172167 2012-08-02   19 F0 0 -13.582  0.6756     4.290   0.001      61   1.30 3477 view_head   get_ccf   view_ccf  
1405770 HD172167 2012-08-02   19 F0 0 -42.600  0.4091     3.144   0.000      60   1.91 3477 view_head   get_ccf   view_ccf  
1405780 HD172167 2012-08-02   19 F0 0  -1.851  0.9194     5.444   0.043      60   1.14 3477 view_head   get_ccf   view_ccf  
1405800 HD172167 2012-08-02   19 F0 0 -89.591  0.0099    34.566   0.000      61 263.49 3477 view_head   get_ccf   view_ccf  
1405820 HD172167 2012-08-02   19 F0 0 -35.543  0.2957     2.080  -0.091      60   2.18 3477 view_head   get_ccf   view_ccf  
1405840 HD172167 2012-08-02   19 F0 0   1.184  0.2545     1.069   0.058      60   1.79 3477 view_head   get_ccf   view_ccf  
1405850 HD172167 2012-08-02   19 F0 0 -14.805  0.4921     2.252  -0.033      61   1.40 3477 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 13 lines were successfully retrieved