|
|
型号： 74125复制
SELECT count(id) as count,`gys_id`,`zzsbh`,`price`,`gm_gys_id`,`sprice_1` FROM `golon_gys_file_new` WHERE ( `zzsbh` = '74125' ) AND ( (`sprice_1` > 0) OR (`price` > 0) ) AND ( `gm_gys_id` > 0 ) LIMIT 1
SELECT count(id) as count,`gys_id`,`zzsbh`,`price`,`purchase_price`,`selling_price`,`gm_gys_id`,`num_1`,`sprice_1`,`num_2`,`sprice_2`,`num_3`,`sprice_3`,`num_4`,`sprice_4`,`num_5`,`sprice_5`,`num_6`,`sprice_6`,`num_7`,`sprice_7` FROM `golon_gys_file_new` WHERE ( `zzsbh` = '74125' ) LIMIT 1
描述：
IC MIXER 1-4GHZ SMA CONNECTORS
封装：-
外壳：-
|
RF 类型：通用
频率：1GHz ~ 4GHz
混频器数：1
增益：-
噪声系数：-
辅助属性：SMA 连接器
电压 - 电源：-
|
select action_name,tags from golon_ics_category where mpn_bm='golon_rf_hpq'
丝印：
料号：R18-481
包装：
|
10+:￥5.1960
750+:￥4.9795
1500+:￥4.6331
3000+:￥4.6115
|
购买数量不能超过商品库存，已为您修正！
SELECT count(a.zzsbh) as c,sum(stock) as stock,`gys_id`,`gys_zq` FROM golon_gys_file_new a LEFT JOIN golon_gys_brand b on a.gys_id=b.id WHERE ( a.zzsbh = '74125' ) AND ( `Gsxx_sx` <> '国际商城平台' ) LIMIT 1
现货:0
最小起订:
总额：
|
SELECT `gys_zq` FROM golon_gys_file_new a LEFT JOIN golon_gys_brand b on a.gys_id=b.id WHERE ( a.zzsbh = '74125' ) AND ( a.sprice_1 > 0 ) AND ( (`Gsxx_sx` = '国内商城平台') OR (`Gsxx_sx` = '其他经销商') OR (`Gsxx_sx` = '授权代理商') ) LIMIT 1
|
