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 180, 20
Cosmetic packaging
Product
N4 611-1 (OCR)
Capacity : 50 ml
Type : Cream Jar (Refillable)
Material
Cap : ABS
Lid : PE
Inner Jar : PP
Outer Jar : SAN
N4 611 (OCR)
Capacity : 30 ml
Type : Cream Jar (Refillable)
Material
Cap : ABS
Lid : PE
Inner Jar : PP
Outer Jar : SAN
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
N4 618-2
Capacity : 100 ml
Type : Screw Bottle
Material
Cap : ABS/PP
Reducer : PE
Bottle : PET
NRG 18 (15ml)
Capacity : 15 ml
Type : Dropper (Roll-on)
Material
Cap : PETG/PP
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 18 (10ml)
Capacity : 10 ml
Type : Dropper (Roll-on)
Material
Cap : PETG/PP
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 18 (5ml)
Capacity : 5 ml
Type : Dropper (Roll-on)
Material
Cap : PETG/PP
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 15 (5ml)
Capacity : 5 ml
Type : Dropper (Roll-on)
Material
Cap : PP/AL
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 15 (7ml)
Capacity : 7 ml
Type : Dropper (Roll-on)
Material
Cap : PP/AL
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 15 (10ml)
Capacity : 10 ml
Type : Dropper (Roll-on)
Material
Cap : PP/AL
Ball : SUS
Holder : PE
Bottle : GLASS
AP10A-2A
Capacity : 2 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP13HA-5A
Capacity : 5 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP13HA-5B
Capacity : 5 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP10A-3A
Capacity : 3 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP13HA-3B
Capacity : 3 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP13A-10B
Capacity : 10 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP18HA-10B
Capacity : 10 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP20A-7A
Capacity : 7 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
Download
Catalog