select product.* , attacheFiles.filename as listfilename , attacheFiles.filename_org as listfilename_org , attacheFiles.filename_alt as listfilename_alt from product left outer join attacheFiles on product.no = attacheFiles.common_fk and attacheFiles.tablename = 'product' and concat(attacheFiles.fileobject,attacheFiles.filename_index) = 'imagename1' where 1 = 1 AND categoryFk REGEXP("20210928qqh7i9z8ef") AND filter REGEXP("t7") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 0, 20
Cosmetic packaging
Product
N6 272
Capacity : 20 ml
Type : Tube
Material
Cap: PP
Head: PP/SUS ball
Tube: PE/EVOH
N6 172-25SSP (White Paper Tube)
Capacity : 30 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-30FP (White Paper Tube)
Capacity : 50 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-50FP (White Paper Tube)
Capacity : 180 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 017FS
Capacity : 30 ml
Type : Tube
Material
Cap : PETG/ABS
Actuator : PP
Shoulder : ABS
Tube : PE+EVOH
N6 016
Capacity : 25 ml
Type : Tube
Material
Cap : PETG/ABS
Pump : PP/AL
Tube : PE/EVOH
N6 044EB
Capacity : 35 ml
Type : Tube
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner tube : PBL
Outer Case : PETG
N6 044E-4
Capacity : 40 ml
Type : Tube
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner tube : PE
Outer Case : PETG/PP
N6 044E-3
Capacity : 60 ml
Type : Tube
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner tube : PE
Outer Case : PETG/PP
N6 044E-2
Capacity : 35 ml
Type : Tube
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner tube : PBL
Outer Case : PETG
N6 172-30FMP (Mono PE Tube)
Capacity : 30 ml
Type : Tube
Material
Cap : PE
Head : PE
Tube : PE / Bio based PE
N6 172-25SMP (Mono PE Tube)
Capacity : 15 ml
Type : Tube
Material
Cap : PE
Head : PE
Tube : PE / Bio based PE
N6 172-40FMP (Mono PE Tube)
Capacity : 100 ml
Type : Tube
Material
Cap : PE
Head : PE
Tube : PE / Bio based PE
N6 172-45FMP (Mono PE Tube)
Capacity : 150 ml
Type : Tube
Material
Cap : PE
Head : PE
Tube : PE / Bio based PE
N6 172-30OSP (Paper Tube)
Capacity : 50 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-25SP (Paper Tube)
Capacity : 30 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-35SP (Paper Tube)
Capacity : 45 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-45FP (Paper Tube)
Capacity : 120 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 237 (RST)
Capacity : 50 ml
Type : Tube
Material
Cap : PP
Roller : SUS316
Shoulder : PP
Button : POM
Tube : LDPE+EVOH
N6 237E
Capacity : 50 ml
Type : Tube
Material
Cap : PP
Roller : TPE
Shoulder : PP
Side Button : POM
Tube : LDPE+EVOH
Download
Catalog