RF Modulators - TeamGene

string(372) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 837 AND attrid = 75 AND valueid = 540941 ) OR ( catid = 837 AND attrid = 1 AND valueid = 1 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 837 GROUP BY `brandid` )"

Filter：

8 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
HMC630LP3ETR	20.938500	Analog Devices, Inc.	RF MODULATOR 700MH...	500	PDF RFQ	3,000 In-stock	Get Quote
HMC500LP3ETR	22.291500	Analog Devices, Inc.	RF MODULATOR 1.8GH...	500	PDF RFQ	3,000 In-stock	Get Quote
HMC500LP3E	22.966860	Analog Devices, Inc.	RF MODULATOR 1.8GH...	35	PDF RFQ	3,000 In-stock	Get Quote
HMC631LP3E	29.390000	Analog Devices, Inc.	RF MODULATOR 1.8GH...	1	PDF RFQ	3 In-stock	Get Quote
HMC630LP3ETR	20.490000	Rochester Electronics	HBT VECTOR MODUL...	15	PDF RFQ	850 In-stock	Get Quote
HMC500LP3ETR	21.800000	Rochester Electronics	HBTVECTORMODULA...	14	PDF RFQ	11,500 In-stock	Get Quote
HMC630LP3E	24.490000	Analog Devices, Inc.	RF MODULATOR 700MH...	1	PDF RFQ	17 In-stock	Get Quote
HMC631LP3ETR	29.390000	Analog Devices, Inc.	RF MODULATOR 1.8GH...	1	PDF RFQ	88 In-stock	Get Quote

1 / 1 Page, 8 Records

Previous Next

Skype

Hotline

E-mail