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
White Duscha Anarkali Suit
$449.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:
Anti Flash White crinkle chiffon shirt
Heavy embellishments on pure jamawar bodice.
Umbrella has a teal patchwork accented with pretty embellishments in floral and leaf pattern.
V neckline with full length sleeves.
Fully lined.
Concealed back zip closure.
Bottom/Pajama:
Chocolate banarsi jamawar churidar pajama with no embellishments.
Full elastic waist.
Dupatta/Veil:
Anti Flash White crinkle chiffon plain dupatta
Dual appliqued borders in orange and silver color.
Chocolate crushed dupatta is not included.
Embellishment work:
Dabka, Swarovski crystals, Sequins, beads.
100% handmade embellishments.
100% pure best quality imported fabric.