Display Modules - LCD, OLED, Graphic - TeamGene

string(379) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 743 AND attrid = 839 AND valueid = 166459 ) OR ( catid = 743 AND attrid = 263 AND valueid = 72593 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 743 GROUP BY `brandid` )"

Display Modules - LCD, OLED, Graphic - TeamGene

Filter：

4 Records

Image	Part	prices	Manufacturer	Description	MOQ		Stock	Action
	E28RA-I-CW600-C	26.760000	Focus LCDs	2.8" IPS TFT CAPACI...	1	PDF RFQ	8 In-stock	Get Quote
	E24RE-I-CW400-C	44.460000	Focus LCDs	2.4" IPS TFT CAPACI...	1	PDF RFQ	10 In-stock	Get Quote
	E32RA-CW370-C	45.020000	Focus LCDs	3.2" TFT CAPACITIV...	1	PDF RFQ	18 In-stock	Get Quote
	E28RA-FW580-C	50.160000	Focus LCDs	2.8" IPS TFT CAPACI...	1	PDF RFQ	13 In-stock	Get Quote

1 / 1 Page, 4 Records