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 = 'AD70000' 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 = 'AD70000' 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 = 'AD70000' 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 = 'AD70000' 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 = 'AD70000' ORDER BY color.disp_sort ASCArray ( [hinban] => AD70000 [color] => KW [del_plan_flag] => 0 [jpn_stock] => 27 [jpn_meter] => 459.0 [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

商品詳細

[AD70000] AD70000 ｶﾗｰ ﾊﾝﾌﾟ

素材

100% COTTON DYED CANVAS

巾×長さ

92.0CM×17.0M

混率

C100%

在庫表

在庫
C/# 反数 M数
※数字は目安
KW
No Image
27 459
1
No Image
4 68
2
No Image
20 340
5
No Image
17 289
10
No Image
5 85
36
No Image
33 561
62
No Image
26 442
81
No Image
108
No Image
17 289
126
No Image
34 578
128
No Image
22 374
134
No Image
19 323
142
No Image
12 204
152
No Image
7 119
166
No Image
8 136
174
No Image
29 493
183
No Image
27 459
211
No Image
13 221
212
No Image
28 476
217
No Image
0 0
249
No Image
0 0
256
No Image
16 272
266
No Image
11 187
275
No Image
現物限り
284
No Image
7 119
300
No Image
57 969
加工中／UP予定
5
/末		 6
/10		 6
/20		 6
/末		 7
/10		 7
/20		 7
/末		 8
/10		 8
/20
　　
フリー
在庫
27
4
20
17
5
33
26
0
17
34
22
19
12
7
8
29
27
13
28
0
0
16
11
0
7
57

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

Back

RECOMMEND ITEM