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 filter REGEXP("t6") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 0, 20
Cosmetic packaging
Product
SP18V-30RDAL
Capacity : 30 ml
Type : Dropper
Material
Button : ABS
Collar : ABS/AL.
Wiper : PE
Bottle : GLASS/AL.
Bottle : Glass
SP18S-BD30
Capacity : 30 ml
Type : Dropper
Material
Bulb : Silicon/NBR/TPE
Collar : PP/AL
Bottle : GLASS/ABS
SP18A-30SQ-NUDE
Capacity : 30 ml
Type : Dropper
Material
Bulb : Silicon/NBR/TPE
Collar : PP
Bottle : GLASS
SP13A-20T
Capacity : 20 ml
Type : Dropper
Material
Bulb : Silicon/NBR/TPE
Collar : PP
Bottle : GLASS
N6 214-1
Capacity : 30 ml
Type : Dropper
Material
Bulb : Silicon / NBR / TPE
Collar : ABS
Shoulder : ABS
Pipette : Glass
Bottle : PETG
N6 289
Capacity : 30 ml
Type : Dropper
Material
Bulb : TPE
Collar : PP
Pipette : PETG
Bottle : PETG
N6 289-1
Capacity : 50 ml
Type : Dropper
Material
Bulb : TPE
Collar : PP
Pipette : PETG
Bottle : PETG
N6 209
Capacity : 30 ml
Type : Dropper
Material
Bulb : SILICONE/NBR
Pipette : GLASS
Wiper : PE
Cap : PP
Bottle : PETG
N6 208
Capacity : 15 ml
Type : Dropper
Material
Bulb : SILICONE/NBR
Cap : ABS/PMMA
Wiper : PE
Pipette : GLASS
Bottle : PETG
NRG 18 (15ml)
Capacity : 15 ml
Type : Dropper (Roll-on)
Material
Cap : PETG/PP
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 18 (10ml)
Capacity : 10 ml
Type : Dropper (Roll-on)
Material
Cap : PETG/PP
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 18 (5ml)
Capacity : 5 ml
Type : Dropper (Roll-on)
Material
Cap : PETG/PP
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 15 (5ml)
Capacity : 5 ml
Type : Dropper (Roll-on)
Material
Cap : PP/AL
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 15 (7ml)
Capacity : 7 ml
Type : Dropper (Roll-on)
Material
Cap : PP/AL
Ball : SUS
Holder : PE
Bottle : GLASS
NRG 15 (10ml)
Capacity : 10 ml
Type : Dropper (Roll-on)
Material
Cap : PP/AL
Ball : SUS
Holder : PE
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
Download
Catalog