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/PAZh/41/896
  Short- and long-term pm of close dwarfs (Khovritchev+, 2015)
Post annotation
img(gal)
1.J/PAZh/41/896/lpmsm15bDelta-mu-binary candidates with epoch difference more than 5 years (121 rows) (released 2016-01-21)
[METAtab] [METAcola]

 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
ShowSortColumn  Constraint Explain   (UCD)
  recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  LSPM (char) LSPM-north (Cat. I/298) catalogue ID (meta.id;meta.main)
  RAJ2000 "h:m:s" (i) Right ascension (J2000) (Note 1)   (pos.eq.ra;meta.main)
  e_RAJ2000 mas Standard error in RA (stat.error;pos.eq.ra)
  DEJ2000 "d:m:s" (i) Declination (Note J2000)   (pos.eq.dec;meta.main)
  e_DEJ2000 mas Standard error in Dec (stat.error;pos.eq.dec)
  pmRA mas/yr Proper motion in Right ascension (Note 2)   (pos.pm;pos.eq.ra)
  e_pmRA mas/yr Standard error of proper motion in RA (stat.error;pos.pm;pos.eq.ra)
  pmDE mas/yr Proper motion in Declination (Note 2)   (pos.pm;pos.eq.dec)
  e_pmDE mas/yr Standard error of proper motion in Dec (stat.error;pos.pm;pos.eq.dec)
  Epoch yr Average epoch of RA, DE (time.epoch;stat.mean)

ALL cols
    
 (i)indexed column
  ltpmRA mas/yr (n) Long-term proper motion in RA (Note 3)   (pos.pm;pos.eq.ra)
  e_ltpmRA mas/yr (n) Standard error of long-term mu in RA (stat.error)
  ltpmDE mas/yr (n) Long-term proper motion in DE (Note 3)   (pos.pm;pos.eq.dec)
  e_ltpmDE mas/yr (n) Standard error of long-term mu in DE (stat.error)
  stpmRA mas/yr (n) Short-term proper motion in RA (Note 4)   (pos.pm;pos.eq.ra)
  e_stpmRA mas/yr (n) Standard error of short-term mu in RA (stat.error)
  stpmDE mas/yr (n) Short-term proper motion in DE (Note 4)   (pos.pm;pos.eq.dec)
  e_stpmDE mas/yr (n) Standard error of short-term mu in DE (stat.error)
  stepoch yr (n) Average epoch short-term proper motion (pos.pm;time.epoch;stat.mean)
  maxEpDiff yr (n) Maximum short-term epoch difference (time.epoch;arith.diff;stat.max)
  F  (n) F-criterion value (stat.fit.param)
  limF  (n) 0.95 limit for F-criterion (Note 5)   (stat.fit.param)
  N  (n) [3/11] Number of epochs for proper motion (meta.number)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  dmuFl  (n) [0/1] Delta-mu-candidate flag (Note 6)   (meta.code)
  WDSfl   [0/1] WDS-flag (WDSfl≡1 if star is in WDS) (meta.code)
  DpmRA mas/yr Difference 'mu - LSPM mu' in RA (pos.pm;pos.eq.ra;arith.diff)
  DpmDE mas/yr Difference 'mu - LSPM mu' in DE (pos.pm;pos.eq.dec;arith.diff)
  Vmag mag (n) LSPM estimated V-magnitude (phot.mag;em.opt)
  V-J mag (n) LSPM V-J color index (phot.color;em.opt.V;em.IR.J)
  plxph mas Photometric parallax from LSPM V-J (pos.parallax.phot)
  plxYa mas (n) Yale trigonometric parallax (pos.parallax.trig)
  e_plxYa mas (n) Yale parallax standard error (stat.error)
  yaF  (n) F-criterion for 'mu - Yale mu' (Note 7)   (stat.fit.param)
  plxMe mas (n) MEarth trigonometric parallax (pos.parallax.trig)
  e_plxMe mas (n) MEarth parallax standard error (stat.error)
  MehF  (n) F-criterion for 'mu - MEarth mu' (stat.fit.param)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  plxPu mas (n) Pulkovo trigonometric parallax (pos.parallax.trig)
  e_plxPu mas (n) Pulkovo parallax standard error (stat.error)
  PuF  (n) F-criterion for 'mu - Pulkovo mu' (stat.fit.param)
  pfDiffRA  Maximum difference of plx facs in RA (pos.parallax;arith.diff;stat.max)
  pfDiffDE  Maximum difference of plx facs in DE (pos.parallax;arith.diff;stat.max)
  DPMRAu4 mas/yr (n) Difference 'mu - UCAC4 mu' in RA (Note 8)   (pos.eq.ra;arith.diff)
  DPMDEu4 mas/yr (n) Difference 'mu - UCAC4 mu' in DE (Note 8)   (pos.eq.dec;arith.diff)
  u4F  (n) F-criterion for 'sh-term mu-UCAC4 mu' (stat.fit.param)
  Fflag  (n) [0/1] Flag for F-criteria (Note 9)   (meta.code.error)
  obtype  (n) [0/8] Object type UCAC4(see UCAC4 ReadMe) (src.class)
  cdsf  (n) Combined double star flag from UCAC4 (meta.code)
  BmagA mag (n) B magnitude from APASS (phot.mag;em.opt.B)
  e_BmagA mag (n) Error of B magnitude from APASS (stat.error;phot.mag;em.opt.B)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  VmagA mag (n) V magnitude from APASS (phot.mag;em.opt.V)
  e_VmagA mag (n) Error of V magnitude from APASS (stat.error;phot.mag;em.opt.V)
  gmagA mag (n) g magnitude from APASS (phot.mag;em.opt.B)
  e_gmagA mag (n) Error of g magnitude from APASS (stat.error;phot.mag)
  rmagA mag (n) r magnitude from APASS (phot.mag;em.opt.R)
  e_rmagA mag (n) Error of r magnitude from APASS (stat.error;phot.mag)
  imagA mag (n) i magnitude from APASS (phot.mag;em.opt.I)
  e_imagA mag (n) Error of i magnitude from APASS (stat.error;phot.mag)
  Jmag mag (n) J magnitude from 2MASS (Cat. II/246) (phot.mag;em.IR.J)
  e_Jmag mag (n) Error of J magnitude from 2MASS (stat.error;phot.mag;em.IR.J)
  Hmag mag (n) H magnitude from 2MASS (phot.mag;em.IR.H)
  e_Hmag mag (n) Error of H magnitude from 2MASS (stat.error;phot.mag;em.IR.H)
  Ksmag mag (n) Ks magnitude from 2MASS (phot.mag;em.IR.K)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Ksmag mag (n) Error of Ks magnitude from 2MASS (stat.error;phot.mag;em.IR.K)
  sdssFlag   [0/2] SDSS flag (Note 10)   (meta.code)
  umag mag (n) u magnitude from SDSS (Cat. V/139) (phot.mag;em.opt.U)
  e_umag mag (n) Error of u magnitude from SDSS (stat.error;phot.mag;em.opt.U)
  gmag mag (n) g magnitude from SDSS (phot.mag;em.opt.B)
  e_gmag mag (n) Error of g magnitude from SDSS (stat.error;phot.mag;em.opt.B)
  rmag mag (n) r magnitude from SDSS (phot.mag;em.opt.R)
  e_rmag mag (n) Error of r magnitude from SDSS (stat.error;phot.mag;em.opt.R)
  imag mag (n) i magnitude from SDSS (phot.mag;em.opt.I)
  e_imag mag (n) Error of i magnitude from SDSS (stat.error;phot.mag;em.opt.I)
  zmag mag (n) z magnitude from SDSS (phot.mag;em.opt.I)
  e_zmag mag (n) Error of z magnitude from SDSS (stat.error;phot.mag;em.opt.I)
  W1mag mag (n) W1 magnitude from WISE (Cat. II/311) (phot.mag;em.IR.3-4um)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_W1mag mag (n) Error of W1 magnitude from WISE (stat.error;phot.mag)
  W2mag mag (n) W2 magnitude from WISE (phot.mag;em.IR.4-8um)
  e_W2mag mag (n) Error of W2 magnitude from WISE (stat.error;phot.mag)
  W3mag mag (n) W3 magnitude from WISE (phot.flux.density;em.IR.8-15um)
  e_W3mag mag (n) Error of W3 magnitude from WISE (stat.error;phot.mag)
  W4mag mag (n) W4 magnitude from WISE (phot.flux.density;em.IR.15-30um)
  e_W4mag mag (n) Error of W4 magnitude from WISE (stat.error;phot.mag)
  IR-OPTd mas (n) IR-OPT displacement (Note 11)   (pos.angDistance)
  IR-OPTsnr  (n) IR-OPT displacement signal-to-noise ratio (stat.snr;pos.angDistance)
  mAsy  Mean asymmetry of stellar image (src.morph.param)
  minAsy  Minimum asymmetry of stellar image (src.morph.param)
  maxAsy  Maximum asymmetry of stellar image (src.morph.param)
  survey (char) Text mark of survey (Note 12)   (meta.id)
  WDS (char) WDS ID (Cat. B/wds) (meta.id)
  rho arcsec (n) Angular separation from WDS (epoch2) (pos.angDistance)
  theta deg (n) Positional Angle from WDS (epoch2) (pos.posAng)
  magp mag (n) Magnitude of primary from WDS (phot.mag;em.opt)
  mags mag (n) Magnitude of secondary from WDS (phot.mag;em.opt)

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/V-3.err (2024-10-07T10:20:01)
-3
-source=J/PAZh/41/896/lpmsm15b
-ref=VIZ6703b5d2385f14
elapse time 1

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


Contents of error file (/tmp/V-3.err):
CDSportal=http://cdsportal.u-strasbg.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=8ae129b2b46e
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=cds:8082
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR=3.143.17.27
HTTP_X_FORWARDED_HOST=viz-beta.u-strasbg.fr
HTTP_X_FORWARDED_SERVER=viz-beta.u-strasbg.fr
LC_ALL=C
LD_LIBRARY_PATH=/srv/httpd/../lib:/srv/lib:/usr/local/lib:/usr/lib
LOGNAME=root
MACHTYPE=x86_64
METADB=metaviz@VIZIR 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
QMOCCMD=.ext-tsv/qat2s_asu --out.form tsv --noheader --out.max=999999999 --source=%s --moc=%s
QUERY_STRING=-source=J%2FPAZh%2F41%2F896%2Flpmsm15b
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=56180
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FPAZh%2F41%2F896%2Flpmsm15b
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SERVER_ADDR=172.17.0.2
SERVER_ADMIN=gilles.landais@astro.u-strasbg.fr
SERVER_NAME=cds
SERVER_PORT=8082
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache/2.4.57 (Unix)
SESAME_SERVER=glu
SHLVL=1
USER=root
VENDOR=unknown
VSEARCH_HOST=cdsarc.cds.unistra.fr
VSEARCH_REDIRECT=http://cdsarc.cds.unistra.fr
Vaccess=*
Vprog=/srv/httpd/bin/vizier
Vprog_ls=-rwxr-xr-x 1 root root 963216 Sep 12 07:38 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/PAZh/41/896/lpmsm15b
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 3
....db1_interfaces(/srv/httpd/interfaces)
----db1_open(metaviz@VIZIR) gives: 0
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select hstid, flag from METAhst where name='8ae129b2b46e.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/PAZh/41/896/lpmsm15b' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   select login from METAdba where dbaid=53
----db1_reset(0 'metaviz@VIZIR')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1728296401]    insert into T1 values(90410896)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZIR'):
[1728296401]    insert into T2 values(90410896)
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   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@VIZIR'):
[1728296401]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=90410896 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=90410896 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=90410896 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1728296401]   Select catid, morid, text From METAmor where catid=90410896 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=90410896 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=15
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=14
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=13
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=12
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=11
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=90410896 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=90410896 and tabid=3
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=90410896 and tabid=4
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=90410896 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=90410896 and tabid=1

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   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@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   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@VIZIR'):
[1728296402]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, id From METAtime where catid=90410896 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=90410896 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=90410896 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   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@VIZIR')
----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_query(1 'metaviz@VIZIR'):
[1728296402]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@VIZIR')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=90410896): 2920 => 0.51
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select idori, kwdid, name, explain From METAorigin
----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_exec(1 'metaviz@VIZIR'):
[1728296402]    Update METAhit set etime=781611602,  Ncalls = Ncalls+1 where catid=90410896 and hstid=-1 and btime=781050600
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1728296402]    UPDATE METAstat set nlocal=nlocal+1, tlocal=781611602 Where phase=3 and catid=90410896
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/PAZh/41/896/lpmsm15b): show_status = (13, 81, 0, 0, 0)
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=359
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1367
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=5
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=355
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=149
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1218
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=930
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=736
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=719
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=262
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1208
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=264
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1211
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=260
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1209
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=64
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=97
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=731
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=747
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1466
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1467
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1468
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=693
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=689
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=935
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=837
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=608
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=926
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=665
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=925
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=666
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=924
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=480
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=923
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=481
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=228
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1110
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=362
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=311
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=308
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=191
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select ucdid, name, class, explain From METAucd where ucdid=268
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=1221
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1728296402]   Select famid, name, explain From METAfam where famid=741
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/PAZh/41/896/lpmsm15b
     [u] -ref=VIZ6703b5d2385f14
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@VIZIR')
----db1_close(1 'metaviz@VIZIR')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact