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

SAREE

Orange and mustard Printed and Hand-embroidered Tussar Linen Pichwai Saree

₹ 65,900/-

Green Printed and Hand-embroidered Tussar Linen Pichwai Saree

₹ 65,900/-

White Hand-embroidered Chikankari Pichwai Saree

₹ 79,900/-

White Hand-embroiedered Chikankari Pichwai Saree

₹ 79,900/-

Pink Hand-embroidered Kalamkari Pichwai Saree

₹ 45,900/-

White Patchwork Kalamkari Pichwai Saree

₹ 35,900/-

Grey Patchwork and Hand-embroidered Pichwai Saree

₹ 89,900/-

Out of Stock

Pink Patchwork and Hand-embroidered Pichwai Saree

₹ 79,900/-

Pink Hand-woven and Hand-embroidered Paithani Pichwai Saree

₹ 92,900/-

Blue Hand-woven and Hand-painted Tussar Linen Paithani Pichwai Saree

₹ 149,900/-

Out of Stock

Green Organza Hand-embroidered Pichwai Saree

₹ 65,900/-

Yellow Organza Hand-embroidered Pichwai Saree

₹ 65,900/-

Grey Hand Embroidered Tussar & Gota Pichwai Saree

₹ 75,900/-

Out of Stock

Black Hand Embroidered Tussar & Gota Pichwai Saree

₹ 75,900/-

Out of Stock

Purple & Beige Hand Embroidered Velvet & Tussar Pichwai Saree

₹ 69,900/-

Out of Stock

Green & Beige Hand Embroidered Velvet & Tussar Pichwai Saree

₹ 69,900/-

Out of Stock

Golden Fusion Paithani Pichwai Saree

₹ 65,900/-

Out of Stock

Dark Grey Fusion Paithani Pichwai Saree

₹ 79,900/-

Out of Stock

Grey Fusion Paithani Pichwai Saree

₹ 79,900/-

Out of Stock

Pink Fusion Paithani Pichwai Saree

₹ 65,900/-

Out of Stock

Green Fusion Paithani Pichwai Saree

₹ 55,900/-

Out of Stock

Mauve Fusion Paithani Pichwai Saree

₹ 59,900/-

Out of Stock

Light Pink Fusion Paithani Pichwai Saree

₹ 80,900/-

Pink Fusion Paithani Pichwai Saree

₹ 69,900/-

Out of Stock

Green Fusion Paithani Pichwai Saree

₹ 69,900/-

Out of Stock

Light Green Fusion Paithani Pichwai Saree

₹ 59,900/-

Yellow Fusion Paithani Pichwai Saree

₹ 59,900/-

Lavender Handwoven Tussar Linen Pichwai Sareee

₹ 35,900/-

Light Mustard Handwoven Tussar Kalamkari Pichwai Saree

₹ 40,900/-

Out of Stock

Multi Pichwai Kalamkari Tussar Saree

₹ 40,900

₹ 30,675/-

Cream Pichwai Kalamkari Silk Saree

₹ 50,900/-

Out of Stock

Green Pichwai Kalamkari Organza Saree

₹ 42,900/-

Out of Stock

Pale Yellow Pichwai Kalamkari Organza Saree

₹ 40,900

₹ 30,675/-

Blue Pichwai Kalamkari Tussar Linen Saree

₹ 35,900/-

Out of Stock

Umber Handwoven Organza Ajrakh Pichwai Saree

₹ 20,900/-

Out of Stock

Green Tussar Handpainted Pichwai Saree

₹ 40,900/-

Out of Stock

Blue Handwoven Tussar Linen Pichwai Saree

₹ 22,900/-

Out of Stock

Peach Georgette Pichwai Saree

₹ 21,900/-

Green Georgette Pichwai Saree

₹ 26,900/-

Out of Stock

Pink Georgette Pichwai Saree

₹ 21,900/-

Grey Georgette Pichwai Saree

₹ 21,900/-

Blue Georgette Pichwai Saree

₹ 21,900/-

Lemon Handwoven Tussar Linen Pichwai Saree

₹ 22,900/-

Out of Stock

Pink Handwoven Tussar Linen Pichwai Saree

₹ 22,900/-

Out of Stock

Green Handwoven Tussar Linen Pichwai Saree

₹ 32,900/-

Light Blue Handwoven Tussar Linen Pichwai Saree

₹ 32,900/-

Sky Blue and Brick Red Handwoven Tussar Linen Pichwai Saree

₹ 32,900/-

Blue Handwoven Tussar Linen Pichwai Saree

₹ 32,900/-

Handwoven Organza Pichwai Saree

₹ 21,900/-

Out of Stock

Handwowen Organza Pichwai Saree

₹ 26,900/-

Out of Stock