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

SAREE

Grey Hand Embroidered Tussar & Gota Pichwai Saree

$ 624/-

Black Hand Embroidered Tussar & Gota Pichwai Saree

$ 624/-

Purple & Beige Hand Embroidered Velvet & Tussar Pichwai Saree

$ 624/-

Green & Beige Hand Embroidered Velvet & Tussar Pichwai Saree

$ 624/-

Golden Fusion Paithani Pichwai Saree

$ 824/-

Out of Stock

Dark Grey Fusion Paithani Pichwai Saree

$ 999/-

Out of Stock

Grey Fusion Paithani Pichwai Saree

$ 999/-

Sold Out

Pink Fusion Paithani Pichwai Saree

$ 824/-

Out of Stock

Green Fusion Paithani Pichwai Saree

$ 699

$ 524/-

Mauve Fusion Paithani Pichwai Saree

$ 749

$ 562/-

Light Pink Fusion Paithani Pichwai Saree

$ 1,011/-

Pink Fusion Paithani Pichwai Saree

$ 874/-

Out of Stock

Green Fusion Paithani Pichwai Saree

$ 874/-

Out of Stock

Light Green Fusion Paithani Pichwai Saree

$ 749

$ 562/-

Yellow Fusion Paithani Pichwai Saree

$ 749

$ 562/-

Lavender Handwoven Tussar Linen Pichwai Sareee

$ 449

$ 359/-

Light Mustard Handwoven Tussar Kalamkari Pichwai Saree

$ 511/-

Out of Stock

Multi Pichwai Kalamkari Tussar Saree

$ 511

$ 383/-

Cream Pichwai Kalamkari Silk Saree

$ 636/-

Out of Stock

Green Pichwai Kalamkari Organza Saree

$ 536/-

Sold Out

Pale Yellow Pichwai Kalamkari Organza Saree

$ 511

$ 383/-

Blue Pichwai Kalamkari Tussar Linen Saree

$ 449/-

Sold Out

Umber Handwoven Organza Ajrakh Pichwai Saree

$ 261/-

Out of Stock

Green Tussar Handpainted Pichwai Saree

$ 361

$ 289/-

Blue Handwoven Tussar Linen Pichwai Saree

$ 286/-

Out of Stock

Peach Georgette Pichwai Saree

$ 336

$ 185/-

Green Georgette Pichwai Saree

$ 336

$ 185/-

Pink Georgette Pichwai Saree

$ 336

$ 185/-

Grey Georgette Pichwai Saree

$ 336

$ 185/-

Blue Georgette Pichwai Saree

$ 336

$ 185/-

Lemon Handwoven Tussar Linen Pichwai Saree

$ 286/-

Out of Stock

Pink Handwoven Tussar Linen Pichwai Saree

$ 286/-

Out of Stock

Green Handwoven Tussar Linen Pichwai Saree

$ 411/-

Light Blue Handwoven Tussar Linen Pichwai Saree

$ 411/-

Sky Blue and Brick Red Handwoven Tussar Linen Pichwai Saree

$ 411/-

Blue Handwoven Tussar Linen Pichwai Saree

$ 411/-

Handwoven Organza Pichwai Saree

$ 336

$ 185/-

Handwowen Organza Pichwai Saree

$ 336/-

Out of Stock