Stage Ninja

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1 LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (14032, 14033, 14034, 14035, 14036, 14037, 14038, 14039, 14040, 14041, 14042, 14043, 14044, 14045, 14046, 14047, 14048, 14049, 14050, 14051, 14052, 14053, 14056, 14057, 14061, 15309)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,14032,14033,14034,14035,14036,14037,14038,14039,14040,14041,14042,14043,14044,14045,14046,14047,14048,14049,14050,14051,14052,14053,14056,14057,14061,15309)
View as Grid List

26 Items

per page
Set Ascending Direction
  1. INS-26S 26' Premium Retractable Cable System
    Stage Ninja INS-26S 26' Premium Retractable Cable System
    USD $49.99
    Out of stock
    SKU: STA-00110
    Model: INS-26S
    Condition: New-In-Box
  2. 26' Premium Retractable XLR Cable System with Female Neutrik NC3-
    SKU: STA-00120
    Model: XLR-26S
    Condition: New-In-Box
  3. 26' Premium Retractable XLR Cable System with Male Retractable En
    SKU: STA-00130
    Model: XLR-26D
    Condition: New-In-Box
  4. 60' Premium Retractable XLR Cable Female Neutrik NC3-XX on Retrac
    SKU: STA-00210
    Model: XLR-60S
    Condition: New-In-Box
  5. 60' Premium Retractable XLR Cable with Male Retractable End
    SKU: STA-00220
    Model: XLR-60D
    Condition: New-In-Box
  6. 40' Retractable Speaker Cable System with Speakon NL2FC Connector
    SKU: STA-00310
    Model: SPK-40SP
    Condition: New-In-Box
  7. 40' Retractable Speaker Cable System with 1/4” to 1/4” Neutrik Co
    SKU: STA-00320
    Model: SPK-40QI
    Condition: New-In-Box
  8. 58' Retractable Speaker Cable System with Speakon NL2FC Connector
    SKU: STA-00330
    Model: SPK-58SP
    Condition: New-In-Box
  9. 58' Retractable Speaker Cable System with 1/4” to 1/4” Neutrik Co
    SKU: STA-00340
    Model: SPK-58QI
    Condition: New-In-Box
  10. 20' Premium CAT6e Retractable Network Cable Reel (Black)
    SKU: STA-00410
    Model: CAT6-20-S
    Condition: New-In-Box
  11. Cable Winder
    Stage Ninja Cable Winder
    USD $12.99
    Out of stock
    SKU: STA-00510
    Model: SCW-125
    Condition: New-In-Box
  12. Stage Ninja Guitar Roadie Case
    USD $12.99
    Out of stock
    SKU: STA-00520
    Model: GTR-CA-2X
    Condition: New-In-Box
  13. Scorpion Series Mic Mount (12")
    Stage Ninja Scorpion Series Mic Mount (12")
    USD $39.99
    Out of stock
    SKU: STA-00610
    Model: MIC-12-CB
    Condition: New-In-Box
  14. Scorpion Series Mic Mount (12") with Magnet
    Stage Ninja Scorpion Series Mic Mount (12") with Magnet
    USD $39.99
    Out of stock
    SKU: STA-00620
    Model: MIC-12-MB
    Condition: New-In-Box
  15. Scorpian Series Camera Mount with Clamp Base
    Stage Ninja Scorpian Series Camera Mount with Clamp Base
    USD $39.99
    Out of stock
    SKU: STA-00710
    Model: CAM-12-CB
    Condition: New-In-Box
  16. Scorpian Series Camera Mount with Magnet Base
    Stage Ninja Scorpian Series Camera Mount with Magnet Base
    USD $39.99
    Out of stock
    SKU: STA-00720
    Model: CAM-12-MB
    Condition: New-In-Box
  17. SKU: STA-00810
    Model: MIN-9-CB
    Condition: New-In-Box
  18. SKU: STA-00820
    Model: MAG-9-CB
    Condition: New-In-Box
  19. SKU: STA-00830
    Model: MAG-9-MB
    Condition: New-In-Box
  20. Stage Ninja Scorpion Series Accessory Kit
    USD $29.99
    Out of stock
    SKU: STA-00910
    Model: SSA-KIT
    Condition: New-In-Box
  21. Stage Ninja 25' 15-amp Musician's Extensions Cord 12 Guard
    USD $99.99
    Out of stock
    SKU: STA-01010
    Model: MXC-25-12
    Condition: New-In-Box
  22. Stage Ninja 50' 15-amp Musician's Extensions Cord 12 Guard
    USD $119.99
    Out of stock
    SKU: STA-01020
    Model: MXC-50-12
    Condition: New-In-Box
  23. 40' 15-Amp 12 Gauge Sound Technician's Retractable Extension Cord
    SKU: STA-01110
    Model: STX-40-3
    Condition: New-In-Box
  24. 50' 13-Amp 14 Gauge Sound Technician's Retractable Extension Cord
    SKU: STA-01120
    Model: STX-50-3
    Condition: New-In-Box
  25. Scorpion Series Microphone Gooseneck
    Stage Ninja Scorpion Series Microphone Gooseneck
    USD $24.99
    Out of stock
    SKU: STA-00920
    Model: GNK-12-MIC
    Condition: New-In-Box
  26. 20' Premium USB Retractable Computer Cable Reel
    Stage Ninja 20' Premium USB Retractable Computer Cable Reel
    USD $159.99
    Out of stock
    SKU: STA-00420
    Model: USB-20-S
    Condition: New-In-Box
View as Grid List

26 Items

per page
Set Ascending Direction