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

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 = 861 AND valueid = 108328 ) OR ( catid = 766 AND attrid = 4 AND valueid = 194364 )  ) 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

Filter：

4 Records

Image	Part	prices	Manufacturer	Description	MOQ		Stock	Action
	WP934SA/3YD	1.360000	Kingbright	LED IND 3MM TRI-LV...	1	PDF RFQ	3,000 In-stock	Get Quote
	WP934PJ/3YD	0.000000	Kingbright	LED 3MM TRI-LEVEL...	1	PDF RFQ	3,000 In-stock	Get Quote
	WP934RZ/3YD	0.000000	Kingbright	LED 3MM TRI-LEVEL...	1	PDF RFQ	3,000 In-stock	Get Quote
	XPZ3LUY147D	0.000000	SunLED	LED 3MM YLW DIFF T...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 4 Records