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

商品詳細

[AD10000L] AD10000L RRｼｰﾁﾝｸﾞ36M

素材

100% COTTON DYED SHEETING

巾×長さ

90.0CM×36.0M

混率

C100%

在庫表

在庫
C/# 反数 M数
※数字は目安
KW
No Image
17 612
OW
No Image
44 1584
KN
No Image
25 900
SKW
No Image
13 468
5
No Image
2 72
6
No Image
8 288
10
No Image
17 612
11
No Image
10 360
12
No Image
6 216
15
No Image
2 72
19
No Image
4 144
21
No Image
11 396
22
No Image
23 828
23
No Image
0 0
24
No Image
17 612
26
No Image
11 396
28
No Image
14 504
31
No Image
4 144
32
No Image
8 288
33
No Image
7 252
34
No Image
13 468
35
No Image
22 792
36
No Image
8 288
38
No Image
13 468
39
No Image
2 72
41
No Image
20 720
42
No Image
43
No Image
3 108
51
No Image
16 576
53
No Image
14 504
54
No Image
9 324
61
No Image
10 360
64
No Image
2 72
65
No Image
5 180
66
No Image
2 72
67
No Image
20 720
68
No Image
5 180
70
No Image
12 432
71
No Image
9 324
81
No Image
18 648
84
No Image
5 180
85
No Image
14 504
108
No Image
12 432
115
No Image
10 360
126
No Image
18 648
127
No Image
2 72
129
No Image
141
No Image
0 0
146
No Image
14 504
149
No Image
21 756
152
No Image
18 648
153
No Image
9 324
154
No Image
16 576
162
No Image
14 504
164
No Image
17 612
167
No Image
5 180
171
No Image
2 72
179
No Image
9 324
183
No Image
212
No Image
15 540
214
No Image
15 540
215
No Image
14 504
217
No Image
17 612
246
No Image
13 468
247
No Image
15 540
249
No Image
18 648
254
No Image
17 612
255
No Image
11 396
256
No Image
0 0
257
No Image
20 720
259
No Image
22 792
261
No Image
19 684
262
No Image
24 864
263
No Image
10 360
265
No Image
5 180
266
No Image
29 1044
267
No Image
7 252
271
No Image
0 0
273
No Image
10 360
289
No Image
12 432
291
No Image
18 648
300
No Image
28 1008
加工中／UP予定
5
/20		 5
/末		 6
/10		 6
/20		 6
/末		 7
/10		 7
/20		 7
/末		 8
/10
　　
フリー
在庫
17
44
25
13
2
8
17
10
6
2
4
11
23
0
17
11
14
4
8
7
13
22
8
13
2
20
0
3
16
14
9
10
2
5
2
20
5
12
9
18
5
14
12
10
18
2
0
0
14
21
18
9
16
14
17
5
2
9
0
15
15
14
17
13
15
18
17
11
0
20
22
19
24
10
5
29
7
0
10
12
18
28

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

Back

RECOMMEND ITEM