SELECT color.hinban, color.color, color.del_plan_flag, zaiko.jpn_stock, zaiko.jpn_meter ,zaiko.up5_3,zaiko.up6_1,zaiko.up6_2,zaiko.up6_3,zaiko.up7_1,zaiko.up7_2,zaiko.up7_3,zaiko.up8_1,zaiko.up8_2 FROM color LEFT JOIN ( SELECT z1.id, z1.hinban, z1.color, z1.jpn_stock, z1.jpn_meter ,z2.up5_3,z2.up6_1,z2.up6_2,z2.up6_3,z2.up7_1,z2.up7_2,z2.up7_3,z2.up8_1,z2.up8_2 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 = 'AD5188' 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 = 'AD5188' GROUP BY z_all.hinban,z_all.color ) AS z1, ( SELECT z_all.hinban, z_all.color ,z_kakou1.up5_3,z_kakou1.up6_1,z_kakou1.up6_2,z_kakou1.up6_3,z_kakou1.up7_1,z_kakou1.up7_2,z_kakou1.up7_3,z_kakou1.up8_1,z_kakou1.up8_2 FROM hcd_shop.zaiko AS z_all LEFT JOIN ( SELECT hinban, color ,sum(up5_3) AS up5_3,sum(up6_1) AS up6_1,sum(up6_2) AS up6_2,sum(up6_3) AS up6_3,sum(up7_1) AS up7_1,sum(up7_2) AS up7_2,sum(up7_3) AS up7_3,sum(up8_1) AS up8_1,sum(up8_2) AS up8_2 FROM hcd_shop.zaiko WHERE shubetsu = '加工中' AND hinban = 'AD5188' 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 = 'AD5188' 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 = 'AD5188' ORDER BY color.disp_sort ASCArray ( [hinban] => AD5188 [color] => OW [del_plan_flag] => 0 [jpn_stock] => [jpn_meter] => [up5_3] => [up6_1] => [up6_2] => [up6_3] => [up7_1] => [up7_2] => [up7_3] => [up8_1] => [up8_2] => ) PRODUCTS SEARCH | コスモテキスタイル株式会社 FOR HOME HOBBY
コスモテキスタイル株式会社

PRODUCTS SEARCH

商品詳細

[AD5188] AD5188 ｼﾌﾞﾐ CLｷｬﾝﾊﾞｽ

素材

C/L 85/15% DYED CANVAS

巾×長さ

108.0CM×36.0M

混率

C85%L15%

在庫表

在庫
C/# 反数 M数
※数字は目安
OW
No Image
KN
No Image
5
No Image
11
No Image
12
No Image
24
No Image
36
No Image
65
No Image
68
No Image
109
No Image
137
No Image
142
No Image
158
No Image
174
No Image
180
No Image
184
No Image
217
No Image
256
No Image
261
No Image
266
No Image
273
No Image
300
No Image
加工中／UP予定
5
/末		 6
/10		 6
/20		 6
/末		 7
/10		 7
/20		 7
/末		 8
/10		 8
/20
　　
フリー
在庫
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

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

Back

RECOMMEND ITEM