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

商品詳細

[310] 310 ｾﾗﾐｶｻﾃﾝ

素材

POLYESTER 100% SATIN

巾×長さ

92.0CM×25.0M

混率

P100%

在庫表

在庫
C/# 反数 M数
※数字は目安
FB
No Image
K
No Image
1
No Image
現物限り
2
No Image
3
No Image
現物限り
4
No Image
1 25
5
No Image
6
No Image
7
No Image
2 50
8
No Image
現物限り
9
No Image
現物限り
10
No Image
11
No Image
現物限り
12
No Image
現物限り
13
No Image
14
No Image
1 25
15
No Image
現物限り
16
No Image
現物限り
17
No Image
現物限り
18
No Image
1 25
19
No Image
現物限り
20
No Image
現物限り
21
No Image
2 50
22
No Image
現物限り
23
No Image
現物限り
25
No Image
26
No Image
現物限り
27
No Image
28
No Image
現物限り
29
No Image
30
No Image
1 25
31
No Image
現物限り
32
No Image
33
No Image
現物限り
34
No Image
現物限り
35
No Image
現物限り
36
No Image
37
No Image
0 0
38
No Image
現物限り
39
No Image
現物限り
40
No Image
現物限り
41
No Image
42
No Image
現物限り
43
No Image
現物限り
44
No Image
45
No Image
現物限り
46
No Image
1 25
47
No Image
現物限り
48
No Image
49
No Image
現物限り
50
No Image
現物限り
51
No Image
現物限り
52
No Image
現物限り
53
No Image
現物限り
54
No Image
現物限り
加工中／UP予定
5
/20		 5
/末		 6
/10		 6
/20		 6
/末		 7
/10		 7
/20		 7
/末		 8
/10
　　
フリー
在庫
0
0
0
0
0
1
0
0
2
0
0
0
0
0
0
1
0
0
0
1
0
0
2
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0

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

Back

RECOMMEND ITEM