select pump.* , attacheFiles.filename as listfilename , attacheFiles.filename_org as listfilename_org , attacheFiles.filename_alt as listfilename_alt from pump left outer join attacheFiles on pump.no = attacheFiles.common_fk and attacheFiles.tablename = 'pump' and concat(attacheFiles.fileobject,attacheFiles.filename_index) = 'imagename1' where 1 = 1 AND categoryFk REGEXP("20240723v8uh4i5tcy") and pump.viewYn in (1,3) ORDER BY registdate desc LIMIT 0, 20
Cosmetic packaging
Pump
A-DMSM(0.1-32-410-A)
Type : Dispenser,Spray
Neck : 32/410
Dosage : 0.10cc
Feature :
Material
A-DMSM(0.2-24-410-C)
Type : Dispenser,Spray
Neck : 24/410
Dosage : 0.20cc
Feature :
Material
A-DMSM(0.2-24-410-B)
Type : Dispenser,Spray
Neck : 24/410
Dosage : 0.20cc
Feature :
Material
A-DMSM(0.2-20-410-A)
Type : Dispenser,Spray
Neck : 20/410
Dosage : 0.20cc
Feature :
Material
A-DMSM(0.2-24-410-A)
Type : Dispenser,Spray
Neck : 24/410
Dosage : 0.20cc
Feature :
Material
A-DMSM(0.1-24-410-A)
Type : Dispenser,Spray
Neck : 24/410
Dosage : 0.10cc
Feature :
Material
A-DMSM(0.15-24-410-B)
Type : Dispenser,Spray
Neck : 24/410
Dosage : 0.15cc
Feature :
Material
A-DMSM(0.15-22-410-B)
Type : Dispenser,Spray
Neck : 22/410
Dosage : 0.15cc
Feature :
Material
A-DMSM(0.15-22-410-A)
Type : Dispenser,Spray
Neck : 22/410
Dosage : 0.15cc
Feature :
Material
A-DMSM(0.15-24-410-A)
Type : Dispenser
Neck : 24/410
Dosage : 0.15cc
Feature :
Material
A-DMSM(0.15-20-410-A)
Type : Dispenser,Spray
Neck : 20/410
Dosage : 0.15cc
Feature :
Material
A-DMSM(0.05-11-415-B)
Type : Dispenser,Spray
Neck : 11/415
Dosage : 0.05cc
Feature :
Material
A-DMSM(0.05-11-415-A)
Type : Dispenser,Spray
Neck : 11/415
Dosage : 0.05cc
Feature :
Material
A-AMSM(0.1-18-400-A)
Type : Airless,Spray
Neck : 18/400
Dosage : 0.10cc
Feature :
Material
D-DLSM(0.25-18-410-J)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
테스트
Type : Dispenser
Neck : 32/415
Dosage : 3.50cc
Feature :
Material
Material
상품명1
Type : Airless
Neck : 11/410 58/400,410,415,425
Dosage : 3.50cc
Feature : Feature test
Material
Material
Download
Catalog