# 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 =1248620]
# 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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
1248620 TYC3281-0800-1 2011-09-21    5 G2 1 -23.196            28.565             560   8.38 4719 view_head   get_ccf   view_ccf  
1248620 TYC3281-0800-1 2011-09-21    5 G2 0 -23.216  0.0278    32.910   0.000     555   9.33 4748 view_head   get_ccf   view_ccf  
1248630 TYC3281-0800-1 2011-09-21    5 G2 1 -23.198            28.432             566   8.41 4719 view_head   get_ccf   view_ccf  
1248630 TYC3281-0800-1 2011-09-21    5 G2 0 -23.227  0.0275    33.065   0.000     561   9.41 4748 view_head   get_ccf   view_ccf  
1248640 TYC3281-0800-1 2011-09-21    5 G2 0 -23.168  0.0276    32.859   0.000     562   9.38 4748 view_head   get_ccf   view_ccf  
1248640 TYC3281-0800-1 2011-09-21    5 G2 1 -23.157            28.410             568   8.42 4719 view_head   get_ccf   view_ccf  
1248650 TYC3281-0800-1 2011-09-21    5 G2 1 -23.187            28.877             571   8.30 4719 view_head   get_ccf   view_ccf  
1248650 TYC3281-0800-1 2011-09-21    5 G2 0 -23.194  0.0278    34.166   0.000     565   9.47 4748 view_head   get_ccf   view_ccf  
1248660 TYC3281-0800-1 2011-09-21    5 G2 0 -23.167  0.0280    34.596   0.000     571   9.42 4748 view_head   get_ccf   view_ccf  
1248660 TYC3281-0800-1 2011-09-21    5 G2 1 -23.172            29.157             577   8.26 4719 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 10 lines were successfully retrieved