![[報告]](/keijiban/kb7/icon/aip2_note.gif){kind=icon}
283. 仕分け結果 ▼ [Raquel] 2004/5/5(14:57)
- 291. 早速 修正しました。 [古川＠SSS] 2004/5/5(19:21)
[掲示板: SSSサイト に関する掲示板 -- 最新メッセージID: 1767 // 時刻: 2024/6/18(22:14)]
283. 仕分け結果 ▼ [Raquel] 2004/5/5(14:57)
上へ
| 
前のメッセージへ
| 
次のメッセージへ
| 
ここから後の返答を全表示
| 
返答を書き込む
| 
訂正する
| 
削除する
お名前: Raquel
投稿日: 2004/5/5(14:57)
------------------------------
古川さん
下記のように、初版年度別に仕分けしてみました。
出版年度の古い物に関しては、ちょっと自信がないのですが。。。
2004
'0439559634','1591161878','1591826330','1591826349','3898858219',
'4140350644'
2003
'0007159196','006051485X','0194244008','0375806164','0375813691',
'038097827X','0439339677','0439339685','043935806X','0439376106',
'0439376122','0439425085','0439425093','0552547123','0582451671',
'0582788943','0670058831','068984980X','0689851081','0744590396',
'0747569401','1569319006','1569319022','159116057X','1591161134',
'1591161703','1591161711','159116172X','1591161789','1591161827',
'3551759618','3551759626','4140350636','4534035721','4872431529',
2002
'0060006706','0060092092','0064473023','014250050X','0194220583',
'0194220737','0194244008','0307264122','0312289871','0340767960',
'0375806113','0375806148','0375806156','0375813675','0375823778',
'0380807343','0385335881','0439201675','0439306078','0439317142',
'0439317150','0439317169','0439317177','0439321026','0439376068',
'0439409756','0439434866','051513287X','0531165604','0590881930',
'0590881949','0689841299','0689842945','0689843593','0735817022',
'0743422732','0743437616','0743437667','0743474325','0747560293',
'0763617121','0763617296','0786845422','0786868163','0888995199',
'1551432153','155143248X','1569315302','1569317917','3551759634',
'4805306777'
2001
'0060934417','0064443035','0199108285','0312980159','0312981589',
'0312982577','0330482068','0340767944','0375762051','0375802215',
'0375802681','0375802983','0375802991','0375804307','0375811176',
'0375813179','0375813551','0375815643','0439050006','0439130263',
'0439130352','0439207851','043920786X','0439235669','0439250536',
'043930606X','0440238412','044086416X','0451205626','0515131229',
'0515132020','0552547093','0553580515','0553582755','0582468876',
'0582468922','0590879979','0590880748','0590880780','0671042017',
'0671042025','0679890696','067989070X','0679892303','0689838824',
'0689841361','0689855532','0698119347','0743406931','0747557012',
'076361503X','0763616133','0773761373','0812575393','1841218588',
2000
'0064435970','0064443159','0385720955','0439139600','0439216486',
'0440416507','0440864151','0671027573','0689836023','0698119169',
'0753456044','0753456095','0763612316','1400031885'
1999
'0064472272','0439136369','0439231493','0689851987','0743436210',
'1405204214'
1997
'0064443183'
1996
'0140566198','0440418062'
1994
'0060503572','0743444523'
1993
'1405200901'
1987
'0199161844'
1982
'0141315989'
1980
'0141312335'
1970
'0007115601'
1955
'0439010365'
1930
'0448095017'
該当なし
〉0073641208 2004 Pooh's Easter Egg Hunt (Disney)
ISBN 0736412085 の間違い？ 2001年
〉0552211583 2004 Dying to Tell
ISBN '0552148776' か？ 2001年
〉0582829844 2004 Stories of Courage
不明
ISBNが抜けていた物
〉'0439130255' 2001 Taking Chances
以上です。
＃タイトルの間違いも、一つ揚げておきます。
0375813179 2004 Kurassic ParkIII: Rescue Mission
→ Jurassic Park
上へ
| 前のメッセージへ
| 次のメッセージへ
| 
ここから後の返答を全表示
| 返答を書き込む
| 訂正する
| 削除する
お名前: 古川＠SSS http://www.seg.co.jp/
投稿日: 2004/5/5(19:21)
------------------------------
古川です。 Raquel さん ありがとうございます。
これだけ調べるのはとても時間がかかったことと思います。
早速修正しました。
＃ふーんさんとRaquel さんへ いつか 食事をおごらさせて下さい。
-----------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2004'
where dt_isbn in (
'0439559634','1591161878','1591826330','1591826349','3898858219',
'4140350644'
)
6行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2003'
where dt_isbn in (
'0007159196','006051485X','0194244008','0375806164','0375813691',
'038097827X','0439339677','0439339685','043935806X','0439376106',
'0439376122','0439425085','0439425093','0552547123','0582451671',
'0582788943','0670058831','068984980X','0689851081','0744590396',
'0747569401','1569319006','1569319022','159116057X','1591161134',
'1591161703','1591161711','159116172X','1591161789','1591161827',
'3551759618','3551759626','4140350636','4534035721','4872431529'
)
35行処理されました。(109 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2004'
where dt_isbn in (
'0439559634','1591161878','1591826330','1591826349','3898858219',
'4140350644'
)
6行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2003'
where dt_isbn in (
'0007159196','006051485X','0194244008','0375806164','0375813691',
'038097827X','0439339677','0439339685','043935806X','0439376106',
'0439376122','0439425085','0439425093','0552547123','0582451671',
'0582788943','0670058831','068984980X','0689851081','0744590396',
'0747569401','1569319006','1569319022','159116057X','1591161134',
'1591161703','1591161711','159116172X','1591161789','1591161827',
'3551759618','3551759626','4140350636','4534035721','4872431529'
)
35行処理されました。(110 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2002'
where dt_isbn in (
'0060006706','0060092092','0064473023','014250050X','0194220583',
'0194220737','0194244008','0307264122','0312289871','0340767960',
'0375806113','0375806148','0375806156','0375813675','0375823778',
'0380807343','0385335881','0439201675','0439306078','0439317142',
'0439317150','0439317169','0439317177','0439321026','0439376068',
'0439409756','0439434866','051513287X','0531165604','0590881930',
'0590881949','0689841299','0689842945','0689843593','0735817022',
'0743422732','0743437616','0743437667','0743474325','0747560293',
'0763617121','0763617296','0786845422','0786868163','0888995199',
'1551432153','155143248X','1569315302','1569317917','3551759634',
'4805306777'
)
51行処理されました。(172 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2001'
where dt_isbn in (
'0060934417','0064443035','0199108285','0312980159','0312981589',
'0312982577','0330482068','0340767944','0375762051','0375802215',
'0375802681','0375802983','0375802991','0375804307','0375811176',
'0375813179','0375813551','0375815643','0439050006','0439130263',
'0439130352','0439207851','043920786X','0439235669','0439250536',
'043930606X','0440238412','044086416X','0451205626','0515131229',
'0515132020','0552547093','0553580515','0553582755','0582468876',
'0582468922','0590879979','0590880748','0590880780','0671042017',
'0671042025','0679890696','067989070X','0679892303','0689838824',
'0689841361','0689855532','0698119347','0743406931','0747557012',
'076361503X','0763616133','0773761373','0812575393','1841218588'
)
55行処理されました。(172 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2000'
where dt_isbn in (
'0064435970','0064443159','0385720955','0439139600','0439216486',
'0440416507','0440864151','0671027573','0689836023','0698119169',
'0753456044','0753456095','0763612316','1400031885'
)
14行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1999'
where dt_isbn in (
'0064472272','0439136369','0439231493','0689851987','0743436210',
'1405204214'
)
6行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1997'
where dt_isbn in ('0064443183')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1996'
where dt_isbn in('0140566198','0440418062')
2行処理されました。(32 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1994'
where dt_isbn in('0060503572','0743444523')
2行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1993'
where dt_isbn in('1405200901')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1987'
where dt_isbn in('0199161844')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1982'
where dt_isbn in('0141315989')
1行処理されました。(16 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1980'
where dt_isbn in('0141312335')
1行処理されました。(15 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1970'
where dt_isbn in('0007115601')
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1955'
where dt_isbn in('0439010365')
1行処理されました。(32 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='1930'
where dt_isbn = '0141315989'
1行処理されました。(15 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2001',
dt_isbn = '0736412085'
where dt_isbn = '0073641208'
1行処理されました。(16 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
da_syohan ='2001',
dt_isbn = '0552148776'
where dt_isbn = '0552211583'
1行処理されました。(16 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set dt_kuser ='0000138',
dt_kpg = 'PSqlEdit',
dt_kdate = '2004-05-05 19:00:00',
dt_syuppan = 'Jurassic ParkIII: Rescue Mission'
where dt_isbn ='0375813179'
1行処理されました。(31 msec.)
--------------------------------------------------------------------------------