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 = 173249 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 766 ORDER BY `id` ASC LIMIT 0,20 )"
LEDs - Circuit Board Indicators, Arrays, Light Bars, Bar Graphs - TeamGene
Welcome to visit our website, our working hours are: Monday to Friday 9:00-18:00.
Image Part prices Manufacturer Description MOQ Stock Action
WP934EW/GD5V 1.150000 Kingbright
GREEN RIGHT ANGL...
1
RFQ
5,814
In-stock
Get Quote
WP934MD/LILGD 1.090000 Kingbright
REDGREEN BI-LEVE...
1
RFQ
11,913
In-stock
Get Quote
SSF-LXH240GGD 1.170000 Lumex, Inc.
LED 3MM RA 2-HI GRN...
1
RFQ
61,410
In-stock
Get Quote
WP934SA/LILYLGD 1.690000 Kingbright
GREEN RIGHT ANGL...
1
RFQ
17,185
In-stock
Get Quote
SSF-LXH240IID 1.120000 Lumex, Inc.
LED 3MM RA 2-HI RED...
1
RFQ
3,830
In-stock
Get Quote
WP934SA/IYGD5V 2.380000 Kingbright
REDYELLOWGREEN T...
1
RFQ
19,821
In-stock
Get Quote
XNK1LUG147D 0.175960 SunLED
LED 1POS GREEN DI...
1,000
RFQ
3,000
In-stock
Get Quote
XNK1LUY147D 0.175960 SunLED
LED 1POS YELLOW D...
1,000
RFQ
3,000
In-stock
Get Quote
XPV1LUR147D 0.175960 SunLED
LED 3MM RED DIFF 1...
1,000
RFQ
3,000
In-stock
Get Quote
XPV1LUY147D 0.175960 SunLED
LED 3MM YELLOW DI...
1,000
RFQ
3,000
In-stock
Get Quote
XVB1LUG147D 0.175960 SunLED
LED 3MM GREEN DIF...
1,000
RFQ
3,000
In-stock
Get Quote
XVB1LUR147D 0.175960 SunLED
LED 3MM RED DIFFU...
1,000
RFQ
3,000
In-stock
Get Quote
XPC2LUG11D 0.364110 SunLED
LED 3MM GRN DIFF B...
1,000
RFQ
3,000
In-stock
Get Quote
XPC2LUR11D 0.364110 SunLED
LED 3MM REG DIFF B...
1,000
RFQ
3,000
In-stock
Get Quote
XPC2LUY11D 0.364110 SunLED
LED 3MM YLW DIFF B...
1,000
RFQ
3,000
In-stock
Get Quote
XPF2LUG11D 0.386370 SunLED
LED IND 3MM GN DIF...
1,000
RFQ
3,000
In-stock
Get Quote
XPF2LUR11D 0.386370 SunLED
LED IND 3MM RD DIF...
1,000
RFQ
3,000
In-stock
Get Quote
XPF2LUY11D 0.386370 SunLED
LED IND 3MM YW DIF...
1,000
RFQ
3,000
In-stock
Get Quote
XVG2LUG147D 0.386370 SunLED
LED 3MM GREEN DIF...
1,000
RFQ
3,000
In-stock
Get Quote
XVG2LUR147D 0.386370 SunLED
LED 3MM RED DIFF B...
1,000
RFQ
3,000
In-stock
Get Quote
1 / 2 Page, 35 Records