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("20210928qqh7i9z8ef") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 200, 20
Cosmetic packaging
Product
AP20A-10A
Capacity : 10 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AP18HA-15B
Capacity : 15 ml
Type : Screw Bottle
Material
Cap : PP/AL
Bottle : GLASS
AU18H-7B
Capacity : 7 ml
Type : Dropper (Auto-Fill)
Material
Plate : AL
Dropper : ABS/PP
Pipette : Glass
Bottle : Glass
AU18H-10B
Capacity : 10 ml
Type : Dropper (Auto-Fill)
Material
Plate : AL
Dropper : ABS/PP
Pipette : Glass
Bottle : Glass
AU18H(R)-12B
Capacity : 12 ml
Type : Dropper (Auto-Fill)
Material
Dropper : ABS/PP
Pipette : Glass
Bottle : Glass
AU18H(R)-7B
Capacity : 7 ml
Type : Dropper (Auto-Fill)
Material
Dropper : ABS/PP
Pipette : Glass
Bottle : Glass
AU18H(R)-15B
Capacity : 15 ml
Type : 3
Material
Dropper : ABS/PP
Pipette : Glass
Bottle : Glass
N6 114
Capacity : 30 ml
Type : Dropper (Auto-Fill)
Material
Plate : AL
Dropper : ABS/PP
Pipette : Glass
Wiper : PE
Bottle : Glass
N6 114-1
Capacity : 30 ml
Type : Dropper (Auto-Fill)
Material
Plate : AL
Dropper : ABS/PP
Pipette : Glass
Wiper : PE
Bottle : Glass
DM2-10A
Capacity : 10 ml
Type : Dropper (Powder Mix)
Material
Powder Cap : PP
Cap : PP(PCR)/AL
Bottle : Glass
DM2-7A
Capacity : 7 ml
Type : Dropper (Powder Mix)
Material
Powder Cap : PP
Cap : PP(PCR)/AL
Bottle : Glass
SP20A-7A
Capacity : 7 ml
Type : Dropper
Material
Bulb : Silicon/NBR/TPE
Collar : PP(PCR)/AL
Bottle : Glass
SP20A-10A
Capacity : 10 ml
Type : Dropper
Material
Bulb : Silicon/NBR/TPE
Collar : PP(PCR)/AL
Bottle : Glass
N4 317
Capacity : 50 ml
Type : Cream Jar
Material
Outer Cap : PMMA
Inner Cap : ABS/PP
Lid : PE
Inner Jar : PP
Outer Jar : PMMA
N4 317-1
Capacity : 30 ml
Type : Cream Jar
Material
Outer Cap : PMMA
Inner Cap : ABS/PP
Lid : PE
Inner Jar : PP
Outer Jar : PMMA
N3 236E
Capacity : 40 ml
Type : Airless
Material
Cap : PETG
Pump : PP/ABS
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : SAN
N3 236-1E
Capacity : 130 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/ABS
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : SAN
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
Download
Catalog