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 Feodora
$329.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 anarkali Descent embellishments on bodice. Gorgeous embroidery work on front and hemline. Beautiful ornamental motifs are made before hem. Heavy sequins spray all over the shirt. Sweetheart neckline. Concealed zip closure on back.
Bottom/Pajama:
Black banarsi jamawar churidar pajama Beautiful embroider motifs on bottom.
Dupatta/Veil:
Black crinkle chiffon dupatta with ornamental motifs Heavy sequins all over. Sleek floral embellishments done on pallu. Finished with piping on edges.
