string(365) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 420 AND attrid = 15 AND valueid = 733 ) OR ( catid = 420 AND attrid = 600 AND valueid = 310821 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 420 ORDER BY `id` ASC LIMIT 0,20 )"
array(13) {
  [7816707] => array(17) {
    ["id"] => int(7816707)
    ["part"] => string(10) "8104210000"
    ["outpart"] => string(10) "8104210000"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "81.000000"
    ["stock"] => int(40)
    ["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(1119)
    ["catid"] => int(420)
  }
  [7816753] => array(17) {
    ["id"] => int(7816753)
    ["part"] => string(10) "8104211200"
    ["outpart"] => string(10) "8104211200"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "90.000000"
    ["stock"] => int(27)
    ["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(1119)
    ["catid"] => int(420)
  }
  [7817090] => array(17) {
    ["id"] => int(7817090)
    ["part"] => string(10) "8103000002"
    ["outpart"] => string(10) "8103000002"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "57.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(1119)
    ["catid"] => int(420)
  }
  [7817118] => array(17) {
    ["id"] => int(7817118)
    ["part"] => string(10) "8032104012"
    ["outpart"] => string(10) "8032104012"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "65.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(1119)
    ["catid"] => int(420)
  }
  [7818044] => array(17) {
    ["id"] => int(7818044)
    ["part"] => string(10) "8105000000"
    ["outpart"] => string(10) "8105000000"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "107.000000"
    ["stock"] => int(25)
    ["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(1119)
    ["catid"] => int(420)
  }
  [7818125] => array(17) {
    ["id"] => int(7818125)
    ["part"] => string(10) "80480D2080"
    ["outpart"] => string(10) "80480D2080"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "115.000000"
    ["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(1119)
    ["catid"] => int(420)
  }
  [7824537] => array(17) {
    ["id"] => int(7824537)
    ["part"] => string(10) "8102020000"
    ["outpart"] => string(10) "8102020000"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "101.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(1119)
    ["catid"] => int(420)
  }
  [7824644] => array(17) {
    ["id"] => int(7824644)
    ["part"] => string(10) "8105002500"
    ["outpart"] => string(10) "8105002500"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "128.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(1119)
    ["catid"] => int(420)
  }
  [7824775] => array(17) {
    ["id"] => int(7824775)
    ["part"] => string(10) "8102020010"
    ["outpart"] => string(10) "8102020010"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "132.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(1119)
    ["catid"] => int(420)
  }
  [7825256] => array(17) {
    ["id"] => int(7825256)
    ["part"] => string(10) "8120200120"
    ["outpart"] => string(10) "8120200120"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "184.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(1119)
    ["catid"] => int(420)
  }
  [7829337] => array(17) {
    ["id"] => int(7829337)
    ["part"] => string(10) "8300200220"
    ["outpart"] => string(10) "8300200220"
    ["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(1119)
    ["catid"] => int(420)
  }
  [7829353] => array(17) {
    ["id"] => int(7829353)
    ["part"] => string(10) "8200200220"
    ["outpart"] => string(10) "8200200220"
    ["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(1119)
    ["catid"] => int(420)
  }
  [7829369] => array(17) {
    ["id"] => int(7829369)
    ["part"] => string(10) "8104211307"
    ["outpart"] => string(10) "8104211307"
    ["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(1119)
    ["catid"] => int(420)
  }
}
Controllers - Process, Temperature - TeamGene
Welcome to visit our website, our working hours are: Monday to Friday 9:00-18:00.
Number of Characters Per Row:
Image Part prices Manufacturer Description MOQ Stock Action
8104210000 81.000000 Novus Automation
N1040 CONTROL TEMP...
1
RFQ
40
In-stock
Get Quote
8104211200 90.000000 Novus Automation
N1040 CONTROL TEMP...
1
RFQ
27
In-stock
Get Quote
8103000002 57.000000 Novus Automation
N1030 CONTROL TEMP...
1
RFQ
3,000
In-stock
Get Quote
8032104012 65.000000 Novus Automation
N321 CONTROL TEMP ...
1
RFQ
3,000
In-stock
Get Quote
8105000000 107.000000 Novus Automation
N1050 CONTROL TEMP...
1
RFQ
25
In-stock
Get Quote
80480D2080 115.000000 Novus Automation
N480D CONTROL TEMP...
1
RFQ
5
In-stock
Get Quote
8102020000 101.000000 Novus Automation
N1020 CONTROL TEMP...
1
RFQ
3,000
In-stock
Get Quote
8105002500 128.000000 Novus Automation
N1050 CONTROL TEMP...
1
RFQ
3,000
In-stock
Get Quote
8102020010 132.000000 Novus Automation
N1020 CONTROL TEMP...
1
RFQ
3,000
In-stock
Get Quote
8120200120 184.000000 Novus Automation
N1200 CONTROL TEMP...
1
RFQ
3,000
In-stock
Get Quote
8300200220 0.000000 Novus Automation
N3000 CONTROL TEMP...
1
RFQ
3,000
In-stock
Get Quote
8200200220 0.000000 Novus Automation
N2000 CONTROL TEMP...
1
RFQ
3,000
In-stock
Get Quote
8104211307 0.000000 Novus Automation
N1040 CONTROL TEMP...
1
RFQ
3,000
In-stock
Get Quote
1 / 1 Page, 13 Records