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

商品詳細

[AD10000S] AD10000S RRｼｰﾁﾝｸﾞ

素材

100% COTTON DYED SHEETING

巾×長さ

90.0CM×12.0M

混率

C100%

在庫表

在庫
C/# 反数 M数
※数字は目安
KW
No Image
23 276
OW
No Image
53 636
KN
No Image
43 516
SKW
No Image
14 168
5
No Image
9 108
6
No Image
4 48
10
No Image
5 60
11
No Image
9 108
12
No Image
6 72
15
No Image
4 48
19
No Image
1 12
21
No Image
12 144
22
No Image
5 60
23
No Image
2 24
24
No Image
3 36
26
No Image
3 36
28
No Image
7 84
31
No Image
4 48
32
No Image
4 48
33
No Image
13 156
34
No Image
5 60
35
No Image
5 60
36
No Image
38
No Image
4 48
39
No Image
2 24
41
No Image
13 156
42
No Image
3 36
43
No Image
2 24
51
No Image
4 48
53
No Image
11 132
54
No Image
7 84
61
No Image
6 72
64
No Image
9 108
65
No Image
4 48
66
No Image
7 84
67
No Image
8 96
68
No Image
12 144
70
No Image
5 60
71
No Image
11 132
81
No Image
9 108
84
No Image
6 72
85
No Image
6 72
108
No Image
11 132
115
No Image
3 36
126
No Image
8 96
127
No Image
6 72
129
No Image
2 24
141
No Image
10 120
146
No Image
18 216
149
No Image
16 192
152
No Image
3 36
153
No Image
13 156
154
No Image
4 48
162
No Image
8 96
164
No Image
2 24
167
No Image
3 36
171
No Image
4 48
179
No Image
9 108
183
No Image
14 168
212
No Image
2 24
214
No Image
10 120
215
No Image
2 24
217
No Image
8 96
246
No Image
4 48
247
No Image
4 48
249
No Image
8 96
254
No Image
0 0
255
No Image
11 132
256
No Image
2 24
257
No Image
6 72
259
No Image
2 24
261
No Image
5 60
262
No Image
0 0
263
No Image
8 96
265
No Image
5 60
266
No Image
12 144
267
No Image
12 144
271
No Image
0 0
273
No Image
2 24
289
No Image
8 96
291
No Image
3 36
300
No Image
41 492
加工中／UP予定
7
/20		 7
/末		 8
/10		 8
/20		 8
/末		 9
/10		 9
/20		 9
/末		 10
/10
　　
フリー
在庫
23
53
43
14
9
4
5
9
6
4
1
12
5
2
3
3
7
4
4
13
5
5
0
4
2
13
3
2
4
11
7
6
9
4
7
8
12
5
11
9
6
6
11
3
8
6
2
10
18
16
3
13
4
8
2
3
4
9
14
2
10
2
8
4
4
8
0
11
2
6
2
5
0
8
5
12
12
0
2
8
3
41

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

Back

RECOMMEND ITEM