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

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

Filter：

8 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
5640100227F	1.570820	Dialight	LED CBI 3MM 3X1 GRN...	535	PDF RFQ	3,000 In-stock	Get Quote
5640100816F	1.570820	Dialight	LED CBI 3MM 3X1 GRN...	535	PDF RFQ	3,000 In-stock	Get Quote
5530172400F	1.865910	Dialight	LED CBI 3MM BI-LVL...	450	PDF RFQ	3,000 In-stock	Get Quote
5640140772F	1.593870	Dialight	LED CBI 3MM 3X1 ORN...	530	PDF RFQ	3,000 In-stock	Get Quote
5640100207F	1.517920	Dialight	LED CBI 3MM 3X1 GRN...	610	PDF RFQ	3,000 In-stock	Get Quote
5640140207F	1.692600	Dialight	LED CBI 3MM 3X1 GRE...	550	PDF RFQ	3,000 In-stock	Get Quote
5680102727F	2.495950	Dialight	LED CBI 3MM 4X1 GRN...	400	PDF RFQ	3,000 In-stock	Get Quote
5680102227F	2.446730	Dialight	LED CBI 3MM 4X1 GRN...	410	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 8 Records

Previous Next

Skype

Hotline

E-mail