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 = '316' 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



Maxi dresses are one of the most versatile pieces of clothing. They are not only comfortable, but also look uber stylish, adding heaps of elegance to one’s look. Easy to wear and style, floor length dresses are a favourite during those sweet summer days.

Long dresses for women were once associated with dressy and formal occasions. But long dresses for ladies are now worn on a variety of occasions. What makes them a great choice for a range of occasions is their inherent versatility. For an office party, sport a formal maxi dress with matching pumps for a sophisticated yet charming look. For a day on the beach, pair a maxi dress with flip-flops and hats and you’re set to sail through the day in style. With AND’s exciting range of breezy and chic floor length dresses, you can now carry yourself in equal parts style and grace. The fashion repertoire of AND has a touch of ultra-modern style in all its long dresses for ladies. With their lovely design and colours, these maxi dresses are sure to captivate onlookers.

Our artful conception of floor length dresses has been used to design stunning pieces for the modern woman. Women love sporting flowy maxi dresses but choosing the right one can be tricky. You need to know what will fit you just perfectly. A new long dress can instantly make you trendy and chic. The best part about maxi dresses is that they look great on all body types and sizes, imparting a clear elegance and grace. While airy long dresses for women work brilliantly in the summer time, they can be worn equally well during the winters. All you need to do is pull up a long coat, jacket or shrug with boots to go with your maxi dress. To look stunning in your new long dress, add a neck piece to finish the look, wear light make-up and put on a matching pair of flats.

When checking out the online collection of AND, you will come across a variety of bold fashion pieces. Be sure to pick one to flaunt your daring side. Our fresh collection of maxi dresses online India, with its lively hues and distinct patterns offers something to all body types and size. AND doesn’t only focus on style but also crafts ensembles keeping comfort in mind. Every maxi dress you pick at AND is sure to keep you at ease with its fine material and style.

Busy professionals might not find the time to go shopping for the perfect maxi dress. So head to our online store to check out the latest collection of the best maxi dresses online India without having to step out of your house. Browse through a multitude of styles, patterns, cuts, and colours to zero in on the floor length dress just for you. With AND as your fashion partner, you can make a distinct style statement. Shop online at AND today and discover a world of elegance.