RF Amplifiers - TeamGene

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

Filter：

6 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
QMC-MX4-15F13	2800.000000	Quantum Microwave Components	WR-15 ACTIVE FREQU...	1	PDF RFQ	3,000 In-stock	Get Quote
QMC-AMP15-62252012	2808.000000	Quantum Microwave Components	POWER AMPLIFIER	1	PDF RFQ	3,000 In-stock	Get Quote
QMC-MX2-28F23	3320.000000	Quantum Microwave Components	WR-28 ACTIVE MULTI...	1	PDF RFQ	3,000 In-stock	Get Quote
QMC-MX6-12N12	3325.000000	Quantum Microwave Components	WR-12 ACTIVE MULTI...	1	PDF RFQ	3,000 In-stock	Get Quote
QMC-AMP28-33142222	3326.000000	Quantum Microwave Components	AMPLIFIER FREQUE...	1	PDF RFQ	3,000 In-stock	Get Quote
QMC-MX4K-F1841	0.000000	Quantum Microwave Components	18-41 GHZ 4X MULTIPL...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 6 Records

Previous Next

Skype

Hotline

E-mail