Controllers - Process, Temperature

string(376) "( 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 = 114 AND valueid = 20 ) OR ( catid = 420 AND attrid = 833 AND valueid = 310132 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 420 GROUP BY `brandid` )"

Filter：

45 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
E5DC-RX2DSM-002	291.110000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	1 In-stock	Get Quote
E5DC-CX2ASM-000	300.650000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-CX2DSM-000	300.650000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-RX2DBM-002	300.650000	Omron Automation	CNTRL TEMP SSR OU...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-QX2ASM-002	310.200000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-QX2DBM-002	319.740000	Omron Automation	CONTROL TEMP RLY...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-CX0ASM-015	334.060000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-CX0DSM-015	334.060000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-CX2ASM-016	343.600000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-CX2DSM-015	357.920000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-QX2ABM-000	243.380000	Omron Automation	CNTRL TEMP SSR OU...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-CX2ASM-015	357.920000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-RX2ASM-000	229.070000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	16 In-stock	Get Quote
E5DC-QX0ASM-015	276.790000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-RX2ASM-017	276.790000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-RX2DSM-017	276.790000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-RX2DSM-600	276.790000	Omron Automation	FM RELAY 2 AUX 24 A...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-RX0DBM-015	276.790000	Omron Automation	CNTRL TEMP RLY OU...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-RX0ABM-015	276.790000	Omron Automation	CNTRL TEMP RLY OU...	1	PDF RFQ	3,000 In-stock	Get Quote
E5DC-QX2ASM-017	286.340000	Omron Automation	CONTROL TEMP/PRO...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 3 Page, 45 Records

Previous Next

Skype

Hotline

E-mail