string(368) "( SELECT `prodid` AS `id` FROM `tbl_product_idx` `t1` INNER JOIN ( SELECT `prodid` AS `id` FROM `tbl_product_attr_idx` WHERE  (   ( catid = 460 AND attrid = 54 AND valueid = 350647 ) OR ( catid = 460 AND attrid = 600 AND valueid = 160604 )  ) GROUP BY `prodid` HAVING COUNT(`prodid`) >= 2 ) t2 ON t1.`prodid`=t2.`id` WHERE  `catid` = 460 ORDER BY `id` ASC LIMIT 0,20 )"
array(20) {
  [8042531] => array(17) {
    ["id"] => int(8042531)
    ["part"] => string(9) "PME-1FF-R"
    ["outpart"] => string(9) "PME-1FF-R"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "67.950000"
    ["stock"] => int(43)
    ["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(746)
    ["catid"] => int(460)
  }
  [8042547] => array(17) {
    ["id"] => int(8042547)
    ["part"] => string(9) "PME-1FF-G"
    ["outpart"] => string(9) "PME-1FF-G"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "67.950000"
    ["stock"] => int(39)
    ["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(746)
    ["catid"] => int(460)
  }
  [8042563] => array(17) {
    ["id"] => int(8042563)
    ["part"] => string(9) "PME-1FF-Y"
    ["outpart"] => string(9) "PME-1FF-Y"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "67.950000"
    ["stock"] => int(26)
    ["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(746)
    ["catid"] => int(460)
  }
  [8042579] => array(17) {
    ["id"] => int(8042579)
    ["part"] => string(9) "PME-1FF-B"
    ["outpart"] => string(9) "PME-1FF-B"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "67.950000"
    ["stock"] => int(26)
    ["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(746)
    ["catid"] => int(460)
  }
  [8042594] => array(17) {
    ["id"] => int(8042594)
    ["part"] => string(9) "PME-1FF-C"
    ["outpart"] => string(9) "PME-1FF-C"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "67.950000"
    ["stock"] => int(26)
    ["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(746)
    ["catid"] => int(460)
  }
  [8042944] => array(17) {
    ["id"] => int(8042944)
    ["part"] => string(10) "PMEF-1FF-B"
    ["outpart"] => string(10) "PMEF-1FF-B"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "77.950000"
    ["stock"] => int(50)
    ["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(746)
    ["catid"] => int(460)
  }
  [8042960] => array(17) {
    ["id"] => int(8042960)
    ["part"] => string(10) "PMEF-1FF-R"
    ["outpart"] => string(10) "PMEF-1FF-R"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "77.950000"
    ["stock"] => int(46)
    ["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(746)
    ["catid"] => int(460)
  }
  [8042976] => array(17) {
    ["id"] => int(8042976)
    ["part"] => string(10) "PMEF-1FF-G"
    ["outpart"] => string(10) "PMEF-1FF-G"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "77.950000"
    ["stock"] => int(43)
    ["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(746)
    ["catid"] => int(460)
  }
  [8042992] => array(17) {
    ["id"] => int(8042992)
    ["part"] => string(10) "PMEF-1FF-Y"
    ["outpart"] => string(10) "PMEF-1FF-Y"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "77.950000"
    ["stock"] => int(43)
    ["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(746)
    ["catid"] => int(460)
  }
  [8043008] => array(17) {
    ["id"] => int(8043008)
    ["part"] => string(10) "PMEF-1FF-C"
    ["outpart"] => string(10) "PMEF-1FF-C"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "77.950000"
    ["stock"] => int(26)
    ["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(746)
    ["catid"] => int(460)
  }
  [8051348] => array(17) {
    ["id"] => int(8051348)
    ["part"] => string(13) "MWEB-4FF-RYGB"
    ["outpart"] => string(13) "MWEB-4FF-RYGB"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "225.950000"
    ["stock"] => int(1)
    ["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(746)
    ["catid"] => int(460)
  }
  [8051412] => array(17) {
    ["id"] => int(8051412)
    ["part"] => string(13) "MWETB-3FF-RYG"
    ["outpart"] => string(13) "MWETB-3FF-RYG"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "229.950000"
    ["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(746)
    ["catid"] => int(460)
  }
  [8051428] => array(17) {
    ["id"] => int(8051428)
    ["part"] => string(14) "MWETB-3FF-RYGM"
    ["outpart"] => string(14) "MWETB-3FF-RYGM"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "229.960000"
    ["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(746)
    ["catid"] => int(460)
  }
  [8052651] => array(17) {
    ["id"] => int(8052651)
    ["part"] => string(10) "PME-2FF-RG"
    ["outpart"] => string(10) "PME-2FF-RG"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "97.950000"
    ["stock"] => int(31)
    ["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(746)
    ["catid"] => int(460)
  }
  [8052667] => array(17) {
    ["id"] => int(8052667)
    ["part"] => string(10) "PME-2FF-RY"
    ["outpart"] => string(10) "PME-2FF-RY"
    ["urlname"] => string(0) ""
    ["price"] => string(9) "97.950000"
    ["stock"] => int(29)
    ["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(746)
    ["catid"] => int(460)
  }
  [8052966] => array(17) {
    ["id"] => int(8052966)
    ["part"] => string(11) "PMEF-2FF-RY"
    ["outpart"] => string(11) "PMEF-2FF-RY"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "107.950000"
    ["stock"] => int(50)
    ["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(746)
    ["catid"] => int(460)
  }
  [8053014] => array(17) {
    ["id"] => int(8053014)
    ["part"] => string(11) "PMEF-2FF-RG"
    ["outpart"] => string(11) "PMEF-2FF-RG"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "107.950000"
    ["stock"] => int(43)
    ["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(746)
    ["catid"] => int(460)
  }
  [8053328] => array(17) {
    ["id"] => int(8053328)
    ["part"] => string(11) "PME-3FF-RYG"
    ["outpart"] => string(11) "PME-3FF-RYG"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "116.950000"
    ["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(746)
    ["catid"] => int(460)
  }
  [8053602] => array(17) {
    ["id"] => int(8053602)
    ["part"] => string(12) "PMEF-3FF-RYG"
    ["outpart"] => string(12) "PMEF-3FF-RYG"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "126.950000"
    ["stock"] => int(47)
    ["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(746)
    ["catid"] => int(460)
  }
  [8053823] => array(17) {
    ["id"] => int(8053823)
    ["part"] => string(14) "MWEB-4FF-RYGBM"
    ["outpart"] => string(14) "MWEB-4FF-RYGBM"
    ["urlname"] => string(0) ""
    ["price"] => string(10) "225.930000"
    ["stock"] => int(1)
    ["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(746)
    ["catid"] => int(460)
  }
}
Stackable Tower Lighting, Beacons, and Components - 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
PME-1FF-R 67.950000 IndustrialeMart
TOWER 45MM STEADY...
1
RFQ
43
In-stock
Get Quote
PME-1FF-G 67.950000 IndustrialeMart
TOWER 45MM STEADY...
1
RFQ
39
In-stock
Get Quote
PME-1FF-Y 67.950000 IndustrialeMart
TOWER 45MM STEADY...
1
RFQ
26
In-stock
Get Quote
PME-1FF-B 67.950000 IndustrialeMart
TOWER 45MM STEADY...
1
RFQ
26
In-stock
Get Quote
PME-1FF-C 67.950000 IndustrialeMart
TOWER 45MM STEADY...
1
RFQ
26
In-stock
Get Quote
PMEF-1FF-B 77.950000 IndustrialeMart
TOWER 45MM FLASH 1...
1
RFQ
50
In-stock
Get Quote
PMEF-1FF-R 77.950000 IndustrialeMart
TOWER 45MM FLASH 1...
1
RFQ
46
In-stock
Get Quote
PMEF-1FF-G 77.950000 IndustrialeMart
TOWER 45MM FLASH 1...
1
RFQ
43
In-stock
Get Quote
PMEF-1FF-Y 77.950000 IndustrialeMart
TOWER 45MM FLASH 1...
1
RFQ
43
In-stock
Get Quote
PMEF-1FF-C 77.950000 IndustrialeMart
TOWER 45MM FLASH 1...
1
RFQ
26
In-stock
Get Quote
MWEB-4FF-RYGB 225.950000 IndustrialeMart
WALL SIGNAL RYGB...
1
RFQ
1
In-stock
Get Quote
MWETB-3FF-RYG 229.950000 IndustrialeMart
WALL MULTI RYG 85D...
1
RFQ
3,000
In-stock
Get Quote
MWETB-3FF-RYGM 229.960000 IndustrialeMart
WALL MULTI RYG 85D...
1
RFQ
3,000
In-stock
Get Quote
PME-2FF-RG 97.950000 IndustrialeMart
TOWER 45MM STEADY...
1
RFQ
31
In-stock
Get Quote
PME-2FF-RY 97.950000 IndustrialeMart
TOWER 45MM STEADY...
1
RFQ
29
In-stock
Get Quote
PMEF-2FF-RY 107.950000 IndustrialeMart
TOWER 45MM FLASH 1...
1
RFQ
50
In-stock
Get Quote
PMEF-2FF-RG 107.950000 IndustrialeMart
TOWER 45MM FLASH 1...
1
RFQ
43
In-stock
Get Quote
PME-3FF-RYG 116.950000 IndustrialeMart
TOWER 45MM STEADY...
1
RFQ
27
In-stock
Get Quote
PMEF-3FF-RYG 126.950000 IndustrialeMart
TOWER 45MM FLASH 1...
1
RFQ
47
In-stock
Get Quote
MWEB-4FF-RYGBM 225.930000 IndustrialeMart
WALL SIGNAL RYGB...
1
RFQ
1
In-stock
Get Quote
1 / 2 Page, 24 Records