[掲示板: SSSサイト に関する掲示板 -- 最新メッセージID: 1767 // 時刻: 2024/11/23(19:37)]
上へ | 前のメッセージへ | 次のメッセージへ | ここから後の返答を全表示 | 返答を書き込む | 訂正する | 削除する
277. Special Thanks to Mr. FOON!!!!!
お名前: 古川@SSS http://www.seg.co.jp/
投稿日: 2004/5/5(11:35)
------------------------------
ふーんさんの絶大なる努力によって、
読みやすさレベルをとりあえず、復活させることができました。
感謝 感謝 感謝 です。
おかげで、YLで検索が可能となったはずです。
編集委員のみなさんへ
個別に内容をチェックしてみて下さい。
---------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.1,
nm_yls= 0.1
where nm_yle is null
and dt_isbn in ('00582406552','0192721232','0199192774','0199192804','0199192812','0199197180','0199197199','0199197202','0199197210','0199197229','0199197237','0582406420','0582406439','0582406463','0582406471','058240648X','0582406498','0582406560','0582406579','0582406587')
19行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.1,
nm_yls= 0.1
where nm_yle is null
and dt_isbn in ('0582406595','0582406609','0582406617','0582406625','0582406633','0689817312','0698116496','0749829850')
8行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.2,
nm_yls= 0.2
where nm_yle is null
and dt_isbn in ('006444211X','009941399X','0170095371','017009538X','0170095398','017009540','017009541X','0170095428','0170095436','0170095444','0170095452','0170095460','0199197296','019919730X','0199197318','0199197326','0199197334','0199197342','0448413043','0582406641')
19行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.2,
nm_yls= 0.2
where nm_yle is null
and dt_isbn in ('058240665X','0582406668','0582406676','0582406684','0582406692','0582406706','0582406714','0582406722','059074240X','0590930028','9620045416','9620045505','9620063953','962006402X')
14行処理されました。(46 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.3,
nm_yls= 0.3
where nm_yle is null
and dt_isbn in ('0064436160','0064442675','0064442888','0199160392','0199160406','0199160414','0199160422','0199160600','0199160619','0199162328','0199162336','0199162344','0199162352','0199162360','0199162379','0199163022','0199163030','0199163049','0199163057','0199163065')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.3,
nm_yls= 0.3
where nm_yle is null
and dt_isbn in ('0199163073','0199197407','0199197415','0199197423','0199197431','019919744X','0199197458','030726100X','0582406730','0582406749','0582406757','0582406765','0582406773','0582406781','058240679X','0582406803','0582406811','0590461923','0590501968','0688042864')
15行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.3,
nm_yls= 0.3
where nm_yle is null
and dt_isbn in ('0694012203','0694015164','9620079515','9620079558')
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.4,
nm_yls= 0.4
where nm_yle is null
and dt_isbn in ('0439067553','043920139X','058240657','058240682X','0582406838','0582406846','0582406854','0582406862','0582406889','0582406897','0582406900','059026267X','0590480871','0590483765','059073878X','0590738798','0679864431','0694000876','0786813512')
10行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.5,
nm_yls= 0.5
where nm_yle is null
and dt_isbn in ('0064440958','0064450961','0099504812','0170096262','0199160694','0199160708','0199160724','0199160732','0199164436','0199164444','0199164460','0199164487','0199164991','0199165017','0199165025','0199165033','0199165041','0316692204','0395557011','0416188915')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.5,
nm_yls= 0.5
where nm_yle is null
and dt_isbn in ('0416188931','0416196527','0416196535','043927057X','0439471524','0440406935','0590331272','0590457160','0590460269','0679889205','0689858523','073641208','0736412263','0736421319')
13行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.6,
nm_yls= 0.6
where nm_yle is null
and dt_isbn in ('0064440087','0064442470','0064442977','0170096246','0170096254','0170096289','0170096297','0170096300','0170096319','017009632','0170096335','0199169632','0199169640','0199169659','0199169667','0439050227','0582407486','0582407494','0582407508','058240751')
15行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.6,
nm_yls= 0.6
where nm_yle is null
and dt_isbn in ('0582407524','0582407532','0582407540','0582407559','0582407567','0689713533','0736412131','0736413537','0811812375','1569317917')
5行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.7,
nm_yls= 0.7
where nm_yle is null
and dt_isbn in ('0170096270','0199163243','0374416893','0582407575','0582407583','0582407591','0582407605','0582407613','058240762','058240763X','0582407648','0582407656')
11行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.8,
nm_yls= 0.8
where nm_yle is null
and dt_isbn in ('0006640613','0064432815','0064440362','0064451054','0064451216','0140505466','0152427309','0316930911','0439250536','0618077022','0694008397')
11行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 0.9,
nm_yls= 0.9
where nm_yle is null
and dt_isbn in ('0007147325','0374477175','058246420X','0582464218','0582464226','0582464234','0582464242','0582464250','0618260102','0672509288','0753456044','0753456095')
6行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.1,
nm_yls= 1.1
where nm_yle is null
and dt_isbn in ('0143519719','01943335461','0394839129','0439160197','0439160200','0439160219','0439160227','0679892478','1558581790')
8行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.2,
nm_yls= 1.2
where nm_yle is null
and dt_isbn in ('0060503572','0064442020','0140567712','0194335356','019433791X','0439173051','0516263102','0516271520','0516271741','0516271776','0516273779','0590972197','0749742720','0773761373','0778708918','1587172178','483401648X')
17行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.3,
nm_yls= 1.3
where nm_yle is null
and dt_isbn in ('0516274996')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.4,
nm_yls= 1.4
where nm_yle is null
and dt_isbn in ('0140553568','0194337928','0316110698','0375806989','0440409675','0448428326','0582464277','0582464285','0582464293','0582464307','0582464315','0582464323','0679885749','0689845065','0863150500','0940793881','4834016447')
11行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.5,
nm_yls= 1.5
where nm_yle is null
and dt_isbn in ('0064451232','043917306X','044046126X','0670058831','0679884645','0689835183','0689835191','0689835442','0689855850','0698116755','1740518942','1740518977')
10行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.6,
nm_yls= 1.6
where nm_yle is null
and dt_isbn in ('0199105227','0375804080','0375804102','0375806024','0440413818','058246434X','0582464358','0582464366','0582464374','0582464382','0582464390','0590383973','0679838783','0679880844','0698114388','0749748249')
10行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.7,
nm_yls= 1.7
where nm_yle is null
and dt_isbn in ('0064451151','0316106194','0316110493','0316110744','0316112917','0316112933','0679847375')
7行処理されました。(46 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.8,
nm_yls= 1.8
where nm_yle is null
and dt_isbn in ('0064442586','0064451542','0440401682','0440410150','0440413028','0516271784','0516273760','0582464447','0582464455','0582464463','0582464471','058246448X','0582464498','0618051511','067987318X')
9行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 1.9,
nm_yls= 1.9
where nm_yle is null
and dt_isbn in ('0027440001','0060261803','006445102X','0064451119','0316110582','038097827X','0399212833','0440410134','0590307207','0679889558')
10行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 2.0,
nm_yls= 2.0
where nm_yle is null
and dt_isbn in ('0060544422','0064430340','0064443132','009975200X','0140502769','0142500356','0394865871','0395629772','0395837324','0399241663','0448401606','0448412632','0448413388','0448413396','044841340X','0816642451','0833548506','0891098445','0899190359')
19行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 2.2,
nm_yls= 2.2
where nm_yle is null
and dt_isbn in ('0060278587','0064450023','0064451356')
3行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 2.4,
nm_yls= 2.4
where nm_yle is null
and dt_isbn in ('0060256575','0060256710','0064431851','0080239697','0090003277','0099825104','009989940X','0140372571','0140566473','0192724053','0439409756','0439588650','0448413418','0448415607','0552548243','0590265903','0590691252','0670888168','0679890017','0689839162')
19行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 2.4,
nm_yls= 2.4
where nm_yle is null
and dt_isbn in ('0689855532','0749835915','0749835931','0763613789','0843115483','0863150756','0891098437','0891098453','0899191924','0899193137','1551432315','1568363044','4770022921')
13行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 2.6,
nm_yls= 2.6
where nm_yle is null
and dt_isbn in ('0064421740','0099413221','0140545476','0141315091','0141315989','0224064940','037580272','0439219477','0448412608','0448417499','0448425467','0582463742','0582463750','0582463769','058246451X','0582464528','0582464536','0613020537','0679890521','0688122655')
12行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 2.6,
nm_yls= 2.6
where nm_yle is null
and dt_isbn in ('0689711530','0698115996','1405202386','1563056267','1865085634')
5行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 2.8,
nm_yls= 2.8
where nm_yle is null
and dt_isbn in ('0060097914','0060097930','0099400774','0448412616','0448412624','0448417367','0448418762','0516422839','0582463785','0582463793','0582463807','0582463823','0582463831','058246384X','0671637916','0689838808','0698115694','0744590396','0749748672','0761315993')
13行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 2.8,
nm_yls= 2.8
where nm_yle is null
and dt_isbn in ('156402525X')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 3.0,
nm_yls= 3.0
where nm_yle is null
and dt_isbn in ('0060006706','006447044X','0091768012','014050172X','0141302291','0141316020','0330400177','0394891171','0439340136','044842682X','0516200682','0516259636','0516260758','0516261460','0516264664','0516265334','0516269771','0516269984','0516269992','0516270419')
20行処理されました。(94 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 3.0,
nm_yls= 3.0
where nm_yle is null
and dt_isbn in ('0516271717','0516271725','0516271733','0516272853','0516278126','0516278142','0516279130','0516422715','0516422723','051642274X','0516422766','0516422774','0516422782','0516422847','0516422928','0516422944','0516422952','0516422960','0516422979','0516422987')
20行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 3.0,
nm_yls= 3.0
where nm_yle is null
and dt_isbn in ('0516422995','0552548235','0590226398','0590444778','059045854X','0590849026','0618152458','0670340839','0679824111','0679890548','0689310528','0689710569','0689841736','0689843496','0689851081','0698116526','0723247706','0723284075','074457241X','0749704691')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 3.0,
nm_yls= 3.0
where nm_yle is null
and dt_isbn in ('074974672','0763621811','0891098461','1405201347','155143248X','1862915431','4140393041','4774303100')
7行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 3.2,
nm_yls= 3.2
where nm_yle is null
and dt_isbn in ('0007141912','0060244003','0061065846','0486403467','0516262432','051626351X','0516269755','0516269763','051626978X','0516270400','0516278134','0516422758','0516422790','051642291X','0516422936','0751304387','0765109514')
17行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 3.4,
nm_yls= 3.4
where nm_yle is null
and dt_isbn in ('0140375724','0316106917','0330271830','0399219900','0440418453','0448426838','0525458263','059043411X1990','068984980X','0749742240')
9行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 3.6,
nm_yls= 3.6
where nm_yle is null
and dt_isbn in ('0060266082','0064430464','0140544429','0141302283','0141304642','0375810471','0394910249','0395536243','0396087981','0399231900','0679815260','0688162673','0713628979','0749704306','0887763804','0887764363','0887764371','1551432153')
18行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 3.8,
nm_yls= 3.8
where nm_yle is null
and dt_isbn in ('0060092092','0140507566','0141301139','0316120243','0316120944','0316121053','0380810484','0395311292','0440403278','0440418461','0590213113','0679808558','0688115691','0689806698','0786813350','082340417X','1562821113','1582700737')
17行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 4.0,
nm_yls= 4.0
where nm_yle is null
and dt_isbn in ('0091816971','0141314508','0316139874','0316910333','0316911488','0340727586','0375415114','0375810838','0380709120','0380709155','038070921X','0380709554','0380732726','0380807343','0380834510','0395959195','0399212582','0439182972','0439182980','043920772X')
20行処理されました。(94 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 4.0,
nm_yls= 4.0
where nm_yle is null
and dt_isbn in ('0439207843','0439207851','043920786X','043930606X','0439306078','0440400872','0440401003','0440402891','0440402913','0440408520','0440413842','0440863384','0531071111','0553272535','0590108395','0590108409','0590108417','0590108425','0590108433','0590108441')
19行処理されました。(110 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 4.0,
nm_yls= 4.0
where nm_yle is null
and dt_isbn in ('0590428330','0670806226','0689827849','0689828683','0689860102','0743244281','0762411201','0781432928','0805068473','0888995199','1558860134','1841217891')
12行処理されました。(94 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 4.2,
nm_yls= 4.2
where nm_yle is null
and dt_isbn in ('0192752626','0340727772','0345335902','0440416485','0440416515','0688117058','0688840531')
7行処理されました。(93 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 4.5,
nm_yls= 4.5
where nm_yle is null
and dt_isbn in ('0064430871','014036837X','0140502017','0141301155','0143300474','0152938230','0192752308','0330398253','0345335686','0394805720','0439974291','0440400597','0440411459','0590406191','0590460757','0679833722','0679887369','068983585X','0689851863','0786814470')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 4.5,
nm_yls= 4.5
where nm_yle is null
and dt_isbn in ('0789464985','0805072314','1569716110')
3行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 5.0,
nm_yls= 5.0
where nm_yle is null
and dt_isbn in ('0060540745','0064405176','006440868X','0064408698','0064408701','0140363254','0141310200','0141310219','0141310901','0141312289','014250050X','0192718371','0380811065','0439130220','0439317150','0439339685','0439425085','0439425093','074343059X','0744536812')
20行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 5.0,
nm_yls= 5.0
where nm_yle is null
and dt_isbn in ('0802786561','0812930185','1892213974')
3行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 5.5,
nm_yls= 5.5
where nm_yle is null
and dt_isbn in ('014030942x','0140320970','0152025413','0679444769','4834031373')
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 5.7,
nm_yls= 5.7
where nm_yle is null
and dt_isbn in ('0152025294')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 6.0,
nm_yls= 6.0
where nm_yle is null
and dt_isbn in ('0142300705','0152008691','0192718096','0295976160','0312982577','0486275434','0671027581','0816769362','1562012541')
9行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 6.5,
nm_yls= 6.5
where nm_yle is null
and dt_isbn in ('0330482068','0330482076','0836213122','1858817625')
4行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 7.0,
nm_yls= 7.0
where nm_yle is null
and dt_isbn in ('0140622373','0312958641','0380733358','0552545929','0743444523','0786887842','0786888512')
7行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 7.5,
nm_yls= 7.5
where nm_yle is null
and dt_isbn in ('0007155018','0345370775','0446353957','0451205421','0553571702','0689846223')
6行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 8.0,
nm_yls= 8.0
where nm_yle is null
and dt_isbn in ('0195202198','0312955006','0441001866','0671743058')
4行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 8.5,
nm_yls= 8.5
where nm_yle is null
and dt_isbn in ('0198600887','0312963416')
2行処理されました。(32 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_yle= 9.0,
nm_yls= 9.0
where nm_yle is null
and dt_isbn in ('0352336420','038072152X','0451169530')
3行処理されました。(47 msec.)
--------------------------------------------------------------------------------
▲返答元
▼返答