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 Taupe Fabiana Anarkali Suit
$349.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/Blouse:
Mauve Taupe crinkle chiffon shir Embellishments and embroidery work at hemline and sleeves cuffs. Stand-collar neckline style with sheered bell sleeves. Silk lining inside. Concealed back zip closure.
Bottom/Trousers:
Black raw silk straight trousers. Concealed front zip closure.
Dupatta/Veil:
Mauve Taupe crinkle chiffon dupatta Extensive sequins spray. Piping edges finished.
Embellishment work:
Sequins, beads, crystals and thread work. 100% pure best quality imported fabric. 100% handmade embellishments.
