select distinct p.products_id, pd.products_name, p.products_ordered, p.products_price, p.products_image
from nl_products p, nl_products_description pd
where p.products_status = '1'
and p.products_ordered > 0
and p.products_id = pd.products_id
and pd.language_id = '1'
order by p.products_ordered desc, pd.products_name
limit 3
Mauve Chesa Anarkali Suit
$629.99
Please Choose:
Select Size
Custom Made-to-Measure
Size (2XL)
Size (2XL-2)
Size (L)
Size (L-2)
Size (M)
Size (M-2)
Size (S)
Size (S-2)
Size (XL)
Size (XL-2)
Size (XS)
Select Sleeve
Sleeve: As shown/described
Sleeve: Bell
Sleeve: Full
Sleeve: Half
Sleeve: Three Quarter
Select Bottom
Bottom: As shown/described
Pyjama: Churidar
Pyjama: Slim Straight
Shalwar: Baggy
Shalwar: Patiala
Shalwar: Regular
Shalwar: Slim
Trouser: Slim Straight
Trouser: Bell Bottom
Trouser: Capris
Trouser: Flappers
Trouser: Straight
Description Top:
Dark Old Mauve crepe silk anarkali style shirt Amazing embellishments on neckline, collar and bottom. Paisley richly embellished ornaments made all over the front. Stand collar neckline. Fully lined. Concealed back zip closure.
Bottom/Pajama:
Old Mauve crepe silk ready churidar pajama with banarsi jamawar bottom. Full elastic waist.
Dupatta/Veil:
Old Mauve crinkle chiffon dupatta with heavy sequins spray. Banarsi edges finished.
Embellishment work:
Sequins, beads, Dabka and Swarovski crystals. 100% pure best quality imported fabric. 100% handmade embellishments.
