LEDs - Circuit Board Indicators, Arrays, Light Bars, Bar Graphs

string(369) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 766 AND attrid = 882 AND valueid = 194137 ) OR ( catid = 766 AND attrid = 865 AND valueid = 171049 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 766 ORDER BY `id` ASC LIMIT 0,20 )"

Filter：

12 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
5320F5	1.400000	Visual Communications Company, LLC	LED GREEN T1 RIGH...	1	PDF RFQ	1,427 In-stock	Get Quote
5322F1	1.450000	Visual Communications Company, LLC	LED RED T1 .25" HI R...	1	PDF RFQ	500 In-stock	Get Quote
5322F7	0.549000	Visual Communications Company, LLC	LED YELLOW T1 .25" H...	2,000	PDF RFQ	3,000 In-stock	Get Quote
5321F7	0.000000	Visual Communications Company, LLC	LED YELLOW T1 RIG...	1	PDF RFQ	3,000 In-stock	Get Quote
5321F1	0.000000	Visual Communications Company, LLC	LED RED T1 .45" HI R...	1	PDF RFQ	3,000 In-stock	Get Quote
5322F5	0.000000	Visual Communications Company, LLC	LED GREEN T1 .25" HI...	1	PDF RFQ	3,000 In-stock	Get Quote
5320F1	0.000000	Visual Communications Company, LLC	LED RED T1 .35" HI R...	1	PDF RFQ	3,000 In-stock	Get Quote
5320F7	0.000000	Visual Communications Company, LLC	LED YELLOW T1 .35" H...	1	PDF RFQ	3,000 In-stock	Get Quote
5321F5	0.000000	Visual Communications Company, LLC	LED GREEN T1 .45" HI...	1	PDF RFQ	3,000 In-stock	Get Quote
5323F5	0.000000	Visual Communications Company, LLC	LED T-1 GREEN 562NM...	1	PDF RFQ	3,000 In-stock	Get Quote
5323F1	0.000000	Visual Communications Company, LLC	LED T-1 RED 650NM RA...	1	PDF RFQ	3,000 In-stock	Get Quote
5323F7	0.000000	Visual Communications Company, LLC	LED T-1 YELLOW 583N...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 12 Records

Previous Next

Skype

Hotline

E-mail