Controllers - Programmable (PLC, PAC)

string(382) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 421 AND attrid = 1176 AND valueid = 311753 ) OR ( catid = 421 AND attrid = 1196 AND valueid = 311343 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 421 GROUP BY `brandid` )"

Filter：

6 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
SG2-20KR-D	159.080000	Advantech	NANOPLC, DC, 20-IO,...	1	PDF RFQ	3,000 In-stock	Get Quote
SG2-20HT-D	204.670000	Advantech	NANOPLC, DC, 20-IO,...	1	PDF RFQ	3,000 In-stock	Get Quote
SG2-20HR-12D	0.000000	Advantech	NANOPLC 12VDC 12-IO...	1	PDF RFQ	3,000 In-stock	Get Quote
SG2-20HR-D	0.000000	Advantech	NANOPLC DC 20-IO R...	1	PDF RFQ	3,000 In-stock	Get Quote
SG2-20VR-D	0.000000	Advantech	NANOPLC DC 20-IO H...	1	PDF RFQ	3,000 In-stock	Get Quote
SG2-20VT-D	0.000000	Advantech	NANOPLC DC 20-IO H...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 6 Records

Previous Next

Skype

Hotline

E-mail