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
Gold Classa Anarkali Suit
$779.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:
Gold, lime fizz and yellow Anarkali dress
Heavy embellished bodice and flared umbrella
Lovely flower ornamental motifs all around.
Scattering sequins work on edges.
Finish with multicolor border from the hemline.
Extra flared silhouette.
Fitted from the bust.
Scoop neck has aqua embellished tab on front.
Full sleeves have gathers on cuffs with wide heavy embellished border.
Super-soft lining.
Hidden zipper at back.
Piping edges finish.
Bottom:
Aqua crepe silk churidar pajama.
Hidden zip closure.
Shawl/Dupatta:
Aqua chiffon dupatta with big flower ornamental motifs all around the border.
Thin floral work beside the flowers.
Small ornamental motifs and sequins shower in the center.
Multicolor border finish.
Embellishments work:
Sequins, beads, pearls, Swarovski crystals, diamantes, rhinestones, dabka, kora, naqshi, badla, kamdani, marorri and resham.
100% natural pure fabrics.
Fully handmade embellishments.
