SELECT fm.uri, fdfpp.field_product_page_type_value,fdfp.field_product_slider_image_alt,fdc.field_color_code_value FROM {field_data_field_product_slider_image} as fdfp JOIN file_managed as fm ON fdfp.field_product_slider_image_fid=fm.fid JOIN field_data_field_product_page_type as fdfpp ON fdfpp.entity_id=fdfp.entity_id JOIN field_data_field_product_type as fdfpt ON fdfpt.entity_id=fdfp.entity_id JOIN field_data_field_color_code as fdc ON fdfpt.entity_id=fdc.entity_id JOIN node as n ON n.nid=fdfp.entity_id where fdfp.bundle='product_slider' AND fdfpp.field_product_page_type_value=2 AND fdfpt.field_product_type_tid=1 AND n.status=1 order by fm.timestamp ASC

Aviation safety shoes

View Details

Aviation Safety Shoes: Fly High

The aviation industry employs millions of working professionals leading to numerous risky challenges as well. Working in an aviation industry requires a lot of walking and dealing with heavy machineries. Under the various tough situations, the safety of the people is at stake. So, keeping your feet healthy and safe under this environment is very important.

Versatile yet Stylish

Fly over our features to find the best aviation safety shoes for yourself. The stylish looking aviation work boots are designed to help you give your best performance on the job.

When Safety meet Functionality & Comfort

The aviation safety boots are made with steel mid sole and steel toe cap to provide outstanding protection for your feet. The shoes are lightweight especially made for the workers and the professionals in the aviation industry. Made with genuine leather, that will help you take up any challenge in any environment. The shoes not only look good but also multi- functional. The shoes include features like anti-skid, water resistance and odour free. The all-weather leather boots is an all-time favorite for the professionals in Aviation.

All-In-One Safety Boots

Anyone who thinks that style, safety and comfort don’t go well together should definitely try out Warrior Safety Shoes to get the taste of all features in one brand. The shoes are carefully designed with the best quality because safety can never compromise under any situation. The moment you wear this all- weather friendly aviation safety footwear, comfort is sure to touch your feet. The brand Warrior is still standing strong in the Indian footwear industry. The superb range of our safety shoes is light on your feet as well as on your pocket. What else do we need when we get all the benefits in one brand?