Hoodbar CAT 906-908 2022-
Sold out
Estimated shipping time:
10-30 business days
Available in multiple model options!
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
)
ORDER BY
FIELD(pm2.meta_value, 'products', 'categories') AS...' at line 13]
SELECT p.ID
FROM wp_posts AS p
LEFT JOIN wp_postmeta AS pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_pricing_discount_status'
LEFT JOIN wp_postmeta AS pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_dynamic_pricing_discounts_display'
LEFT JOIN wp_postmeta AS pm3 ON p.ID = pm3.post_id AND pm3.meta_key = '_product_pricing_discount_ids'
LEFT JOIN wp_term_relationships AS tr ON p.ID = tr.object_id
LEFT JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = 'product_cat'
WHERE p.post_type = 'em_pricing_discount'
AND p.post_status = 'publish'
AND pm1.meta_value = 'yes'
AND (
(pm2.meta_value = 'products' AND pm3.meta_value LIKE '%197952%')
OR (pm2.meta_value = 'categories' AND tt.term_id IN ())
)
ORDER BY
FIELD(pm2.meta_value, 'products', 'categories') ASC,
p.menu_order ASC,
p.post_date DESC
LIMIT 1
Description
Hoodbar CAT 906-908 2022- Mounted on Engine Hood
RST-Steel hoodbars are high-quality Key Flag products made in Finland from stainless steel.
This stylish hoodbar enhances the look of your machine while providing practical functionality – it can be equipped with marker lights and strobe lights, increasing your visibility both in traffic and on the worksite.
Why Choose RST-Steel?
-
Reliability: Years of experience and expertise ensure the high quality and durability of our products.
-
Customer satisfaction: Thousands of satisfied customers worldwide trust RST-Steel products.
Technical specifications:
-
Color: Polished stainless steel or painted in RAL base colors
-
Tube diameter: 42 mm
Package includes:
-
Hoodbar CAT 906-908
-
Required mounting brackets
-
Installation instructions
Vehicle compatibility
Hoodbar CAT 906-908 2022- fits the following brands/models:
Fits all vehicles and models.





