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

string(378) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 766 AND attrid = 4 AND valueid = 194677 ) OR ( catid = 766 AND attrid = 165 AND valueid = 194172 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 766 GROUP BY `brandid` )"

Filter：

7 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
5640100777F	3.420000	Dialight	LED 3HI 3MM ORANGE...	1	PDF RFQ	3,000 In-stock	Get Quote
5640140777F	1.593870	Dialight	LED CBI 3MM 3X1 ORN...	530	PDF RFQ	3,000 In-stock	Get Quote
QLA764B-3A	0.549080	QT Brightek	LED 3MM BI-LVL RA ...	400	PDF RFQ	3,000 In-stock	Get Quote
593151515302F	3.914390	Dialight	LED PRISM	255	PDF RFQ	3,000 In-stock	Get Quote
5640100772F	1.669190	Dialight	LED CBI 3MM 3X1 ORN...	505	PDF RFQ	3,000 In-stock	Get Quote
593151515313F	3.396630	Dialight	LED PRISM	300	PDF RFQ	3,000 In-stock	Get Quote
5640100777	0.000000	Dialight	LED 3HI 3MM ORANGE...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 7 Records

Previous Next

Skype

Hotline

E-mail