Headphones

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 (572276, 11189, 6172, 4086, 6080, 6087, 405087, 436465, 240871, 244006, 48691, 48692, 48694, 48695, 48703, 48704, 48706, 48707, 61506, 70099, 70100, 70101, 71169, 71231, 71253, 25915, 26059, 38545, 38546, 38561)) 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,572276,11189,6172,4086,6080,6087,405087,436465,240871,244006,48691,48692,48694,48695,48703,48704,48706,48707,61506,70099,70100,70101,71169,71231,71253,25915,26059,38545,38546,38561)
View as Grid List

Items 1-30 of 76

Page
per page
Set Ascending Direction
  1. MDR-ZX110 Wired On-Ear Headphones (Black)
    SKU: SON-20944
    Model: MDRZX110BLK
    Condition: New-In-Box
  2. MDR-7506 Headphones
    Sony MDR-7506 Headphones
    USD $130.00
    SKU: SON-20910
    Model: MDR7506
    Condition: New-In-Box
  3. MDRV150 Studio Monitor Series Headphones
    Sony MDRV150 Studio Monitor Series Headphones
    USD $16.97
    Out of stock
    SKU: SON-20930
    Model: MDRV150
    Condition: New-In-Box
  4. SRH440 Professional Studio Headphones
    Shure SRH440 Professional Studio Headphones
    USD $99.97
    Out of stock
    SKU: SHU-00060
    Model: SRH440
    Condition: New-In-Box
  5. HD280Pro Headphones
    Sennheiser HD280Pro Headphones
    USD $99.97
    Out of stock
    SKU: SEN-00035
    Model: HD280Pro
    Condition: New-In-Box
  6. SRH840 Professional Monitoring Headphones
    Shure SRH840 Professional Monitoring Headphones
    USD $199.97
    Out of stock
    SKU: SHU-00060A
    Model: SRH840
    Condition: New-In-Box
  7. SR-BH600 Wireless Over-Ear Headphones
    Saramonic SR-BH600 Wireless Over-Ear Headphones
    USD $125.00
    Out of stock
    SKU: SAR-00276
    Model: SR-BH600
    Condition: New-In-Box
  8. SRH440 Professional Studio Headphones
    Shure SRH440 Professional Studio Headphones
    USD $79.00
    Out of stock
    SKU: SHU-00061
    Model: SRH440-BK
    Condition: New-In-Box
  9. ATH-M50x Professional Monitor Headphones (Black)
    Audio 2000's ATH-M50x Professional Monitor Headphones (Black)
    USD $149.00
    Out of stock
    SKU: ADT-00119
    Model: ATH-M50X
    Condition: New-In-Box
  10. ATH-M20x Professional Monitor Headphones (Black)
    Audio-Technica ATH-M20x Professional Monitor Headphones (Black)
    USD $54.00
    Out of stock
    SKU: ADT-00121
    Model: ATH-M20X
    Condition: New-In-Box
  11. Gear Circle (Silver)
    Samsung Gear Circle (Silver)
    USD $59.99
    Out of stock
    SKU: SAMS-20010
    Model: SM-R130NZSSXAR
    Condition: New-In-Box
  12. Gear Circle (Red)
    Samsung Gear Circle (Red)
    USD $59.99
    Out of stock
    SKU: SAMS-20011
    Model: SM-R130NZRSXAR
    Condition: New-In-Box
  13. Gear Circle (Blue)
    Samsung Gear Circle (Blue)
    USD $59.99
    Out of stock
    SKU: SAMS-20012
    Model: SM-R130NMBSXAR
    Condition: New-In-Box
  14. Gear Circle (Black)
    Samsung Gear Circle (Black)
    USD $59.99
    Out of stock
    SKU: SAMS-20013
    Model: SM-R130NZKSXAR
    Condition: New-In-Box
  15. Level U Wireless Headphones (White)
    Samsung Level U Wireless Headphones (White)
    USD $39.95
    Out of stock
    SKU: SAMS-20001
    Model: EO-BG920BWEBUS
    Condition: New-In-Box
  16. Level U Wireless Headphones (Black Sapphire)
    Samsung Level U Wireless Headphones (Black Sapphire)
    USD $39.95
    Out of stock
    SKU: SAMS-20002
    Model: EO-BG920BBEST1
    Condition: New-In-Box
  17. Level U PRO Wireless Headphones (Black)
    Samsung Level U PRO Wireless Headphones (Black)
    USD $99.95
    Out of stock
    SKU: SAMS-20003
    Model: EO-BN920CBEGUS
    Condition: New-In-Box
  18. Level U PRO Wireless Headphones (Bronze)
    Samsung Level U PRO Wireless Headphones (Bronze)
    USD $99.95
    Out of stock
    SKU: SAMS-20004
    Model: EO-BN920CFEGUS
    Condition: New-In-Box
  19. MDR-RF985RK Wireless Headphones
    Sony MDR-RF985RK Wireless Headphones
    USD $129.00
    Out of stock
    SKU: SON-20937
    Model: MDR-RF985RK
    Condition: New-In-Box
  20. Gear IconX Wireless Earbuds (Blue)
    Samsung Gear IconX Wireless Earbuds (Blue)
    USD $199.99
    Out of stock
    SKU: SAMS-20100
    Model: SM-R150NZBAXAR
    Condition: New-In-Box
  21. Gear IconX Wireless Earbuds (Black)
    Samsung Gear IconX Wireless Earbuds (Black)
    USD $199.99
    Out of stock
    SKU: SAMS-20101
    Model: SM-R150NZKAXAR
    Condition: New-In-Box
  22. Gear IconX Wireless Earbuds (White)
    Samsung Gear IconX Wireless Earbuds (White)
    USD $199.99
    Out of stock
    SKU: SAMS-20102
    Model: SM-R150NZWAXAR
    Condition: New-In-Box
  23. SE215 Sound Isolating Earphones (Black)
    Shure SE215 Sound Isolating Earphones (Black)
    USD $99.00
    Out of stock
    SKU: SHU-00027
    Model: SE215-K
    Condition: New-In-Box
  24. SRH1540 Premium Closed-Back Headphones
    Shure SRH1540 Premium Closed-Back Headphones
    USD $499.00
    Out of stock
    SKU: SHU-00230
    Model: SRH1540
    Condition: New-In-Box
  25. SE846 Sound Isolating Earphones (Clear)
    Shure SE846 Sound Isolating Earphones (Clear)
    USD $999.00
    Out of stock
    SKU: SHU-00220
    Model: SE846-CL
    Condition: New-In-Box
  26. MDR-Z7 Hi-Res Stereo Headphones
    Sony MDR-Z7 Hi-Res Stereo Headphones
    USD $699.99
    Out of stock
    SKU: SON-20941
    Model: MDR-Z7
    Condition: New-In-Box
  27. HD 380 Pro Headphones
    Sennheiser HD 380 Pro Headphones
    USD $199.95
    Out of stock
    SKU: SEN-00105
    Model: 502717
    Condition: New-In-Box
  28. Bluebuds X Premium Bluetooth Buds (Midnight Black)
    SKU: JAY-13641
    Model: BBX1MB
    Condition: New-In-Box
  29. Bluebuds X Premium Bluetooth Buds (Storm White)
    Jaybird Bluebuds X Premium Bluetooth Buds (Storm White)
    USD $126.99
    Out of stock
    SKU: JAY-13718
    Model: BBX1SW
    Condition: New-In-Box
  30. Earphones with Mic (2 Pack)
    Charge N Go Earphones with Mic (2 Pack)
    USD $19.97
    Out of stock
    SKU: JRS-1IEARPH2PK-02
    Model: 1IEARPH2PK-02
    Condition: New-In-Box
View as Grid List

Items 1-30 of 76

Page
per page
Set Ascending Direction