Test Leads - Banana, Meter Interface

string(380) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 1029 AND attrid = 306 AND valueid = 551 ) OR ( catid = 1029 AND attrid = 132 AND valueid = 426556 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 1029 GROUP BY `brandid` )"

Filter：

Test Leads - Banana, Meter Interface
Material - Insulation : Silicone
2nd Connector : Alligator Clip, Insulated, Extra Large

4 Records

Part	Manufacturer	Description	MOQ		Stock	Action
6570-36-0	Pomona Electronics	TEST LEAD BANANA...	1	PDF RFQ	3,000 In-stock	Get Quote
6570-36-2	Pomona Electronics	TEST LEAD BANANA...	1	PDF RFQ	3,000 In-stock	Get Quote
6570-60-0	Pomona Electronics	TEST LEAD BANANA...	1	PDF RFQ	3,000 In-stock	Get Quote
6570-60-2	Pomona Electronics	TEST LEAD BANANA...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 4 Records

Previous Next

Skype

Hotline

E-mail