Controllers - Process, Temperature

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

Filter：

78 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
ATC500-0105-00	249.630000	Mueller Electric Co.	PID CONTROLLER 1....	1	PDF RFQ	3,000 In-stock	Get Quote
E5EC-QX2ABM-008	520.180000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
E5EC-QX2DBM-008	520.180000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
E5EC-QX4DBM-008	520.180000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU11AB0	154.290000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU21AB0	154.290000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU31AB0	154.290000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU41AB0	154.290000	Red Lion	PID CTLR TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU11A30	161.390000	Red Lion	CNTRL TEMP/PROC R...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU21A30	161.390000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU31A30	161.390000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU209B0	162.200000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
PXU309B0	162.200000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
CL-B101D40-RTD	649.000000	Texmate	SWITCHBOARD STYL...	1	PDF RFQ	50 In-stock	Get Quote
PXU21B20	165.450000	Red Lion	PID CTLR TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
CL-B101D40-TC	649.000000	Texmate	SWITCHBOARD STYL...	1	PDF RFQ	50 In-stock	Get Quote
CL-B101D40HZ	653.000000	Texmate	SWITCHBOARD STYL...	1	PDF RFQ	50 In-stock	Get Quote
PXU11AC0	167.480000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
CL-B101D40RPM	660.000000	Texmate	SWITCHBOARD STYL...	1	PDF RFQ	50 In-stock	Get Quote
PXU21AC0	167.480000	Red Lion	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 4 Page, 78 Records

Previous Next

Skype

Hotline

E-mail