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



Let your clothes do the talking with trendy bottomwear for women online by AND. Find yourself some great deals and styles at AND. AND is known for its novel and modern approach to fashion. Check out our stunning collection of women’s leggings, palazzos, pencil skirts, trousers, and much more. These styles are here to impress.

Move from the 9 to 5 job to rocking the dance floor with comfortable ladies bottomwear from AND. Known for graceful style, AND brings to you fresh and vibrant ladies trousers for all ages. Blending the concept of tradition and modernity, AND has emerged as one of the most sought-after fashion brands for women. The collection has something in store for everyone. Be it a knitted trouser for office or a pair of cropped pants for a party, you will find just what you’re looking for in AND’s online collection.

Whether it’s a plaid skirt with a plain black top for a music concert or a leaf print palazzo paired with a white layered top for an evening with friends - you will get the latest and most fashionable trousers for women at AND. Transcend effortlessly from office wear to party wear with a pair of women’s jeggings by matching them with different tops. Go out for a picnic with your friends in a breezy polka dot skirt.

Brighten your day with a linear abstract print high slit skirt or show off your style in a striped mini skirt. There is so much to choose from. If you are looking for formal outfits, then style an open front blazer with a pair of black trousers and breeze through your meetings. With the wide range of colours and styles to choose from, your wardrobe would be classier than ever. Check out all trendy styles today and bring home your favourites.

The stylish yet comfortable bottomwear for women by AND come in a variety of styles and hues. The perfectly tailored bottomwear adds a twist to your everyday look by lending it an element of distinction. A playful energy is what AND portrays in its collection of ladies trousers and pants. The designs are inspired by modern culture and are crafted to match the fashion sense of today’s women.

Select the best bottomwear from AND to go with your formal shirt to create an impression in the boardroom. Turn heads at any party with a shimmering pant and a cute tank top. And don’t forget to wear matching jewellery and your high-heels to complete the look. Once you browse through our trousers for women online, you will find it challenging to decide which wide-legged trouser or cropped jeggings to pick. At AND, you would want to shop just everything.

Other than offering the signature of the brand, AND aims to offer the urban woman the freedom to live in style and be a trendsetter. Lay your hands on some exclusive fashion today by choosing AND as your style partner.