Simple TargetList Of TargetsFast Xmatch with large catalogs or Simbad
Target Name (resolved by Sesame) or Position:
Target dimension:
NB: The epoch used for the query is the original epoch of the table(s)Radius Box size

  
J/ApJS/237/17
  Temporal frequency shifts in 87 Kepler stars (Santos+, 2018)
Post annotation
img(gal)
1.J/ApJS/237/17/table1(c)Stellar parameters of the target sample composed of 87 Kepler solar-type stars (87 rows) (released 2019-01-07)
[METAtab] [METAcola]
2.J/ApJS/237/17/table2Peak-bagging for the Kepler stars in the sample (1854 rows) (released 2019-01-07)
[METAtab] [METAcola]

 
Query by Constraints constraints help applied on Columns (Output Order: + - )
ShowSortJoin tables
more join
Column  Constraint Explain   (UCD)
  (ALL)recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  (1)Nm  (n)Number of peak-bagging measurements for this star (link to table 2) (meta.number)
   (ALL)KIC  (i) [1435467/12317678] Kepler Input Cat. identifier (meta.id;meta.main)
  (1)KIC_data (char) Link to all parameters of KIC catalogue (time.epoch)
  (1)KOI  (n) [2/3158] KOI star number (meta.id)
  (1)Kpmag mag [5.8/12.3] Kepler magnitude (phot.mag;em.opt)
  (1)Q (char) Quarters (Note 1)   (time.interval)
  (1)numax uHz [884.7/4660] Frequency of the maximum power (Note 2)   (em.freq;src.var)
  (1)e_numax uHz [2.7/280] Negative uncertainty on numax (stat.error)
  (1)E_numax uHz [2.8/280] Positive uncertainty on numax (stat.error;stat.max)
  (1)Delnu uHz [48.4/179.7] Large frequency separation (Note 2)   (em.freq;src.var)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)e_Delnu uHz [0.01/2.5] Negative uncertainty on Delnu (stat.error)
  (1)E_Delnu uHz [0.01/2.5] Positive uncertainty on Delnu (stat.error;stat.max)
  (1)Teff K [5046/6642] Effective temperature (phys.temperature.effective)
  (1)e_Teff K [50/180] Negative uncertainty on Teff (stat.error;phys.temperature.effective)
  (1)E_Teff K [1/8] Positive uncertainty on Teff (stat.error;stat.max)
  (1)[Fe/H] [Sun] [-1/0.4] Metallicity (phys.abund.Z)
  (1)e_[Fe/H] [Sun] [0.02/0.2] [Fe/H] uncertainty (stat.error;phys.abund.Fe)
  (1)r_[Fe/H]   [1/8] Reference for [Fe/H] and Teff (Note 3)   (meta.ref)
  (1)logg [cm/s2] [3.9/4.6] Log of gravity surface from Silva Aguirre+ (2015, J/MNRAS/452/2127 and 2017, J/ApJ/835/173) (phys.gravity)
  (1)e_logg [cm/s2] [0.002/0.02] Negative uncertainty on logg (stat.error)
  (1)E_logg [cm/s2] [0.002/0.02] Positive uncertainty on logg (stat.error;stat.max)
  (1)Prot d (n) [0.9/35.4] Rotational period (time.period)
  (1)e_Prot d (n) [0.001/6] Prot uncertainty (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)r_Prot  (n) [9/16] Reference for Prot (Note 3)   (meta.ref;pos.frame)
  (1)LEGACY (char) Display the LEGACY data (Lund+, 2017, J/ApJ/835/172 and Silva Aguirre+, 2017, J/ApJ/835/173) and BASTA data (Silva Aguirre+, 2015, J/MNRAS/452/2127) for this star (meta.ref.url)
  (1)Simbad (char) ask the Simbad data-base about this object (meta.ref.url)
  (1)_RA deg (i) Right Ascension (J2000) from SIMBAD (not part of the original data) (pos.eq.ra;meta.main)
  (1)_DE deg (i) Declination (J2000) from SIMBAD (not part of the original data) (pos.eq.dec;meta.main)
  (2)Order1   [15/24] First central order (meta.number)
  (2)Order2   [19/28] Fifth central order (meta.number)
  (2)f_shiftsCC (char) [*] Flag on shiftsCC (Note 2)   (meta.code)
  (2)Time d [45/1450] Time of the sub-series midpoint (time.epoch)
  (2)DC  (n) [0.01/1] Duty cycle of the sub-series (meta.number;time.period)
  (2)taug s (n) [133/667] Characteristic granulation timescale (time.scale)
  (2)e_taug s (n) [0/812] Uncertainty in taug (stat.error)
  (2)shift0 uHz (n) [-2.2/2.1] Mean frequency shifts for l=0 (Note 3)   (em.freq;stat.mean)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (2)e_shift0 uHz (n) [0.05/1.1] Uncertainty in shift0 (stat.error)
  (2)shift1 uHz (n) [-1.3/1.6] Mean frequency shifts for l=1 (Note 3)   (em.freq;stat.mean)
  (2)e_shift1 uHz (n) [-1.3/1.1] Uncertainty in shift1 (stat.error)
  (2)shift2 uHz (n) [-1.9/1.8] Mean frequency shifts for l=2 (Note 3)   (em.freq;stat.mean)
  (2)e_shift2 uHz (n) [0.05/2] Uncertainty in shift2 (stat.error)
  (2)<shift> uHz (n) [-1.4/1.6] Mean frequency shifts, combining l=0 and l=1 (Note 3)   (em.freq;stat.mean)
  (2)e_<shift> uHz (n) [0.04/0.7] Uncertainty in <shift> (stat.error;phys.atmol.lineShift)
  (2)logS  (n) [-1/3.7] Mean logarithmic mode heights (Note 3)   (src.var.amplitude)
  (2)e_logS  (n) [0.08/1.2] Uncertainty in logS (stat.error)
  (2)shiftsCC uHz (n) [-0.9/1.6] Frequency shifts obtained with CC method (Note 4)   (em.freq)
  (2)e_shiftsCC uHz (n) [0.06/16.6] Uncertainty in shiftsCC (stat.error)
  (2)JD d (n) Julian date of the observation (updated column) (time.epoch)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
Adapt form
Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  
.errorfile=/tmp/VR1466329.err (2026-08-14T09:54:15)
-3
-source=J/ApJS/237/17
-ref=VIZ6a7ee5c7165fd9
elapse time 0

Options: wopt=0, optS=0, onote=0, opt1=8, opos=0


Contents of error file (/tmp/VR1466329.err):
....vizier, Version 7.5.8
CDSportal=http://cdsportal.cds.unistra.fr/StoreVizierData.html
COCAT=130.79.128.31
COCATPORT=1801
CONTEXT_DOCUMENT_ROOT=/srv/httpd/local/cgi/
CONTEXT_PREFIX=/local/viz-bin/
Content=text/html
DOCKER=yes
DOCUMENT_ROOT=/srv/httpd/Pages/
GATEWAY_INTERFACE=CGI/1.1
GLUDIR=/srv/glu
GLUHOME=/srv/glu
GROUP=root
HOME=/srv/httpd
HOST=3cc090d0de86
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=localhost:8081
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR=216.73.217.5, 127.0.0.1
HTTP_X_FORWARDED_HOST=tapvizier1.u-strasbg.fr
HTTP_X_FORWARDED_SERVER=tapvizier1.cds.unistra.fr
LC_ALL=C
LD_LIBRARY_PATH=/srv/httpd/../lib:/srv/lib:/usr/local/lib:/usr/lib
LOGNAME=root
MACHTYPE=x86_64
MAX_UPLOADS=100000
METADB=metaviz@TAPVIZIER1 asu asu4VizieR
MOCCMD=mocset query /srv/httpd/mocs/mocset10.bin cone -p 5 
NEWS=/VizieR/+news.htx
OSTYPE=linux
PATH=/srv/httpd/bin:/usr/local/bin:/usr/bin:/bin
PATH_INFO=/
PWD=/srv/httpd/cgi
QUERY_STRING=-source=J%2FApJS%2F237%2F17
REMOTE_ADDR=172.19.0.1
REMOTE_PORT=49360
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FApJS%2F237%2F17
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SERVER_ADDR=172.19.0.3
SERVER_ADMIN=gilles.landais@astro.u-strasbg.fr
SERVER_NAME=localhost
SERVER_PORT=8081
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache/2.4.66 (Unix)
SESAME_SERVER=glu
SHLVL=1
USER=root
VENDOR=unknown
VIZCLONE_STATISTICS=no
Vaccess=*
Vprog=/srv/httpd/bin/vizier
Vprog_ls=-rwxr-xr-x 1 root root 974128 Aug  5 14:41 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/ApJS/237/17
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 3
....db1_interfaces(/srv/httpd/interfaces)
----db1_open(metaviz@TAPVIZIER1) gives: 0
----Open server: tapvizier1.cds.unistra.fr, port 5434 (type postgres base vizier)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdba'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAtab'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAcol'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAcat'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAmor'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdic'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdig'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAfam'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAucd'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAauth'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select hstid, flag from METAhst where name='3cc090d0de86.astro.unistra.fr'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/ApJS/237/17' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   SELECT catid FROM METAcat WHERE name='J/ApJS/237/17'
----db1_reset(0 'metaviz@TAPVIZIER1')
....existing catid 22370017 from METAcat
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=22370017 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22370017 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   select login from METAdba where dbaid=45
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   select k.catid,k.kwdid from METAkwd k where catid=22370017 and ((-1*kwdid)<(select min(kwdno_min*1) from METAkwcat where name in ('Astronomy')) or  (-1*kwdid)>(select max(kwdno_max*1) from METAkwcat where name in ('Astronomy'))) order by catid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAkwdef' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and  tabid=11 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAfilter'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAsed'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   select login from METAdba where login like 'large_tables%'
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 147/0 tuples [tested=147]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=22370017 order by catid,tabid,colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, morid, text From METAmor where catid=22370017 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=22370017 and tabid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, type, fmt, explain, more From METAdic where name='KIC' Order by type
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=22370017 and tabid=2

====Contents of more_defs:
(nil)
====argColors='(nil)'

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=22370017 and  tabid=1 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=22370017 and tabid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtime' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and  tabid=52 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, flags From METAtime where catid=22370017 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, flags From METAtime where catid=22370017 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, morid, text From METAmor where catid=22370017 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=22370017 and  tabid=2 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=22370017 and tabid=2
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, flags From METAtime where catid=22370017 and tabid=2
#...meta_close(1): retrieved 1/1000 tuples [tested=1]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtimeRel' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and  tabid=49 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=22370017 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   SELECT catid FROM METAcat WHERE name='22370017'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=22370017 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22370017 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METApop' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_open(metaviz@TAPVIZIER1) gives: 1
----Open server: tapvizier1.cds.unistra.fr, port 5434 (type postgres base vizier)
----db1_query(1 'metaviz@TAPVIZIER1'):
[1786701255]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@TAPVIZIER1')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=22370017): 696 => 0.42
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select idori, kwdid, name, explain From METAorigin
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786701255]    Update METAhit set etime=840016455,  Ncalls = Ncalls+1 where catid=22370017 and hstid=-1 and btime=838906200
------------(0 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786701255]    Insert into METAhit (catid, hstid, btime, etime, Ncalls, N2list) VALUES (22370017,-1,838906200,840016455, 1,0)
------------(1 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786701255]    UPDATE METAstat set nlocal=nlocal+1, tlocal=840016455 Where phase=3 and catid=22370017
------------(1 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786701255]    Update METAhit set etime=840016455,  N2list = N2list+2 where catid=22370017 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786701255]    Update METAhit set etime=840016455,  N2list = N2list+2 where catid=22370017 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786701255]    UPDATE METAstat set nlocal=nlocal+1, tlocal=840016455 Where phase=3 and catid=22370017
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name From METAucd where ucdid>=0
....show_tuple: show_status = (35, 13, 0, 0, 3)
====Tuple 'J/ApJS/237/17' from 2/0 tables:
    #22370017.1 'J/ApJS/237/17/table1' 29/40 columns
    #22370017.2 'J/ApJS/237/17/table2' 22/32 columns
[00000003] col#000 v000 OA002 J/ApJS/237/17/table1*recno           
[00000001] col#001 v000 O80C3 J/ApJS/237/17/table1*Nm              
[80000003] col#002 v000 O2403 J/ApJS/237/17/table1*KIC             
[00000001] col#002 v004 O0011 J/ApJS/237/17/table1*KIC_data        
[00000001] col#003 v000 O00C0 J/ApJS/237/17/table1*KOI             
[00000001] col#004 v001 O0043 J/ApJS/237/17/table1*Kpmag           
[00000001] col#005 v004 O4003 J/ApJS/237/17/table1*Q               
[00000001] col#006 v001 O0003 J/ApJS/237/17/table1*numax           
[00000001] col#007 v001 O0040 J/ApJS/237/17/table1*e_numax         
[00000001] col#008 v001 O0040 J/ApJS/237/17/table1*E_numax         
[00000001] col#009 v001 O0003 J/ApJS/237/17/table1*Delnu           
[00000001] col#010 v001 O0040 J/ApJS/237/17/table1*e_Delnu         
[00000001] col#011 v001 O0040 J/ApJS/237/17/table1*E_Delnu         
[00000001] col#012 v000 O0043 J/ApJS/237/17/table1*Teff            
[00000001] col#013 v000 O0040 J/ApJS/237/17/table1*e_Teff          
[00000001] col#014 v000 O0040 J/ApJS/237/17/table1*E_Teff          
[00000001] col#015 v001 O0043 J/ApJS/237/17/table1*[Fe/H]          
[00000001] col#016 v001 O0040 J/ApJS/237/17/table1*e_[Fe/H]        
[00000001] col#017 v000 O0043 J/ApJS/237/17/table1*r_[Fe/H]        
[00000001] col#018 v001 O0043 J/ApJS/237/17/table1*logg            
[00000001] col#019 v001 O0040 J/ApJS/237/17/table1*e_logg          
[00000001] col#020 v001 O0040 J/ApJS/237/17/table1*E_logg          
[00000001] col#021 v001 O0083 J/ApJS/237/17/table1*Prot            
[00000001] col#022 v001 O00C0 J/ApJS/237/17/table1*e_Prot          
[00000001] col#023 v000 O00C3 J/ApJS/237/17/table1*r_Prot          
[00000001] col#024 v004 OA051 J/ApJS/237/17/table1*LEGACY          
[00000001] col#025 v004 OA051 J/ApJS/237/17/table1*Simbad          
[00000001] col#026 v311 O8023 J/ApJS/237/17/table1*_RA             
[00000001] col#027 v011 O8023 J/ApJS/237/17/table1*_DE             
[00000003] col#000 v000 OA002 J/ApJS/237/17/table2*recno           
[80000003] col#001 v000 O0803 J/ApJS/237/17/table2*KIC             
[00000002] col#002 v000 O0043 J/ApJS/237/17/table2*Order1          
[00000002] col#003 v000 O0043 J/ApJS/237/17/table2*Order2          
[00000002] col#004 v004 O4003 J/ApJS/237/17/table2*f_shiftsCC      
[00000002] col#005 v000 O0043 J/ApJS/237/17/table2*Time            
[00000002] col#006 v001 O00C3 J/ApJS/237/17/table2*DC              
[00000002] col#007 v001 O00C3 J/ApJS/237/17/table2*taug            
[00000002] col#008 v001 O00C3 J/ApJS/237/17/table2*e_taug          
[00000002] col#009 v001 O00C3 J/ApJS/237/17/table2*shift0          
[00000002] col#010 v001 O00C3 J/ApJS/237/17/table2*e_shift0        
[00000002] col#011 v001 O00C3 J/ApJS/237/17/table2*shift1          
[00000002] col#012 v001 O00C3 J/ApJS/237/17/table2*e_shift1        
[00000002] col#013 v001 O00C3 J/ApJS/237/17/table2*shift2          
[00000002] col#014 v001 O00C3 J/ApJS/237/17/table2*e_shift2        
[00000002] col#015 v001 O00C3 J/ApJS/237/17/table2*<shift>         
[00000002] col#016 v001 O00C3 J/ApJS/237/17/table2*e_<shift>       
[00000002] col#017 v001 O00C3 J/ApJS/237/17/table2*logS            
[00000002] col#018 v001 O00C3 J/ApJS/237/17/table2*e_logS          
[00000002] col#019 v001 O00C3 J/ApJS/237/17/table2*shiftsCC        
[00000002] col#020 v001 O00C3 J/ApJS/237/17/table2*e_shiftsCC      
[00000002] col#021 v001 O0083 J/ApJS/237/17/table2*JD              

----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=930
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=736
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=375
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1371
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=12
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=324
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1405
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1066
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=129
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=920
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=126
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=187
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=976
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=377
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1374
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=251
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1373
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1362
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=381
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1379
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=359
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=145
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select ucdid, name, class, explain From METAucd where ucdid=325
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1385
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786701255]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@TAPVIZIER1')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/ApJS/237/17
     [u] -ref=VIZ6a7ee5c7165fd9
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@TAPVIZIER1')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© UDS/CNRS

Contact