# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiescc
# Description of the table:        Cross-correlation functions (series truncated to the first observation)
# Object:                          HD172718
# 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                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
1389720 HD172718 2012-06-29    1 G2 0 -42.457  0.0045     9.584   0.005     668  26.69 4724 view_head   get_ccf   view_ccf  
1442940 HD172718 2012-08-25    1 G2 0 -42.442  0.0055     9.562   0.020     483  26.80 4684 view_head   get_ccf   view_ccf  
1443870 HD172718 2012-08-27    1 G2 0 -42.449  0.0042     9.552   0.050     785  26.98 4683 view_head   get_ccf   view_ccf  
1447090 HD172718 2012-09-01    1 G2 0 -42.461  0.0043     9.522   0.014     772  26.87 4684 view_head   get_ccf   view_ccf  
1447590 HD172718 2012-09-03    1 G2 0 -42.442  0.0043     9.543   0.044     765  27.04 4683 view_head   get_ccf   view_ccf  
1449170 HD172718 2012-09-06    1 G2 0 -42.444  0.0042     9.557   0.033     746  26.83 4681 view_head   get_ccf   view_ccf  
1450510 HD172718 2012-09-08    1 G2 0 -42.475  0.0042     9.546   0.062     727  26.76 4681 view_head   get_ccf   view_ccf  
1453510 HD172718 2012-09-13    1 G2 0 -42.446  0.0043     9.527   0.027     746  27.08 4680 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 8 lines were successfully retrieved