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 = 1701 AND valueid = 2632 ) OR ( catid = 846 AND attrid = 46 AND valueid = 141964 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 846 ORDER BY `id` ASC LIMIT 0,20 )"

array(10) {
  [10049322] => array(17) {
    ["id"] => int(10049322)
    ["part"] => string(11) "MNZB-A24-U0"
    ["outpart"] => string(11) "MNZB-A24-U0"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "29.450000"
    ["stock"] => int(370)
    ["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(846)
  }
  [10062518] => array(17) {
    ["id"] => int(10062518)
    ["part"] => string(18) "JN5148/001M04T,534"
    ["outpart"] => string(18) "JN5148/001M04T,534"
    ["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(1127)
    ["catid"] => int(846)
  }
  [10063258] => array(17) {
    ["id"] => int(10063258)
    ["part"] => string(12) "ATZB-A24-UFL"
    ["outpart"] => string(12) "ATZB-A24-UFL"
    ["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(1004)
    ["catid"] => int(846)
  }
  [10063274] => array(17) {
    ["id"] => int(10063274)
    ["part"] => string(11) "ATZB-A24-U0"
    ["outpart"] => string(11) "ATZB-A24-U0"
    ["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(1004)
    ["catid"] => int(846)
  }
  [10066298] => array(17) {
    ["id"] => int(10066298)
    ["part"] => string(11) "ATZB-A24-U0"
    ["outpart"] => string(11) "ATZB-A24-U0"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "47.540000"
    ["stock"] => int(20)
    ["minqty"] => int(7)
    ["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(1376)
    ["catid"] => int(846)
  }
  [10078748] => array(17) {
    ["id"] => int(10078748)
    ["part"] => string(6) "AWP24S"
    ["outpart"] => string(6) "AWP24S"
    ["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(158)
    ["catid"] => int(846)
  }
  [10078778] => array(17) {
    ["id"] => int(10078778)
    ["part"] => string(6) "AWA24S"
    ["outpart"] => string(6) "AWA24S"
    ["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(158)
    ["catid"] => int(846)
  }
  [10080163] => array(17) {
    ["id"] => int(10080163)
    ["part"] => string(12) "AW24RUH-U-AA"
    ["outpart"] => string(12) "AW24RUH-U-AA"
    ["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(158)
    ["catid"] => int(846)
  }
  [10085141] => array(17) {
    ["id"] => int(10085141)
    ["part"] => string(13) "ATZB-A24-UFLR"
    ["outpart"] => string(13) "ATZB-A24-UFLR"
    ["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(1004)
    ["catid"] => int(846)
  }
  [10085153] => array(17) {
    ["id"] => int(10085153)
    ["part"] => string(12) "ATZB-A24-U0R"
    ["outpart"] => string(12) "ATZB-A24-U0R"
    ["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(1004)
    ["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：
10 Records
Image Part prices Manufacturer Description MOQ Stock Action
MNZB-A24-U0
MNZB-A24-U0
 29.450000 -
RF TXRX MODULE 802...
 1
RFQ
370
In-stock
 Get Quote
JN5148/001M04T,534
JN5148/001M04T,534
 0.000000 NXP Semiconductors
RX TXRX MODULE 802...
 1
RFQ
3,000
In-stock
 Get Quote
ATZB-A24-UFL
ATZB-A24-UFL
 0.000000 Microchip Technology
RX TXRX MODULE 802...
 1
RFQ
3,000
In-stock
 Get Quote
ATZB-A24-U0
ATZB-A24-U0
 0.000000 Microchip Technology
RX TXRX MODULE 802...
 1
RFQ
3,000
In-stock
 Get Quote
ATZB-A24-U0
ATZB-A24-U0
 47.540000 Rochester Electronics
ZIGBIT 2.4 GHZ AMP...
 7
RFQ
20
In-stock
 Get Quote
AWP24S
AWP24S
 0.000000 Artaflex Inc.
RX TXRX MOD ISM > ...
 1
RFQ
3,000
In-stock
 Get Quote
AWA24S
AWA24S
 0.000000 Artaflex Inc.
RX TXRX MOD ISM > ...
 1
RFQ
3,000
In-stock
 Get Quote
AW24RUH-U-AA
AW24RUH-U-AA
 0.000000 Artaflex Inc.
RX TXRX MOD ISM > ...
 1
RFQ
3,000
In-stock
 Get Quote
ATZB-A24-UFLR
ATZB-A24-UFLR
 0.000000 Microchip Technology
RX TXRX MODULE 802...
 1
RFQ
3,000
In-stock
 Get Quote
ATZB-A24-U0R
ATZB-A24-U0R
 0.000000 Microchip Technology
RX TXRX MODULE 802...
 1
RFQ
3,000
In-stock
 Get Quote
1 / 1 Page, 10 Records
Previous Next
TeamGene
About Us
Policies
CONNECT WITH US
Copyright © TEAMGENE LIMITED