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
Light Green Kaptelina
$229.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:
Light Green crepe silk long shirt has marvelous and colorful embroidered detail at the bottom. Stand collar neckline style. Fully lined. Concealed back zip closure.
Bottom/Trousers:
Offwhite raw silk plain straight trousers in full length. Concealed front zip fastening.
Dupatta/Veil:
Light Green crinkle chiffon dupatta having heavy sequins embellishments all over. Finished with piping on edges.
Embellishment work:
Resham and Swarovski crystals. 100% handmade embellishments. 100% pure highest quality imported fabric.
