Re: レベル（YLじゃないやつ）

　こんばんわ、ふ〜んです。

"古川＠SSS"さんは[url:kb:341]で書きました:
〉命令文でなくてもいいですが、

〉最後に　
〉）;
〉をつけて下さい。

付けたやつをアップしました。
以前のフォルダにあります。
MLをご覧下さい。

レベル　件数
0 501
1 412
2 440
3 406
4 205
5 118
6 85
7 62
8 66
9 79
10 8

計　2382件

・・・なんか少ない気がする(ーー;

書評からDL　　4879

GR(ISBN有り)　1130

GR以外(”)　　3256
内YL有り　　　 706（先日の分）
同YL無し　　　2550（ホントはこれだけ有るはず）
レベル無し　　 168 件あるので、上記の件数のみになるって事でOKかな。

でわ。

とりあえず、旧レベル０　でＹＬのはいっていない
ものについて　YL=0.501 と設定しました。
この妙な小数点がついているデータは旧レベルから
暫定的に移行したことを示します。

レベル１以上のものについては、金曜日の夕方〜深夜に
一括して行います。。

今後、各リーダーのシリーズを登録してゆく
段階でさらに改めます。

--------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0199164568','0199194661','0199166595','0199186774','0199163766','0199162131','0199163014','019916133X','019916214X','0199163081','0199161348','0199164320','0199185069','0199161356','0199164967','0199161364','0199163790','019916455X','0199163804','0199163812')
0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0198450117','0394839730','0199164576','0199164541','0199163820','0199163847','0199163839','0199164533','0199164525','0199186723','019918674X','0395870828','0199186766','0199186715','0199186731','0744561027','0785306722','0199167931','019916794X','0199167966')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in
('0684137712','0199186758','0679892257','067989490X','0694010677','0679830669','0679888306','0744567521','1584760095','0763611638','4834016471','019919369X','0199192782','0199193649','0199192820','0199160384','0199167974','0199167923','0199167958','0590466631')
20行処理されました。(62 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0694010669','0152163387','0806959347','0199192790','0199193673','0199193665','0199193681','0590461907','0199193657','019916035X','0516420666','0516420852','0516264753','1568362692','1568362676','0679886893','0399235981','0140563717','0516270001','0199160368')
20行処理されました。(63 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0199162204','0199160333','0439099064','0439317037','0199160376','0199160341','0199162174','0590461931','0590254960','059048513X','1568362684','0439179327','0590483692','0199162190','0199162980','0199162220','0199162956','0199162182','0590379305','0199162972')
20行処理されました。(62 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0590461915','0590689940','0590306995','0590254995','0439099080','0590379747','039921822X','0199162964','0199162212','0199162999','4834016498','076361503X','0763609102','0763609080','0679864407','014130670X','0199163006','0375802215','0199164347','0199160856')
20行処理されました。(94 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0064432106','015623811X','0763616133','0679894047','4834016420','0064442497','0763609099','0763609072','0064442403','067986444X','0590262653','0679864466','0679887202','0679887180','0679887172','0679871462','0679864415','0516270753','0516265423','0679891668')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'014050639X','0516270478','1568362641','0140371435','037581230','0370007743','0-590-26266-1','0064430758','0590254987','0590847791','0516420119','0448409704','0448418495','051642047X','044841967X','0763617121','0763610852','0763617296','0763610844','044842455X')
18行処理されました。(78 msec.)
--------------------------------------------------------------------------------
'0375813993','0789452154','0590485148','0516265458','0375810854','0516260782','0679894438','0516265431','0140552820','0375805087','0679864393','0806959355','0516436333','0679886508','0679864458','0439098564','0679881263','0448412942','0064442136','0199164355')
ERROR: parser: parse error at or near "'0375813993'" at character 1

--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0199160627','0199160643','0199185018','0064443159','0439099110','0590254979','0811827623','0448422999','0140508198','0679893873','0590259458','0199160635','0140365370','0590689975','0590371274','0590308599','0590120077','0140552987','0140567089','0689716885')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0062050141','019918500X','0679864423','0064442128','0064442438','0064430170','0064431916','0590449486','0201853315','0141302704','0199185026','0199174741','0439179335','0439200563','0064442640','0439098602','0448421844','0516420674','0375802843','006444273x')
19行処理されました。(79 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0590396382','0590635980','0439200598','0140545190','0141309059','0439099129','0590371282','0753452545','044841127X','0140383239','0374370923','0448412934','059026143','0590485881','0590673602','0201522098','006443348X','0899194214','0064430995','0140365397')
19行処理されました。(63 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0141309687','0140376534','0448425408','089919124X','0688087434','0060255668','0698118308','0140501193','0374461953','019916438X','006444046X','0439099102','0201193590','0590265865','0688132839','0679892532','0590262629','0312490836','0448409690','059025944X')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0199164371','0448413035','0140368523','0199160678','0448415666','0027863514','0199185042','0199160651','0199164363','0590719491','0099400022','014037857X','0582428688','0679887105','0808523120','0375803114','0199185050','0582448093','0064442314','0679808094')
18行処理されました。(141 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'020152208X','0439210372','0201522063','0140501207','0516265520','0439200571','059033072','0394882776','0140382941','0679839348','037000776x','0199192839','0199193703','059025944x','0201193655','0064442276','0140365400','0439416590','0064440729','0064440710')
17行処理されました。(94 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0448426226','019916066X','0199164339','0448419734','0590847783','0201190532','044840849X','0140365362','0448424568','0789452138','0199185034','0439205417','0201853574','0399213015','0448426382','0448409682','0140385398','0201853108','0394881826','0448424827')
20行処理されました。(156 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0448412950','0140381864','0439323150','0064442829','0448419963','0590439049','059044297','0448424983','0590221965','0140370005','0439321018','058242867X','0199160686','0142300195','044841306','0140380825','0448417162','0439206413','006444239x','0140501177')
16行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0448412578','0201853116','0201190583','0399215921','0439206367','0679811176','0689828985','044842472X','0201193604','0064435970','0140381880','0448424134','0688092349','0064442373','0590149040','0064432076','044840219','0395666112','0590870386','0582344085')
17行処理されました。(63 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0140386912','0448419661','0394895711','0679887024','0375806199','0679887067','0395390354','0394888677','0582428734','0375811176','0064434362','0064440508','0448407485','0064431622','0590457837','0590441868','0201853582','0679889914','043911425X','067989134X')
19行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0140380833','0448416050','0394896254','0394891279','0140369996','0439321026','0201853353','059045359','0590475002','0448405369','0199160716','0064437078','0312490313','0199164452','0448416425','0060207485','087406127X','0199165009','0140383522','0448417391')
19行処理されました。(94 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0140388206','0694009997','0416198546','059046437X','0439077834','0064441466','0590929534','0140387927','0064441768','0140378170','0141305770','0375828370','0140381899','0141304073','0448402238','0201853361','0448425440','0064442381','0064441458','0670867799')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in ('0395390338','0590738879','0395570352','0531071669','0721415636','0439098335','0140376240','0064440737','0448403803','0374399697','0448411482','0060226811','0448401576','0064443019','0064441024','1879085690','0064443027','0064441784','0064441423','0340698292')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in ('0448415682','0721415202','0064443035','0199161046','0721415628','0060239662','0199174903','0439098599','0064442462','0064441792','0064440850','0694013870','0064434877','0140384294','0064442284','1581342195','0064440575','0448421518','0689829523','0448419807')
20行処理されました。(79 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in ('0064451860','0064451003','0064450988','0194220214','0194220583','0064441431','0064442721','0679892303','067987366','068984431X','0199163219','0064440753','0194220737','019433547X','0375806652','0064440028','0064440370','0395389496','0064451240','0679812415')
18行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* level 0 */

update m_syuppan
set nm_yle = 0.501,
nm_yls = 0.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-07 01:00:00'
where nm_yle is null
and dt_isbn in (
'0448425998','0064442454','0698117727','0199166668','0064451798','0064441512','0064441032','006445178','0679874844','0064442802','0064440451','0064440516','0199163448','0064440044','0064440141','0199163286','0199166676','0199194750','0199161844','0199163294','0199194351')
20行処理されました。(94 msec.)
--------------------------------------------------------------------------------