Counterweight Bar Doosan DX235LCR-7
In Stock
Estimated shipping time:
Varies by model
Several model options available!
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 '%197752%')
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 Doosan DX235LCR-7
RST-Steel’s counterweight bars are high-quality products made of stainless steel.
The counterweight 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.
Technical information:
- Color: Polished stainless steel or painting with RAL-basic colors
- Pipes diameter: 60 mm
- 2-part
Delivery contents:
- Counterweight bar
- Fasteners required for installation
- Installation instructions
Vehicle compatibility
Counterweight Bar Doosan DX235LCR-7 fits the following brands/models:
Fits all vehicles and models.



