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.
