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("20210928s7jqc7if8c") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 20, 20
Cosmetic packaging
Product
N4 199
Capacity : 4 ml
Type : Powder Jar
Material
Ribbon : Nylon
Cap : ABS
Body : ABS
Puff : PU
Base : ABS
N5 378
Capacity : 4.5 ml
Type : Lip Stick
Material
Cap : ABS
Cone : AL.
Ring : ABS
Base : ABS
N5 379
Capacity : 2.5 ml
Type : Lip Stick (Dial)
Material
Cap : ABS
Cone : ABS
Ring : ABS
Body : ABS
Base : ABS
N5 378AL
Capacity : 4.5 ml
Type : Lip Stick
Material
Cap : AL.
Cone : AL.
Ring : ABS
Base : AL.
N5 378MG
Capacity : 4.5 ml
Type : Lip Stick
Material
Cap : ABS/AL.
Cone : AL.
Closer : Magnet
Base : ABS/AL.
N5 378-1AL
Capacity : 4 ml
Type : Lip Stick
Material
Cap : AL.
Cone : AL.
Ring : AL.
Base : AL.
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 355
Capacity : 15 ml
Type : Airless
Material
Actuator : PCTA
Shoulder : PP
Bottle : PP
Base : HIPS
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 208
Capacity : 15 ml
Type : Dropper
Material
Bulb : SILICONE/NBR
Cap : ABS/PMMA
Wiper : PE
Pipette : GLASS
Bottle : PETG
Download
Catalog