# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiecc
# Description of the table:        Cross-correlation functions
# Extended object search:          HD190007,HD400
# Restrict with the SQL clause:    (sn26 > 200)
# Order by:                        ra,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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
 690540 HD000400 2008-09-23    2 G2 0 -15.106  0.0011     9.751   0.038   13303  23.65 4735 view_head   get_ccf   view_ccf  
 830210 HD000400 2009-08-12    2 G2 0 -15.138  0.0010     9.759   0.044   18435  22.87 4760 view_head   get_ccf   view_ccf  
 830220 HD000400 2009-08-12    2 G2 0 -15.132  0.0010     9.759   0.040   17436  22.79 4760 view_head   get_ccf   view_ccf  
1475860 HD000400 2012-10-28    1 G2 0 -15.105  0.0010     9.745   0.037   14812  23.98 4707 view_head   get_ccf   view_ccf  
1477700 HD000400 2012-10-31    2 G2 0 -15.117  0.0010     9.743   0.030   15202  24.10 4706 view_head   get_ccf   view_ccf  
1477710 HD000400 2012-10-31    2 G2 0 -15.119  0.0010     9.750   0.036   15778  24.08 4706 view_head   get_ccf   view_ccf  
1478700 HD000400 2012-11-02    2 G2 0 -15.110  0.0008     9.745   0.039   22901  24.19 4705 view_head   get_ccf   view_ccf  
1478710 HD000400 2012-11-02    2 G2 0 -15.108  0.0009     9.738   0.036   20181  24.17 4705 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 8 lines were successfully retrieved