Controllers - Process, Temperature

string(375) "( 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 = 15 AND valueid = 733 ) OR ( catid = 420 AND attrid = 80 AND valueid = 240158 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 420 GROUP BY `brandid` )"

Filter：

95 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
E5GC-QX1ACM-015	300.650000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5CC-RX2ABM-001	324.510000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	1 In-stock	Get Quote
E5CC-QX2ABM-001	324.510000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5CC-RX2ABM-802	334.060000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
E5GC-QX1ACM-024	381.780000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	1 In-stock	Get Quote
E5EC-QX2ABM-000	386.550000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	1 In-stock	Get Quote
E5CC-QX2DBM-001	396.100000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
E5CC-RX2ABM-006	443.820000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5CC-QX2DBM-004	453.360000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	1 In-stock	Get Quote
E5CC-RX2ABM-004	453.360000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	1 In-stock	Get Quote
E5CC-QX2DBM-006	453.360000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
E5GC-RX0DCM-000	224.300000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5GC-QX0DCM-000	229.070000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5GC-RX1ACM-000	233.840000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
E5GC-QX2ACM-000	248.160000	Omron Automation	VOLT 2AUX CLAMP 10...	1	PDF RFQ	3,000 In-stock	Get Quote
E5GC-QX2ACM-023	357.920000	Omron Automation	VOLT 2AUX CLAMP H...	1	PDF RFQ	3,000 In-stock	Get Quote
E5CC-RX2DBM-002	462.910000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
E5EC-QR2ABM-800	515.400000	Omron Automation	CONTROL TEMP REL...	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

1 / 5 Page, 95 Records

Previous Next

Skype

Hotline

E-mail