RF Antennas - TeamGene

string(363) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 828 AND attrid = 1 AND valueid = 1 ) OR ( catid = 828 AND attrid = 1671 AND valueid = 528023 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 828 ORDER BY `id` ASC LIMIT 0,20 )"

Filter：

6 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
SATPC-24A33AC5-UWB2	3.110000	Suntsu Electronics, Inc.	RF ANT 6250-8250MHZ U...	1	PDF RFQ	499 In-stock	Get Quote
1005193-B02	7.740000	Ethertronics	ANTENNA ASSY,UWB...	1	PDF RFQ	39 In-stock	Get Quote
1005194-A01	5.785000	Ethertronics	ANTENNA ASSY,UWB...	200	PDF RFQ	3,000 In-stock	Get Quote
1005193-A01	7.740000	Ethertronics	ANTENNA ASSY, UWB...	1	PDF RFQ	1,011 In-stock	Get Quote
1005194-B02	7.740000	Ethertronics	ANTENNA ASSY,UWB...	1	PDF RFQ	204 In-stock	Get Quote
W3340	2.400000	Pulse Electronics	ANTENNA 6.0-8.5 GHZ ...	36,000	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 6 Records

Previous Next

Skype

Hotline

E-mail