# 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 =1002480]
# 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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
1002480 HD217014 2010-08-10   20 G2 0 -33.170  0.0008     7.971  -0.017    5381  43.00 4745 view_head   get_ccf   view_ccf  
1002490 HD217014 2010-08-10   20 G2 0 -33.171  0.0010     7.967  -0.018    4068  42.81 4745 view_head   get_ccf   view_ccf  
1002500 HD217014 2010-08-10   20 G2 0 -33.177  0.0012     7.958  -0.010    2965  42.48 4745 view_head   get_ccf   view_ccf  
1002510 HD217014 2010-08-10   20 G2 0 -33.188  0.0020     7.945  -0.023    1147  41.03 4745 view_head   get_ccf   view_ccf  
1002520 HD217014 2010-08-10   20 G2 0 -33.183  0.0013     7.952  -0.020    2402  42.22 4745 view_head   get_ccf   view_ccf  
1002530 HD217014 2010-08-10   20 G2 0 -33.184  0.0014     7.948  -0.020    2284  42.13 4745 view_head   get_ccf   view_ccf  
1002540 HD217014 2010-08-10   20 G2 0 -33.181  0.0020     7.934  -0.011    1147  41.14 4745 view_head   get_ccf   view_ccf  
1002550 HD217014 2010-08-10   20 G2 0 -33.173  0.0012     7.963  -0.014    2753  42.34 4745 view_head   get_ccf   view_ccf  
1002560 HD217014 2010-08-10   20 G2 0 -33.176  0.0010     7.969  -0.017    4024  42.77 4745 view_head   get_ccf   view_ccf  
1002570 HD217014 2010-08-10   20 G2 0 -33.176  0.0013     7.947  -0.015    2272  42.19 4745 view_head   get_ccf   view_ccf  
1002580 HD217014 2010-08-10   20 G2 0 -33.173  0.0010     7.967  -0.018    3642  42.69 4745 view_head   get_ccf   view_ccf  
1002590 HD217014 2010-08-10   20 G2 0 -33.174  0.0011     7.966  -0.007    3334  42.62 4745 view_head   get_ccf   view_ccf  
1002600 HD217014 2010-08-10   20 G2 0 -33.178  0.0007     7.974  -0.016    6669  43.24 4745 view_head   get_ccf   view_ccf  
1002610 HD217014 2010-08-10   20 G2 0 -33.176  0.0007     7.973  -0.018    6831  43.27 4745 view_head   get_ccf   view_ccf  
1002620 HD217014 2010-08-10   20 G2 0 -33.181  0.0007     7.967  -0.014    7827  43.41 4745 view_head   get_ccf   view_ccf  
1002630 HD217014 2010-08-10   20 G2 0 -33.182  0.0007     7.972  -0.017    7855  43.40 4745 view_head   get_ccf   view_ccf  
1002640 HD217014 2010-08-10   20 G2 0 -33.181  0.0007     7.969  -0.014    8407  43.42 4745 view_head   get_ccf   view_ccf  
1002650 HD217014 2010-08-10   20 G2 0 -33.184  0.0007     7.969  -0.021    8259  43.41 4745 view_head   get_ccf   view_ccf  
1002660 HD217014 2010-08-10   20 G2 0 -33.183  0.0007     7.974  -0.015    7058  43.32 4745 view_head   get_ccf   view_ccf  
1002670 HD217014 2010-08-10   20 G2 0 -33.186  0.0009     7.962  -0.021    4437  42.94 4745 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 20 lines were successfully retrieved