Controllers - Process, Temperature

string(368) "( 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 = 1190 AND valueid = 7720 ) OR ( catid = 420 AND attrid = 114 AND valueid = 310206 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 420 ORDER BY `id` ASC LIMIT 0,20 )"

array(2) { [0] => array(3) { [0] => string(371) "( 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 = 1190 AND valueid = 7720 ) OR ( catid = 420 AND attrid = 114 AND valueid = 310206 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 420 ORDER BY `id` ASC LIMIT 0,20 ) t2" [1] => string(19) "(t1.`id` = t2.`id`)" [2] => string(5) "INNER" } [1] => array(3) { [0] => string(15) "product_idx idx" [1] => string(24) "(t1.`id` = idx.`prodid`)" [2] => string(4) "LEFT" } }

Filter：

13 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
TC4S-N4N	69.950000	IndustrialeMart	TEMP CONTROL IND...	1	PDF RFQ	15 In-stock	Get Quote
TC4S-N4R	75.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	19 In-stock	Get Quote
TC4S-14R	78.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	613 In-stock	Get Quote
TC4SP-14R	78.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	124 In-stock	Get Quote
TC4S-24R	81.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	571 In-stock	Get Quote
TCN4S-22R	87.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	49 In-stock	Get Quote
TC4SP-N4R	75.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	10 In-stock	Get Quote
TC4S-12R	78.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	12 In-stock	Get Quote
TC4SP-12R	78.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	5 In-stock	Get Quote
TC4S-22R	81.950000	IndustrialeMart	TEMP CONTROL REL...	1	PDF RFQ	6 In-stock	Get Quote
T4M-B4RJ4C-N	157.950000	IndustrialeMart	TEMP CONTROL J 400...	1	PDF RFQ	3 In-stock	Get Quote
E5CSL-RP AC100-240	338.830000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote
E5CSL-RTC AC100-240	338.830000	Omron Automation	CONTROL TEMP REL...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 13 Records

Previous Next

Skype

Hotline

E-mail