.errorfile=/tmp/V-2.err (2025-04-08T02:44:19) -2 -kw.cat=74835554 -ref=VIZ67f48d83f0d6d
-rwxr-xr-x 1 root root 963656 Mar 12 13:03 /srv/httpd/bin/vizier vizier -- Version 7.4.6 cgiprint -- version 9.68 (2016-01-16) b1_select_into(0): temporary table=T1 Select catid as id, 63*(4-count(*)) as w from METAkwd where kwdid in (Select kwdid from METAkwd where catid=35290108) Group by catid ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select COUNT(*) as n From T1 ----db1_reset(0 'metaviz@VIZIR') #---resulting table T1: 9092 tuples ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select COUNT(*) as n From T1 Where w=0 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select COUNT(*) as n From T1 Where w=63 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select COUNT(*) as n From T1 Where w=126 ----db1_reset(0 'metaviz@VIZIR') ----db1_exec(0 'metaviz@VIZIR'): [1744080259] Delete from T1 where w >= 126 ------------(9000 records affected) ----db1_query(0 'metaviz@VIZIR'): [1744080259] select k.catid,k.kwdid from METAkwd k,T1 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'): [1744080259] Select authid, name From METAauth where authid=0 ----db1_query(0 'metaviz@VIZIR'): [1744080259] 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'): [1744080259] Select catid, morid, text From METAmor where catid=0 order by morid ----db1_query(0 'metaviz@VIZIR'): [1744080259] 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'): [1744080259] 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'): [1744080259] 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'): [1744080259] Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11 ----db1_query(0 'metaviz@VIZIR'): [1744080259] select login from METAdba where login like 'large_tables%' ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef #...meta_close(1): retrieved 146/0 tuples [tested=146] ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select COUNT(*) as n From T1 Where w>=0 ----db1_reset(0 'metaviz@VIZIR') ...t+0: First pass finds 92 catalogues ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select COUNT(*) as n From METAcat Where catid in (Select id from T1) ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid in (Select id from T1) and (authid=0) ++++popularity(all): 6.73243e+06 => 6.83 ++++popularity(catid=16020231): 3293 => 0.52 ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select idori, kwdid, name, explain From METAorigin ....DisplayFile(/srv/httpd/VizieR/=16020231) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17360090 order by tabid ++++popularity(catid=17360090): 978 => 0.44 ....DisplayFile(/srv/httpd/VizieR/=17360090) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17490130 order by tabid ++++popularity(catid=17490130): 1026 => 0.44 ....DisplayFile(/srv/httpd/VizieR/=17490130) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17630128 order by tabid ++++popularity(catid=17630128): 525 => 0.40 ....DisplayFile(/srv/httpd/VizieR/=17630128) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17800083 order by tabid ++++popularity(catid=17800083): 3529 => 0.52 ....DisplayFile(/srv/httpd/VizieR/=17800083) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18170095 order by tabid ++++popularity(catid=18170095): 370 => 0.38 ....DisplayFile(/srv/httpd/VizieR/=18170095) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18360050 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18360050) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18620073 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18620073) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18650043 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select COUNT(*) as n From METAobj Where catid=18650043 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=18650043) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18790112 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18790112) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18900150 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18900150) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19060120 order by tabid ....DisplayFile(/srv/httpd/VizieR/=19060120) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19070017 order by tabid ....DisplayFile(/srv/httpd/VizieR/=19070017) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19320027 order by tabid ....DisplayFile(/srv/httpd/VizieR/=19320027) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=21570059 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744080259] select login from METAdba where dbaid=45 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=21570059): 4677 => 0.54 ....DisplayFile(/srv/httpd/VizieR/=21570059) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=21610271 order by tabid ++++popularity(catid=21610271): 734 => 0.42 ....DisplayFile(/srv/httpd/VizieR/=21610271) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=21770465 order by tabid ++++popularity(catid=21770465): 796 => 0.42 ....DisplayFile(/srv/httpd/VizieR/=21770465) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22040014 order by tabid ++++popularity(catid=22040014): 1070 => 0.44 ....DisplayFile(/srv/httpd/VizieR/=22040014) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22430003 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22430003) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22480031 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22480031) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22500023 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22500023) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=34291125 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744080259] select login from METAdba where dbaid=41 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=34291125): 1924 => 0.48 ....DisplayFile(/srv/httpd/VizieR/=34291125) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51500094 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744080259] select login from METAdba where dbaid=43 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=51500094): 461 => 0.39 ....DisplayFile(/srv/httpd/VizieR/=51500094) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74222302 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744080259] select login from METAdba where dbaid=46 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=74222302): 1037 => 0.44 ....DisplayFile(/srv/httpd/VizieR/=74222302) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74830711 order by tabid ....DisplayFile(/srv/httpd/VizieR/=74830711) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74835554 order by tabid ....DisplayFile(/srv/httpd/VizieR/=74835554) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74913606 order by tabid ....DisplayFile(/srv/httpd/VizieR/=74913606) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744080259] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=120690339 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744080259] select login from METAdba where dbaid=54 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=120690339) ****Non-existant file**** ----inherit(u=used, h=hidden): +kw.cat=74835554 [u] -ref=VIZ67f48d83f0d6d [h] +kw.cat=74835554 ====inherit(): added 1 hidden fields ----free temporary files ----db1_close(0 'metaviz@VIZIR')
© Université de Strasbourg/CNRS
• Contact