RF Antennas - TeamGene

string(368) "( 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 = 30 AND valueid = 85849 ) OR ( catid = 828 AND attrid = 1669 AND valueid = 243396 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 828 ORDER BY `id` ASC LIMIT 0,20 )"

Filter：

5 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
EXC902BN	18.800000	Laird - Antennas	RF ANT 931MHZ WHIP...	1	PDF RFQ	318 In-stock	Get Quote
EXC450BN	18.800000	Laird - Antennas	RF ANT 460MHZ WHIP...	1	PDF RFQ	3,000 In-stock	Get Quote
EXC420BN	16.557420	Laird - Antennas	RF ANT 435MHZ WHIP...	31	PDF RFQ	3,000 In-stock	Get Quote
EXC806BN	16.557420	Laird - Antennas	RF ANT 836MHZ WHIP...	31	PDF RFQ	3,000 In-stock	Get Quote
EXC400BN	16.687000	Laird - Antennas	RF ANT 410MHZ WHIP...	30	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 5 Records

Previous Next

Skype

Hotline

E-mail