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("t1_") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 0, 20
Cosmetic packaging
Product
N3 288P
Capacity : 20 ml
Type : Airless
Material
Cap : PETG
Nozzle Tip : Silicone
Spring : SUS-304
Inner Bottle : PP
Outer Bottle : PETG
Base : PP
N3 133-1
Capacity : 110 ml
Type : Airless
Material
Fixing cap : ABS
Button : ABS
Inner bottle : PP
Outer bottle : SAN
Base : ABS
N3 133
Capacity : 50 ml
Type : Airless
Material
Fixing cap : ABS
Button : ABS
Inner bottle : PP
Outer bottle : SAN
Base : ABS
N3 667
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Pump : PP
Bottle : PETG
Base : PETG
N3 667-1
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Pump : PP
Bottle : PETG
Base : PETG
N3 166
Capacity : 35 ml
Type : Airless
Material
Cap : PETG
Button : PP
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : SAN / PETG
Base : ABS
N3 167
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Button : PP
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : SAN / PETG
Base : ABS
N3 414A
Capacity : 50 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 344S
Capacity : 30 ml
Type : Airless
Material
Cap: PP / PETG
Pump: PP
Bottle: PP / PETG
Base: PETG
N3 344-1
Capacity : 50 ml
Type : Airless
Material
Cap: PP / PETG
Pump: PP
Bottle: PP / PETG
Base: PETG
N3 174-1H
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Button : PP
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : PETG
Base : ABS / SAN
N3 173-1H
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Button : PP
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : PETG
Base : ABS / SAN
N3 016S
Capacity : 100 ml
Type : Airless
Material
Over Cap: PETG/ABS
Actuator : PP / AL.
Shoulder : ABS
Bottle : SAN / PETG
Base : ABS
N3 014S
Capacity : 60 ml
Type : Airless
Material
Over Cap: PETG/ABS
Actuator : PP / AL.
Shoulder : ABS
Bottle : SAN / PETG
Base : ABS
N3 204-1
Capacity : 40 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 204A
Capacity : 30 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 414-3A
Capacity : 150 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 414-2A
Capacity : 100 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 204-5
Capacity : 15 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 204-4
Capacity : 50 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
Download
Catalog