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

  
IX/52
  XXL Survey. DR2 (Chiappetti+, 2018)
2018yCat.9052....0C
Official XXL DR2
Post annotation
img(gal)
1.IX/52/3xlsoptnThe 3XLSSOPTN XXL-N multiwave catalogue (Paper XXVII Chiappetti et al. 2018A&A...620A..12C) (31585 rows) (released 2020-09-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)
  Xseq  Internal sequence identifier (Note G1)   (meta.id)
  Xcatname (char) Catalog name of the object, 3XLSS JHHMMSS.s+DDMMSS (Note G2)   (meta.id;meta.table)
  RAX deg (i) X-ray Right ascension (J2000) (pos.eq.ra)
  DEX deg (i) X-ray Declination (J2000) (pos.eq.dec)
  Bseq  (n) Identifier in 0.5-2keV band (Note G3)   (meta.id)
  Bcatname (char) Alternate name in 0.5-2keV band (meta.id;meta.main)
  Bp1  (n) [0/1] Pointlike source class (Note G4)   (src.class)
  RABdeg deg (n) Right ascension (J2000) (pos.eq.ra)
  DEBdeg deg (n) Declination (J2000) (pos.eq.dec)
  CDseq  (n) Identifier in 2-10keV band (Note G3)   (meta.id)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  CDcatname (char) Alternate name in 2-10keV band (meta.id)
  CDp1  (n) [0/1] pointlike source class (src.class)
  RACDdeg deg (n) Right ascension (J2000) (pos.eq.ra)
  DECDdeg deg (n) Declination (J2000) (pos.eq.dec)
  Xlsspointr  (n) Pointer in 2XLSSd catalogue (Note G10)   (meta.id)
  XLSSC  (n) XLSSC cluster number (Note G11)   (meta.id)
  Xrank (char) Identification rank (Note G12)   (meta.id)
  RACtpdeg deg (n) Right ascension (J2000) (Note G13)   (pos.eq.ra)
  DECtpdeg deg (n) Declination (J2000) (pos.eq.dec)
  Pbest  (n) Best band chance probability (stat.fit.goodness)
  LRbest  (n) Best band likelihood ratio (meta.note)
  zspec  (n) Spectroscopic redshift (src.redshift)
  r_zspec (char) Origin of spectroscopic z (meta.ref;pos.frame)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  simbadId (char) SIMBAD identifier (meta.id)
  nedId (char) NED identifier (meta.id)
  star   [0/3] star flag (Note G14)   (meta.code)
  agn1000  AGN1000 flag (Note G15)   (meta.code)
  RASDSSdeg deg (n) SDSS Right ascension (J2000) (Note G16)   (pos.eq.ra)
  DESDSSdeg deg (n) SDSS Declination (J2000) (pos.eq.dec)
  SDSSdist arcsec (n) X-ray to SDSS ctpt distance (pos.angDistance)
  uSDSSmag mag (n) SDSS u magnitude (AB) (phot.mag;em.opt.U)
  e_uSDSSmag mag (n) Error on uSDSSmag (stat.error;phot.mag)
  gSDSSmag mag (n) SDSS g magnitude (AB) (phot.mag;em.opt.B)
  e_gSDSSmag mag (n) Error on gSDSSmag (stat.error;phot.mag)
  rSDSSmag mag (n) SDSS r magnitude (AB) (phot.mag;em.opt.R)
  e_rSDSSmag mag (n) Error on rSDSSmag (stat.error;phot.mag)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  iSDSSmag mag (n) SDSS i magnitude (AB) (phot.mag;em.opt.I)
  e_iSDSSmag mag (n) Error on iSDSSmag (stat.error;phot.mag)
  zSDSSmag mag (n) SDSS z magnitude (AB) (phot.mag;em.opt.I)
  e_zSDSSmag mag (n) Error on zSDSSmag (stat.error;phot.mag)
  RACFHTdeg deg (n) CFHT Right ascension (J2000) (Note G16)   (pos.eq.ra)
  DECFHTdeg deg (n) CFHT Declination (J2000) (pos.eq.dec)
  CFHTdist arcsec (n) X-ray to CFHT ctpt distance (pos.angDistance)
  uCFHTmag mag (n) CFHT u magnitude (AB) (phot.mag;em.opt.U)
  e_uCFHTmag mag (n) Error on uCFHTmag (stat.error;phot.mag)
  gCFHTmag mag (n) CFHT g magnitude (AB) (phot.mag;em.opt.B)
  e_gCFHTmag mag (n) Error on gCFHTmag (stat.error;phot.mag)
  rCFHTmag mag (n) CFHT r magnitude (AB) (phot.mag;em.opt.R)
  e_rCFHTmag mag (n) Error on rCFHTmag (stat.error;phot.mag)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  iCFHTmag mag (n) CFHT i magnitude (AB) (phot.mag;em.opt.I)
  e_iCFHTmag mag (n) Error on iCFHTmag (stat.error;phot.mag)
  yCFHTmag mag (n) CFHT y magnitude (AB) (phot.mag;em.IR.J)
  e_yCFHTmag mag (n) Error on yCFHTmagy (stat.error;phot.mag)
  zCFHTmag mag (n) CFHT z magnitude (AB) (phot.mag;em.opt.I)
  e_zCFHTmag mag (n) Error on zCFHTmagz (stat.error;phot.mag)
  RAVISTAdeg deg (n) VISTA Right ascension (J2000) (Note G16)   (pos.eq.ra)
  DEVISTAdeg deg (n) VISTA Declination (J2000) (pos.eq.dec)
  VISTAdist arcsec (n) X-ray to VISTA ctpt distance (pos.angDistance)
  zVISTAmag mag (n) VISTA z magnitude (AB) (phot.mag;em.opt.I)
  e_zVISTAmag mag (n) Error on zVISTAmag (stat.error;phot.mag)
  YVISTAmag mag (n) VISTA Y magnitude (AB) (phot.mag;em.IR.J)
  e_YVISTAmag mag (n) Error on YVISTAmag (stat.error;phot.mag)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  JVISTAmag mag (n) VISTA J magnitude (AB) (phot.mag;em.IR.J)
  e_JVISTAmag mag (n) Error on JVISTAmag (stat.error;phot.mag)
  HVISTAmag mag (n) VISTA H magnitude (AB) (phot.mag;em.IR.H)
  e_HVISTAmag mag (n) Error on HVISTAmag (stat.error;phot.mag)
  KVISTAmag mag (n) VISTA K magnitude (AB) (phot.mag;em.IR.K)
  e_KVISTAmag mag (n) Error on KVISTAmag (stat.error;phot.mag)
  RAUKIDSSdeg deg (n) UKIDSS Right ascension (J2000) (Note G16)   (pos.eq.ra)
  DEUKIDSSdeg deg (n) UKIDSS Declination (J2000) (pos.eq.dec)
  UKIDSSdist arcsec (n) X-ray to UKIDSS ctpt distance (pos.angDistance)
  JUKIDSSmag mag (n) UKIDSS J magnitude (AB) (phot.mag;em.IR.J)
  e_JUKIDSSmag mag (n) Error on JUKIDSmag (stat.error;phot.mag)
  HUKIDSSmag mag (n) UKIDSS H magnitude (AB) (phot.mag;em.IR.H)
  e_HUKIDSSmag mag (n) Error on HUKIDSmag (stat.error;phot.mag)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  KUKIDSSmag mag (n) UKIDSS K magnitude (AB) (phot.mag;em.IR.K)
  e_KUKIDSSmag mag (n) Error on KUKIDSmag (stat.error;phot.mag)
  RAWIRcamdeg deg (n) WIRcam Right ascension (J2000) (Note G16)   (pos.eq.ra)
  DEWIRcamdeg deg (n) WIRcam Declination (J2000) (pos.eq.dec)
  WIRcamdist arcsec (n) X-ray to WIRcam ctpt distance (pos.angDistance)
  KWIRcammag mag (n) WIRcam K magnitude (AB) (phot.mag;em.IR.K)
  e_KWIRcammag mag (n) Error on KWIRCammag (stat.error;phot.mag)
  RAIRACdeg deg (n) IRAC Right ascension (J2000) (Note G16)   (pos.eq.ra)
  DEIRACdeg deg (n) IRAC Declination (J2000) (pos.eq.dec)
  IRACdist arcsec (n) X-ray to IRAC ctpt distance (pos.angDistance)
  IRAC3.6mag mag (n) IRAC 3.6 micron magnitude (AB) (phot.mag;em.IR.3-4um)
  e_IRAC3.6mag mag (n) Error on IRAC3.6mag (stat.error)
  IRAC4.5mag mag (n) IRAC 4.5 micron magnitude (AB) (phot.mag;em.IR.4-8um)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_IRAC4.5mag mag (n) Error on IRAC4.5mag (stat.error)
  RAGALEXdeg deg (n) GALEX Right ascension (J2000) (Note G16)   (pos.eq.ra)
  DEGALEXdeg deg (n) GALEX Declination (J2000) (pos.eq.dec)
  GALEXdist arcsec (n) X-ray to GALEX ctpt distance (pos.angDistance)
  GALEXFUVmag mag (n) GALEX FUV magnitude (AB) (phot.mag;em.UV.100-200nm)
  e_GALEXFUVmag mag (n) Error on GALEXFUVmag (stat.error;phot.mag)
  GALEXNUVmag mag (n) GALEX NUV magnitude (AB) (phot.mag;em.UV.200-300nm)
  e_GALEXNUVmag mag (n) Error on GALEXNUVmag (stat.error;phot.mag)
  RAWISEdeg deg (n) WISE Right ascension (J2000) (Note G16)   (pos.eq.ra)
  DEWISEdeg deg (n) WISE Declination (J2000) (pos.eq.dec)
  WISEdist arcsec (n) X-ray to WISE ctpt distance (pos.angDistance)
  WISE1mag mag (n) WISE W1 magnitude (AB) (phot.mag;em.IR.3-4um)
  e_WISE1mag mag (n) Error on WISE1mag (stat.error;phot.mag)
  WISE2mag mag (n) WISE W2 magnitude (AB) (phot.mag;em.IR.4-8um)
  e_WISE2mag mag (n) Error on WISE2mag (stat.error;phot.mag)
  WISE3mag mag (n) WISE W3 magnitude (AB) (phot.flux.density;em.IR.8-15um)
  e_WISE3mag mag (n) Error on WISE3mag (stat.error;phot.mag)
  WISE4mag mag (n) WISE W4 magnitude (AB) (phot.flux.density;em.IR.15-30um)
  e_WISE4mag mag (n) Error on WISE4mag (stat.error;phot.mag)

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-09-20T05:37:32)
-3
-source=IX/52/3xlsoptn
-ref=VIZ66ed0a1c4427c
elapse time 0

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=18.116.86.92
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=IX%2F52%2F3xlsoptn
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=34946
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=IX%2F52%2F3xlsoptn
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=IX/52/3xlsoptn
################################################################

....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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select hstid, flag from METAhst where name='8ae129b2b46e.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'IX/52/3xlsoptn' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   select login from METAdba where dbaid=39
----db1_reset(0 'metaviz@VIZIR')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1726810652]    insert into T1 values(9052)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZIR'):
[1726810652]    insert into T2 values(9052)
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   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'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=9052 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=9052 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=9052 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select catid, morid, text From METAmor where catid=9052 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=3822
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=3
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=4
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=5
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=309 and fltrid=7
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=309 and fltrid=6
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=6
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=7
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=802 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=802 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=208 and fltrid=5
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=208 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=208 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=309 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=15
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=14
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=13
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=12
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=205 and fltrid=11
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=8
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=9
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=10
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=3286
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=12
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=13
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=14
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=15
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=306 and fltrid=14
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=8420
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=3646
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=9052 and  tabid=7 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=9052 and tabid=7

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   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'):
[1726810652]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   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'):
[1726810652]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   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=9052 and tabid=7
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=9052 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=9052 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   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'):
[1726810652]    Update METAhit set etime=780125852,  Ncalls = Ncalls+1 where catid=9052 and hstid=-1 and btime=778420800
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726810652]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780125852 Where phase=3 and catid=9052
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name From METAucd where ucdid>=0
....show_table(IX/52/3xlsoptn): show_status = (16, 92, 0, 0, 0)
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=184
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=85
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=162
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=97
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=353
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1351
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1346
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=251
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=228
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1110
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=935
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1465
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1466
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1467
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1468
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=1469
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=749
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=730
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=734
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=743
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=926
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=665
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=925
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=666
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=942
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=746
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=941
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=924
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=480
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select ucdid, name, class, explain From METAucd where ucdid=923
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726810652]   Select famid, name, explain From METAfam where famid=481
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=IX/52/3xlsoptn
     [u] -ref=VIZ66ed0a1c4427c
====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