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

  
V/162
  LAMOST DR11 catalogs (Luo+, 2026)
Post annotation
img(gal)
1.V/162/dr11mlLAMOST LRS Catalog of gM, dM, and sdM Stars (original column names in green) (926048 rows) (released 2026-07-28)
[METAtab] [METAcola]

 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
Standard Original
ShowSortColumn  Constraint Explain   (UCD)
  recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  sp  Display the LAMOST spectrum (meta.ref.url)
  ObsID  (i) [101007/1128116236] Unique Spectra ID (obsid) (meta.id)
  uID (char) (i) Unique source identifier calculated with the "uRA" and "uDE" given in table dr11mel (uid) (meta.id;meta.main)
  gpID  Source identifier in the survey of origin (gp_id) (Note G1)   (meta.id)
  Target (char) Target Designation, JHHMMSS.ss+DDMMSS.s (designation) (meta.id)
  Obs.Date "Y:M:D" (n)(i) Target Observation Date (obsdate) (time.epoch;obs)
  LMJD d [55859/60111] Local Modified Julian Day (lmjd) (time.epoch)
  MJD d [55858/60110] Modified Julian Day (mjd) (time.epoch)
  PlanID (char) Plan Name (planid) (obs.field)
  spID   [1/16] Spectrograph ID (spid) (meta.id;instr)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  FiberID   [1/250] Fiber ID (fiberid) (meta.id)
  RAJ2000 deg (i) Fiber Pointing Right Ascension (J2000) (ra_obs) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) Fiber Pointing Declination (J2000) (dec_obs) (pos.eq.dec;meta.main)
  snru  (n) [0/999] S/N of u filter (snru) (stat.snr)
  snrg  (n) [0/999] S/N of g filter (snrg) (stat.snr)
  snrr  (n) [0/999] S/N of r filter (snrr) (stat.snr)
  snri  (n) [0/999] S/N of i filter (snri) (stat.snr)
  snrz  (n) [0/999] S/N of z filter (snrz) (stat.snr)
  Class (char) [STAR] Spectral Type (class) (src.class)
  subClass (char) Stellar Sub-Class (subclass) (Note 1)   (src.class)
  z  (n) [-9999/4.56] Redshift estimated by the LAMOST 1D pipeline (z) (Note G3)   (src.redshift)
  e_z  (n) [-9999/46883] Redshift uncertainty estimated by the LAMOST 1D pipeline (z_err) (Note G3)   (stat.error;src.redshift)
  PanSTARRS  (n) The objID in the Pan-STARRS (II/349) catalog (ps_ID) (meta.id)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  gmag mag (n) [-999/28.4] Pan-STARRS g band magnitude (mag_ps_g) (Note G2)   (phot.mag;em.opt.B)
  rmag mag (n) [-999/22.92] Pan-STARRS r band magnitude (mag_ps_r) (Note G2)   (phot.mag;em.opt.R)
  imag mag (n) [-999/27.9] Pan-STARRS i band magnitude (mag_ps_i) (Note G2)   (phot.mag;em.opt.I)
  zmag mag (n) [-999/26.3] Pan-STARRS z band magnitude (mag_ps_z) (Note G2)   (phot.mag;em.opt.I)
  ymag mag (n) [-999/24.6] Pan-STARRS y band magnitude (mag_ps_y) (Note G2)   (phot.mag;em.IR.J)
  GaiaDR3  (n) Gaia DR3 (I/355) source identifier (gaia_source_id) (meta.id)
  Gmag mag (n) [4/23] G-band mean magnitude from Gaia DR3 (I/355) catalog (gaia_g_mean_mag) (phot.mag;em.opt)
  FiberType (char) Fiber Type of target (fibertype) (Note 2)   (meta.note)
  offsets   [0/1] Whether there is a fiber offset during observation (0=No, 1=Yes) (offsets) (Note 3)   (meta.code)
  offsetsv arcsec (n) [0/9] If the "offsets" field is true, "offsetsv" gives the offset distance from the target's coordinator in input catalog (table dr11il) (offsets_v) (Note G5)   (pos;arith.diff)
  RAOdeg deg Right Ascension from input catalog (table dr11il) (ra) (pos.eq.ra)
  DEOdeg deg Declination from input catalog (table dr11il) (dec) (pos.eq.dec)
  Teff K (n) Effective temperature obtained by the minimum chi-square estimation (teff) (Note 4)   (phys.temperature.effective;meta.modelled)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Teff K (n) Teff uncertainty estimated with the method LASP used (teff_err) (stat.error;phys.temperature.effective)
  logg [cm/s2] (n) Surface gravity obtained by the minimu chi-square estimation (in dex) (logg) (Note 4)   (phys.gravity;meta.modelled)
  e_logg [cm/s2] (n) logg uncertainty estimated with the method LASP used (in dex) (logg_err) (stat.error)
  Z [-] (n) Metallicity obtained by the minimum chi-square estimation (m_h) (Note 4)   (phys.abund.Z;meta.modelled)
  e_Z [-] (n) Metallicity Uncertainty estimated with the method LASP used (m_h_err) (stat.error;src.redshift)
  EWHa 0.1nm (n) Halpha line equivalent width (ewha) (Note 5)   (spect.line.eqWidth)
  e_EWHa 0.1nm (n) EWHa uncertainty (ewha_err) (Note 5)   (stat.error)
  TiO5  (n) Spectral index of TiO5 (tio5) (Note 5)   (spect.index)
  CaH2  (n) Spectral index of CaH2 (cah2) (Note 5)   (spect.index)
  CaH3  (n) Spectral index of CaH3 (cah3) (Note 5)   (spect.index)
  TiO1  (n) Spectral index of TiO1 (tio1) (Note 5)   (spect.index)
  TiO2  (n) Spectral index of TiO2 (tio2) (Note 5)   (spect.index)
  TiO3  Spectral index of TiO3 (tio3) (Note 5)   (spect.index)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  TiO4  (n) Spectral index of TiO4 (tio4) (Note 5)   (spect.index)
  CaH1  (n) Spectral index of CaH1 (cah1) (Note 5)   (spect.index)
  CaOH  (n) Spectral index of CaOH (caoh) (Note 5)   (spect.index)
  e_TiO5  (n) TiO5 uncertainty (tio5_err) (Note 5)   (stat.error)
  e_CaH2  (n) CaH2 uncertainty (cah2_err) (Note 5)   (stat.error)
  e_CaH3  (n) CaH3 uncertainty (cah3_err) (Note 5)   (stat.error)
  e_TiO1  (n) TiO1 uncertainty (tio1_err) (Note 5)   (stat.error)
  e_TiO2  (n) TiO2 uncertainty (tio2_err) (Note 5)   (stat.error)
  e_TiO3  (n) TiO3 uncertainty (tio3_err) (Note 5)   (stat.error)
  e_TiO4  (n) TiO4 uncertainty (tio4_err) (Note 5)   (stat.error)
  e_CaH1  (n) CAH1 uncertainty (cah1_err) (Note 5)   (stat.error)
  e_CaOH  (n) CaOH uncertainty (caoh_err) (Note 5)   (stat.error)
  zeta  (n) Metallicity sensitive parameter (zeta) (Note 5)   (phys.abund.Z)
  e_zeta  (n) zeta uncertainty (zeta_err) (Note 5)   (stat.error)
  MA  (n) [0/1] Magnetic activity (type) (Note 6)   (meta.code)
  NA 0.1nm (n) Line index of Na Line (na) (Note 5)   (spect.index)

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/VR375244.err (2026-08-06T16:25:50)
-3
-source=V/162/dr11ml
-ref=VIZ6a74b58f5b9cc
elapse time 1

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


Contents of error file (/tmp/VR375244.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=V%2F162%2Fdr11ml
REMOTE_ADDR=172.19.0.1
REMOTE_PORT=58960
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=V%2F162%2Fdr11ml
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=V/162/dr11ml
################################################################

....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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   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'):
[1786033550]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033550]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033550]   Select hstid, flag from METAhst where name='3cc090d0de86.astro.unistra.fr'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033550]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033550]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'V/162/dr11ml' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033550]   select login from METAdba where dbaid=35
----db1_reset(0 'metaviz@TAPVIZIER1')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786033550]    insert into T1 values(5162)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786033550]    insert into T2 values(5162)
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033550]   select k.catid,k.kwdid from METAkwd k,T2 t where k.catid=t.id 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'):
[1786033551]   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'):
[1786033551]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   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'):
[1786033551]   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'):
[1786033551]   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'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   select login from METAdba where login like 'large_tables%'
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 147/0 tuples [tested=147]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   SELECT catid FROM METAcat WHERE name='5162'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=5162 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=5162 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=5162 order by catid,tabid,colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select catid, morid, text From METAmor where catid=5162 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=970 and fltrid=7
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=970 and fltrid=6
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=970 and fltrid=5
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=970 and fltrid=2
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=970 and fltrid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=2
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=3
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=4
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=5
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=6
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=7
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=8
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=9
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=10
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=11
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=3
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=2
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=12
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=13
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=14
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=15
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=5162 and  tabid=4 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=5162 and tabid=4

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   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'):
[1786033551]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   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'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   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=5162 and tabid=4
#...meta_close(1): retrieved 3/1000 tuples [tested=3]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   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'):
[1786033551]   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'):
[1786033551]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=5162 and tabid=4
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   SELECT catid FROM METAcat WHERE name='5162'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=5162 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=5162 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select idori, kwdid, name, explain From METAorigin
----db1_open(metaviz@TAPVIZIER1) gives: 1
----Open server: tapvizier1.cds.unistra.fr, port 5434 (type postgres base vizier)
----db1_exec(1 'metaviz@TAPVIZIER1'):
[1786033551]    Update METAhit set etime=839348751,  Ncalls = Ncalls+1 where catid=5162 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(1 'metaviz@TAPVIZIER1'):
[1786033551]    UPDATE METAstat set nlocal=nlocal+1, tlocal=839348751 Where phase=3 and catid=5162
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name From METAucd where ucdid>=0
....show_table(V/162/dr11ml): show_status = (25, 40, 0, 0, 1)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=184
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=90
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=94
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=186
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=17
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=233
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=170
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=362
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1322
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=97
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1466
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1467
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1468
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1469
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=749
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=930
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=741
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=227
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=5
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1204
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=79
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=187
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=976
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=129
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=919
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=293
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1273
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select ucdid, name, class, explain From METAucd where ucdid=288
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=1288
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786033551]   Select famid, name, explain From METAfam where famid=149
----db1_reset(0 'metaviz@TAPVIZIER1')
----inherit(u=used, h=hidden):
     [u] +source=V/162/dr11ml
     [u] -ref=VIZ6a74b58f5b9cc
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@TAPVIZIER1')
----db1_close(1 'metaviz@TAPVIZIER1')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© UDS/CNRS

Contact