string(360) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 261 AND attrid = 8 AND valueid = 20 ) OR ( catid = 261 AND attrid = 10 AND valueid = 1752 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 261 ORDER BY `id` ASC LIMIT 0,20 )"

array(8) {
  [4406202] => array(17) {
    ["id"] => int(4406202)
    ["part"] => string(7) "2906193"
    ["outpart"] => string(7) "2906193"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "1063.210000"
    ["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(1216)
    ["catid"] => int(261)
  }
  [4406218] => array(17) {
    ["id"] => int(4406218)
    ["part"] => string(7) "2906194"
    ["outpart"] => string(7) "2906194"
    ["urlname"] => string(0) ""
    ["price"] => string(11) "1063.210000"
    ["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(1216)
    ["catid"] => int(261)
  }
  [4408042] => array(17) {
    ["id"] => int(4408042)
    ["part"] => string(6) "912171"
    ["outpart"] => string(6) "912171"
    ["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(1781)
    ["catid"] => int(261)
  }
  [4408058] => array(17) {
    ["id"] => int(4408058)
    ["part"] => string(6) "911915"
    ["outpart"] => string(6) "911915"
    ["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(1781)
    ["catid"] => int(261)
  }
  [4408074] => array(17) {
    ["id"] => int(4408074)
    ["part"] => string(6) "911916"
    ["outpart"] => string(6) "911916"
    ["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(1781)
    ["catid"] => int(261)
  }
  [4411765] => array(17) {
    ["id"] => int(4411765)
    ["part"] => string(7) "2906189"
    ["outpart"] => string(7) "2906189"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "823.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(1216)
    ["catid"] => int(261)
  }
  [4411797] => array(17) {
    ["id"] => int(4411797)
    ["part"] => string(7) "2906196"
    ["outpart"] => string(7) "2906196"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "863.970000"
    ["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(1216)
    ["catid"] => int(261)
  }
  [4411812] => array(17) {
    ["id"] => int(4411812)
    ["part"] => string(7) "2906195"
    ["outpart"] => string(7) "2906195"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "863.970000"
    ["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(1216)
    ["catid"] => int(261)
  }
}
Terminal Blocks - Interface Modules - TeamGene
Welcome to visit our website, our working hours are: Monday to Friday 9:00-18:00.
TeamGene
  1. Home
  2. All products
  3. Connectors, Interconnects
  4. Terminal Blocks - Interface Modules
Manufacturer：
More
Part Status：
Features：
Wire Gauge：
Control Side Connection：
Control Side Cable Retainer：
Positions / Poles：
Current Rating (Per Contact)：
Filter：
8 Records
Image Part prices Manufacturer Description MOQ Stock Action
2906193
2906193
 1063.210000 Phoenix Contact
INTERFACE MOD DS...
 1
RFQ
3,000
In-stock
 Get Quote
2906194
2906194
 1063.210000 Phoenix Contact
INTERFACE MOD DS...
 1
RFQ
3,000
In-stock
 Get Quote
912171
912171
 0.000000 Weidmuller
INTERFACE MOD RJ...
 1
RFQ
3,000
In-stock
 Get Quote
911915
911915
 0.000000 Weidmuller
INTERFACE MOD RJ...
 1
RFQ
3,000
In-stock
 Get Quote
911916
911916
 0.000000 Weidmuller
INTERFACE MOD RJ...
 1
RFQ
3,000
In-stock
 Get Quote
2906189
2906189
 823.230000 Phoenix Contact
VARIOFACE 16-CHAN...
 1
RFQ
3,000
In-stock
 Get Quote
2906196
2906196
 863.970000 Phoenix Contact
INTERFACE MOD DS...
 1
RFQ
3,000
In-stock
 Get Quote
2906195
2906195
 863.970000 Phoenix Contact
INTERFACE MOD DS...
 1
RFQ
3,000
In-stock
 Get Quote
1 / 1 Page, 8 Records
Previous Next
TeamGene
About Us
Policies
CONNECT WITH US
Copyright © TEAMGENE LIMITED