# 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 =997730]
# 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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
 997730 HD217014 2010-08-07   20 G2 0 -33.135  0.0007     7.971  -0.021    6995  43.18 4746 view_head   get_ccf   view_ccf  
 997740 HD217014 2010-08-07   20 G2 0 -33.142  0.0007     7.964  -0.016    8214  43.37 4746 view_head   get_ccf   view_ccf  
 997750 HD217014 2010-08-07   20 G2 0 -33.145  0.0007     7.964  -0.021    7950  43.32 4746 view_head   get_ccf   view_ccf  
 997760 HD217014 2010-08-07   20 G2 0 -33.144  0.0007     7.963  -0.021    8075  43.35 4746 view_head   get_ccf   view_ccf  
 997770 HD217014 2010-08-07   20 G2 0 -33.135  0.0008     7.965  -0.016    5850  43.04 4746 view_head   get_ccf   view_ccf  
 997780 HD217014 2010-08-07   20 G2 0 -33.134  0.0008     7.962  -0.021    6144  43.09 4746 view_head   get_ccf   view_ccf  
 997790 HD217014 2010-08-07   20 G2 0 -33.140  0.0007     7.962  -0.016    7646  43.31 4746 view_head   get_ccf   view_ccf  
 997800 HD217014 2010-08-07   20 G2 0 -33.142  0.0007     7.963  -0.019    8512  43.40 4746 view_head   get_ccf   view_ccf  
 997810 HD217014 2010-08-07   20 G2 0 -33.143  0.0007     7.966  -0.019    8091  43.37 4746 view_head   get_ccf   view_ccf  
 997820 HD217014 2010-08-07   20 G2 0 -33.141  0.0007     7.966  -0.020    7871  43.34 4746 view_head   get_ccf   view_ccf  
 997830 HD217014 2010-08-07   20 G2 0 -33.143  0.0007     7.958  -0.022    8082  43.38 4746 view_head   get_ccf   view_ccf  
 997840 HD217014 2010-08-07   20 G2 0 -33.143  0.0007     7.966  -0.016    8682  43.41 4746 view_head   get_ccf   view_ccf  
 997850 HD217014 2010-08-07   20 G2 0 -33.143  0.0007     7.964  -0.023    7851  43.35 4746 view_head   get_ccf   view_ccf  
 997860 HD217014 2010-08-07   20 G2 0 -33.141  0.0007     7.964  -0.020    7966  43.34 4746 view_head   get_ccf   view_ccf  
 997870 HD217014 2010-08-07   20 G2 0 -33.144  0.0007     7.964  -0.023    7452  43.28 4746 view_head   get_ccf   view_ccf  
 997880 HD217014 2010-08-07   20 G2 0 -33.140  0.0007     7.960  -0.018    6883  43.23 4746 view_head   get_ccf   view_ccf  
 997890 HD217014 2010-08-07   20 G2 0 -33.142  0.0007     7.966  -0.019    7545  43.28 4746 view_head   get_ccf   view_ccf  
 997900 HD217014 2010-08-07   20 G2 0 -33.144  0.0006     7.965  -0.020    9892  43.52 4746 view_head   get_ccf   view_ccf  
 997910 HD217014 2010-08-07   20 G2 0 -33.149  0.0006     7.963  -0.019   10097  43.51 4746 view_head   get_ccf   view_ccf  
 997920 HD217014 2010-08-07   20 G2 0 -33.147  0.0006     7.966  -0.019   10160  43.50 4746 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 20 lines were successfully retrieved