Nordcode Oslo Lady Pants Black
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1 AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND variation_group_products.group_id IN (12271) GROUP BY products.product_id ORDER BY product asc, products.product_id ASC LIMIT 0, 100SELECT SQL_CALC_FOUND_ROWS products.product_id, products.amount, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1 AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND variation_group_products.group_id IN (12271) GROUP BY products.product_id ORDER BY NULL asc- View all variations as list
| Sort by Price | Sort by Availability | Sort by CODE | Sort by Color | Sort by Size |
|---|---|---|---|---|
|
€10990
€12490
(Including tax)
|
In stock
|
NOR000PAN76-XS
|
Color:
|
Size:
|
|
€10990
€12490
(Including tax)
|
In stock
|
NOR000PAN76-S
|
Color:
|
Size:
|
|
€10990
€12490
(Including tax)
|
In stock
|
NOR000PAN76-M
|
Color:
|
Size:
|
|
€10990
€12490
(Including tax)
|
In stock
|
NOR000PAN76-XL
|
Color:
|
Size:
|
|
€10990
€12490
(Including tax)
|
In stock
|
NOR000PAN76-XXL
|
Color:
|
Size:
|
- Also available in
- Compatible Products
Protective clothing for motorcycle use certified EN 17092-3:2019 Class AA
OSLO pants is the perfect choice for riders in search of riding pants, aiming to comfort and safety.
SAFETY
Removable CE-certified knee protectors
Removable CE-certified Ηip protectors
Reflective graphic details improve rider visibility in varying light conditions
COMFORT
500D Polyamide with high abrasion resistance
Waterproof, windproof and breathable garment
Removable thermal liner 50gr ensures comfort on cold days
Fixed waterproof membrane
Mesh lining
ERGONOMY
Adjustment waist system features buckle and velcro straps for highly customizable fit.
Calf zippers
2 Zippered, hand pockets
- Solid colour
- For Women
No reviews found
