position----desc---SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`bar_code`, `e`.`size`, `e`.`size_value`, `e`.`brand`, `e`.`brand_value`, `e`.`coming_soon`, `e`.`new`, `e`.`gender`, `e`.`gender_value`, `e`.`info_details`, `e`.`googleshopping_exclude`, `e`.`aw_gc2_amounts`, `e`.`aw_gc2_open_amount_min`, `e`.`aw_gc2_open_amount_max`, `e`.`item_code`, `e`.`hsn_code`, `e`.`gtin`, `e`.`ean`, `e`.`jan`, `e`.`is_accessories`, `e`.`disc_p`, `e`.`disc_p_value`, `e`.`disc_off`, `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`, IF(at_back_label.value_id > 0, at_back_label.value, at_back_label_default.value) AS `back_label`, (SELECT value FROM `catalog_product_entity_int` camp WHERE `camp`.`attribute_id` =(SELECT attribute_id FROM `eav_attribute` WHERE `attribute_code` = 'campaign_product') AND `camp`.`entity_id`=`e`.`entity_id`) AS `campaign`, (SELECT value FROM `catalog_product_entity_int` acc WHERE `acc`.`attribute_id` =(SELECT attribute_id FROM `eav_attribute` WHERE `attribute_code` = 'is_accessories') AND `acc`.`entity_id`=`e`.`entity_id`) AS `accessories` FROM `catalog_product_flat_10` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=10 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '390' 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 LEFT JOIN `catalog_product_entity_varchar` AS `at_back_label_default` ON (`at_back_label_default`.`entity_id` = `e`.`entity_id`) AND (`at_back_label_default`.`attribute_id` = '175') AND `at_back_label_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_back_label` ON (`at_back_label`.`entity_id` = `e`.`entity_id`) AND (`at_back_label`.`attribute_id` = '175') AND (`at_back_label`.`store_id` = 10) WHERE (e.status = 1) ORDER BY FIELD(campaign, 1) DESC, FIELD(accessories, 1) ASC

Formal Wear


Your look at the workplace is just as important as your work itself. When you turn up well dressed, you create a desirable impression and command authority. Dressing sloppily doesn’t help your reputation, even if you remain committed towards your job. To make the right impression, you need to choose the right ladies formal wear for a professional yet stylish 9-to-5 look. Be it a pair of trousers or a formal skirt you’re wearing to work, style is more important than ever. AND’s fresh collection of formal dresses for women is crafted to add grace and style to your everyday office look. With our ladies formal wear, you are sure to earn praises for your neat and chic look at work.

Formal dressing doesn’t have to be drab anymore. With AND’s fabulous range of professional wear for the modern woman, you can revamp your wardrobe and mix a little fun into work. Understanding the demands of the modern workplace, AND has designed contemporary formal dresses and formal shirts for women. The exclusive designs from AND create a striking effect by blending breezy colours with lively patterns. No longer do you have to stick with dull shirts and uninspiring dresses in a bid to look professional at work.

Presentations are important but looking presentable yourself is equally important. For those times when you are tasked with the job of making an impression on an audience in a formal setting, choose one of the solid colour formal shirts for women from AND. Pair it with a black trouser, match it with nude pumps and you are all set for a remarkable presentation. For a different look, try a formal dress with a blazer during the winters. Remember to match the colour of your blazer with your AND formal dress for the complete effect.

Sartorial and comfort issues feature among the top problems of working women. Wearing a formal dress for 9 hours can be quite tricky if it is not comfortable. With AND as your fashion stylist, you can let go of such worries. AND not only uses only the finest material to create its range of ladies formal wear but also believes in keeping a woman comfortable even as she looks gorgeous. Try our ladies formal shirts and your favourite jeans for your next meeting - you won’t be disappointed either with the comfort level nor the effect you have on the audience. To enhance your look, wear a formal neck piece matching with your shirt. Keep it simple by wearing matching peep-toes and you are sure to earn jealous looks from co-workers.

To buy formal dresses or formal shirts for women from AND, you don’t even need to leave the comfort of your house. Visit our online shopping platform to glance through our vast collection of formal wear available in a range of style and sizes. Wear AND to flaunt your feminine charm at work like never before.