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 Cadia
$749.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 Fabulous embellishments at front and neckline. Multicolor panels on sides adorned with tiny floral ornaments and graceful embellishments. Dipped hemline style draped with floor touching length at the back and fashion with mutlicolor appliques. Chinese collar neckline style. Fully lined. Banarsi piping edges finished.
Bottom/Trousers:
Tiffany Blue raw silk straight trousers Sequin spread at the bottom. Concealed front zip closure.
Dupatta/Veil:
Radical Red crinkle chiffon dupatta Dual and multicolor appliqued border with heavy embellishments. Small sized ornamental motifs are made all over Heavy sequins spray all over
Embellishment work:
Sequins, beads, dabka, swarovski crystals. 100% handmade embellishments. 100% pure best quality imported fabric.
