select * from table_product_search_view where status = 1 and collection = 'Dresses' order by tlid desc

Dresses

Pink and Red Paithani & Chanderi Dress with Belt

₹ 42,900/-

Out of Stock

Grey and Rust Paithani & Chanderi Dress with Belt

₹ 42,900/-

Out of Stock

Peach and Mustard Paithani & Chanderi Dress with Belt

₹ 42,900/-

Out of Stock

Golden and Blue Hand Embroidered Co-Ord Set

₹ 46,900/-

Pink Hand Embroidered Co-Ord Set

₹ 18,900/-

Out of Stock

Grey Hand Embroidered Co-Ord Set

₹ 18,900/-

Light Blue Hand Embroidered Co-Ord Set

₹ 25,900/-

Sold Out

Dark Grey Hand Embroidered Co-Ord Set

₹ 18,900/-

Peach Hand Embroidered Co-Ord Set

₹ 18,900/-

Peach Pichwai Lehenga

₹ 55,900/-

Out of Stock

Pink Pichwai Lehenga

₹ 55,900/-

Olive Green Handpainted Pichwai Lehenga Saree

₹ 75,900/-

Out of Stock

Mauve Handpainted Pichwai Lehenga Saree

₹ 75,900/-

Out of Stock

Peach Pichwai Lehenga

₹ 175,900/-

Out of Stock

Green Pichwai Lehenga

₹ 175,900/-

Peach Pichwai Lehenga

₹ 175,900/-

Sold Out

Mustard Pichwai Lehenga

₹ 175,900/-

Blue Pichwai Lehenga

₹ 185,900/-

Peach Pichwai Lehenga

₹ 185,900/-

Yellow Pichwai Lehenga

₹ 55,900/-

Grey Raw Silk Gown

₹ 75,900/-

Peach Raw Silk Gown

₹ 55,900/-

Ice Blue Raw Silk Gown

₹ 55,900/-

Yellow Ghicha Silk & Raw Silk Gown

₹ 55,900/-

Out of Stock

Purple Silk Velvet Gown with Belt

₹ 125,900/-

Sold Out

Yellow Raw Silk Gown

₹ 75,900/-

Green Ghicha Silk Gown

₹ 75,900/-

Black Ghicha Silk Gown with Belt

₹ 75,900/-

Sold Out