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 = 'A8000' 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 = 'A8000' 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 = 'A8000' 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 = 'A8000' 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 = 'A8000' ORDER BY color.disp_sort ASCArray ( [hinban] => A8000 [color] => FB [del_plan_flag] => 0 [jpn_stock] => 85 [jpn_meter] => 2125.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

商品詳細

[A8000] A8000 ﾃﾄﾛﾝｻﾃﾝ ﾗﾙ

素材

100%POLYESTER DYED SATIN

巾×長さ

92.0CM×25.0M

混率

P100%

在庫表

在庫
C/# 反数 M数
※数字は目安
FB
No Image
85 2125
2
No Image
26 650
5
No Image
5 125
7
No Image
22 550
16
No Image
17
No Image
18 450
18
No Image
2 50
26
No Image
18 450
34
No Image
36
No Image
3 75
45
No Image
18 450
46
No Image
39 975
49
No Image
17 425
53
No Image
25 625
60
No Image
7 175
61
No Image
27 675
64
No Image
37 925
65
No Image
6 150
67
No Image
50 1250
78
No Image
15 375
102
No Image
24 600
108
No Image
5 125
115
No Image
11 275
118
No Image
24 600
131
No Image
2 50
132
No Image
12 300
137
No Image
35 875
146
No Image
31 775
175
No Image
178
No Image
13 325
179
No Image
25 625
192
No Image
1 25
193
No Image
1 25
200
No Image
20 500
253
No Image
6 150
加工中／UP予定
5
/20		 5
/末		 6
/10		 6
/20		 6
/末		 7
/10		 7
/20		 7
/末		 8
/10
　　
フリー
在庫
85
26
5
22
0
18
2
18
0
3
18
39
17
25
7
27
37
6
50
15
24
5
11
24
2
12
35
31
0
13
25
1
1
20
6

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

Back

RECOMMEND ITEM