position----desc---SELECT DISTINCT `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 = '15' 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 INNER JOIN `catalog_product_index_eav` AS `color_idx` ON color_idx.entity_id = e.entity_id AND color_idx.attribute_id = '92' AND color_idx.store_id = 10 AND color_idx.value in ('25') 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



AND began its journey with a vision to give the Indian urban woman the kind of fashion that doesn’t fit just her body but also her lifestyle. AND blends classic charm with contemporary style to give a modern twist to western wear for women. With its vast collection of western clothing for women, AND designs silhouettes that are comfortable and beautifully flattering.

Widely popular, dresses are vital to every woman’s wardrobe. AND takes you on a fairy tale journey with its party wear western dresses collection. Having styles from casual striped to elegant dresses, this splendid collection will truly liven up your wardrobe. Offering an explosion of colors, AND has something in store for everyone. Whether it is a beach party buzzing with college friends or a graceful corporate party, AND brings you the perfect collection of western dresses online India. If it is a family gathering, you can pick up AND’s one piece dress created for those casual and fun parties. The comfortable dresses will help you let your hair down and have a gala time with your friends and relatives. Even though the dresses are created to bestow comfort, they don’t compromise on style.

With its fashion dresses online, AND India offers you a chance to be the star of your own story. Meanwhile, with its business attire for women, the label boosts your confidence up and offers you a chance to wear your personality. You can choose to mesmerize your date with AND’s gorgeous A-line dresses that are available online. For a touch of poise, you can easily rummage through the evening-wear collection and pick any dress for women. Whether you want a fairy tale effect or a graceful feminine one, the collection will help you wear any guise for the evening. With a huge variety of prints, designs, and cuts, AND has something in store for every occasion.

Each dress is made to outline those feminine curves that you are so proud of. You can turn into a fashion model for any party without much effort. All you have to do is pick a dress that fits and then pick the right accessories to enhance the effect. Each AND ladies dress has been made with painstaking care and heaps of love. When you wear an AND dress, you put on novelty and distinction. Our ladies dresses are more than just pieces of clothing. They are magnificence and beauty combined to create grace. Our fashion dresses help you charm those around you, beautifully bringing out your feminine side.

AND’s unique collection of dresses for women is for those who refuse to compromise on fashion. So, explore the wonderful collection and wear your attitude with poise and grace. AND offers western dresses for women in sizes ranging from XS to XXL. View our entire collection of lovely and versatile dresses to make your pick. Put your best fashion foot forward everyday as you step out draped in AND’s fashion dresses for women.