Smallrig

Accessory Thumb-Wheel-Lock-Nut-877

MFR #877BLK #394-0191
Price: € 3.46 + VAT
Online price: € 3.32 + VAT
✓ Installment payments by credit card.
3pcs in stock
SELECT cf.custom_field_name, cfm.custom_field_custom_id, GROUP_CONCAT(DISTINCT cfv.custom_field_value_option ORDER BY cfv.custom_field_value_order_number ASC SEPARATOR '|') as value FROM cms_products_customfields_map cfm LEFT JOIN cms_custom_fields cf ON cf.custom_field_custom_id = cfm.custom_field_custom_id LEFT JOIN cms_custom_fields_values cfv ON cfv.custom_field_custom_id = cfm.custom_field_custom_id AND cfv.custom_field_value_option = cfm.product_customfield_value WHERE cfm.product_custom_id IN( SELECT rp2.product_custom_id FROM cms_relative_products rp LEFT JOIN cms_relative_products rp2 ON rp2.relative_id = rp.relative_id LEFT JOIN cms_products p ON p.product_custom_id = rp2.product_custom_id WHERE rp.product_custom_id = 27755597205 AND p.product_status NOT IN ('Discontinued','NoView') ) AND cfm.custom_field_custom_id IN( SELECT rcf.custom_field_custom_id FROM cms_relative_customfields rcf LEFT JOIN cms_relative_products rp2 ON rp2.relative_id = rcf.relative_id WHERE rp2.product_custom_id = 27755597205 ) GROUP BY cf.custom_field_name ORDER BY cf.custom_field_order_number ASC, cfv.custom_field_value_order_number ASC
Array ( [customFields] => Array ( [Options] => Array ( [0] => Array ( [cfValue] => Array ( [0] => 828 [1] => 838 [2] => 877 [3] => 1065 [4] => 1713 [5] => 2326 [6] => 3995 [7] => 4385 ) [cfCustomId] => 1587139475 ) ) ) [curCustomFields] => Array ( [Options] => 877 ) [relativeId] => 217 ) Array ( [Options] => Array ( [0] => Array ( [cfValue] => Array ( [0] => 828 [1] => 838 [2] => 877 [3] => 1065 [4] => 1713 [5] => 2326 [6] => 3995 [7] => 4385 ) [cfCustomId] => 1587139475 ) ) )
Options
$curCustomFields[key]:877
828 $curCustomFields[key]:877
838 $curCustomFields[key]:877
877 $curCustomFields[key]:877
1065 $curCustomFields[key]:877
1713 $curCustomFields[key]:877
2326 $curCustomFields[key]:877
3995 $curCustomFields[key]:877
4385

  • Wheel Lock Nut
  • 1/4" Female thread
  • Lock Nut
  • For Maigic Arms and Ball heads

Share this product

Thumb-Wheel-Lock-Nut-877

Thumb Wheel Lock Nut 2pcs pack
Center 1/4" screw hole

It features a standard 1/4" hole that can be used in articulating arms or shoe mounts with 1/4" screws. It is lightweight, durable and compact. 


Source: https://www.smallrig.com/smallrig-thumb-wheel-lock-nut-2pcs-pack-877.html