RF Misc ICs and Modules - TeamGene

string(376) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 835 AND attrid = 15 AND valueid = 194 ) OR ( catid = 835 AND attrid = 120 AND valueid = 184986 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 835 GROUP BY `brandid` )"

RF Misc ICs and Modules - TeamGene

Filter：

4 Records

Image	Part	prices	Manufacturer	Description	MOQ		Stock	Action
	ASNT5076-KMC	440.000000	ADSANTEC	16G DELAY LINE 0-155...	1	PDF RFQ	54 In-stock	Get Quote
	ASNT5105A-KMC	880.000000	ADSANTEC	32GHZ DELAY LINE, ...	1	PDF RFQ	42 In-stock	Get Quote
	ASNT5101-KMC	990.000000	ADSANTEC	23GHZ DELAY LINE, ...	1	PDF RFQ	801 In-stock	Get Quote
	ASNT5102-KMC	990.000000	ADSANTEC	32GHZ DELAY LINE, ...	1	PDF RFQ	108 In-stock	Get Quote

1 / 1 Page, 4 Records