Display Modules - LCD, OLED, Graphic

string(374) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 743 AND attrid = 842 AND valueid = 4 ) OR ( catid = 743 AND attrid = 263 AND valueid = 72879 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 743 GROUP BY `brandid` )"

Filter：

13 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
1077656	87.180000	Phoenix Contact	COVER WITH2.4 DISP...	1	PDF RFQ	7 In-stock	Get Quote
1209364	87.730000	Phoenix Contact	COVER WITH 2.4 TOU...	1	PDF RFQ	12 In-stock	Get Quote
1226370	103.610000	Phoenix Contact	COVER WITH2.4 DISP...	1	PDF RFQ	10 In-stock	Get Quote
1225275	106.640000	Phoenix Contact	COVER WITH 2.4 TOU...	1	PDF RFQ	10 In-stock	Get Quote
1246286	210.030000	Phoenix Contact	UCS 125X87 MM GRAY E...	1	PDF RFQ	10 In-stock	Get Quote
GLT24064R-1U-USB-FGW	139.300000	Matrix Orbital	LCD GRAPHIC TOUC...	1	PDF RFQ	3,000 In-stock	Get Quote
GLT24064R-1U-422-FGW	144.300000	Matrix Orbital	240X64 GRAPHIC DISP...	1	PDF RFQ	3,000 In-stock	Get Quote
GLT24064	189.500000	Matrix Orbital	LCD DISPLAY MONO...	1	PDF RFQ	3,000 In-stock	Get Quote
GLT24064-USB-FGW	194.500000	Matrix Orbital	240X64 GRAPHIC DISP...	1	PDF RFQ	3,000 In-stock	Get Quote
GLT24064R-1U-FGW-VPT	159.300000	Matrix Orbital	240X64 GRAPHIC DISP...	1	PDF RFQ	3,000 In-stock	Get Quote
GLT24064R-1U-422-FGW-VPT	164.300000	Matrix Orbital	240X64 GRAPHIC DISP...	1	PDF RFQ	3,000 In-stock	Get Quote
GLT240128-422-FGW	223.450000	Matrix Orbital	240X128 GRAPHIC DIS...	1	PDF RFQ	3,000 In-stock	Get Quote
GLT240128-422-FGW-VPT	243.450000	Matrix Orbital	240X128 GRAPHIC DIS...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 13 Records

Previous Next

Skype

Hotline

E-mail