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
Black Manda
$289.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:
Black crinkle chiffon shirt Stunning detailed embroidery in butterfly and floral design made all over the front. Mutli-color appliqued hemline adorned with amazing and colorful embroidery. Dual applique accents the sleeve cuffs and stand collar neckline. Front hook-closure silhouette with pink buttons detail. Fully lined. Concealed back zip closure.
Bottom/Trousers:
Off-white raw silk straight trousers. Concealed front zip closure.
Dupatta/Veil:
Black crinkle chiffon dupatta Heavy sequins embellishments. Piping edges finished.
Embellishment work:
Threads, sequins, beads, swarovski crystals. 100% pure imported fabric. 100% handmade embellishments.
