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/AJ/143/39
  Analysis of hot Jupiters in Kepler Q2 (Coughlin+, 2012)
ReadMe+ftp
2012AJ....143...39C
Similar Catalogs
[METAcat] [METAcells] [stats]
Post annotation 		img(gal)
1.J/AJ/143/39/table1(c)Modeled systems and their host star properties (55 rows) (released 2018-01-02)
[METAtab] [METAcola]
2.J/AJ/143/39/table2Modeling results: median values and associated 1{sigma} uncertainties (180 rows) (released 2018-01-02)
[METAtab] [METAcola]
3.J/AJ/143/39/table3Derived system parameters and associated 1{sigma} uncertainties (360 rows) (released 2018-01-02)
[METAtab] [METAcola]

Simple ConstraintList Of Constraints
 
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)
   (ALL)KOI  (i) [1.01/1543.01] Kepler Object of Interest (meta.id;meta.main)
  (1)KIC   [3351888/12019440] Kepler ID number (meta.id.parent)
  (1)Kpmag mag [9.958/15.979] KIC host stars' Kepler magnitude (Note 1)   (phot.mag;em.opt)
  (1)Teff K KIC effective temperature of the star (phys.temperature.effective)
  (1)logg [cm/s2] KIC surface gravity (phys.gravity)
  (1)[Fe/H] [Sun] KIC metallicity (phys.abund.Z)
  (1)M1 Msun Stellar mass from KIC (Note 2)   (phys.mass)
  (1)E_M1 Msun Upper 1{sigma} uncertainty on M1 (stat.error;stat.max)
  (1)e_M1 Msun Lower 1{sigma} uncertainty on M1 (stat.error)
  (1)R1 Rsun Stellar radius from KIC (Note 2)   (phys.size.radius)

ALL cols		    
 (i)indexed column
  (1)E_R1 Rsun Upper 1{sigma} uncertainty on R1 (stat.error;stat.max)
  (1)e_R1 Rsun Lower 1{sigma} uncertainty on R1 (stat.error)
  (1)M2 Msun Stellar mass from isochrones (Note 3)   (phys.mass)
  (1)E_M2 Msun Upper 1{sigma} uncertainty on M2 (stat.error;stat.max)
  (1)e_M2 Msun Lower 1{sigma} uncertainty on M2 (stat.error)
  (1)R2 Rsun Stellar radius from isochrones (Note 3)   (phys.size.radius)
  (1)E_R2 Rsun Upper 1{sigma} uncertainty on R2 (stat.error;stat.max)
  (1)e_R2 Rsun Lower 1{sigma} uncertainty on R2 (stat.error)
  (1)Simbad (char) ask the Simbad data-base about this object (meta.ref)
  (1)_RA deg (i) Positions from KIC catalog (Cat. V/133) (right ascension part) (pos.eq.ra;meta.main)
  (1)_DE deg (i) Positions from KIC catalog (Cat. V/133) (declination part) (pos.eq.dec;meta.main)
  (2+3)Type   [1/4] Model type (Note 1)   (meta.id;stat.fit)
  (2)J  Planet-to-star surface brightness ratio (phot.mag.sb;arith.ratio)

ALL cols		    
 (i)indexed column
  (2)E_J  Upper 1{sigma} uncertainty in J (stat.error;stat.max)
  (2)e_J  Lower 1{sigma} uncertainty in J (stat.error)
  (2)rsum  Sum of the fractional radius (phys.size.radius;arith.ratio)
  (2)E_rsum  Upper 1{sigma} uncertainty in rsum (stat.error;stat.max)
  (2)e_rsum  Lower 1{sigma} uncertainty in rsum (stat.error)
  (2)k  Planet-to-star radii ratio (phys.size;arith.ratio)
  (2)E_k  Upper 1{sigma} uncertainty in k (stat.error;stat.max)
  (2)e_k  Lower 1{sigma} uncertainty in k (stat.error)
  (2)i deg Orbital inclination (src.orbital.inclination)
  (2)E_i deg Upper 1{sigma} uncertainty in i (stat.error;stat.max)
  (2)e_i deg Lower 1{sigma} uncertainty in i (stat.error)
  (2)ecosw  Eccentricity times cosine of longitude of periastron e.cos{omega} (src.orbital.eccentricity)
  (2)E_ecosw  Upper 1{sigma} uncertainty in ecosw (stat.error;stat.max)

ALL cols		    
 (i)indexed column
  (2)e_ecosw  Lower 1{sigma} uncertainty in ecosw (stat.error)
  (2)esinw  Eccentricity times sine of longitude of periastron e.sin{omega} (src.orbital.eccentricity)
  (2)E_esinw  Upper 1{sigma} uncertainty in esinw (stat.error;stat.max)
  (2)e_esinw  Lower 1{sigma} uncertainty in esinw (stat.error)
  (2)P d Orbital period (time.period)
  (2)E_P d Upper 1{sigma} uncertainty in P (stat.error;stat.max)
  (2)e_P d Lower 1{sigma} uncertainty in P (stat.error)
  (2)T0 d Time of primary transit minimum; BJD-2450000 (time.epoch)
  (2)E_T0 d Upper 1{sigma} uncertainty in T0 (stat.error;stat.max)
  (2)e_T0 d Lower 1{sigma} uncertainty in T0 (stat.error)
  (2)ALp  Amplitude of planet's luminosity (phys.luminosity)
  (2)E_ALp  Upper 1{sigma} uncertainty in ALp (stat.error;stat.max)
  (2)e_ALp  Lower 1{sigma} uncertainty in ALp (stat.error)

ALL cols		    
 (i)indexed column
  (2)chi2  Reduced {chi}2 of model (stat.fit.chi2)
  (3)Lr 10-6 Planet-to-star luminosity ratio in parts per million (phys.luminosity;arith.ratio)
  (3)E_Lr 10-6 Upper 1{sigma} uncertainty in Lr (stat.error;stat.max)
  (3)e_Lr 10-6 Uncertainty in Lr (stat.error)
  (3)sig2  Detection significance of secondary eclipse (Note 3)   (stat.likelihood;obs)
  (3)T0 K Equilibrium temperature (phys.temperature)
  (3)E_T0 K Upper 1{sigma} uncertainty in T0 (stat.error;stat.max)
  (3)e_T0 K Lower 1{sigma} uncertainty in T0 (stat.error)
  (3)Teps0 K Maximum effective temperature, assuming no albedo or heat recirculation (T({epsilon}=0)) (phys.temperature.effective;stat.max)
  (3)E_Teps0 K Upper 1{sigma} uncertainty in Teps=0 (stat.error;stat.max)
  (3)e_Teps0 K Lower 1{sigma} uncertainty in Teps=0 (stat.error)
  (3)Tb K Brightness temperature, assuming zero albedo (phys.temperature)
  (3)E_Tb K Upper 1{sigma} uncertainty in Tb (stat.error;stat.max)

ALL cols		    
 (i)indexed column
  (3)e_Tb K Lower 1{sigma} uncertainty in Tb (stat.error)
  (3)Tb/T0  Brightness to equilibrium temperature ratio (phys.temperature)
  (3)E_Tb/T0  Upper 1{sigma} uncertainty in Tb/T0 (stat.error;stat.max)
  (3)e_Tb/T0  Lower 1{sigma} uncertainty in Tb/T0 (stat.error)
  (3)Rp Rjup Planetary radius; in Jupiter radii (phys.size.radius)
  (3)E_Rp Rjup Upper 1{sigma} uncertainty in Rp (stat.error;stat.max)
  (3)e_Rp Rjup Lower 1{sigma} uncertainty in Rp (stat.error)
  (3)a AU System semi-major axis (phys.size.smajAxis)
  (3)E_a AU Upper 1{sigma} uncertainty in a (stat.error;stat.max)
  (3)e_a AU Lower 1{sigma} uncertainty in a (stat.error)
  (3)Amax  Maximum possible geometric albedo (phys.albedo)
  (3)E_Amax  Upper 1{sigma} uncertainty in Amax (stat.error;stat.max)
  (3)e_Amax  Lower 1{sigma} uncertainty in Amax (stat.error)

ALL cols		    
 (i)indexed column
Adapt form
 Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  
.errorfile=/tmp/VR1078742.err (2026-08-06T19:19:11)
-3
-source=J/AJ/143/39
-ref=VIZ6a74de2f1075d6
elapse time 0

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

Contents of error file (/tmp/VR1078742.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.111, 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%2FAJ%2F143%2F39
REMOTE_ADDR=172.19.0.1
REMOTE_PORT=52888
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FAJ%2F143%2F39
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/AJ/143/39
################################################################

....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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select hstid, flag from METAhst where name='3cc090d0de86.astro.unistra.fr'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/AJ/143/39' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   SELECT catid FROM METAcat WHERE name='J/AJ/143/39'
----db1_reset(0 'metaviz@TAPVIZIER1')
....existing catid 51430039 from METAcat
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51430039 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51430039 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   select login from METAdba where dbaid=43
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   select k.catid,k.kwdid from METAkwd k where catid=51430039 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'):
[1786043951]   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'):
[1786043951]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   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'):
[1786043951]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   select login from METAdba where login like 'large_tables%'
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 147/0 tuples [tested=147]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51430039 order by catid,tabid,colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select catid, morid, text From METAmor where catid=51430039 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51430039 and tabid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51430039 and tabid=2
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51430039 and tabid=3

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51430039 and  tabid=1 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51430039 and tabid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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'):
[1786043951]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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'):
[1786043951]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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=51430039 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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=51430039 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select catid, morid, text From METAmor where catid=51430039 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51430039 and  tabid=2 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51430039 and tabid=2
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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=51430039 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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=51430039 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51430039 and  tabid=3 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51430039 and tabid=3
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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=51430039 and tabid=3
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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=51430039 and tabid=3
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   SELECT catid FROM METAcat WHERE name='51430039'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51430039 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51430039 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   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'):
[1786043951]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@TAPVIZIER1')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=51430039): 1713 => 0.47
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select idori, kwdid, name, explain From METAorigin
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name From METAucd where ucdid>=0
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786043951]    Update METAhit set etime=839359151,  Ncalls = Ncalls+1 where catid=51430039 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786043951]    UPDATE METAstat set nlocal=nlocal+1, tlocal=839359151 Where phase=3 and catid=51430039
------------(1 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786043951]    Update METAhit set etime=839359151,  N2list = N2list+2 where catid=51430039 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786043951]    Update METAhit set etime=839359151,  N2list = N2list+2 where catid=51430039 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786043951]    UPDATE METAstat set nlocal=nlocal+1, tlocal=839359151 Where phase=3 and catid=51430039
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name From METAfam where famid>=0
....show_tuple: show_status = (35, 45, 0, 0, 1)
====Tuple 'J/AJ/143/39' from 3/0 tables:
    #51430039.1 'J/AJ/143/39/table1' 22/32 columns
    #51430039.2 'J/AJ/143/39/table2' 31/40 columns
    #51430039.3 'J/AJ/143/39/table3' 28/40 columns
[00000007] col#000 v000 OA002 J/AJ/143/39/table1*recno           
[80000007] col#001 v001 O2403 J/AJ/143/39/table1*KOI             
[00000001] col#002 v000 O2003 J/AJ/143/39/table1*KIC             
[00000001] col#003 v001 O0043 J/AJ/143/39/table1*Kpmag           
[00000001] col#004 v000 O0043 J/AJ/143/39/table1*Teff            
[00000001] col#005 v001 O0043 J/AJ/143/39/table1*logg            
[00000001] col#006 v001 O0003 J/AJ/143/39/table1*[Fe/H]          
[00000001] col#007 v001 O0003 J/AJ/143/39/table1*M1              
[00000001] col#008 v001 O0000 J/AJ/143/39/table1*E_M1            
[00000001] col#009 v001 O0000 J/AJ/143/39/table1*e_M1            
[00000001] col#010 v001 O0003 J/AJ/143/39/table1*R1              
[00000001] col#011 v001 O0000 J/AJ/143/39/table1*E_R1            
[00000001] col#012 v001 O0000 J/AJ/143/39/table1*e_R1            
[00000001] col#013 v001 O0003 J/AJ/143/39/table1*M2              
[00000001] col#014 v001 O0000 J/AJ/143/39/table1*E_M2            
[00000001] col#015 v001 O0000 J/AJ/143/39/table1*e_M2            
[00000001] col#016 v001 O0003 J/AJ/143/39/table1*R2              
[00000001] col#017 v001 O0000 J/AJ/143/39/table1*E_R2            
[00000001] col#018 v001 O0000 J/AJ/143/39/table1*e_R2            
[00000001] col#019 v004 OA051 J/AJ/143/39/table1*Simbad          
[00000001] col#020 v311 O8023 J/AJ/143/39/table1*_RA             
[00000001] col#021 v011 O8023 J/AJ/143/39/table1*_DE             
[00000007] col#000 v000 OA002 J/AJ/143/39/table2*recno           
[00000006] col#001 v000 O0043 J/AJ/143/39/table2*Type            
[80000007] col#002 v001 O0803 J/AJ/143/39/table2*KOI             
[00000002] col#003 v001 O0003 J/AJ/143/39/table2*J               
[00000002] col#004 v001 O0000 J/AJ/143/39/table2*E_J             
[00000002] col#005 v001 O0000 J/AJ/143/39/table2*e_J             
[00000002] col#006 v001 O0003 J/AJ/143/39/table2*rsum            
[00000002] col#007 v001 O0000 J/AJ/143/39/table2*E_rsum          
[00000002] col#008 v001 O0000 J/AJ/143/39/table2*e_rsum          
[00000002] col#009 v001 O0003 J/AJ/143/39/table2*k               
[00000002] col#010 v001 O0000 J/AJ/143/39/table2*E_k             
[00000002] col#011 v001 O0000 J/AJ/143/39/table2*e_k             
[00000002] col#012 v001 O0043 J/AJ/143/39/table2*i               
[00000002] col#013 v001 O0000 J/AJ/143/39/table2*E_i             
[00000002] col#014 v001 O0000 J/AJ/143/39/table2*e_i             
[00000002] col#015 v001 O0003 J/AJ/143/39/table2*ecosw           
[00000002] col#016 v001 O0000 J/AJ/143/39/table2*E_ecosw         
[00000002] col#017 v001 O0000 J/AJ/143/39/table2*e_ecosw         
[00000002] col#018 v001 O0003 J/AJ/143/39/table2*esinw           
[00000002] col#019 v001 O0000 J/AJ/143/39/table2*E_esinw         
[00000002] col#020 v001 O0000 J/AJ/143/39/table2*e_esinw         
[00000002] col#021 v001 O0003 J/AJ/143/39/table2*P               
[00000002] col#022 v001 O0000 J/AJ/143/39/table2*E_P             
[00000002] col#023 v001 O0000 J/AJ/143/39/table2*e_P             
[00000002] col#024 v001 O0003 J/AJ/143/39/table2*T0              
[00000002] col#025 v001 O0000 J/AJ/143/39/table2*E_T0            
[00000002] col#026 v001 O0000 J/AJ/143/39/table2*e_T0            
[00000002] col#027 v001 O0003 J/AJ/143/39/table2*ALp             
[00000002] col#028 v001 O0000 J/AJ/143/39/table2*E_ALp           
[00000002] col#029 v001 O0000 J/AJ/143/39/table2*e_ALp           
[00000002] col#030 v001 O0043 J/AJ/143/39/table2*chi2            
[00000007] col#000 v000 OA002 J/AJ/143/39/table3*recno           
[00000006] col#001 v000 O0043 J/AJ/143/39/table3*Type            
[80000007] col#002 v001 O0803 J/AJ/143/39/table3*KOI             
[00000004] col#003 v001 O0003 J/AJ/143/39/table3*Lr              
[00000004] col#004 v001 O0000 J/AJ/143/39/table3*E_Lr            
[00000004] col#005 v001 O0000 J/AJ/143/39/table3*e_Lr            
[00000004] col#006 v001 O0043 J/AJ/143/39/table3*sig2            
[00000004] col#007 v000 O0043 J/AJ/143/39/table3*T0              
[00000004] col#008 v000 O0040 J/AJ/143/39/table3*E_T0            
[00000004] col#009 v000 O0040 J/AJ/143/39/table3*e_T0            
[00000004] col#010 v000 O0043 J/AJ/143/39/table3*Teps0           
[00000004] col#011 v000 O0040 J/AJ/143/39/table3*E_Teps0         
[00000004] col#012 v000 O0040 J/AJ/143/39/table3*e_Teps0         
[00000004] col#013 v000 O0003 J/AJ/143/39/table3*Tb              
[00000004] col#014 v000 O0040 J/AJ/143/39/table3*E_Tb            
[00000004] col#015 v000 O0040 J/AJ/143/39/table3*e_Tb            
[00000004] col#016 v001 O0003 J/AJ/143/39/table3*Tb/T0           
[00000004] col#017 v001 O0000 J/AJ/143/39/table3*E_Tb/T0         
[00000004] col#018 v001 O0000 J/AJ/143/39/table3*e_Tb/T0         
[00000004] col#019 v001 O0003 J/AJ/143/39/table3*Rp              
[00000004] col#020 v001 O0000 J/AJ/143/39/table3*E_Rp            
[00000004] col#021 v001 O0000 J/AJ/143/39/table3*e_Rp            
[00000004] col#022 v001 O0003 J/AJ/143/39/table3*a               
[00000004] col#023 v001 O0000 J/AJ/143/39/table3*E_a             
[00000004] col#024 v001 O0000 J/AJ/143/39/table3*e_a             
[00000004] col#025 v001 O0003 J/AJ/143/39/table3*Amax            
[00000004] col#026 v001 O0040 J/AJ/143/39/table3*E_Amax          
[00000004] col#027 v001 O0040 J/AJ/143/39/table3*e_Amax          

----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=77
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=185
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=930
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=741
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=187
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=976
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=129
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=920
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=196
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1025
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=221
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1052
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=350
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=301
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=117
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=9
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=804
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1053
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=219
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1054
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=316
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1188
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=315
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=356
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=377
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1374
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1367
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=191
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=995
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=351
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=151
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1012
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=357
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=90
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=326
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=224
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=1075
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=222
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=374
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select ucdid, name, class, explain From METAucd where ucdid=131
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786043951]   Select famid, name, explain From METAfam where famid=921
----db1_reset(0 'metaviz@TAPVIZIER1')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/AJ/143/39
     [u] -ref=VIZ6a74de2f1075d6
====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