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 160, 20
Cosmetic packaging
Pump
D-DLSF(0.25-18-410-J)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-I)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-P)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-O)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-H)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-G)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-F)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-N)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-E)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-D)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSF(0.25-18-410-D)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-C)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
D-DLSM(0.25-18-410-M)
Type : Dispenser
Neck : 18/410
Dosage : 0.25cc
Feature :
Material
테스트
Type : Airless
Neck : 11/410 33/425
Dosage : 0.02cc
Feature : 테스트
Material
테스트
D-DLSM(0.25-18-410-B)
Type : Dispenser
Neck : 18/410
Dosage : 0.20cc
Feature : Classic Essence Pump
Material
Button : PPShoulder : PPSpring : SUS
D-DLSM(0.25-18-410-A)
Type : Dispenser
Neck : 18/410
Dosage : 0.20cc
Feature : Classic Essence Pump
Material
Button : PPShoulder : PPSpring : SUS
테스트
Type : Airless
Neck : 22/415 42/410
Dosage : 1cc
Feature : Feature
Material
test
테스트
Type : Airless
Neck : 22/415 42/410
Dosage : 1cc
Feature :
Material
test
테스트
Type : Spray
Neck :
Dosage : 1cc
Feature : 0
Material
테스트
Type : Dispenser
Neck : 32/415
Dosage : 3.50cc
Feature :
Material
Material
Download
Catalog