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 product.viewYn in (1,3) ORDER BY registdate desc LIMIT 100, 20
Cosmetic packaging
Product
N3 555
Capacity : 30 ml
Type : Airless
Material
Pump : ABS/PP
Inner Bottle : PP
Outer Bottle : SAN
Base : ABS
N6 208
Capacity : 15 ml
Type : Dropper
Material
Bulb : SILICONE/NBR
Cap : ABS/PMMA
Wiper : PE
Pipette : GLASS
Bottle : PETG
N4 455
Capacity : 50 ml
Type : Cream Jar
Material
Cap : PETG/ABS/PP
Lid : LLDPE
Inner Jar : PP
Outer Jar : PMMA
N4 454
Capacity : 30 ml
Type : Cream Jar
Material
Cap : PETG/ABS/PP
Lid : LLDPE
Inner Jar : PP
Outer Jar : PMMA
N4 545
Capacity : 10 ml
Type : Cream Jar
Material
Cap : PP
Inner jar : PP
Outer Jar : SAN
N4 522-1U
Capacity : 50 ml
Type : Cream Jar
Material
Outer cap : PMMA / ABS
Inner cap : ABS / PP
Lid : LLDPE
Inner jar : PP
Outer jar : PMMA
N4 522-2U
Capacity : 30 ml
Type : Cream Jar
Material
Outer cap : PMMA / ABS
Inner cap : ABS / PP
Lid : LLDPE
Inner jar : PP
Outer jar : PMMA
N4 519
Capacity : 50 ml
Type : Cream Jar
Material
Outer cap : ABS
Inner cap : PP
Lid : LLDPE
Inner jar : PP
Outer jar : PMMA
N4 519-1A
Capacity : 30 ml
Type : Cream Jar
Material
Outer cap : ABS
Inner cap : PP
Lid : LLDPE
Inner jar : PP
Outer jar : PMMA
N4 317A
Capacity : 50 ml
Type : Cream Jar
Material
Cap : ABS/PP
Lid : LLDPE
Inner Jar : PP
Outer Jar : PMMA
N4 309-1
Capacity : 30 ml
Type : Cream Jar
Material
Outer Cap : ABS
Inner Cap : PP
Lid : LLDPE
Shoulder : ABS
Inner Jar : PP
Outer Jar : SAN
N4 309
Capacity : 50 ml
Type : Cream Jar
Material
Outer cap : PMMA
Inner cap : PP
Shoulder : ABS
Lid : LLDPE
Inner jar : PP
Outer jar : PMMA
N4 218
Capacity : 30 ml
Type : Cream Jar
Material
Outer cap : PMMA
Inner cap : PP
Shoulder : ABS
Lid : LLDPE
Inner jar : PP
Outer jar : PMMA
N3 234-1
Capacity : 140 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/AL.
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : PMMA
N4 217
Capacity : 140 ml
Type : Screw Bottle
Material
Outer cap : PMMA
Inner cap : PP
Shoulder : ABS
Inner bottle : PETG
Outer bottle : PMMA
N3 234
Capacity : 45 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/AL.
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : PMMA
N3 233
Capacity : 35 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/AL.
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : PMMA
N3 232
Capacity : 25 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/AL.
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : PMMA
N4 216
Capacity : 50 ml
Type : Cream Jar
Material
Cap : PMMA/PP
Lid : LLDPE
Shoulder : ABS
Inner Jar : PP
Outer Jar : PMMA
N4 215
Capacity : 30 ml
Type : Cream Jar
Material
Cap : PMMA/PP
Lid : LLDPE
Shoulder : ABS
Inner Jar : PP
Outer Jar : PMMA
Download
Catalog