Controllers - Process, Temperature

string(378) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 420 AND attrid = 54 AND valueid = 9261 ) OR ( catid = 420 AND attrid = 1189 AND valueid = 310320 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 420 GROUP BY `brandid` )"

Filter：

23 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
E5AR-C43DB-FLK AC100-240V	1503.900000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-Q43DB-FLK AC100-240V	1503.900000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-TQ43B-FLK AC100-240	1582.320000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-QC43DB-FLK AC100-240	1586.930000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-QC43DB-FLK AC/DC24	1586.930000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-C43DW-FLK AC100-240V	1669.970000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-Q43DW-FLK AC100-240V	1669.970000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-TCE3MB-FLK AC100-240	1716.100000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-PRQ43DF-FLK AC100-240	1729.940000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-PRQ43DF-FLK AC/DC24	1729.940000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-QQ43DW-FLK AC/24	1771.460000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-TQ43DW-FLK AC100-240	1831.430000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-TC43DW-FLK AC100-240	1969.830000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-TQQE3MW-FLK AC100-240	2103.610000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-QQ43DWW-FLK AC100-240V	2306.590000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-CC43DWW-FLK AC100-240	2334.270000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-CC43DWW-FLK AC/DC24	2334.270000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-TQQE3MWW-332 AC100-240	2758.680000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-TCCE3MWW-FLK AC100-240	2915.530000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5AR-TCCE3MWW-FLK AC/DC24	2915.530000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 2 Page, 23 Records

Previous Next

Skype

Hotline

E-mail