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 filter REGEXP("t10") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 0, 20
Cosmetic packaging
Product
N4 517
Capacity : 10 ml
Type : Powder Jar
Material
Cap : ABS
Sifter : PP
Jar : SAN
N4 017
Capacity : 50 ml
Type : Powder Jar
Material
Cap : ABS
Jar : SAN
N4 199
Capacity : 4 ml
Type : Powder Jar
Material
Ribbon : Nylon
Cap : ABS
Body : ABS
Puff : PU
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
N1 169-1
Capacity : 8 ml
Type : Powder Jar
Material
Cover : ABS
Lid : LDPE
Base : ABS
N4 510
Capacity : 20 ml
Type : Powder Jar (Ball blusher)
Material
Cover : ABS
Case : PMMA
N4 517-2H
Capacity : 25 ml
Type : Powder Jar
Material
Cap : ABS
Middle Cap : PP
Mesh : Nylon
Jar : SAN
N4 517-1H
Capacity : 20 ml
Type : Powder Jar
Material
Cap : ABS
Middle Cap : PP
Mesh : Nylon
Jar : SAN
N4 517H
Capacity : 10 ml
Type : Powder Jar
Material
Cap : ABS
Middle Cap : PP
Mesh : Nylon
Jar : SAN
N4 511
Capacity : 10 ml
Type : Powder Jar
Material
Cap : ABS
Jar : SAN
N4 007P
Capacity : 2 ml
Type : Powder Jar
Material
Cap : ABS
Sifter : PE
Jar : SAN
N4 316P
Capacity : 5 ml
Type : Powder Jar
Material
Cap : ABS
Sifter : PE
Jar : SAN
N4 001
Capacity : 2 ml
Type : 99
Material
Cap : ABS
Sifter : PE
Bottle : SAN
N4 200-2
Capacity : 2.5 ml
Type : Powder Jar
Material
Cap : ABS
Shoulder : ABS
Jar : SAN
N4 201-2
Capacity : 5 ml
Type : Powder Jar
Material
Cap : ABS
Shoulder : ABS
Jar : SAN
N4 202-4
Capacity : 7 ml
Type : Powder Jar
Material
Cap : ABS
Shoulder : ABS
Jar : SAN
N4 202
Capacity : 10 ml
Type : Powder Jar
Material
Cap : ABS (with mirror)
Shoulder : ABS
Jar : SAN
N4 203
Capacity : 15 ml
Type : Powder Jar
Material
Cap : ABS
Shoulder : ABS
Jar : SAN
Download
Catalog