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 pump.viewYn in (1,3) ORDER BY registdate desc LIMIT 20, 20
Cosmetic packaging
Pump
A-DLSM(2-24-410-G)
Type : Dispenser
Neck : 24/410
Dosage : 2cc
Feature :
Material
A-DLSM(2-24-410-E)
Type : Dispenser
Neck : 24/410
Dosage : 2cc
Feature : 0
Material
A-DLSM(2-24-410-D)
Type : Dispenser
Neck : 24/410
Dosage : 2cc
Feature : 0
Material
A-DLSM(2-24-410-C)
Type : Dispenser
Neck : 24/410
Dosage : 2cc
Feature : 0
Material
A-DLSM(2-24-410-B)
Type : Dispenser
Neck : 24/410
Dosage : 2cc
Feature : 0
Material
A-DLSM(1-28-410-B)
Type : Dispenser
Neck : 28/410
Dosage : 1cc
Feature :
Material
A-DLSM(1-28-410-A)
Type : Dispenser
Neck : 28/410
Dosage : 1cc
Feature : 0
Material
A-DLSM(1-24-410-B)
Type : Dispenser
Neck : 24/410
Dosage : 1cc
Feature : 0
Material
A-DLSM(1-24-410-A)
Type : Dispenser
Neck : 24/410
Dosage : 1cc
Feature :
Material
A-DLSM(2-24-410-A)
Type : Dispenser
Neck : 24/410
Dosage : 2cc
Feature : 0
Material
A-DMSM(0.1-32-410-A)
Type : Dispenser,Spray
Neck : 32/410
Dosage : 0.10cc
Feature :
Material
A-DLSM(0.25-32-410-A)
Type : Dispenser
Neck : 32/410
Dosage : 0.10cc
Feature : 0
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.1-20-410-A)
Type : Dispenser,Spray
Neck : 20/410
Dosage : 0.10cc
Feature :
Material
A-DMSM(0.15-22-410-B)
Type : Dispenser,Spray
Neck : 22/410
Dosage : 0.15cc
Feature :
Material
Download
Catalog