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 = 'AP4187' 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 = 'AP4187' 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 = 'AP4187' 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 = 'AP4187' 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 = 'AP4187' ORDER BY color.disp_sort ASCArray ( [hinban] => AP4187 [color] => 2A [del_plan_flag] => 0 [jpn_stock] => 13 [jpn_meter] => 540.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

[AP4187] AP4187 コバナブロードPT

素材

100% COTTON PRINTED BROAD

巾×長さ

110.0CM×40.0M

混率

C100%


在庫表

在庫
C/# 反数 M数
※数字は目安
2A
No Image
13 520
2B
No Image
3 120
2C
No Image
11 440
2D
No Image
21 840
6A
No Image
現物限り
6B
No Image
現物限り
6C
No Image
現物限り
6D
No Image
現物限り
6E
No Image
現物限り
8A
No Image
4 160
8B
No Image
5 200
8C
No Image
6 240
8D
No Image
9 360
8E
5 200
8F
1 40
10A
No Image
3 120
10B
No Image
現物限り
10C
No Image
4 160
10D
No Image
7 280
10E
No Image
10 400
11A
No Image
現物限り
11B
No Image
現物限り
11C
No Image
現物限り
11D
No Image
現物限り
11E
No Image
現物限り
13A
No Image
現物限り
13B
No Image
現物限り
13C
No Image
現物限り
13D
No Image
現物限り
13E
No Image
現物限り
14A
No Image
1 40
14B
No Image
4 160
14C
No Image
14D
No Image
3 120
14E
No Image
5 200
15A
No Image
現物限り
15B
No Image
現物限り
15C
No Image
現物限り
15D
No Image
現物限り
15E
No Image
現物限り
15F
No Image
現物限り
16A
No Image
現物限り
16B
No Image
現物限り
16C
No Image
現物限り
16D
No Image
現物限り
16E
No Image
現物限り
16F
No Image
現物限り
加工中/UP予定
7
/20
7
/末
8
/10
8
/20
8
/末
9
/10
9
/20
9
/末
10
/10
  
フリー
在庫
13
3
11
21
0
0
0
0
0
4
5
6
9
5
1
3
0
4
7
10
0
0
0
0
0
0
0
0
0
0
1
4
0
3
5
0
0
0
0
0
0
0
0
0
0
0
0

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