Controllers - Cable Assemblies

string(322) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 416 AND attrid = 25 AND valueid = 308521 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 1 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 416 GROUP BY `brandid` )"

Filter：

7 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
2304872	149.950000	Phoenix Contact	CABLE ASSEMBLY I...	1	PDF RFQ	3,000 In-stock	Get Quote
2304908	192.740000	Phoenix Contact	CABLE ASSEMBLY I...	1	PDF RFQ	3,000 In-stock	Get Quote
2304937	248.230000	Phoenix Contact	CABLE ASSEMBLY I...	1	PDF RFQ	3,000 In-stock	Get Quote
2304940	270.080000	Phoenix Contact	CABLE ASSEMBLY I...	1	PDF RFQ	3,000 In-stock	Get Quote
2304911	213.410000	Phoenix Contact	CABLE ASSEMBLY I...	1	PDF RFQ	3,000 In-stock	Get Quote
2304953	303.140000	Phoenix Contact	CABLE ASSEMBLY I...	1	PDF RFQ	3,000 In-stock	Get Quote
2304924	232.880000	Phoenix Contact	CABLE ASSEMBLY I...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 7 Records

Previous Next

Skype

Hotline

E-mail