select product.* , attacheFiles.filename as listfilename , attacheFiles.filename_org as listfilename_org , attacheFiles.filename_alt as listfilename_alt from product left outer join attacheFiles on product.no = attacheFiles.common_fk and attacheFiles.tablename = 'product' and concat(attacheFiles.fileobject,attacheFiles.filename_index) = 'imagename1' where 1 = 1 and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 160, 20
Cosmetic packaging
Product
N3 274N
Capacity : 50 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 273N
Capacity : 30 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 272N
Capacity : 15 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 274-1
Capacity : 50 ml
Type : Airless
Material
Pump : PP
Bottle : PP
N3 273-1
Capacity : 30 ml
Type : Airless
Material
Pump : PP
Bottle : PP
N3 272-1
Capacity : 15 ml
Type : Airless
Material
Pump : PP
Bottle : PP
N3 212-10
Capacity : 120 ml
Type : Airless
Material
Button : ASA
Outer Bottle : SAN
Inner Bottle : PP
Bottle Base : ABS
N3 211-1
Capacity : 30 ml
Type : Airless
Material
Button : ASA
Outer Bottle : SAN
Inner Bottle : PP
Bottle Base : ABS
N3 210-1
Capacity : 50 ml
Type : Airless
Material
Button : ASA
Outer Bottle : SAN
Inner Bottle : PP
Bottle Base : ABS
N3 211
Capacity : 20 ml
Type : Airless
Material
Button : ASA
Outer Bottle : PETG
Inner Bottle : PP
Bottle Base : ABS
N3 209
Capacity : 30 ml
Type : Airless
Material
Button : ASA
Outer Bottle : PETG
Inner Bottle : PP
Bottle Base : ABS
N3 154
Capacity : 100 ml
Type : Airless
Material
Cap : PCTA
Pump : PP
Shoulder : ABS
Bottle : SAN
N3 153
Capacity : 50 ml
Type : Airless
Material
Cap : PCTA
Pump : PP
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : SAN
N3 150
Capacity : 130 ml
Type : Airless
Material
Cap : PCTA
Pump : PP
Shoulder : ABS
Bottle : SAN
N3 151
Capacity : 150 ml
Type : Airless
Material
Cap : PCTA
Pump : PP
Shoulder : ABS
Bottle : SAN
N3 149
Capacity : 100 ml
Type : Airless
Material
Cap : PCTA
Pump : PP
Shoulder : ABS
Bottle : SAN
N6 207-3
Capacity : 50 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
N6 207-2
Capacity : 200 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
N6 207-1
Capacity : 100 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
N6 207
Capacity : 25 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
Download
Catalog