Display Modules - LCD, OLED, Graphic

string(312) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 743 AND attrid = 839 AND valueid = 167536 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 1 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 743 ORDER BY `id` ASC LIMIT 0,20 )"

array(2) { [0] => array(3) { [0] => string(315) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 743 AND attrid = 839 AND valueid = 167536 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 1 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 743 ORDER BY `id` ASC LIMIT 0,20 ) t2" [1] => string(19) "(t1.`id` = t2.`id`)" [2] => string(5) "INNER" } [1] => array(3) { [0] => string(15) "product_idx idx" [1] => string(24) "(t1.`id` = idx.`prodid`)" [2] => string(4) "LEFT" } }

Filter：

7 Records

Part	prices	Manufacturer	Description	MOQ		Stock	Action
NHD-4.3-480272MB-ASXN-CTP	95.820000	Newhaven Display, Intl.	4.3" MOUNTABLE SUN...	1	PDF RFQ	3,000 In-stock	Get Quote
NHD-4.3-480272MB-ASXN	58.530000	Newhaven Display, Intl.	4.3" MOUNTABLE SUN...	100	PDF RFQ	3,000 In-stock	Get Quote
NHD-4.3-480272MB-ASXN-T	63.720000	Newhaven Display, Intl.	LCD DISPLAY TFT 4...	100	PDF RFQ	3,000 In-stock	Get Quote
NHD-4.3-480272EF-ASXN#	54.670000	Newhaven Display, Intl.	LCD 4.3" TFT SUNLIG...	1	PDF RFQ	3,000 In-stock	Get Quote
NHD-4.3-480272EF-ASXN#-T	58.270000	Newhaven Display, Intl.	LCD DISPLAY TFT 4...	1	PDF RFQ	3,000 In-stock	Get Quote
NHD-4.3-480272EF-ASXN#-CTP	90.150000	Newhaven Display, Intl.	LCD 4.3"TFT CAP TOU...	1	PDF RFQ	3,000 In-stock	Get Quote
ST0430E3WY-RSLW-F	26.490000	Santek	4.3" TFT LCD 480X272 W...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 7 Records

Previous Next

Skype

Hotline

E-mail