review data の読みやすさレベル　設定

本日の書籍データ　Reivew データ　の修正作業です。

１　書籍データに　お薦め度がはいっていない本（１冊）のおすすめ度を４にしました。

２　書籍データのおすすめ度平均が０となっているデータのうち
　　書評数が０のものは、　おすすめ平均＝書評委員のおすすめ度
　　となるべきなので、そのように設定し直しました。（553件）

３　書籍データに書評委員推定の読みやすさ範囲がはいっている
　　ものについては、
　　　　読みやすさレベルの平均＝（ＹＬ下限値＋ＹＬ上限値）/２
　　としました。（4217件）

４　新システムでは、ＹＬの平均は
　　　書評委員２票　Review者１票　による　ＹＬ評価の平均
　　で計算します。しかし、旧システムからの移行データには
　　Review 者のＹＬ評価がはいっていないため、
　　　REVIEWのＹＬ評価　＝　書籍データの平均レベル
　　としました。（ただし、多少　手を抜いて移行してあります）

　　（疑問　新システム　で YL評価の　棄権　はできないのか？
　　　棄権ができるのなら　null　値の場合、平均評価から抜くべき）

５　以上の操作により、書籍データ(m_syuppan)の YL が正しく設定
　　されているものについては、正しく平均ＹＬ　が表示されるように
　　なるはずです。

update m_syuppan
set nm_osusume = 4
where nm_osusume is null

1行処理されました。(32 msec.)
--------------------------------------------------------------------------------
update m_syuppan
set nm_review = 0
where nm_review is null

0行処理されました。(15 msec.)
--------------------------------------------------------------------------------
/* osususume heikin no saisettei */

update m_syuppan
set nm_osusume_a = nm_osusume
where nm_osusume_a = 0
and nm_review = 0

553行処理されました。(218 msec.)
----------------------------------------------------------------------
--------------------------------------------------------------------------------/* YL heikin no saisettei */

update m_syuppan
set nm_yl_a = (nm_yls + nm_yle)/2
where nm_yls is not null
and nm_yle is not null

4217行処理されました。(5203 msec.)
----------------------------------------------------------------------
----------------------------------------------------------------------
update m_review
set nm_yl = 0.1
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.1 and 0.1999
and nm_yle is not null )
5行処理されました。(94 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.2
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.2 and 0.2999
and nm_yle is not null )

6行処理されました。(141 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.3
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.3 and 0.3999
and nm_yle is not null )

29行処理されました。(187 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.4
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.4 and 0.4999
and nm_yle is not null )

10行処理されました。(125 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.5 and 0.5999
and nm_yle is not null )

286行処理されました。(1203 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.6
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.6 and 0.6999
and nm_yle is not null )

2行処理されました。(125 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.7
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.7 and 0.7999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.8
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.8 and 0.8999
and nm_yle is not null )

174行処理されました。(235 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 0.9
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 0.9 and 0.9999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.0 and 1.09999
and nm_yle is not null )

125行処理されました。(219 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.1
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.1 and 1.19999
and nm_yle is not null )

1行処理されました。(94 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.2
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.2 and 1.29999
and nm_yle is not null )

56行処理されました。(203 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.3
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.3 and 1.39999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.4
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.4 and 1.49999
and nm_yle is not null )

0行処理されました。(63 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.5 and 1.59999
and nm_yle is not null )

314行処理されました。(875 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.6
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.6 and 1.69999
and nm_yle is not null )

21行処理されました。(172 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.7
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.7 and 1.79999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.8
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.8 and 1.89999
and nm_yle is not null )

0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 1.9
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 1.9 and 1.99999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.0 and 2.099999
and nm_yle is not null )

172行処理されました。(219 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.1
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.1 and 2.199999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.2
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.2 and 2.299999
and nm_yle is not null )

86行処理されました。(157 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.3
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.3 and 2.399999
and nm_yle is not null )

0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.4
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.4 and 2.499999
and nm_yle is not null )

252行処理されました。(344 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.5 and 2.599999
and nm_yle is not null )

348行処理されました。(797 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.6
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.6 and 2.699999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.7
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.7 and 2.799999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.8
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.8 and 2.899999
and nm_yle is not null )

0行処理されました。(46 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 2.9
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 2.9 and 2.999999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.0 and 3.0999999
and nm_yle is not null )

34行処理されました。(187 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.1
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.1 and 3.1999999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.2
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.2 and 3.2999999
and nm_yle is not null )

429行処理されました。(422 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.3
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.3 and 3.3999999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.4
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.4 and 3.4999999
and nm_yle is not null )

4行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.5 and 3.5999999
and nm_yle is not null )

366行処理されました。(578 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.6
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.6 and 3.6999999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.7
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.7 and 3.7999999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.8
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.8 and 3.8999999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 3.9
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 3.9 and 3.9999999
and nm_yle is not null )

0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 4.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 4.0 and 4.49999999
and nm_yle is not null )

183行処理されました。(266 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 4.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 4.5 and 4.99999999
and nm_yle is not null )

433行処理されました。(1219 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 5.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 5.0 and 5.499999999
and nm_yle is not null )

83行処理されました。(218 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 5.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 5.5 and 5.999999999
and nm_yle is not null )

184行処理されました。(297 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 6.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 6.0 and 6.499999
and nm_yle is not null )

63行処理されました。(172 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 6.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 6.5 and 6.999999
and nm_yle is not null )

105行処理されました。(187 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 7.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 7.0 and 7.4999999
and nm_yle is not null )

4行処理されました。(94 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 7.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 7.5 and 7.999999
and nm_yle is not null )

29行処理されました。(141 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 8.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 8.0 and 8.49999
and nm_yle is not null )

1行処理されました。(62 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 8.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 8.5 and 8.99999
and nm_yle is not null )

24行処理されました。(125 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 9.0
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 9.0 and 9.4999
and nm_yle is not null )

0行処理されました。(47 msec.)
--------------------------------------------------------------------------------
update m_review
set nm_yl = 9.5
where nm_yl= 0
and cd_syuppan
in (select cd_syuppan from m_syuppan
where nm_yl_a between 9.5 and 9.9999
and nm_yle is not null )

49行処理されました。(141 msec.)
--------------------------------------------------------------------------------