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 60, 20
Cosmetic packaging
Product
N2 138-2
Capacity : 4 ml
Type : Pallet
Material
Cover : ABS (Magnet)
Insert : ABS
Case : ABS
N2 138-1
Capacity : 1 ml
Type : Pallet
Material
Cover : ABS (Magnet)
Insert : ABS
Case : ABS
N2 133
Capacity : 12 ml
Type : Pallet
Material
Cover : ABS
Insert : ABS
Case : ABS
N2 023
Capacity : 10 ml
Type : Pallet
Material
Cover : PC
Case : ABS
N2 007
Capacity : 3 ml
Type : Pallet
Material
Cover : ABS
Insert : ABS / EVA
Case : ABS
N2 007-2P
Capacity : 7 ml
Type : Pallet
Material
Cover : ABS
Insert : ABS / EVA
Case : ABS
N2 004P
Capacity : 2 ml
Type : Pallet
Material
Cover : ABS/PMMA
Inner case: ABS
Outer Case : ABS
N2 004
Capacity : 2 ml
Type : Pallet
Material
Cover : ABS
Case : ABS
Insert : EVA
N1 169-2
Capacity : 5 ml
Type : Compact
Material
Upper case: ABS
Lower case: SAN
N6 200
Capacity : 15 ml
Type : Stick
Material
Cap : PET
Body : PP
Inner Cap : PP
Piston : PE
Dial : PP
Base : PETG
N6 235
Capacity : 80 ml
Type : Stick
Material
Cap : PP
Body : PP
Piston : PP
Dial : PP
N6 234
Capacity : 20 ml
Type : Stick
Material
Cap : ABS
Body : ABS
Piston : PP
N6 235-1
Capacity : 50 ml
Type : Stick
Material
Cap : PP
Body : PP
Piston : PP
Dial : PP
N3 302F
Capacity : 30 ml
Type : 5
Material
Actuator: PCTA
Shoulder Cap: PP
Bottle: SAN/PETG
Base: HIPS/PETG
N3 356
Capacity : 40 ml
Type : Airless
Material
Actuator: PCTA
Shoulder Cap: PP
Bottle: PP
Base: HIPS
N3 304F
Capacity : 50 ml
Type : Airless
Material
Actuator: PCTA
Shoulder Cap: PP
Bottle: SAN/PETG
Base: PETG
N3 356-1
Capacity : 40 ml
Type : Airless
Material
Over Cap: PETG
Actuator: PCTA
Shoulder : PP
Bottle: PP
Base: HIPS
N3 594 (LDP)
Capacity : 30 ml
Type : Dispenser
Material
Cap : PETG
Actuator : PP
Shoulder : PETG
Bottle : Blass
N3 659
Capacity : 30 ml
Type : 5
Material
Cap : PP
Actuator : PP
Pump : PP+PE (metal-free)
Shoulder : PP
Bottle : PP
Piston : TPE+PP
N3 618-2
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Pump : PCTA
Bottle : PETG
Base : PETG
Download
Catalog