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 80, 20
Cosmetic packaging
Product
N3 617-2
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Pump : PCTA
Bottle : PETG
Base : PETG
N6 011-1S
Capacity : 8 ml
Type : Tottle
Material
Cap : PP (PCR Available)
Reducer : PE
Body : PE+EVOH (PCR Available)
N6 011
Capacity : 40 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : PE
Body : PE+EVOH (PCR Available)
N6 011-2
Capacity : 50 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : PE
Body : PE+EVOH (PCR Available)
N3 401F
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Nozzle : PP
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 403F
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Nozzle : PP
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 401-1F
Capacity : 35 ml
Type : Airless
Material
Cap : PETG
Nozzle : PP
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 402F
Capacity : 40 ml
Type : Airless
Material
Cap : PETG
Nozzle : PP
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 402-1F
Capacity : 45 ml
Type : Airless
Material
Cap : PETG
Nozzle : PP
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 328
Capacity : 30 ml
Type : Airless
Material
Cap : SAN
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 329
Capacity : 35 ml
Type : Airless
Material
Cap : SAN
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 330
Capacity : 40 ml
Type : Airless
Material
Cap : SAN
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 331
Capacity : 45 ml
Type : Airless
Material
Cap : SAN
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 332
Capacity : 50 ml
Type : Airless
Material
Cap : SAN
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 255-1
Capacity : 15 ml
Type : Airless
Material
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 255-2
Capacity : 20 ml
Type : Airless
Material
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 255
Capacity : 30 ml
Type : Airless
Material
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 257
Capacity : 40 ml
Type : Airless
Material
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 258-1
Capacity : 50 ml
Type : Airless
Material
Button : ABS
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 478 (RDB)
Capacity : 30 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/AL
Bottle : Glass
Download
Catalog