Counterweight Bar Caterpillar NextGen 330
Sold out
Estimated shipping time:
10-30 business days
Rear Bar for Caterpillar NextGen 330 models!
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 '%197318%')
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
Counterweight Bar Caterpillar NextGen 330
RST-Steel’s counterweight bars are high-quality products made of stainless steel. The rear bars can be equipped with work lights and position lights, which improve your visibility in traffic, and at the same time increase safety for yourself and others in traffic.
Bar has 2 Yellow LED position lights on both sides, 6 Red LED position lights at the back. 2 LED warning light at the back and 1 LED warning light on both sides.
Technical information:
- Color: Polished stainless steel or painting with RAL-basic colors
- Pipes diameter: 76 mm
Delivery contents:
- Counterweight bar Caterpillar NextGen
- Fasteners required for installation
- Installation instructions
Vehicle compatibility
Counterweight Bar Caterpillar NextGen 330 fits the following brands/models:
Fits all vehicles and models.









