Interface Boards - TeamGene

string(375) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 347 AND attrid = 874 AND valueid = 20 ) OR ( catid = 347 AND attrid = 75 AND valueid = 128092 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 347 GROUP BY `brandid` )"

Filter：

77 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
PCM-CAN200D	419.000000	ICP DAS USA Inc.	2 PORT ISOLATED P...	1	PDF RFQ	30 In-stock	Get Quote
PEX-CAN200I-D	579.000000	ICP DAS USA Inc.	2 PORT ISOLATED P...	1	PDF RFQ	30 In-stock	Get Quote
PEX-CAN200I-T	579.000000	ICP DAS USA Inc.	2 PORT ISOLATED P...	1	PDF RFQ	30 In-stock	Get Quote
PISO-CAN200U-D	609.000000	ICP DAS USA Inc.	2 PORT ISOLATED P...	1	PDF RFQ	30 In-stock	Get Quote
PISO-CAN200U-T	609.000000	ICP DAS USA Inc.	2 PORT ISOLATED P...	1	PDF RFQ	30 In-stock	Get Quote
PISO-CM100U-T	649.000000	ICP DAS USA Inc.	INTELLIGENT CAN ...	1	PDF RFQ	30 In-stock	Get Quote
PISO-CM100U-D	649.000000	ICP DAS USA Inc.	INTELLIGENT CAN ...	1	PDF RFQ	30 In-stock	Get Quote
PISO-CAN400U-D	889.000000	ICP DAS USA Inc.	4 PORT ISOLATED P...	1	PDF RFQ	30 In-stock	Get Quote
PISO-CAN400U-T	889.000000	ICP DAS USA Inc.	4 PORT ISOLATED P...	1	PDF RFQ	30 In-stock	Get Quote
PISO-CAN800U-D	1099.000000	ICP DAS USA Inc.	8-PORT ISOLATED P...	1	PDF RFQ	30 In-stock	Get Quote
PCI-1602B-CE	140.420000	Advantech	2-PORT RS-232/422/485 P...	1	PDF RFQ	10 In-stock	Get Quote
PCI-1602C-AE	272.700000	Advantech	2 PORT RS232/422/485 PC...	1	PDF RFQ	2 In-stock	Get Quote
PCI-1751-BE	160.500000	Advantech	48-BIT DI/O CARD FO...	1	PDF RFQ	1 In-stock	Get Quote
PCI-1610B-DE	182.750000	Advantech	4-PORT RS-232 PCI CO...	1	PDF RFQ	3 In-stock	Get Quote
PCI-1739U-AE	187.440000	Advantech	48CH TTL DIGITAL I...	1	PDF RFQ	3 In-stock	Get Quote
PCI-1730U-BE	197.980000	Advantech	32CH ISO. DIO W/ 32C...	1	PDF RFQ	3 In-stock	Get Quote
PCIE-1765-AE	214.120000	Advantech	12-CH RELAY PCIE C...	1	PDF RFQ	3 In-stock	Get Quote
PCI-1753-CE	236.640000	Advantech	96CH TTL DIGITAL I...	1	PDF RFQ	6 In-stock	Get Quote
PCI-1762-BE	257.730000	Advantech	16CH RELAY & 16CH IS...	1	PDF RFQ	2 In-stock	Get Quote
PCI-1752U-BE	261.240000	Advantech	64CH ISOLATED DIG...	1	PDF RFQ	2 In-stock	Get Quote

1 / 4 Page, 77 Records

Previous Next

Skype

Hotline

E-mail