string(363) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 456 AND attrid = 54 AND valueid = 20 ) OR ( catid = 456 AND attrid = 55 AND valueid = 349783 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 456 ORDER BY `id` ASC LIMIT 0,20 )"
array(2) {
  [0] => array(3) {
    [0] => string(366) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 456 AND attrid = 54 AND valueid = 20 ) OR ( catid = 456 AND attrid = 55 AND valueid = 349783 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 456 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"
  }
}
array(13) {
  [8037380] => array(17) {
    ["id"] => int(8037380)
    ["part"] => string(14) "ACC_GRP_SFRMP2"
    ["outpart"] => string(14) "ACC_GRP_SFRMP2"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "6736.700000"
    ["stock"] => int(5)
    ["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(0)
    ["catid"] => int(456)
  }
  [8037393] => array(17) {
    ["id"] => int(8037393)
    ["part"] => string(21) "JAWS PACK - NIRYO NED"
    ["outpart"] => string(21) "JAWS PACK - NIRYO NED"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "99.000000"
    ["stock"] => int(15)
    ["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(1102)
    ["catid"] => int(456)
  }
  [8037423] => array(17) {
    ["id"] => int(8037423)
    ["part"] => string(25) "LARGE GRIPPER - NIRYO NED"
    ["outpart"] => string(25) "LARGE GRIPPER - NIRYO NED"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "149.000000"
    ["stock"] => int(15)
    ["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(1102)
    ["catid"] => int(456)
  }
  [8037702] => array(17) {
    ["id"] => int(8037702)
    ["part"] => string(14) "ACC_GRP_EGP_40"
    ["outpart"] => string(14) "ACC_GRP_EGP_40"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "1647.560000"
    ["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(0)
    ["catid"] => int(456)
  }
  [8037913] => array(17) {
    ["id"] => int(8037913)
    ["part"] => string(7) "1320370"
    ["outpart"] => string(7) "1320370"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "2885.800000"
    ["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(1419)
    ["catid"] => int(456)
  }
  [8037926] => array(17) {
    ["id"] => int(8037926)
    ["part"] => string(7) "1348129"
    ["outpart"] => string(7) "1348129"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "2923.730000"
    ["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(1419)
    ["catid"] => int(456)
  }
  [8037942] => array(17) {
    ["id"] => int(8037942)
    ["part"] => string(14) "ACC_GRP_EGP_50"
    ["outpart"] => string(14) "ACC_GRP_EGP_50"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "2929.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(0)
    ["catid"] => int(456)
  }
  [8037958] => array(17) {
    ["id"] => int(8037958)
    ["part"] => string(7) "1348128"
    ["outpart"] => string(7) "1348128"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "3040.590000"
    ["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(1419)
    ["catid"] => int(456)
  }
  [8037974] => array(17) {
    ["id"] => int(8037974)
    ["part"] => string(7) "1327751"
    ["outpart"] => string(7) "1327751"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "3193.340000"
    ["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(1419)
    ["catid"] => int(456)
  }
  [8037989] => array(17) {
    ["id"] => int(8037989)
    ["part"] => string(7) "1327748"
    ["outpart"] => string(7) "1327748"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "3249.730000"
    ["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(1419)
    ["catid"] => int(456)
  }
  [8038004] => array(17) {
    ["id"] => int(8038004)
    ["part"] => string(7) "1327749"
    ["outpart"] => string(7) "1327749"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "3270.230000"
    ["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(1419)
    ["catid"] => int(456)
  }
  [8038021] => array(17) {
    ["id"] => int(8038021)
    ["part"] => string(7) "1327750"
    ["outpart"] => string(7) "1327750"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "3347.110000"
    ["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(1419)
    ["catid"] => int(456)
  }
  [8038036] => array(17) {
    ["id"] => int(8038036)
    ["part"] => string(7) "1327747"
    ["outpart"] => string(7) "1327747"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "3520.370000"
    ["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(1419)
    ["catid"] => int(456)
  }
}
Robotics - End Effectors - TeamGene
Welcome to visit our website, our working hours are: Monday to Friday 9:00-18:00.
Image Part prices Manufacturer Description MOQ Stock Action
ACC_GRP_SFRMP2 6736.700000 -
THE SOFT ROBOTIC...
1
RFQ
5
In-stock
Get Quote
JAWS PACK - NIRYO NED 99.000000 Niryo
JAWS PACK NED
1
RFQ
15
In-stock
Get Quote
LARGE GRIPPER - NIRYO NED 149.000000 Niryo
LARGE GRIPPER NE...
1
RFQ
15
In-stock
Get Quote
ACC_GRP_EGP_40 1647.560000 -
THE SCHUNK EGP 40 ...
1
RFQ
3,000
In-stock
Get Quote
1320370 2885.800000 SCHUNK
EOA-UR3510-EGP 40
1
RFQ
3,000
In-stock
Get Quote
1348129 2923.730000 SCHUNK
EOA-UR3510-JGP 80-1
1
RFQ
3,000
In-stock
Get Quote
ACC_GRP_EGP_50 2929.000000 -
THE SCHUNK EGP 50 ...
1
RFQ
3,000
In-stock
Get Quote
1348128 3040.590000 SCHUNK
EOA-UR3510-JGP 100-1
1
RFQ
3,000
In-stock
Get Quote
1327751 3193.340000 SCHUNK
EOA-UR3510-PGN+P 80-1
1
RFQ
3,000
In-stock
Get Quote
1327748 3249.730000 SCHUNK
EOA-UR3510-KGG-100-80
1
RFQ
3,000
In-stock
Get Quote
1327749 3270.230000 SCHUNK
EOA-UR3510-PZN+ 64-1
1
RFQ
3,000
In-stock
Get Quote
1327750 3347.110000 SCHUNK
EOA-UR3510-PGN+P 100-...
1
RFQ
3,000
In-stock
Get Quote
1327747 3520.370000 SCHUNK
EOA-UR3510-PSH-22-1
1
RFQ
3,000
In-stock
Get Quote
1 / 1 Page, 13 Records