Display Modules - LED Character and Numeric

string(363) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 744 AND attrid = 847 AND valueid = 168224 ) OR ( catid = 744 AND attrid = 4 AND valueid = 15 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 744 ORDER BY `id` ASC LIMIT 0,20 )"

Filter：

17 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
LSHD-A101	1.280000	LITEON	DISPLAY 7-SEG 0.3" S...	1	PDF RFQ	37,730 In-stock	Get Quote
LSHD-A103	1.680000	LITEON	DISPLAY 7-SEG 0.3" S...	1	PDF RFQ	4,602 In-stock	Get Quote
MANF260C	0.960000	Rochester Electronics	DISPLAY 7 SEG 4" 1 C...	314	PDF RFQ	4,210 In-stock	Get Quote
INND-SS56RCB	1.830000	Inolux	DISPLAY 7SEG 0.56" S...	1	PDF RFQ	67 In-stock	Get Quote
LDQ-M286RI	7.330000	Lumex, Inc.	DISP 7SEG 0.28" QUAD...	1	PDF RFQ	3,000 In-stock	Get Quote
INND-SS56RAB	1.830000	Inolux	DISPLAY 7SEG 0.56" S...	1	PDF RFQ	3,000 In-stock	Get Quote
INND-SS56RAG	0.750000	Inolux	DISPLAY 7SEG 0.56" S...	3,750	PDF RFQ	3,000 In-stock	Get Quote
INND-SS56RCG	0.750000	Inolux	DISPLAY 7SEG 0.56" S...	3,750	PDF RFQ	3,000 In-stock	Get Quote
LDS-AD14RI	8.440000	Lumex, Inc.	DISPLAY 7SEG 2.24" S...	1	PDF RFQ	2 In-stock	Get Quote
LDS-CD14RI	9.550000	Lumex, Inc.	DISPLAY 7SEG 2.24" S...	1	PDF RFQ	5 In-stock	Get Quote
MANF260C	0.000000	onsemi	DISPLAY 7-SEG 4" SG...	1	PDF RFQ	3,000 In-stock	Get Quote
MANF280C	0.000000	onsemi	DISPLAY 7-SEG 4" SG...	1	PDF RFQ	3,000 In-stock	Get Quote
LDS-F3906RI	3.675000	Lumex, Inc.	DISP 14SEG 0.39" SGL...	1,008	PDF RFQ	3,000 In-stock	Get Quote
LDQ-N286RI	4.105500	Lumex, Inc.	DISP 7SEG 0.28" QUAD...	1,005	PDF RFQ	3,000 In-stock	Get Quote
LDS-CA504RI	0.000000	Lumex, Inc.	DISPLAY 7SEG 4.98" S...	1	PDF RFQ	3,000 In-stock	Get Quote
LDS-CD14RE	0.000000	Lumex, Inc.	DISPLAY LED 7-SEG...	1	PDF RFQ	3,000 In-stock	Get Quote
LDQ-N3606RI	0.000000	Lumex, Inc.	DISP 7SEG 0.36" QUAD...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 17 Records

Previous Next

Skype

Hotline

E-mail