Software, Services

string(366) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE ( ( catid = 316 AND attrid = 5 AND valueid = 238282 ) OR ( catid = 316 AND attrid = 55 AND valueid = 267307 ) ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE `catid` = 316 ORDER BY `id` ASC LIMIT 0,20 )"

array(2) { [7175012] => array(17) { ["id"] => int(7175012) ["part"] => string(8) "SW300001" ["outpart"] => string(8) "SW300001" ["urlname"] => string(0) "" ["price"] => string(10) "249.990000" ["stock"] => int(3000) ["minqty"] => int(1) ["incqty"] => int(1) ["weight"] => string(6) "0.0000" ["volume"] => string(6) "0.0000" ["footprint"] => string(0) "" ["rohs"] => int(1) ["url"] => string(0) "" ["remote_url"] => string(0) "" ["status"] => int(1) ["brandid"] => int(1004) ["catid"] => int(316) } [7181027] => array(17) { ["id"] => int(7181027) ["part"] => string(11) "SW300001-LT" ["outpart"] => string(11) "SW300001-LT" ["urlname"] => string(0) "" ["price"] => string(8) "0.000000" ["stock"] => int(3000) ["minqty"] => int(1) ["incqty"] => int(1) ["weight"] => string(6) "0.0000" ["volume"] => string(6) "0.0000" ["footprint"] => string(0) "" ["rohs"] => int(1) ["url"] => string(0) "" ["remote_url"] => string(0) "" ["status"] => int(1) ["brandid"] => int(1004) ["catid"] => int(316) } }

Filter：

2 Records

Image	Part	prices	Manufacturer	Description	MOQ		Stock	Action
	SW300001	249.990000	Microchip Technology	SOFTWARE VISUAL ...	1	PDF RFQ	3,000 In-stock	Get Quote
	SW300001-LT	0.000000	Microchip Technology	DIGITAL FILTER D...	1	PDF RFQ	3,000 In-stock	Get Quote

1 / 1 Page, 2 Records

Previous Next

Skype

Hotline

E-mail