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

商品詳細

[AL5200] AC5200 ｱｾｻﾃﾝ

素材

100%ACETATE SATIN

巾×長さ

92.0CM×23.0M

混率

AC100%

在庫表

在庫
C/# 反数 M数
※数字は目安
KW
No Image
43 989
2
No Image
3 69
6
No Image
31 713
12
No Image
32 736
13
No Image
14
No Image
41 943
15
No Image
5 115
16
No Image
36 828
18
No Image
20
No Image
67 1541
24
No Image
50 1150
25
No Image
35 805
29
No Image
84 1932
36
No Image
37
No Image
38
No Image
38 874
39
No Image
20 460
40
No Image
5 115
41
No Image
11 253
42
No Image
3 69
43
No Image
44
No Image
29 667
47
No Image
52 1196
48
No Image
49
No Image
20 460
50
No Image
52 1196
51
No Image
1 23
52
No Image
54
No Image
7 161
55
No Image
57
No Image
58
No Image
62
No Image
52 1196
63
No Image
65
No Image
6 138
66
No Image
28 644
67
No Image
30 690
68
No Image
42 966
71
No Image
41 943
72
No Image
49 1127
73
No Image
40 920
76
No Image
加工中／UP予定
5
/20		 5
/末		 6
/10		 6
/20		 6
/末		 7
/10		 7
/20		 7
/末		 8
/10
　　
フリー
在庫
43
3
31
32
0
41
5
36
0
67
50
35
84
0
0
38
20
5
11
3
0
29
52
0
20
52
1
0
7
0
0
0
52
0
6
28
30
42
41
49
40
0

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

Back

RECOMMEND ITEM