string(367) "( 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 = 4 AND valueid = 194149 ) OR ( catid = 766 AND attrid = 848 AND valueid = 194347 )  ) 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
5530112F 2.270000 Dialight
LED CBI 3MM BI-LVL...
1
RFQ
3,000
In-stock
Get Quote
5520212F 2.270000 Dialight
LED CBI 5MM BI-LVL...
1
RFQ
76
In-stock
Get Quote
5530121F 1.910000 Dialight
LED 2HI 3MM GREEN ...
1
RFQ
3,000
In-stock
Get Quote
5530112010F 0.956010 Dialight
LED CBI 3MM BI-LVL...
900
RFQ
3,000
In-stock
Get Quote
5530112300F 0.750000 Dialight
LED 3MM RED/GREEN...
1,100
RFQ
3,000
In-stock
Get Quote
5520821F 0.784500 Dialight
LED 5MM CBI BI-LEV...
1,050
RFQ
3,000
In-stock
Get Quote
5520812F 0.784500 Dialight
LED CBI 5MM BI-LVL...
1,050
RFQ
3,000
In-stock
Get Quote
5530112202F 2.557950 Dialight
LED CBI 3MM BI-LVL...
420
RFQ
3,000
In-stock
Get Quote
5530112212F 2.557950 Dialight
LED CBI 3MM BI-LVL...
420
RFQ
3,000
In-stock
Get Quote
5530121 0.000000 Dialight
LED 2HI 3MM GREEN ...
1
RFQ
3,000
In-stock
Get Quote
5530112006F 5.648300 Dialight
LED CBI 3MM BI-LVL...
171
RFQ
3,000
In-stock
Get Quote
5530112306F 7.107820 Dialight
LED CBI 3MM BI-LVL...
133
RFQ
3,000
In-stock
Get Quote
5530112206F 7.716920 Dialight
LED CBI 3MM BI-LVL...
133
RFQ
3,000
In-stock
Get Quote
5530112216F 7.716920 Dialight
LED CBI 3MM BI-LVL...
133
RFQ
3,000
In-stock
Get Quote
1 / 1 Page, 14 Records