Controllers - PLC Modules

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

Filter：

7 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
DFR0900	130.000000	DFRobot	10 I/OS PLC MODULE...	1	PDF RFQ	3,000 In-stock	Get Quote
DFR0901	133.750000	DFRobot	10 I/OS RELAY MODU...	1	PDF RFQ	3,000 In-stock	Get Quote
DFR0898	138.750000	DFRobot	10 I/OS PLC MODULE...	1	PDF RFQ	3,000 In-stock	Get Quote
DFR0899	145.000000	DFRobot	10 I/OS RELAY MODU...	1	PDF RFQ	3,000 In-stock	Get Quote
USB-2068-18	319.000000	ICP DAS USA Inc.	USB REMOTE I/O DA...	1	PDF RFQ	30 In-stock	Get Quote
CJ2M-MD211	426.020000	Omron Automation	I/O MODULE 10 DIGI...	1	PDF RFQ	3,000 In-stock	Get Quote
CJ2M-MD212	426.020000	Omron Automation	I/O MODULE 10 DIGI...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 7 Records

Previous Next

Skype

Hotline

E-mail