string(379) "( 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 = 80 AND valueid = 13932 ) OR ( catid = 419 AND attrid = 1176 AND valueid = 309289 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 419 GROUP BY `brandid` )"
Controllers - PLC Modules - TeamGene
Welcome to visit our website, our working hours are: Monday to Friday 9:00-18:00.
For Use With/Related Products:
Features:
Voltage - Supply:
Number of Outputs and Type:
Image Part prices Manufacturer Description MOQ Stock Action
I-7015 489.000000 ICP DAS USA Inc.
RS-485 REMOTE I/O D...
1
RFQ
30
In-stock
Get Quote
M-7015 489.000000 ICP DAS USA Inc.
MODBUS RTU RS-485 R...
1
RFQ
30
In-stock
Get Quote
M-7026 529.000000 ICP DAS USA Inc.
MODBUS RTU RS-485 R...
1
RFQ
30
In-stock
Get Quote
I-7015P 599.000000 ICP DAS USA Inc.
RS-485 REMOTE I/O D...
1
RFQ
30
In-stock
Get Quote
M-7015P 589.000000 ICP DAS USA Inc.
MODBUS RTU RS-485 R...
1
RFQ
25
In-stock
Get Quote
CJ1W-TS561 1549.730000 Omron Automation
INPUT MODULE 6 AN...
1
RFQ
3,000
In-stock
Get Quote
CJ1W-TS562 1549.730000 Omron Automation
INPUT MODULE 6 AN...
1
RFQ
3,000
In-stock
Get Quote
1 / 1 Page, 7 Records