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 Trendy
$1,649.99
Description Top:
Black Banarsi jamawar shirt
Beautiful ornamental motifs all over.
Big ornamental motifs all over standing on a heavy embellished border.
Embellished boat neckline.
Super-soft lining.
Hidden zipper at back.
Piping edges finish .
Skirt/Lehenga :
Black crepe silk flared lehenga
Extensive embellished borders around the hemline with tall ornamental motifs.
Stunning floral motifs scattered all over the skirt.
Banarsi jamawar border edges.
Extra flared silhouette.
Super-soft lining.
Hidden zipper at back.
Piping edges finish.
Shawl/Dupatta:
Black chiffon dupatta has extensive embellished borders.
Black border with beautiful floral work.
Gold border filled with sparkling work.
Small floral ornamental motifs made in sequins in the third border.
The center has big ornamental motifs among heavy sequins shower.
Embellishment work:
Sequins, beads, kora, dabka, Swarovski crystals
Diamantes, cut-glass, marorri, pearls, naqshi, kamdani and badla.
100% natural pure fabrics.
Fully handmade embellishments.
