string(367) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 846 AND attrid = 63 AND valueid = 158460 ) OR ( catid = 846 AND attrid = 600 AND valueid = 56674 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 846 ORDER BY `id` ASC LIMIT 0,20 )"

array(4) {
  [10063922] => array(17) {
    ["id"] => int(10063922)
    ["part"] => string(8) "MM2-LV-T"
    ["outpart"] => string(8) "MM2-LV-T"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "419.530000"
    ["stock"] => int(38)
    ["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(606)
    ["catid"] => int(846)
  }
  [10073598] => array(17) {
    ["id"] => int(10073598)
    ["part"] => string(11) "MM2-LV-T-LF"
    ["outpart"] => string(11) "MM2-LV-T-LF"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "392.019050"
    ["stock"] => int(3000)
    ["minqty"] => int(21)
    ["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(606)
    ["catid"] => int(846)
  }
  [10073661] => array(17) {
    ["id"] => int(10073661)
    ["part"] => string(10) "MM2-LV-T-U"
    ["outpart"] => string(10) "MM2-LV-T-U"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "419.530000"
    ["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(606)
    ["catid"] => int(846)
  }
  [10073862] => array(17) {
    ["id"] => int(10073862)
    ["part"] => string(11) "MM2-LV-T-CC"
    ["outpart"] => string(11) "MM2-LV-T-CC"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "565.780000"
    ["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(606)
    ["catid"] => int(846)
  }
}
RF Transceiver Modules and Modems - TeamGene
Welcome to visit our website, our working hours are: Monday to Friday 9:00-18:00.
TeamGene
  1. Home
  2. All products
  3. RF/IF and RFID
  4. RF Transceiver Modules and Modems
Filter：
4 Records
Image Part prices Manufacturer Description MOQ Stock Action
MM2-LV-T
MM2-LV-T
 419.530000 FreeWave Technologies, Inc.
RX TXRX MOD ISM < ...
 1
RFQ
38
In-stock
 Get Quote
MM2-LV-T-LF
MM2-LV-T-LF
 392.019050 FreeWave Technologies, Inc.
RX TXRX MOD ISM < ...
 21
RFQ
3,000
In-stock
 Get Quote
MM2-LV-T-U
MM2-LV-T-U
 419.530000 FreeWave Technologies, Inc.
RX TXRX MOD ISM < ...
 1
RFQ
3,000
In-stock
 Get Quote
MM2-LV-T-CC
MM2-LV-T-CC
 565.780000 FreeWave Technologies, Inc.
RX TXRX MOD ISM < ...
 1
RFQ
3,000
In-stock
 Get Quote
1 / 1 Page, 4 Records
Previous Next
TeamGene
About Us
Policies
CONNECT WITH US
Copyright © TEAMGENE LIMITED