Shop our latest arrivals of womens jackets and coats. If you’re after the latest trends in outerwear in premium quality and design, Superdry’s jackets for women are for you. Looking for a relaxed bomber or an iconic leather jacket that will be the perfect addition to your athleisure style. Other key styles this season are parka coats, quilted and cool military styles. Look out for our down jackets and keep warm whatever the weather.
SELECT DISTINCT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`url_key`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`size`, `e`.`size_value`, `e`.`vendor`, `e`.`vendur_address`, `e`.`importer`, `e`.`importer_address`, `e`.`country`, `e`.`season_code`, `e`.`season_code_value`, `e`.`style_code`, `e`.`size_guide_image`, `e`.`specification`, `e`.`modelinfo`, `e`.`rma_allowed`, `e`.`prod_type`, `e`.`prod_type_value`, `e`.`colormaster`, `e`.`colormaster_value`, `e`.`battery_product`, `e`.`care_instructions`, `e`.`character`, `e`.`fabric_composition`, `e`.`keywords`, `e`.`length_of_guarantee`, `e`.`product_depth`, `e`.`product_height`, `e`.`product_length`, `e`.`product_weight`, `e`.`product_width`, `e`.`season`, `e`.`usp`, `e`.`what_in_the_box`, `e`.`features_benefits`, `e`.`hover_catalog`, `e`.`heel_height`, `e`.`heel_height_value`, `e`.`toys_of_the_month`, `e`.`deal_of_the_month`, `e`.`new_arrivals`, `e`.`red_hot_deals`, `e`.`no_of_component`, `e`.`washable`, `e`.`material`, `e`.`activity_type`, `e`.`skills_developed`, `e`.`skills_developed_value`, `e`.`hamleys_character`, `e`.`hamleys_character_value`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='43'
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`created_at` DESC, `e`.`entity_id` DESC
LIMIT 12