Robotics - End Effectors - TeamGene

string(374) "( SELECT `brandid`,COUNT(`brandid`) AS `count` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 456 AND attrid = 1295 AND valueid = 8658 ) OR ( catid = 456 AND attrid = 10 AND valueid = 20 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 456 GROUP BY `brandid` )"

Robotics - End Effectors - TeamGene

Filter：

2 Records

Image	Part	prices	Manufacturer	Description	MOQ		Stock	Action
	1348128	3040.590000	SCHUNK	EOA-UR3510-JGP 100-1	1	PDF RFQ	3,000 In-stock	Get Quote
	1327750	3347.110000	SCHUNK	EOA-UR3510-PGN+P 100-...	1	PDF RFQ	3,000 In-stock	Get Quote

1348128

EOA-UR3510-JGP 100-1

Stock : 3,000

: $3,040.5900

Buy RFQ

1327750

EOA-UR3510-PGN+P 100-1

Stock : 3,000

: $3,347.1100

Buy RFQ

1 / 1 Page, 2 Records