ProMediaGear

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 (91507, 91495, 91496, 91497, 91498, 91500, 91503, 91506, 194910, 101223, 171931, 171934, 174006, 175339, 128729, 128730, 128731, 128781, 133701, 135398, 189670, 189671, 192147, 470252, 440624, 296757, 217818, 218284, 218285, 218286)) 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,91507,91495,91496,91497,91498,91500,91503,91506,194910,101223,171931,171934,174006,175339,128729,128730,128731,128781,133701,135398,189670,189671,192147,470252,440624,296757,217818,218284,218285,218286)
View as Grid List

Items 1-30 of 31

Page
per page
Set Ascending Direction
  1. PMG-DUO 36"Interview Video Slider with Straight track and 8' Curve Track
    SKU: PMG-VS368
    Model: VS368
    Condition: New-In-Box
  2. Cameras and flash not included
    ProMediaGear BBX-PBX3BD Boomerang Flash Bracket with QR Plate
    USD $299.95
    Out of stock
    SKU: PMG-BBX-PBX3BD
    Model: BBX-PBX3BD
    Condition: New-In-Box
  3. BLSA Light Stud Adapter for Profoto B1 B2 Broncolor Elichrom Standard Lightstand Mount
    SKU: PMG-BLSA
    Model: BLSA
    Condition: New-In-Box
  4. 5" Tall Light Adapter Spigot
    ProMediaGear 5" Tall Light Adapter Spigot
    USD $39.95
    Out of stock
    SKU: PMG-BLSA5A
    Model: BLSA5A
    Condition: New-In-Box
  5. PMG-DUO Slider Clamp
    ProMediaGear PMG-DUO Slider Clamp
    USD $59.95
    Out of stock
    SKU: PMG-CS60
    Model: CS60
    Condition: New-In-Box
  6. HB70QR Handle with Universal Bracket Plate
    ProMediaGear HB70QR Handle with Universal Bracket Plate
    USD $99.95
    Out of stock
    SKU: PMG-HB70QR-PBX3
    Model: HB70QR-PBX3
    Condition: New-In-Box
  7. 4" Universal L-Bracket
    ProMediaGear 4" Universal L-Bracket
    USD $89.95
    Out of stock
    SKU: PMG-PLX4
    Model: PLX4
    Condition: New-In-Box
  8. PMG-DUO 24" Video Slider with Carrying Case
    ProMediaGear PMG-DUO 24" Video Slider with Carrying Case
    USD $699.95
    Out of stock
    SKU: PMG-VS24
    Model: VS24
    Condition: New-In-Box
  9. VRH1 Nato Rail 90-Degree Handle with Padded Grip & CN30 Clamp
    SKU: PMG-VRH1
    Model: VRH1
    Condition: New-In-Box
  10. HB70QR Handle for Bracket Plates
    ProMediaGear HB70QR Handle for Bracket Plates
    USD $59.95
    Out of stock
    SKU: PMG-HB70QR
    Model: HB70QR
    Condition: New-In-Box
  11. PBND850 Bracket Plate for Nikon D850 Arca Swiss Type
    ProMediaGear PBND850 Bracket Plate for Nikon D850 Arca Swiss Type
    USD $49.95
    Out of stock
    SKU: PMG-PBND850
    Model: PBND850
    Condition: New-In-Box
  12. PBNMBD18 Bracket plate for Nikon D850 with MB-D18 Grip Arca Swiss type
    SKU: PMG-PBNMBD18
    Model: PBNMBD18
    Condition: New-In-Box
  13. PLNMBD18 L-Bracket for Nikon D850 MB-D18 Grip for Arca-Swiss Type (L-Plate)
    SKU: PMG-PLNMBD18
    Model: PLNMBD18
    Condition: New-In-Box
  14. PBND850 L-Bracket Plate for Nikon D850
    ProMediaGear PBND850 L-Bracket Plate for Nikon D850
    USD $129.95
    Out of stock
    SKU: PMG-PLND850
    Model: PLND850
    Condition: New-In-Box
  15. BBGV2 Boomerang Flash Bracket (Black)
    ProMediaGear BBGV2 Boomerang Flash Bracket (Black)
    USD $349.95
    Out of stock
    SKU: PMG-BBGV2-PBX3
    Model: BBGV2-PBX3
    Condition: New-In-Box
  16. GK Katana Gimbal Tripod Head (Black)
    ProMediaGear GK Katana Gimbal Tripod Head (Black)
    USD $999.95
    Out of stock
    SKU: PMG-GK
    Model: GK
    Condition: New-In-Box
  17. PBX3 Universal Bracket Plate
    ProMediaGear PBX3 Universal Bracket Plate
    USD $49.95
    Out of stock
    SKU: PMG-PBX3
    Model: PBX3
    Condition: New-In-Box
  18. VS36 PMG-DUO 36" Video Slider with Carrying Case
    ProMediaGear VS36 PMG-DUO 36" Video Slider with Carrying Case
    USD $799.95
    Out of stock
    SKU: PMG-0VS36
    Model: VS36
    Condition: New-In-Box
  19. C40 Arca-Type Quick-Release Clamp (40mm)
    ProMediaGear C40 Arca-Type Quick-Release Clamp (40mm)
    USD $59.95
    Out of stock
    SKU: PMG-C40
    Model: C40
    Condition: New-In-Box
  20. BLH2 Rigid Tube / Light Stand Mount
    ProMediaGear BLH2 Rigid Tube / Light Stand Mount
    USD $79.95
    Out of stock
    SKU: PMG-BLH2
    Model: BLH2
    Condition: New-In-Box
  21. BG-E20 Grip Arca Swiss Plate
    ProMediaGear BG-E20 Grip Arca Swiss Plate
    USD $49.95
    Out of stock
    SKU: PMG-PBCBGE20
    Model: PBCBGE20
    Condition: New-In-Box
  22. SS2P3 Retrofit Quick Release Plug Adapter for 1" Strap
    SKU: PMG-SS2P3
    Model: SS2P3
    Condition: New-In-Box
  23. VRNR-10 Video Rig Nato, Picatinny Rail with 3 Clamps and 2 Cold Shoes
    SKU: PMG-VRNR10
    Model: VRNR10
    Condition: New-In-Box
  24. Tomahawk Gimbal Attachment for Ball Heads
    ProMediaGear Tomahawk Gimbal Attachment for Ball Heads
    USD $399.95
    Out of stock
    SKU: PMG-GT2
    Model: GT2
    Condition: New-In-Box
  25. TR344L Pro-Stix Carbon Fiber Tripod
    ProMediaGear TR344L Pro-Stix Carbon Fiber Tripod
    USD $1,079.95
    Out of stock
    SKU: PMG-TR344L-BLACK
    Model: TR344L-BLACK
    Condition: New-In-Box
  26. TR344L Pro-Stix 71"  Carbon Fiber Tripod w/ 34mm Diameter Legs, 4-Section Long
    SKU: PMG-TR344L
    Model: TR344L
    Condition: New-In-Box
  27. VS32 PMG-DUO 32" Video Slider with Carrying Case
    ProMediaGear VS32 PMG-DUO 32" Video Slider with Carrying Case
    USD $749.95
    Out of stock
    SKU: PMG-VS32
    Model: VS32
    Condition: New-In-Box
  28. VSMDC1 Motor Control for PMG-DUO Sliders
    ProMediaGear VSMDC1 Motor Control for PMG-DUO Sliders
    USD $549.95
    Out of stock
    SKU: PMG-0VSMDC1
    Model: VSMDC1
    Condition: New-In-Box
  29. PBSA73 Bracket Plate for Sony Alpha A7r Mark III and A7 Mark III (Arca-Swiss Type)
    SKU: PMG-PBSA73
    Model: PBSA73
    Condition: New-In-Box
  30. PLSA73 L-Bracket for Sony Alpha A7 Mark III
    ProMediaGear PLSA73 L-Bracket for Sony Alpha A7 Mark III
    USD $129.95
    Out of stock
    SKU: PMG-PLSA73
    Model: PLSA73
    Condition: New-In-Box
View as Grid List

Items 1-30 of 31

Page
per page
Set Ascending Direction