SELECT color.hinban, color.color, color.del_plan_flag, zaiko.jpn_stock, zaiko.jpn_meter ,zaiko.up7_2,zaiko.up7_3,zaiko.up8_1,zaiko.up8_2,zaiko.up8_3,zaiko.up9_1,zaiko.up9_2,zaiko.up9_3,zaiko.up10_1 FROM color LEFT JOIN ( SELECT z1.id, z1.hinban, z1.color, z1.jpn_stock, z1.jpn_meter ,z2.up7_2,z2.up7_3,z2.up8_1,z2.up8_2,z2.up8_3,z2.up9_1,z2.up9_2,z2.up9_3,z2.up10_1 FROM ( SELECT z_all.id, z_all.hinban, z_all.color, z_all.jpn_stock, z_all.jpn_meter FROM hcd_shop.zaiko AS z_all LEFT JOIN ( SELECT id, hinban, color, shubetsu, jpn_stock, jpn_meter FROM hcd_shop.zaiko WHERE shubetsu = '現物' AND hinban = 'AK3400' GROUP BY hinban,color ) AS z_genbutsu ON z_all.hinban = z_genbutsu.hinban AND z_all.color = z_genbutsu.color WHERE z_all.hinban = 'AK3400' GROUP BY z_all.hinban,z_all.color ) AS z1, ( SELECT z_all.hinban, z_all.color ,z_kakou1.up7_2,z_kakou1.up7_3,z_kakou1.up8_1,z_kakou1.up8_2,z_kakou1.up8_3,z_kakou1.up9_1,z_kakou1.up9_2,z_kakou1.up9_3,z_kakou1.up10_1 FROM hcd_shop.zaiko AS z_all LEFT JOIN ( SELECT hinban, color ,sum(up7_2) AS up7_2,sum(up7_3) AS up7_3,sum(up8_1) AS up8_1,sum(up8_2) AS up8_2,sum(up8_3) AS up8_3,sum(up9_1) AS up9_1,sum(up9_2) AS up9_2,sum(up9_3) AS up9_3,sum(up10_1) AS up10_1 FROM hcd_shop.zaiko WHERE shubetsu = '加工中' AND hinban = 'AK3400' AND year = DATE_FORMAT(NOW(),'%Y') GROUP BY hinban,color ) AS z_kakou1 ON z_all.hinban = z_kakou1.hinban AND z_all.color = z_kakou1.color WHERE z_all.hinban = 'AK3400' GROUP BY z_all.hinban,z_all.color ) AS z2 WHERE (z1.hinban = z2.hinban AND z1.color = z2.color)) zaiko ON color.hinban = zaiko.hinban AND color.color = zaiko.color WHERE color.hinban = 'AK3400' ORDER BY color.disp_sort ASCArray ( [hinban] => AK3400 [color] => KW [del_plan_flag] => 0 [jpn_stock] => 19 [jpn_meter] => 531.0 [up7_2] => [up7_3] => [up8_1] => [up8_2] => [up8_3] => [up9_1] => [up9_2] => [up9_3] => [up10_1] => ) PRODUCTS SEARCH | コスモテキスタイル株式会社 FOR HOME HOBBY
コスモテキスタイル株式会社

PRODUCTS SEARCH

商品詳細

[AK3400] AK3400 ﾍﾞﾝｴﾐｰﾙ

素材

100% CUPRO LINING

巾×長さ

92.0CM×25.0M

混率

CU100%

在庫表

在庫
C/# 反数 M数
※数字は目安
KW
No Image
19 475
5
No Image
18
No Image
27
No Image
78
No Image
91
No Image
112
No Image
124
No Image
1 25
139
No Image
145
No Image
147
No Image
1 25
152
No Image
154
No Image
162
No Image
163
No Image
173
No Image
185
No Image
現物限り
231
No Image
239
No Image
241
No Image
現物限り
253
No Image
263
No Image
286
No Image
351
No Image
361
No Image
364
No Image
496
No Image
1 25
531
No Image
602
No Image
607
No Image
685
No Image
現物限り
707
No Image
711
No Image
714
No Image
737
No Image
738
No Image
1 25
739
No Image
763
No Image
767
No Image
880
No Image
924
No Image
944
No Image
978
No Image
980
No Image
現物限り
986
No Image
987
No Image
999
No Image
加工中／UP予定
7
/20		 7
/末		 8
/10		 8
/20		 8
/末		 9
/10		 9
/20		 9
/末		 10
/10
　　
フリー
在庫
19
0
0
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0

※M以外は反数単位で表示となります。
※原反在庫は30分ごとに更新しています。
※カット反の有無は1日1度、朝に更新した情報です。

Back

RECOMMEND ITEM