SELECT g.goods_id, g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb, g.goods_img, g.goods_brief, g.goods_type, MATCH (goods_name,keywords,goods_desc) AGAINST ('junction box') as relevance FROM `indolistrik_db`.`ecs_goods` AS g LEFT JOIN `indolistrik_db`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.parent_id = 0 AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND (( 1 ) ) AND MATCH (goods_name,keywords,goods_desc) AGAINST ('junction box') ORDER BY relevance DESC , goods_id DESC
Product search_junction box | Alat Listrik
Hello,Welcome you back! Login nowRegister now
  • 0821 1159 9086
  • 2C2C DD1A
    2AC6 5CDA
  • 0821 1396 1479
  • 0813-1446-8584
    (021) 391-5565

View History

Search result
Display:   

Junction Box Plastik

Junction Box Plastik

Shop price
Rp 23.563
    
Junction Box Explosion Proof

Junction Box Explosion Proof

Shop price
Rp 525.000
    
Schneider Clipsal Junction Box S56JB1GY

Schneider Clipsal Junction Box S56JB1GY

Shop price
Rp 0
    
Kabel Gland Tipe CG

Kabel Gland Tipe CG

Shop price
Rp 4.986
    
Kabel Gland Tipe MG

Kabel Gland Tipe MG

Shop price
Rp 3.500
    
Kabel Gland Tipe PG

Kabel Gland Tipe PG

Shop price
Rp 1.000
    
Total 46 records 1 [2]