Controllers - Process, Temperature

string(367) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 420 AND attrid = 600 AND valueid = 14633 ) OR ( catid = 420 AND attrid = 55 AND valueid = 310884 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 420 ORDER BY `id` ASC LIMIT 0,20 )"

Filter：

19 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
TM2-22CE	299.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	31 In-stock	Get Quote
TM2-42CB	332.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	67 In-stock	Get Quote
TM2-22RE	299.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	10 In-stock	Get Quote
TMHE-82RE	304.950000	IndustrialeMart	MULTI-CH MODULAR...	1	PDF RFQ	2 In-stock	Get Quote
TM2-22RB	310.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	7 In-stock	Get Quote
TM2-42RE	321.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	20 In-stock	Get Quote
TM2-42CE	321.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	9 In-stock	Get Quote
TM2-42RB	332.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	13 In-stock	Get Quote
TM4-N2SE	363.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	4 In-stock	Get Quote
TMH2-22CE	367.950000	IndustrialeMart	MULTI-CH MODULAR...	1	PDF RFQ	2 In-stock	Get Quote
TM4-N2SB	385.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	19 In-stock	Get Quote
TMH2-42CB	447.950000	IndustrialeMart	MULTI-CH MODULAR...	1	PDF RFQ	2 In-stock	Get Quote
TMH4-N2CB	814.950000	IndustrialeMart	MULTI-CH MODULAR...	1	PDF RFQ	7 In-stock	Get Quote
TM2-22CB	310.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	1 In-stock	Get Quote
TMH4-N2CE	732.950000	IndustrialeMart	MULTI-CH MODULAR...	1	PDF RFQ	3,000 In-stock	Get Quote
TM4-N2RE	363.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	3,000 In-stock	Get Quote
TM4-N2RB	385.950000	IndustrialeMart	MODULAR PID CONT...	1	PDF RFQ	3,000 In-stock	Get Quote
TMH2-42CE	403.950000	IndustrialeMart	MULTI-CH MODULAR...	1	PDF RFQ	1 In-stock	Get Quote
TMH2-22CB	407.950000	IndustrialeMart	MULTI-CH MODULAR...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 19 Records

Previous Next

Skype

Hotline

E-mail