RF Transceiver Modules and Modems - TeamGene

string(379) "( 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 = 15 AND valueid = 104852 ) OR ( catid = 846 AND attrid = 900 AND valueid = 547910 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 846 GROUP BY `brandid` )"

RF Transceiver Modules and Modems - TeamGene

Filter：

3 Records

Image	Part	prices	Manufacturer	Description	MOQ		Stock	Action
	EM7421 Q-M2M-1104681	138.300000	Sierra Wireless	EM7421 GENERIC FW 0...	1	PDF RFQ	26 In-stock	Get Quote
	MC7411 Q-M2M-1104689	147.020000	Sierra Wireless	MC7411 GENERIC FW 0...	1	PDF RFQ	519 In-stock	Get Quote
	MC7421 Q-M2M-1104688	142.660000	Sierra Wireless	MC7421 GENERIC FW 0...	1	PDF RFQ	23 In-stock	Get Quote

1 / 1 Page, 3 Records