Clamps

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, 547263, 12556, 12670, 12335, 4873, 2692, 2795, 79, 181, 378512, 385127, 444649, 447879, 338402, 338419, 338420, 346897, 359392, 367952, 367953, 436326, 436329, 238261, 244996, 246260, 248774, 265690)) 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,547263,12556,12670,12335,4873,2692,2795,79,181,378512,385127,444649,447879,338402,338419,338420,346897,359392,367952,367953,436326,436329,238261,244996,246260,248774,265690)
View as Grid List

Items 1-30 of 46

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. Camera Cable Clamp 3685
    SmallRig Camera Cable Clamp 3685
    USD $22.89
    SKU: SMR-03685
    Model: 3685
    Condition: New-In-Box
  5. Double Super Clamp
    Manfrotto Double Super Clamp
    USD $88.95
    Out of stock
    SKU: MAN-00095
    Model: 038
    Condition: New-In-Box
  6. Manfrotto Binocular Super Clamp
    USD $49.99
    Out of stock
    SKU: MAN-00084
    Model: 035BN (2893)
    Condition: New-In-Box
  7. 035 Super Clamp without Stud, includes 035WDG Wedge
    SKU: MAN-00080
    Model: 035
    Condition: New-In-Box
  8. Super Clamp with Stud
    Manfrotto Super Clamp with Stud
    USD $40.95
    SKU: MAN-00086
    Model: 035RL
    Condition: New-In-Box
  9. 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
  10. Quick Action Super Clamp
    Manfrotto Quick Action Super Clamp
    USD $74.99
    SKU: MAN-00872
    Model: 635
    Condition: New-In-Box
  11. Avenger Heavy Duty Super Clamp
    USD $69.99
    Out of stock
    SKU: AVE-00210
    Model: C1550
    Condition: New-In-Box
  12. Super Clamp
    Avenger Super Clamp
    USD $40.95
    Out of stock
    SKU: AVE-00212
    Model: C1575B
    Condition: New-In-Box
  13. 4" Super Viser Clamp End Jaw
    Kupo 4" Super Viser Clamp End Jaw
    USD $64.95
    SKU: KUPO-KG604012
    Model: KG604012
    Condition: New-In-Box
  14. Counterweight & Mounting Clamp Kit
    SmallRig Counterweight & Mounting Clamp Kit
    USD $38.90
    Out of stock
    SKU: SMR-04535
    Model: BSS2465
    Condition: New-In-Box
  15. Universal Spring Cable Clamp (2 pcs)
    SmallRig Universal Spring Cable Clamp (2 pcs)
    USD $19.90
    SKU: SMR-02418
    Model: MD2418
    Condition: New-In-Box
  16. Universal Holder for External SSD
    SmallRig Universal Holder for External SSD
    USD $39.90
    Out of stock
    SKU: SMR-02343
    Model: BSH2343
    Condition: New-In-Box
  17. Multi-Functional Crab-Shaped Clamp with Ballhead Magic Arm
    SKU: SMR-02164
    Model: SR_2164
    Condition: New-In-Box
  18. Super Clamp with 1/4" and 3/8" Thread (2 Pack)
    SmallRig Super Clamp with 1/4" and 3/8" Thread (2 Pack)
    USD $12.90
    SKU: SMR-05094
    Model: 2058
    Condition: New-In-Box
  19. Super Clamp Mount with 1/4" Screw Ball Head Mount
    SKU: SMR-09406
    Model: 1124
    Condition: New-In-Box
  20. Super Convi Clamp Griphead
    Kupo Super Convi Clamp Griphead
    USD $69.95
    SKU: KUPO-KG202711
    Model: KG202711
    Condition: New-In-Box
  21. Spring Clamp (4")
    Savage Spring Clamp (4")
    USD $2.15
    SKU: SAV-C4
    Model: C-4
    Condition: New-In-Box
  22. Multi-Clip
    Promaster Multi-Clip
    USD $14.95
    SKU: PRO-74305
    Model: 1022
    Condition: New-In-Box
  23. Large Clip Clamp
    Promaster Large Clip Clamp
    USD $14.95
    Out of stock
    SKU: PRO-74306
    Model: 1025
    Condition: New-In-Box
  24. Stand Clamp for Forza Power Adapters
    Nanlite Stand Clamp for Forza Power Adapters
    USD $32.90
    SKU: NLT-ASSCHFZ
    Model: ASSCHFZ
    Condition: New-In-Box
  25. Baby Pipe Clamp
    Kupo Baby Pipe Clamp
    USD $34.95
    Out of stock
    SKU: KUPO-KG083521
    Model: KG083521
    Condition: New-In-Box
  26. Super Clamp with 1/4" and 3/8" Thread
    SmallRig Super Clamp with 1/4" and 3/8" Thread
    USD $8.99
    Out of stock
    SKU: SMR-01025
    Model: 735
    Condition: New-In-Box
  27. Duck Bill Clamp
    Kupo Duck Bill Clamp
    USD $83.95
    SKU: KUPO-KG602612
    Model: KG602612
    Condition: New-In-Box
  28. Micro Jaw Clamp
    Promaster Micro Jaw Clamp
    USD $29.95
    SKU: PRO-61247
    Model: 1872
    Condition: New-In-Box
  29. Mini Viser Clamp With 2" Jaw With 5/8" Baby Stud
    SKU: KUPO-KG603111
    Model: KG603111
    Condition: New-In-Box
  30. Scrim Jim Cine Clamp with 5/8" Stud
    Westcott Scrim Jim Cine Clamp with 5/8" Stud
    USD $54.90
    SKU: WES-02080
    Model: 2080
    Condition: New-In-Box
View as Grid List

Items 1-30 of 46

Page
per page
Set Ascending Direction