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 120, 20
Cosmetic packaging
Product
N3 567
Capacity : 15 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : PP
Bottle : SAN
N5 208A
Capacity : 20 ml
Type : Airless
Material
Cap : PP
Head : PP
Inner Bottle : PP
Outer Bottle : PP
Button : PP
Refill Cap : PP
N5 207A
Capacity : 20 ml
Type : Airless
Material
Cap : PP
Head : PP+Brush
Inner Bottle : PP
Outer Bottle : PP
Button : PP
Refill Cap : PP
N6 017FS
Capacity : 30 ml
Type : Tube
Material
Cap : PETG/ABS
Actuator : PP
Shoulder : ABS
Tube : PE+EVOH
N6 016
Capacity : 25 ml
Type : Tube
Material
Cap : PETG/ABS
Pump : PP/AL
Tube : PE/EVOH
N6 044EB
Capacity : 35 ml
Type : Tube
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner tube : PBL
Outer Case : PETG
N6 044E-4
Capacity : 40 ml
Type : Tube
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner tube : PE
Outer Case : PETG/PP
N6 044E-3
Capacity : 60 ml
Type : Tube
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner tube : PE
Outer Case : PETG/PP
N6 044E-2
Capacity : 35 ml
Type : Tube
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner tube : PBL
Outer Case : PETG
N3 006D
Capacity : 15 ml
Type : Airless
Material
Cap : PETG/ABS
Pump : PP/AL
Bottle : SAN/PETG
Base : HIPS
N3 006
Capacity : 15 ml
Type : Airless
Material
Cap : PETG/ABS
Pump : PP/AL
Bottle : SAN/PETG
Base : ABS
N3 009
Capacity : 30 ml
Type : Airless
Material
Cap : PETG/ABS
Pump : PP/AL
Bottle : SAN/PETG
Base : ABS
N3 012
Capacity : 45 ml
Type : Airless
Material
Cap : PETG/ABS
Pump : PP/AL
Bottle : SAN/PETG
Base : ABS
N3 013
Capacity : 50 ml
Type : Airless
Material
Cap : PETG/ABS
Pump : PP/AL
Bottle : SAN/PETG
Base : ABS
N3 013D
Capacity : 50 ml
Type : Airless
Material
Cap : PETG/ABS
Pump : PP/AL
Bottle : SAN/PETG
Base : HIPS
N3 001A
Capacity : 10 ml
Type : Dispenser
Material
Cap : ABS/SAN/PETG
Actuator : PP/AL
Shoulder : ABS
Outer Bottle : PETG/SAN
N3 002A
Capacity : 15 ml
Type : Dispenser
Material
Cap : ABS/SAN/PETG
Actuator : PP/AL
Shoulder : ABS
Outer Bottle : PETG/SAN
N3 003A
Capacity : 20 ml
Type : Dispenser
Material
Cap : ABS/SAN/PETG
Actuator : PP/AL
Shoulder : ABS
Outer Bottle : PETG/SAN
N3 004B
Capacity : 20 ml
Type : Dispenser
Material
Cap : ABS/SAN/PETG
Actuator : PP/AL
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : PETG/SAN
N3 006SD
Capacity : 15 ml
Type : Airless
Material
Cap : PETG/ABS
Actuator : PP/AL
Shoulder : ABS
Bottle : SAN/PETG
Base : HIPS
Download
Catalog