Shirts are a classic wardrobe staple and our new season collection of shirts for women has just the update you need. Whether you are looking for a classic blouse for the office or an oversized boyfriend shirt for those laid back weekend brunches, our range of women's shirts has got you covered. Why not tuck a military style shirt into a denim skirt for a tough but feminine look, or put your own twist on one of our checked shirts by knotting it at the front and pairing with jeans and ankle boots. Whatever shirt you choose, style it your way.
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='77'
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