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 80, 20
Cosmetic packaging
Pump
A-DFSM(0.8-42-410-F)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-E)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature : 0
Material
A-DFSM(0.8-42-410-D)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-C)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-B)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.8-42-410-A)
Type : Dispenser
Neck : 42/410
Dosage : 0.80cc
Feature :
Material
A-DFSM(0.5-30-400-D)
Type : Dispenser
Neck : 30/400
Dosage : 0.50cc
Feature :
Material
A-DFSM(0.5-33-400-A)
Type : Dispenser
Neck : 33/400
Dosage : 0.50cc
Feature :
Material
A-DFSM(0.5-30-400-C)
Type : Dispenser
Neck : 30/400
Dosage : 0.50cc
Feature :
Material
A-DFSM(0.5-30-400-B)
Type :
Neck : 30/400
Dosage : 0.50cc
Feature :
Material
A-DFSM(0.5-30-400-A)
Type : Dispenser
Neck : 30/400
Dosage : 0.50cc
Feature : 0
Material
K-ALSM(0.20-20-425-G)
Type : Airless,ETC
Neck : 20/425
Dosage : 0.20cc
Feature : 0
Material
K-ALSM(0.20-20-425-F)
Type : Airless
Neck : 20/425
Dosage : 0.20cc
Feature :
Material
K-ALSM(0.20-20-425-E)
Type : Airless
Neck : 20/425
Dosage : 0.20cc
Feature :
Material
K-ALSM(0.20-20-425-D)
Type : Airless
Neck : 20/425
Dosage : 0.20cc
Feature : 0
Material
K-ALSF(0.20-20-425-A)
Type : Dispenser
Neck : 20/425
Dosage : 0.20cc
Feature :
Material
K-ALSM(0.20-20-425-B)
Type : Airless
Neck : 20/425
Dosage : 0.20cc
Feature :
Material
K-ALSM(0.20-20-425-A)
Type : Airless
Neck : 20/425
Dosage : 0.20cc
Feature :
Material
K-DLSF(4.00-32-410-A)
Type : Dispenser
Neck : 32/410
Dosage : 4cc
Feature :
Material
K-DLSF(3.50-32-410-A)
Type : Dispenser
Neck : 32/410
Dosage : 3.50cc
Feature :
Material
Download
Catalog