Clamps, Grips, & Arms

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 (582639, 578472, 578469, 564556, 547263, 12556, 12557, 12670, 12689, 12714, 12717, 12728, 12930, 13260, 13494, 13502, 13503, 12335, 12347, 6660, 4873, 4876, 2692, 2715, 2732, 2744, 2745, 2795, 9620, 79)) 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,582639,578472,578469,564556,547263,12556,12557,12670,12689,12714,12717,12728,12930,13260,13494,13502,13503,12335,12347,6660,4873,4876,2692,2715,2732,2744,2745,2795,9620,79)
View as Grid List

Items 1-30 of 138

Page
per page
Set Ascending Direction
  1. Alien Series Crab Clamp with Magic Arm (Black)
    SKU: SIR-00007
    Model: MA-GK
    Condition: New-In-Box
  2. Articulating Arm & Clamp for Phone
    Promaster Articulating Arm & Clamp for Phone
    USD $34.95
    SKU: PRO-68579
    Model: 68579
    Condition: New-In-Box
  3. Articulating Arm & Clamp
    Promaster Articulating Arm & Clamp
    USD $24.95
    SKU: PRO-68572
    Model: 68572
    Condition: New-In-Box
  4. Float Wall Mount Arm Kit
    Westcott Float Wall Mount Arm Kit
    USD $59.80
    SKU: WES-01580
    Model: 1580
    Condition: New-In-Box
  5. Camera Cable Clamp 3685
    SmallRig Camera Cable Clamp 3685
    USD $22.89
    SKU: SMR-03685
    Model: 3685
    Condition: New-In-Box
  6. Double Super Clamp
    Manfrotto Double Super Clamp
    USD $88.95
    Out of stock
    SKU: MAN-00095
    Model: 038
    Condition: New-In-Box
  7. Manfrotto Magic Arm Kit
    USD $226.95
    Out of stock
    SKU: MAN-00249
    Model: 143
    Condition: New-In-Box
  8. Manfrotto Binocular Super Clamp
    USD $49.99
    Out of stock
    SKU: MAN-00084
    Model: 035BN (2893)
    Condition: New-In-Box
  9. Manfrotto Magic Arm, Arm Alone without Camera Bracket
    USD $144.95
    Out of stock
    SKU: MAN-00254
    Model: 143N
    Condition: New-In-Box
  10. Flex Arm for Super Clamp
    Manfrotto Flex Arm for Super Clamp
    USD $44.99
    Out of stock
    SKU: MAN-00399
    Model: 237
    Condition: New-In-Box
  11. Manfrotto Sliding Support Arm Only
    USD $77.95
    SKU: MAN-00388
    Model: 231ARM
    Condition: New-In-Box
  12. Manfrotto Magic Arm with Quick Release Plate
    USD $279.95
    Out of stock
    SKU: MAN-00256
    Model: 143RC
    Condition: New-In-Box
  13. Manfrotto Snake Arm with Super Clamp
    USD $204.00
    Out of stock
    SKU: MAN-02201
    Model: MA050ASC
    Condition: New-In-Box
  14. Rosco LitePad Swivel Arm
    USD $35.00
    Out of stock
    SKU: ROSC-L661581420
    Model: 290661581420
    Condition: New-In-Box
  15. SKU: KUPO-KG001712
    Model: KG001712
    Condition: New-In-Box
  16. Kupo MAX ARM
    USD $102.95
    SKU: KUPO-KG100211
    Model: KG100211
    Condition: New-In-Box
  17. Grip Arm Support
    Kupo Grip Arm Support
    USD $84.95
    SKU: KUPO-KG200912
    Model: KG200912
    Condition: New-In-Box
  18. 035 Super Clamp without Stud, includes 035WDG Wedge
    SKU: MAN-00080
    Model: 035
    Condition: New-In-Box
  19. BoomPole
    Rode Microphones BoomPole
    USD $149.00
    Out of stock
    SKU: RODE-00180
    Model: BOOMPOLE
    Condition: New-In-Box
  20. Illuminator Reflector Arm
    Westcott Illuminator Reflector Arm
    USD $79.90
    SKU: WES-01100
    Model: 1100
    Condition: New-In-Box
  21. Super Clamp with Stud
    Manfrotto Super Clamp with Stud
    USD $40.95
    SKU: MAN-00086
    Model: 035RL
    Condition: New-In-Box
  22. Manfrotto Ext Arm with 3094 Stud
    USD $29.99
    Out of stock
    SKU: MAN-00100
    Model: 2906
    Condition: New-In-Box
  23. Super Clamp Wedges (Set of 5)
    Manfrotto Super Clamp Wedges (Set of 5)
    USD $10.99
    Out of stock
    SKU: MAN-00088
    Model: 2915W5
    Condition: New-In-Box
  24. Magic Arm with Camera Platform
    Manfrotto Magic Arm with Camera Platform
    USD $156.95
    Out of stock
    SKU: MAN-00250
    Model: 143A (2930)
    Condition: New-In-Box
  25. Variable Friction Magic Arm with Camera Platform
    Manfrotto Variable Friction Magic Arm with Camera Platform
    USD $176.95
    SKU: MAN-00414
    Model: 244 (2929)
    Condition: New-In-Box
  26. SKU: MAN-00582
    Model: 396B-2
    Condition: New-In-Box
  27. SKU: MAN-00584
    Model: 396B-3
    Condition: New-In-Box
  28. Quick Action Super Clamp
    Manfrotto Quick Action Super Clamp
    USD $74.99
    SKU: MAN-00872
    Model: 635
    Condition: New-In-Box
  29. 20" Extension Arm
    Avenger 20" Extension Arm
    USD $61.95
    Out of stock
    SKU: AVE-00319
    Model: D500
    Condition: New-In-Box
  30. Avenger Heavy Duty Super Clamp
    USD $69.99
    Out of stock
    SKU: AVE-00210
    Model: C1550
    Condition: New-In-Box
View as Grid List

Items 1-30 of 138

Page
per page
Set Ascending Direction