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

PRODUCTS SEARCH

商品詳細

[AK750] AK750 ﾍﾞﾝﾆｭｰﾋｯﾄ

素材

100% CUPRO LINING

巾×長さ

92.0CM×25.0M

混率

CU100%

在庫表

在庫
C/# 反数 M数
※数字は目安
KW
No Image
12 300
5
No Image
0 0
7
No Image
11
No Image
14
No Image
1 25
17
No Image
26
No Image
27
No Image
65
No Image
71
No Image
78
No Image
2 50
112
No Image
2 50
119
No Image
120
No Image
2 50
128
No Image
1 25
139
No Image
4 100
141
No Image
152
No Image
1 25
154
No Image
4 100
160
No Image
4 100
162
No Image
1 25
184
No Image
現物限り
191
No Image
231
No Image
1 25
234
No Image
239
No Image
1 25
242
No Image
1 25
255
No Image
0 0
263
No Image
3 75
266
No Image
2 50
271
No Image
0 0
279
No Image
289
No Image
294
No Image
315
No Image
322
No Image
361
No Image
5 125
363
No Image
2 50
364
No Image
4 100
393
No Image
401
No Image
410
No Image
458
No Image
1 25
494
No Image
1 25
496
No Image
517
No Image
531
No Image
0 0
545
No Image
5 125
580
No Image
現物限り
602
No Image
1 25
607
No Image
0 0
616
No Image
629
No Image
630
No Image
676
No Image
2 50
685
No Image
1 25
691
No Image
711
No Image
1 25
714
No Image
4 100
724
No Image
1 25
737
No Image
3 75
738
No Image
9 225
739
No Image
3 75
763
No Image
3 75
767
No Image
5 125
787
No Image
806
No Image
891
No Image
903
No Image
924
No Image
5 125
931
No Image
944
No Image
949
No Image
960
No Image
1 25
963
No Image
4 100
978
No Image
1 25
984
No Image
987
No Image
1 25
999
No Image
20 500
加工中／UP予定
5
/20		 5
/末		 6
/10		 6
/20		 6
/末		 7
/10		 7
/20		 7
/末		 8
/10
　　
フリー
在庫
12
0
0
0
1
0
0
0
0
0
2
2
0
2
1
4
0
1
4
4
1
0
0
1
0
1
1
0
3
2
0
0
0
0
0
0
5
2
4
0
0
0
1
1
0
0
0
5
0
1
0
0
0
0
2
1
0
1
4
1
3
9
3
3
5
0
0
0
0
5
0
0
0
1
4
1
0
1
20

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

Back

RECOMMEND ITEM