RF Transceiver Modules and Modems

string(380) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 846 AND attrid = 1701 AND valueid = 1438 ) OR ( catid = 846 AND attrid = 1672 AND valueid = 547900 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 846 GROUP BY `brandid` )"

Filter：

9 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
AC4790-200M	75.130000	Laird Connectivity	RX TXRX MOD ISM < ...	1	PDF RFQ	845 In-stock	Get Quote
AC4790LR-1000M	99.170000	Laird Connectivity	RX TXRX MOD ISM < ...	1	PDF RFQ	111 In-stock	Get Quote
ZFSM-201-1C-B	0.000000	CEL (California Eastern Laboratories)	RX TXRX MODULE 802...	1	PDF RFQ	3,000 In-stock	Get Quote
ZFSM-201-2C-B	0.000000	CEL (California Eastern Laboratories)	RX TXRX MODULE 802...	1	PDF RFQ	3,000 In-stock	Get Quote
AC4790-1000M	88.720000	Laird Connectivity	RX TXRX MOD ISM < ...	1	PDF RFQ	3,000 In-stock	Get Quote
AC4790-1000M-485	0.000000	Laird Connectivity	RX TXRX MOD ISM < ...	1	PDF RFQ	3,000 In-stock	Get Quote
AC4790-200M-485	0.000000	Laird Connectivity	RX TXRX MOD ISM < ...	1	PDF RFQ	3,000 In-stock	Get Quote
AC4790LR-200M	0.000000	Laird Connectivity	RX TXRX MOD ISM < ...	1	PDF RFQ	3,000 In-stock	Get Quote
AC4790-200M-02	0.000000	Laird Connectivity	RX TXRX MOD ISM < ...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 9 Records

Previous Next

Skype

Hotline

E-mail