string(362) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 419 AND attrid = 600 AND valueid = 147073 ) OR ( catid = 419 AND attrid = 1 AND valueid = 1 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 419 ORDER BY `id` ASC LIMIT 0,20 )"
Controllers - PLC Modules - TeamGene
Welcome to visit our website, our working hours are: Monday to Friday 9:00-18:00.
Image Part prices Manufacturer Description MOQ Stock Action
AFP0HXY64D2T 450.000000 Panasonic
FP0H EXPANSION I/...
1
RFQ
16
In-stock
Get Quote
AFP0HXY64D2P 450.000000 Panasonic
FP0H EXPANSION I/...
1
RFQ
5
In-stock
Get Quote
AS08AM10N-A 74.450000 Delta Electronics
AS300 IO MODULE - 8 ...
1
RFQ
10
In-stock
Get Quote
AS16AM10N-A 157.890000 Delta Electronics
AS300 IO MODULE - 16...
1
RFQ
3
In-stock
Get Quote
NX-ECC202 308.860000 Omron Automation
COMMUNICATIONS M...
1
RFQ
3,000
In-stock
Get Quote
NX-PF0630 96.500000 Omron Automation
POWER SUPPLY MOD...
1
RFQ
3,000
In-stock
Get Quote
AS32AM10N-A 260.970000 Delta Electronics
AS300 IO MODULE - 32...
1
RFQ
6
In-stock
Get Quote
NX-ECC201 303.030000 Omron Automation
COMMUNICATIONS M...
1
RFQ
3,000
In-stock
Get Quote
2861755 433.980000 Phoenix Contact
INPUT MODULE 4 DI...
1
RFQ
3,000
In-stock
Get Quote
AS64AM10N-A 389.420000 Delta Electronics
AS300 IO MODULE - 64...
1
RFQ
6
In-stock
Get Quote
2861852 449.600000 Phoenix Contact
TEMP CONTROL MOD...
1
RFQ
3,000
In-stock
Get Quote
2861632 304.560000 Phoenix Contact
OUTPUT MOD 2 PWM/S...
1
RFQ
1
In-stock
Get Quote
AH02HC-5A 1002.187500 Delta Electronics
HIGH SPEED COUNT...
4
RFQ
3,000
In-stock
Get Quote
AH04HC-5A 1353.637500 Delta Electronics
HIGH SPEED COUNT...
4
RFQ
3,000
In-stock
Get Quote
1 / 1 Page, 14 Records