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 60, 20
Cosmetic packaging
Pump
A-DOSM(0.4-24-410-A)
Type : Dispenser,ETC
Neck : 24/410
Dosage : 0.40cc
Feature :
Material
A-DLSM(0.7-24-410-B)
Type : Dispenser
Neck : 24/410
Dosage : 0.70cc
Feature :
Material
A-DLSM(0.6-24-410-B)
Type : Dispenser
Neck : 24/410
Dosage : 0.60cc
Feature :
Material
A-DLSM(0.6-24-410-A)
Type : Dispenser
Neck : 24/410
Dosage : 0.60cc
Feature :
Material
A-DLSM(0.7-24-410-A)
Type : Dispenser
Neck : 24/410
Dosage : 0.70cc
Feature :
Material
A-DLSM(0.25-24-410-C)
Type : Dispenser
Neck : 24/410
Dosage : 0.25cc
Feature :
Material
A-DLSM(0.25-24-410-B)
Type : Dispenser
Neck : 24/410
Dosage : 0.25cc
Feature :
Material
A-DLSM(0.25-24-410-A)
Type : Dispenser
Neck : 24/410
Dosage : 0.25cc
Feature :
Material
A-DLSM(0.25-18-400-A)
Type : Dispenser
Neck : 18/400
Dosage : 0.25cc
Feature :
Material
A-AMSM(0.1-18-400-A)
Type : Airless,Spray
Neck : 18/400
Dosage : 0.10cc
Feature :
Material
A-ALSM(0.25-18-400-C)
Type : Airless
Neck : 18/400
Dosage : 0.25cc
Feature :
Material
A-ALSM(0.25-18-400-A)
Type : Airless
Neck : 18/400
Dosage : 0.25cc
Feature : 0
Material
A-DFSM(0.8-42-410-L)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-K)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-J)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-I)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-H)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature : 0
Material
A-DFSM(0.8-58-400-B)
Type : Dispenser
Neck : 58/400
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-58-400-A)
Type : Dispenser
Neck : 58/400
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-G)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
Download
Catalog