Interface Boards - TeamGene

string(360) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 347 AND attrid = 10 AND valueid = 190 ) OR ( catid = 347 AND attrid = 76 AND valueid = 20 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 347 ORDER BY `id` ASC LIMIT 0,20 )"

array(2) { [0] => array(3) { [0] => string(363) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 347 AND attrid = 10 AND valueid = 190 ) OR ( catid = 347 AND attrid = 76 AND valueid = 20 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 347 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：

12 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
PCM-3680-BE	220.500000	Advantech	PC-104 DUAL PORT IS...	1	PDF RFQ	2 In-stock	Get Quote
GW16146	86.900000	Gateworks Corporation	802.11AH HaLow Wi-Fi car...	1	PDF RFQ	25 In-stock	Get Quote
MIOE-3680-AE	244.500000	Advantech	2 PORT CAN BUS WIT...	1	PDF RFQ	3,000 In-stock	Get Quote
PCM-3610-CE	249.000000	Advantech	PC/104 ISOLATED DU...	1	PDF RFQ	3,000 In-stock	Get Quote
MM-217-Y	93.000000	Phytools	CANOPEN CHIP-F40 W...	1	PDF RFQ	3,000 In-stock	Get Quote
PCM-3680I-AE	0.000000	Advantech	PCI-104 DUAL PORT I...	1	PDF RFQ	3,000 In-stock	Get Quote
EXM-522-MPH01E	21.490000	Advantech	2CH USB 2.0 MODULE	1	PDF RFQ	3,000 In-stock	Get Quote
EXM-540-MPF01E	39.900000	Advantech	4CH USB 2.0 MODULE	1	PDF RFQ	3,000 In-stock	Get Quote
MOS-2120-Z1101E	94.500000	Advantech	GIGA LAN ETHERNE...	1	PDF RFQ	3,000 In-stock	Get Quote
MOS-2220-Z1101E	103.500000	Advantech	HIGH SPEED SERIA...	1	PDF RFQ	3,000 In-stock	Get Quote
PCM-3612-BE	136.500000	Advantech	PC/104 DUAL-PORT RS...	1	PDF RFQ	3,000 In-stock	Get Quote
MOS-2230-Z1201E	139.500000	Advantech	CANBUS MODULE 2-C...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 12 Records

Previous Next

Skype

Hotline

E-mail