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 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-2
Capacity : 120 ml
Type : Dispenser
Material
Fixing cap : ABS
Button : ABS
Inner bottle : PETG
Outer bottle : SAN
Base : ABS
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
SP18V-30RDAL
Capacity : 30 ml
Type : Dropper
Material
Button : ABS
Collar : ABS/AL.
Wiper : PE
Bottle : GLASS/AL.
Bottle : Glass
SP18S-BD30
Capacity : 30 ml
Type : Dropper
Material
Bulb : Silicon/NBR/TPE
Collar : PP/AL
Bottle : GLASS/ABS
SP18A-30SQ-NUDE
Capacity : 30 ml
Type : Dropper
Material
Bulb : Silicon/NBR/TPE
Collar : PP
Bottle : GLASS
SP13A-20T
Capacity : 20 ml
Type : Dropper
Material
Bulb : Silicon/NBR/TPE
Collar : PP
Bottle : GLASS
N6 272
Capacity : 20 ml
Type : Tube
Material
Cap: PP
Head: PP/SUS ball
Tube: PE/EVOH
N6 263-2
Capacity : 10 ml
Type : Stick
Material
Outer Cap : PET
Inner Cap : PP
Bottle : PP
Base : PP
Base Cover : PETG / PET
N6 214-1
Capacity : 30 ml
Type : Dropper
Material
Bulb : Silicon / NBR / TPE
Collar : ABS
Shoulder : ABS
Pipette : Glass
Bottle : PETG
N6 139
Capacity : 35 ml
Type : Tottle
Material
Outer cap : ABS
Inner cap : PP
Reducer : LDPE
Bottle : PE/EVOH
N6 139-3
Capacity : 140 ml
Type : Tottle
Material
Outer cap : ABS
Inner cap : PP
Reducer : LDPE
Bottle : PE/EVOH
N6 139-2
Capacity : 70 ml
Type : Tottle
Material
Outer cap : ABS
Inner cap : PP
Reducer : LDPE
Bottle : PE/EVOH
N6 139-1
Capacity : 60 ml
Type : Tottle
Material
Outer cap : ABS
Inner cap : PP
Reducer : LDPE
Bottle : PE/EVOH
N6 289
Capacity : 30 ml
Type : Dropper
Material
Bulb : TPE
Collar : PP
Pipette : PETG
Bottle : PETG
N6 289-1
Capacity : 50 ml
Type : Dropper
Material
Bulb : TPE
Collar : PP
Pipette : PETG
Bottle : PETG
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
N6 052
Capacity : 15 ml
Type : Stick
Material
Cap : PP
Body : PP
Download
Catalog