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("t4") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 0, 20
Cosmetic packaging
Product
N3 101
Capacity : 130 ml
Type : Screw Bottle
Material
Outer Cap : PMMA
Middle Cap : ABS
Inner Cap : PP
Shoulder : ABS
Inner Bottle : PCTA
Outer Bottle : PMMA
N4 532A
Capacity : 20 ml
Type : Screw Bottle
Material
Cap : ABS
Reducer : PE
Bottle : PET
N4 217
Capacity : 140 ml
Type : Screw Bottle
Material
Outer cap : PMMA
Inner cap : PP
Shoulder : ABS
Inner bottle : PETG
Outer bottle : PMMA
N4 609-1
Capacity : 150 ml
Type : Screw Bottle
Material
Cap : ABS/PP
Reducer: LDPE
Bottle : PETG
N6 155-2
Capacity : 30 ml
Type : Roll-On
Material
Cap : PP
Ball : PP
Bottle : PE/Adhesive/EVOH
N6 155-1
Capacity : 100 ml
Type : Roll-On
Material
Cap : PP
Ball : PP
Bottle : PE/Adhesive/EVOH
N6 142
Capacity : 50 ml
Type : Roll-On
Material
Cap : PP
Ball : PP
Bottle : PE/Adhesive/EVOH
N4 618-2
Capacity : 100 ml
Type : Screw Bottle
Material
Cap : ABS/PP
Reducer : PE
Bottle : PET
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
AP20A-10A
Capacity : 10 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP18HA-15B
Capacity : 15 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
N4 214-1
Capacity : 100 ml
Type : Screw Bottle
Material
Cap : ABS/PMMA
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : PMMA
N4 214
Capacity : 130 ml
Type : Screw Bottle
Material
Cap : ABS/PMMA
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : PMMA
Download
Catalog