Notice (8): Undefined index: native_type [CORE/Cake/Model/Datasource/Database/Postgres.php, line 758]
Notice (8): Undefined index: native_type [CORE/Cake/Model/Datasource/Database/Postgres.php, line 758]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
CakePHP: the rapid development php framework: Errors

Database Error

Error: SQLSTATE[HY000]: General error: 7 no connection to the server

SQL Query: SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70935') and i_delete is not true;

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
(default) 16 queries took 95 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70527') and i_delete is not true; 1116
2SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70548') and i_delete is not true; 117
3SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('167974') and i_delete is not true; 116
4SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('135412') and i_delete is not true; 116
5SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70816') and i_delete is not true; 116
6SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70755') and i_delete is not true; 116
7SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70743') and i_delete is not true; 115
8SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70957') and i_delete is not true; 114
9SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70983') and i_delete is not true; 114
10SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('162187') and i_delete is not true; 004
11SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('162185') and i_delete is not true; 114
12SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('70892') and i_delete is not true; 114
13SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('110475') and i_delete is not true; 114
14SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1～4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('152530') and i_delete is not true; 114