Controllers - PLC Modules

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 = 419 AND attrid = 600 AND valueid = 20 ) OR ( catid = 419 AND attrid = 11 AND valueid = 309526 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 419 GROUP BY `brandid` )"

Filter：

10 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
CS1W-PTS55	2546.770000	Omron Automation	INPUT MODULE 8 AN...	1	PDF RFQ	3,000 In-stock	Get Quote
CJ1W-TC003	986.190000	Omron Automation	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
CJ1W-TC004	986.190000	Omron Automation	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
CQM1-TC204	0.000000	Omron Automation	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
CJ1W-TC001	1040.380000	Omron Automation	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
CJ1W-TC002	1040.380000	Omron Automation	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
CQM1-TC201	0.000000	Omron Automation	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
CQM1-TC202	0.000000	Omron Automation	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
CQM1-TC203	0.000000	Omron Automation	TEMP CONTROL MOD...	1	PDF RFQ	3,000 In-stock	Get Quote
CS1W-PTS51	1528.060000	Omron Automation	INPUT MODULE 4 AN...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 10 Records

Previous Next

Skype

Hotline

E-mail