RF Transceiver Modules and Modems

string(364) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 846 AND attrid = 63 AND valueid = 20 ) OR ( catid = 846 AND attrid = 900 AND valueid = 548852 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 846 ORDER BY `id` ASC LIMIT 0,20 )"

Filter：

8 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
CMP9010-1C-R	15.930000	CEL (California Eastern Laboratories)	WIFI BGN BT5 BT ME...	600	PDF RFQ	3,000 In-stock	Get Quote
CMP9010-2-R	16.665000	CEL (California Eastern Laboratories)	EXT-TEMP, WIFI BG...	600	PDF RFQ	3,000 In-stock	Get Quote
CMP9010-2C-R	16.770000	CEL (California Eastern Laboratories)	EXT-TEMP, WIFI BG...	600	PDF RFQ	3,000 In-stock	Get Quote
CMP9010-1-R	22.310000	CEL (California Eastern Laboratories)	WIFI BGN BT5 BT ME...	1	PDF RFQ	600 In-stock	Get Quote
CMP9010-1-B	33.030000	CEL (California Eastern Laboratories)	WIFI BGN BT5 BT ME...	1	PDF RFQ	50 In-stock	Get Quote
CMP9010-1C-B	33.500000	CEL (California Eastern Laboratories)	WIFI BGN BT5 BT ME...	1	PDF RFQ	10 In-stock	Get Quote
CMP9010-2-B	31.898000	CEL (California Eastern Laboratories)	EXT-TEMP, WIFI BG...	10	PDF RFQ	3,000 In-stock	Get Quote
CMP9010-2C-B	32.036000	CEL (California Eastern Laboratories)	EXT-TEMP, WIFI BG...	10	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 8 Records

Previous Next

Skype

Hotline

E-mail