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 = 506 AND valueid = 194206 ) OR ( catid = 766 AND attrid = 847 AND valueid = 194207 )  ) 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
5680701144F 5.760000 Dialight
LED CBI 3MM 4X1 R/G...
1
RFQ
134
In-stock
Get Quote
5530741F 3.340000 Dialight
LED CBI 3MM BI-LVL...
1
RFQ
450
In-stock
Get Quote
5530714F 3.340000 Dialight
LED CBI 3MM BI-LVL...
1
RFQ
3,000
In-stock
Get Quote
5680701041F 4.680000 Dialight
LED CBI 3MM 4X1 R/G...
1
RFQ
20
In-stock
Get Quote
5530741200F 1.550150 Dialight
LED CBI 3MM BI-LVL...
600
RFQ
3,000
In-stock
Get Quote
5530754F 1.550150 Dialight
LED 3MM BI-LEVEL R...
600
RFQ
3,000
In-stock
Get Quote
5680701823F 3.635470 Dialight
LED CBI 3MM 4X1 R/G...
300
RFQ
3,000
In-stock
Get Quote
5640700818F 2.911650 Dialight
LED CBI 3MM 3X1 R/G...
345
RFQ
3,000
In-stock
Get Quote
5680701444F 1.812130 Dialight
LED CBI 3MM 4X1 R/G...
465
RFQ
3,000
In-stock
Get Quote
5690714100F 2.547000 Dialight
LED 3MM RA DIFF BI...
400
RFQ
3,000
In-stock
Get Quote
5690711400F 2.547000 Dialight
LED CBI 3MM BI-LEV...
400
RFQ
3,000
In-stock
Get Quote
5680701411F 3.471380 Dialight
LED CBI 3MM 4X1 Y/G...
290
RFQ
3,000
In-stock
Get Quote
5680701414F 3.635450 Dialight
LED CBI 3MM 4X1 R/G...
275
RFQ
3,000
In-stock
Get Quote
5680704411F 3.635450 Dialight
LED CBI 3MM 4X1 Y/G...
275
RFQ
3,000
In-stock
Get Quote
1 / 1 Page, 14 Records