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 80, 20
Cosmetic packaging
Product
N5 378-1
Capacity : 4 ml
Type : Lip Stick
Material
Cap : ABS
Cone : AL.
Ring : ABS
Base : ABS
N5 288
Capacity : 8.5 ml
Type : Stick
Material
Cap : PP/AL.
Body : AL.
Base : ABS/AL.
N5 376-2
Capacity : 2 ml
Type : Stick
Material
Cap : ABS
Body : ABS
Base : ABS
N5 376-1
Capacity : 4 ml
Type : Stick
Material
Cap : ABS
Body : ABS
Base : ABS
N5 376
Capacity : 10 ml
Type : Stick
Material
Cap : ABS
Body : ABS
Brush holder : ABS
Brush : Nylon
N5 377
Capacity : 4 ml
Type : Stick
Material
Cap : ABS
Body : ABS
Base : ABS
N5 332
Capacity : 7 ml
Type : Stick (Brush/Puff)
Material
Cap : ABS
Applicator : NBR(Puff) / Nylon(Brush)
Body : ABS
N3 210
Capacity : 50 ml
Type : Airless
Material
Button : ASA
Outer Bottle : PETG
Inner Bottle : PP
Bottle Base : ABS
N3 355
Capacity : 15 ml
Type : Airless
Material
Actuator : PCTA
Shoulder : PP
Bottle : PP
Base : HIPS
N3 015S
Capacity : 80 ml
Type : Airless
Material
Over cap : SAN/ABS/PETG
Pump : PP/AL.
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS/HIPS/PETG
N3 106-1
Capacity : 200 ml
Type : Dispenser
Material
Button : ABS
Fixing cap : ABS
Inner bottle : PETG
Outer Bottle : SAN / PETG
N5 330B
Capacity : 2 ml
Type : Stick
Material
Cap : ABS
Body : ABS
Base : ABS
N5 330A
Capacity : 4 ml
Type : Stick
Material
Cap : ABS
Body : ABS
Base : ABS
N5 330
Capacity : 9 ml
Type : Stick
Material
Cap : ABS
Body : ABS
Base : ABS
N4 516-1
Capacity : 20 ml
Type : Powder Jar
Material
Cap : ABS
Sifter : LLDPE
Jar : PMMA / SAN
N4 516
Capacity : 10 ml
Type : Powder Jar
Material
Cap : ABS
Sifter : LLDPE
Jar : PMMA / SAN
N6 209
Capacity : 30 ml
Type : Dropper
Material
Bulb : SILICONE/NBR
Pipette : GLASS
Wiper : PE
Cap : PP
Bottle : PETG
N4 532A
Capacity : 20 ml
Type : Screw Bottle
Material
Cap : ABS
Reducer : PE
Bottle : PET
N3 555-2
Capacity : 120 ml
Type : Airless
Material
Pump : ABS/PP
Inner Bottle : PP
Outer Bottle : SAN
Base : ABS
N3 555-1
Capacity : 50 ml
Type : Airless
Material
Pump : ABS/PP
Inner Bottle : PP
Outer Bottle : SAN
Base : ABS
Download
Catalog