Controllers - PLC Modules

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

Filter：

15 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
2869911	431.750000	Phoenix Contact	I/O MODULE 4 DIG 4 ...	1	PDF RFQ	8 In-stock	Get Quote
2863070	338.040000	Phoenix Contact	COMMUNICATIONS M...	1	PDF RFQ	3,000 In-stock	Get Quote
2862385	685.000000	Phoenix Contact	I/O MODULE 16 DIG 1...	1	PDF RFQ	3,000 In-stock	Get Quote
2862178	72.510000	Phoenix Contact	OUTPUT MODULE 1 R...	1	PDF RFQ	3,000 In-stock	Get Quote
2862110	74.750000	Phoenix Contact	OUTPUT MODULE 1 R...	1	PDF RFQ	3,000 In-stock	Get Quote
2861548	82.560000	Phoenix Contact	INPUT MODULE 1 DI...	1	PDF RFQ	3,000 In-stock	Get Quote
2737009	157.300000	Phoenix Contact	COMMUNICATIONS M...	1	PDF RFQ	3,000 In-stock	Get Quote
2862369	790.990000	Phoenix Contact	OUTPUT MODULE 32 S...	1	PDF RFQ	3,000 In-stock	Get Quote
2869910	553.350000	Phoenix Contact	POWER SUPPLY MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
2702289	834.490000	Phoenix Contact	IO MOD INLINE 32IN...	1	PDF RFQ	3,000 In-stock	Get Quote
2700605	1200.410000	Phoenix Contact	INLINE MULTI-MAS...	1	PDF RFQ	3,000 In-stock	Get Quote
2869912	1228.310000	Phoenix Contact	I/O MODULE 4 ANALO...	1	PDF RFQ	1 In-stock	Get Quote
2869913	1341.000000	Phoenix Contact	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
2701160	603.550000	Phoenix Contact	COMMUNICATIONS M...	1	PDF RFQ	3,000 In-stock	Get Quote
2862343	661.560000	Phoenix Contact	INPUT MODULE 32 DI...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 15 Records

Previous Next

Skype

Hotline

E-mail