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/A+A/682/A34
  SRG/eROSITA all-sky survey catalogs (eRASS1) (Merloni+, 2024)
Post annotation
img(gal)
1.J/A+A/682/A34/erass1-hAll X-ray sources detected in the 2.3-5keV band with detection likelihood DET_LIKE>12 (original column names in green) (5466 rows) (released 2025-10-14)
[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)
  IAUName (char) String containing the official IAU name of the source (IAUNAME) (meta.id;meta.main)
  DetUId (char) String unique detection ID (DETUID) (meta.id)
  SkyTile  Skytile ID (SKYTILE) (obs.field)
  IdSrc  Source ID in each sky tile (ID_SRC) (Note G1)   (meta.id)
  UId  Integer unique detection ID (UID) (Note G2)   (meta.id)
  UId-1B  1B catalog UID of the source with a strong association, or -UID if the association is weak (UIdHard in erass1-m.dat and erass1-s.dat)(UID_1B) (meta.id)
  IdCluster  Group ID of simultaneously fitted sources (ID_CLUSTER) (meta.id.parent)
  RA_ICRS deg (i) Right ascension (ICRS), corrected (RA) (pos.eq.ra;meta.main)
  DE_ICRS deg (i) Declination (ICRS), corrected (DEC) (pos.eq.dec;meta.main)
  RARdeg deg Right ascension (ICRS), uncorrected (RA_RAW) (pos.eq.ra)

ALL cols
    
 (i)indexed column
  DERdeg deg Declination (ICRS), uncorrected (DEC_RAW) (pos.eq.dec)
  e_RA_ICRS arcsec (n) 1-sigma lower error on RA (RA_LOWERR) (stat.error;pos.eq.ra)
  E_RA_ICRS arcsec (n) 1-sigma upper error on RA (RA_UPERR) (stat.error;stat.max)
  e_DE_ICRS arcsec (n) 1-sigma lower error on DEC (DEC_LOWERR) (stat.error;pos.eq.dec)
  E_DE_ICRS arcsec (n) 1-sigma upper error on DEC (DEC_UPERR) (stat.error;stat.max)
  posErr arcsec 1-sigma positional uncertainty (POS_ERR) (stat.error;pos)
  RADEErr arcsec Combined positional error, raw output from PSF fitting (RADEC_ERR) (stat.error;pos)
  GLON deg Galactic longitude (LII) (pos.galactic.lon)
  GLAT deg Galactic latitude (BII) (pos.galactic.lat)
  ELON deg Ecliptic longitude (ELON) (pos.ecliptic.lon)
  ELAT deg Ecliptic latitude (ELAT) (pos.ecliptic.lat)
  MJD d Modified Julian Date of the observation of the source nearest to the optical axis of the telescope (MJD) (time.epoch)
  b_MJD d Modified Julian Date of the first observation of the source (MJD_MIN) (time.epoch)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  B_MJD d Modified Julian Date of the last observation of the source (MJD_MAX) (time.epoch)
  EXT arcsec Source Extent Parameter (EXT) (stat.param)
  s_EXT arcsec (n) 1-sigma error on EXT (EXT_ERR) (stat.error)
  e_EXT arcsec (n) 1-sigma lower error on EXT (EXT_LOWERR) (stat.error)
  E_EXT arcsec (n) 1-sigma upper error on EXT (EXT_UPERR) (stat.error;stat.max)
  EXTLike  Extent likelihood (EXT_LIKE) (stat.likelihood)
  MLcts0 ct Source net counts in 0.2-5.0 keV band (ML_CTS_0) (phot.count;em.X-ray)
  s_MLcts0 ct (n) 1-sigma combined counts error in 0.2-5.0 keV band (ML_CTS_ERR_0) (stat.error;phot.count;em.X-ray.medium)
  MLRate0 ct/s Source count rate in 0.2-5.0 keV band (ML_RATE_0) (phot.count;em.X-ray)
  s_MLRate0 ct/s (n) 1-sigma combined count rate error in 0.2-5.0 keV band (ML_RATE_ERR_0) (arith.rate;phot.count;em.X-ray.medium)
  MLFlux0 mW/m2 Source flux in 0.2-5.0 keV band (ML_FLUX_0) (phot.flux;em.X-ray)
  s_MLFlux0 mW/m2 (n) 1-sigma combined error on flux in 0.2-5.0 keV band (ML_FLUX_ERR_0) (stat.error;phot.flux;em.X-ray.medium)
  DetLike0  Detection likelihood in 0.2-5.0 keV band (DET_LIKE_0) (stat.likelihood)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  MLBkg0 arcmin-2 Background at the source position in the 0.2-5.0 keV band (ML_BKG_0) (instr.background)
  MLcts1 ct Source net counts in 0.2-0.6 keV band (ML_CTS_1) (phot.count;em.X-ray)
  s_MLcts1 ct (n) 1-sigma combined counts error in 0.2-0.6 keV band (ML_CTS_ERR_1) (stat.error;phot.count;em.X-ray.soft)
  e_MLcts1 ct (n) 1-sigma lower counts error in 0.2-0.6 keV band (ML_CTS_LOWERR_1) (stat.error)
  E_MLcts1 ct (n) 1-sigma upper counts error in 0.2-0.6 keV band (ML_CTS_UPERR_1) (stat.error;stat.max)
  MLRate1 ct/s Source count rate in 0.2-0.6 keV band (ML_RATE_1) (phot.count;em.X-ray)
  s_MLRate1 ct/s (n) 1-sigma combined count rate error in 0.2-0.6 keV band (ML_RATE_ERR_1) (arith.rate;phot.count;em.X-ray.soft)
  e_MLRate1 ct/s (n) 1-sigma lower count rate error in 0.2-0.6 keV band (ML_RATE_LOWERR_1) (stat.error)
  E_MLRate1 ct/s (n) 1-sigma upper count rate error in 0.2-0.6 keV band (ML_RATE_UPERR_1) (stat.error;stat.max)
  MLFlux1 mW/m2 Source flux in 0.2-0.6 keV band (ML_FLUX_1) (phot.flux;em.X-ray)
  s_MLFlux1 mW/m2 (n) 1-sigma combined error on flux in 0.2-0.6 keV ban (ML_FLUX_ERR_1) (stat.error;phot.flux;em.X-ray.soft)
  e_MLFlux1 mW/m2 (n) 1-sigma lower error on flux in 0.2-0.6 keV band (ML_FLUX_LOWERR_1) (stat.error)
  E_MLFlux1 mW/m2 (n) 1-sigma upper error on flux in 0.2-0.6 keV band (ML_FLUX_UPERR_1) (stat.error;stat.max)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  DetLike1  (n) Detection likelihood in 0.2-0.6 keV band (DET_LIKE_1) (stat.likelihood)
  MLBkg1 arcmin-2 Background at the source position in the 0.2-0.6 keV band (ML_BKG_1) (instr.background)
  MLExp1 s Vignetted exposure time at the source position in 0.2-0.6 keV band (ML_EXP_1) (time.duration;obs.exposure)
  MLEef1  Enclosed energy fraction in 0.2-0.6 keV band (ML_EEF_1) (phys.energy)
  APEcts1 ct Total counts extracted within the aperture in 0.2-0.6 keV band (APE_CTS_1) (phot.count;em.X-ray)
  APEBkg1 ct Background counts extracted within the aperture in 0.2-0.6 keV band, excluding nearby sources using the source map (APE_BKG_1) (instr.background;em.X-ray.soft)
  APEExp1 s Exposure map value in 0.2-0.6 keV band at the given position (APE_EXP_1) (time.expo)
  APERad1 pix Extraction radius in pixels (4'') in the 0.2-0.6 keV band (APE_RADIUS_1) (phys.angSize)
  APEPois1  (n) Poisson probability that the extracted counts (APECTS1) are a background fluctuation (APE_POIS_1) (stat.fit.goodness)
  MLcts2 ct Source net counts in 0.6-2.3 keV band (ML_CTS_2) (phot.count;em.X-ray)
  s_MLcts2 ct (n) 1-sigma combined counts error in 0.6-2.3 keV band (ML_CTS_ERR_2) (stat.error;phot.count;em.X-ray.soft)
  e_MLcts2 ct (n) 1-sigma lower counts error in 0.6-2.3 keV band (ML_CTS_LOWERR_2) (stat.error)
  E_MLcts2 ct (n) 1-sigma upper counts error in 0.6-2.3 keV band (MLcts2) (stat.error;stat.max)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  MLRate2 ct/s Source count rate in 0.6-2.3 keV band (ML_RATE_2) (phot.count;em.X-ray)
  s_MLRate2 ct/s (n) 1-sigma combined count rate error in 0.6-2.3 keV band (ML_RATE_ERR_2) (arith.rate;phot.count;em.X-ray.soft)
  e_MLRate2 ct/s (n) 1-sigma lower count rate error in 0.6-2.3 keV band (ML_RATE_LOWERR_2) (stat.error)
  E_MLRate2 ct/s (n) 1-sigma upper count rate error in 0.6-2.3 keV band (ML_RATE_UPERR_2) (stat.error;stat.max)
  MLFlux2 mW/m2 Source flux in 0.6-2.3 keV band (ML_FLUX_2) (phot.flux;em.X-ray)
  s_MLFlux2 mW/m2 (n) 1-sigma combined error on flux in 0.6-2.3 keV band (ML_FLUX_ERR_2) (stat.error;phot.flux;em.X-ray.soft)
  e_MLFlux2 mW/m2 (n) 1-sigma lower error on flux in 0.6-2.3 keV band (ML_FLUX_LOWERR_2) (stat.error)
  E_MLFlux2 mW/m2 (n) 1-sigma upper error on flux in 0.6-2.3 keV band (ML_FLUX_UPERR_2) (stat.error;stat.max)
  DetLike2  (n) Detection likelihood in 0.6-2.3 keV band (DET_LIKE_2) (stat.likelihood)
  MLBkg2 arcmin-2 Background at the source position in the 0.6-2.3 keV band (ML_BKG_2) (instr.background)
  MLExp2 s Vignetted exposure time at the source position in 0.6-2.3 keV band (ML_EXP_2) (time.duration;obs.exposure)
  MLEef2  Enclosed energy fraction in 0.6-2.3 keV band (ML_EEF_2) (phys.energy)
  APEcts2 ct Total counts extracted within the aperture in 0.6-2.3 keV band (APE_CTS_2) (phot.count;em.X-ray)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  APEBkg2 ct Background counts extracted within the aperture in 0.6-2.3 keV band, excluding nearby sources using the source map (APE_BKG_2) (instr.background;em.X-ray.soft)
  APEExp2 s Exposure map value in 0.6-2.3 keV band at the given position (APE_EXP_2) (time.expo)
  APERad2 pix Extraction radius in pixels (4'') in the 0.6-2.3 keV band (APE_RADIUS_2) (phys.angSize)
  APEPois2  (n) Poisson probability that the extracted counts (APECTS2) are a background fluctuation (APE_POIS_2) (stat.fit.goodness)
  MLcts3 ct Source net counts in 2.3-5.0 keV band (ML_CTS_3) (phot.count;em.X-ray)
  s_MLcts3 ct (n) 1-sigma combined counts error in 2.3-5.0 keV band (ML_CTS_ERR_3) (stat.error;phot.count;em.X-ray.medium)
  e_MLcts3 ct (n) 1-sigma lower counts error in 2.3-5.0 keV band (ML_CTS_LOWERR_3) (stat.error)
  E_MLcts3 ct (n) 1-sigma upper counts error in 2.3-5.0 keV band (ML_CTS_UPERR_3) (stat.error;stat.max)
  MLRate3 ct/s Source count rate in 2.3-5.0 keV band (ML_RATE_3) (phot.count;em.X-ray)
  s_MLRate3 ct/s (n) 1-sigma combined count rate error in 2.3-5.0 keV band (ML_RATE_ERR_3) (arith.rate;phot.count;em.X-ray.medium)
  e_MLRate3 ct/s (n) 1-sigma lower count rate error in 2.3-5.0 keV band (ML_RATE_LOWERR_3) (stat.error)
  E_MLRate3 ct/s (n) 1-sigma upper count rate error in 2.3-5.0 keV band (ML_RATE_UPERR_3) (stat.error;stat.max)
  MLFlux3 mW/m2 Source flux in 2.3-5.0 keV band (ML_FLUX_3) (phot.flux;em.X-ray)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  s_MLFlux3 mW/m2 (n) 1-sigma combined error on flux in 2.3-5.0 keV band (ML_FLUX_ERR_3) (stat.error;phot.flux;em.X-ray.medium)
  e_MLFlux3 mW/m2 (n) 1-sigma lower error on flux in 2.3-5.0 keV band (ML_FLUX_LOWERR_3) (stat.error)
  E_MLFlux3 mW/m2 (n) 1-sigma upper error on flux in 2.3-5.0 keV band (ML_FLUX_UPERR_3) (stat.error;stat.max)
  DetLike3  Detection likelihood in 2.3-5.0 keV band (DET_LIKE_3) (stat.likelihood)
  MLBkg3 arcmin-2 Background at the source position in the 2.3-5.0 keV band (ML_BKG_3) (instr.background)
  MLExp3 s Vignetted exposure time at the source position in 2.3-5.0 keV band (ML_EXP_3) (time.duration;obs.exposure)
  MLEef3  Enclosed energy fraction in 2.3-5.0 keV band (ML_EEF_3) (phys.energy)
  APEcts3 ct Total counts extracted within the aperture in 2.3-5.0 keV band (APE_CTS_3) (phot.count;em.X-ray)
  APEBkg3 ct Background counts extracted within the aperture in 2.3-5.0 keV band, excluding nearby sources using the source map (APE_BKG_3) (instr.background;em.X-ray.medium)
  APEExp3 s Exposure map value in 2.3-5.0 keV band at the given position (APE_EXP_3) (time.expo)
  APERad3 pix Extraction radius in pixels (4'') in the 2.3-5.0 keV band (APE_RADIUS_3) (phys.angSize)
  APEPois3  (n) Poisson probability that the extracted counts (APECTS3) are a background fluctuation (APE_POIS_3) (stat.fit.goodness)
  FSPSNR  Source may lie within an overdense region near a supernova remnant (FLAG_SP_SNR) (meta.code)
  FSPBPS  Source may lie within an overdense region near a bright point source (FLAG_SP_BPS) (meta.code)
  FSPSCL  Source may lie within an overdense region near a stellar cluster (FLAG_SP_SCL) (meta.code)
  FSPLGA  Source may lie within an overdense region near a local large galaxy (FLAG_SP_LGA) (meta.code)
  FSPGCCONS  Source may lie within an overdense region near a galaxy cluster (FLAG_SP_GC_CONS) (meta.code)
  FNORADEerr  Source contained no RADEC_ERR in the pre-processed version of the catalogue (FLAG_NO_RADEC_ERR) (meta.code)
  FNOEXTerr  Source contained no EXT_ERR in the pre-processed version of the catalogue (FLAG_NO_EXT_ERR) (meta.code)
  FNOCTSerr  Source contained no CTS_ERR in the pre-processed version of the catalogue (FLAG_NO_CTS_ERR) (meta.code)
  FOPT  Source matched within 15'' with a bright optical star, likely contaminated by optical loading (FLAG_OPT) (meta.code)

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/VR1031556.err (2026-08-12T13:50:18)
-3
-source=J/A+A/682/A34/erass1-h
-ref=VIZ6a7c7a1bfbd84
elapse time 1

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


Contents of error file (/tmp/VR1031556.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_CACHE_CONTROL=max-age=0
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_VIA=1.1 squid-proxy-5b96dc6d46-cwzbt (squid/6.13)
HTTP_X_FORWARDED_FOR=10.9.32.164, 216.73.216.183, 127.0.0.1
HTTP_X_FORWARDED_HOST=tapvizier.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%2FA%2BA%2F682%2FA34%2Ferass1-h
REMOTE_ADDR=172.19.0.1
REMOTE_PORT=33032
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FA%2BA%2F682%2FA34%2Ferass1-h
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/A+A/682/A34/erass1-h
################################################################

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

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   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'):
[1786542619]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   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'):
[1786542619]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   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=36820034 and tabid=3
#...meta_close(1): retrieved 3/1000 tuples [tested=3]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   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'):
[1786542619]   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'):
[1786542619]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=36820034 and tabid=3
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   SELECT catid FROM METAcat WHERE name='36820034'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=36820034 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36820034 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   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'):
[1786542619]    Update METAhit set etime=839857819,  Ncalls = Ncalls+1 where catid=36820034 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(1 'metaviz@TAPVIZIER1'):
[1786542619]    UPDATE METAstat set nlocal=nlocal+1, tlocal=839857819 Where phase=3 and catid=36820034
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/A+A/682/A34/erass1-h): show_status = (12, 98, 0, 0, 0)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=94
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=171
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=77
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=185
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=227
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=256
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1172
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=255
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1171
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=244
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1129
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=243
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1128
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=361
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=124
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=357
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1345
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=104
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=945
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=445
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=947
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=437
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=8
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=106
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=584
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=20
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=207
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=946
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=416
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=430
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1370
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=183
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=957
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=372
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=134
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=353
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=1351
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786542619]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@TAPVIZIER1')
----inherit(u=used, h=hidden):
     [u] +source=J/A+A/682/A34/erass1-h
     [u] -ref=VIZ6a7c7a1bfbd84
====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