เวลาทำการ จันทร์ - เสาร์ 09.00 - 18.00 น.
ของแท้ประกันศูนย์
1,000 บาทขึ้นไปส่งฟรี
@Headdaddy
@Headdaddy

- Film&Case SAMSUNG GALAXY J7
- Film&Case HUAWEI ASCEND MATE 7
- Film&Case HUAWEI P8 Lite
- Film&Case ACER Z410
- Film&Case ACER Z630
- Film&Case VIVO Y21
- Film&Case VIVO Y31 / Y31L
- Film&Case VIVO Y51
- Film&Case VIVO Y55/Y55S
- Film&Case VIVO V3
- Film&Case VIVO V3 Max
- Film&Case AIS LAVA (IRIS 702)
- Film&Case OPPO JOY
- Film&Case OPPO JOY 3
- Film&Case IPHONE 4/4s
- Film&Case IPHONE 5/5c/5s
- Film&Case IPHONE 6/6s
- Film&Case IPHONE 6/6s PLUS
- Film&Case IPHONE 7
- Film&Case IPHONE 7 PLUS
- Film&Case VIVO V5 LITE
- Film&Case VIVO V5/V5S
- Film&Case SAMSUNG GALAXY NOTE 5
- Film&Case HUAWEI P9 PLUS
- Film&Case ASUS ZENFONE 3
- Film&Case ASUS ZENFONE MAX PRO (M1)
- Film&Case Lenovo A6600 Plus
- Film&Case IPHONE 7&8
- Film&Case IPHONE 7&8 PLUS
- Film IPHONE X
- Film&Case SAMSUNG GALAXY J2 Prime
- Film&Case SAMSUNG GALAXY J4
- Film&Case SAMSUNG GALAXY J5 Pro
- Film&Case SAMSUNG GALAXY J7 Pro
- Film&Case SAMSUNG GALAXY J6
- Film&Case SAMSUNG GALAXY J7 Version 2
- Film&Case SAMSUNG GALAXY J7 PRIME
- Film&Case SAMSUNG GALAXY J7 (J700F) & J7 Core
- Film&Case SAMSUNG GALAXY J8
- Film&Case SAMSUNG GALAXY A5 (2017)
- Film&Case SAMSUNG GALAXY A6&A6+ (2018)
- Film&Case SAMSUNG GALAXY A7 (2016)
- Film&Case SAMSUNG GALAXY A7 (2017)
- Film&Case SAMSUNG GALAXY A8 & A8 PLUS (2018)
- Film&Case SAMSUNG GALAXY A9 PRO
- Film&Case SAMSUNG GALAXY S7
- Film&Case SAMSUNG GALAXY S7 Edge
- Film&Case SAMSUNG GALAXY S8
- Film&Case SAMSUNG GALAXY S8+
- Film&Case SAMSUNG GALAXY S9&S9+
- Film&Case SAMSUNG GALAXY NOTE 8
- Film&Case HUAWEI (Y-Series)
- Film&Case HUAWEI ( Y-Series 2017 )
- Film&Case HUAWEI ( Y-Series 2018 )
- Film&Case HUAWEI GR5
- Film&Case HUAWEI NOVA3 Series
- Film&Case HUAWEI P9
- Film&Case HUAWEI P10&P10 PLUS
- Film&Case HUAWEI P20&P20 PRO
- Film&Case HUAWEI MATE 9&Mate 9 Pro
- Film&Case HUAWEI MATE 10 Pro
- Film&Case VIVO Y53 / Y53C
- Film&Case VIVO Y71
- Film&Case VIVO Y85/Y81
- Film&Case VIVO V5 PLUS
- Film&Case VIVO V9/X21
- Film&Case VIVO V7/V7+
- Film VIVO V11i
- Film VIVO V11
- Film&Case ASUS ZENFONE GO (4.5'')
- Film&Case ASUS ZEN GO (6.9")
- Film&Case ASUS ZENFONE 3 Laser
- Film&Case ASUS ZENFONE 3 Ultra
- Film&Case ASUS ZENFONE 4 Max&Max Pro
- Film&Case ASUS ZENFONE 4 Selfie&Selfie Pro
- Film&Case XIAOMI Original
- Film&Case LENOVO A6020
- Film&Case DTAC Happy Phone 3G 4.0 (ZTE Blade L110)
select pri.code,pri.Product,pri.warranty,pri.First ,recommend.rec_discount ,recommend.note as rec_note ,'' as pic_had,'' as path,'' as pic_type,recommend.imp,'' as Note ,recommend.rec_srp /*,if(recommend.rec_name='',IF( recommend.`rec_product` = '', pri.Product,pri.Product),recommend.rec_name) AS Product*/ ,pri.menu_id FROM advice_co_th.price pri inner join advice_co_th.menu_list_dtl mdtl on pri.menu_dtl_id = mdtl.menu_dtl_id left join advice_co_th.spec_picture sp on pri.code = sp.code left join system_44352001.recommend on pri.code = recommend.rec_code WHERE pri.online_only='T' and ((sp.pic_type ='s' and sp.pic_had <> '' and recommend.rec_discount > 0 and mdtl.menu_dtl_alive = 'T' ) or pri.code like 'D%' ) and mdtl.menu_dtl_id = '009970' GROUP BY pri.code order by pri.Url Film&Case Smartphone
พบสินค้า 0 รายการ