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

string(365) "( 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 = 861 AND valueid = 20 ) OR ( catid = 766 AND attrid = 506 AND valueid = 194513 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 766 ORDER BY `id` ASC LIMIT 0,20 )"

Filter：

9 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
5510003828F	2.050000	Dialight	LED CBI 3MM YW/GN/...	1	PDF RFQ	733 In-stock	Get Quote
5642210233F	1.552370	Dialight	LED CBI 3MM 3X1 GRN...	540	PDF RFQ	3,000 In-stock	Get Quote
5642210332F	1.847470	Dialight	LED CBI 3MM 3X1 YLW...	455	PDF RFQ	3,000 In-stock	Get Quote
5642210223F	1.607810	Dialight	LED CBI 3MM 3X1 GRN...	575	PDF RFQ	3,000 In-stock	Get Quote
5510003829F	1.068210	Dialight	LED CBI 3MM GN/YW/...	800	PDF RFQ	3,000 In-stock	Get Quote
5530123801F	1.014420	Dialight	LED CBI 3MM BI-LVL...	900	PDF RFQ	3,000 In-stock	Get Quote
5680008808F	3.961830	Dialight	LED CBI 3MM 4X2 G,G...	251	PDF RFQ	3,000 In-stock	Get Quote
5642210232F	1.640040	Dialight	LED CBI 3MM 3X1 GRN...	565	PDF RFQ	3,000 In-stock	Get Quote
5530012803F	6.561930	Dialight	LED CBI 3MM G/Y DI...	140	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 9 Records

Previous Next

Skype

Hotline

E-mail