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

DUPATTA

Dark Blue Tussar Silk & Linen Dupatta

$ 86/-

Out of Stock

Peach Tussar Silk & Linen Dupatta

$ 86/-

Out of Stock

Grey Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Green Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Green Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Green Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Blue Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Dark Grey Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Mustard Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Dark Grey Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Rust Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Blue Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Grey Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Grey Tussar Silk & Linen Dupatta

$ 86/-

Out of Stock

Grey Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Blue Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Multi Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Indigo Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Olive Green & Brown Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Blue Tussar Silk & Linen Dupatta

$ 86

$ 65/-

Green Tussar Silk &Linen Dupatta

$ 86

$ 65/-

Pink Paithani Silk Dupatta

$ 536

$ 429/-

Golden Paithani Silk Dupatta

$ 699

$ 594/-

Golden Paithani Silk Dupatta

$ 624/-

Sold Out

Pink Paithani Silk Dupatta

$ 536/-

Sold Out

Silver Grey Paithani Silk Dupatta

$ 536/-

Sold Out

Sky blue Paithani Cotton Dupatta

$ 236/-

Out of Stock

Yellow Embroidered Organza Dupatta

$ 574/-

Beige Embroidered Organza Dupatta

$ 386

$ 328/-

Pink Embroidered Organza Dupatta

$ 386

$ 328/-

Red Embroidered Organza Dupatta

$ 449

$ 381/-

Blue Embroidered Organza Dupatta

$ 386/-

Out of Stock

Mustard Embroidered Organza Dupatta

$ 386/-

Out of Stock

Red Ajrakh Tussar Silk & Linen Dupatta

$ 324

$ 275/-

Red Ajrakh Tussar Silk & Linen Dupatta

$ 324

$ 275/-

Brown Ajrakh Tussar Silk & Linen Dupatta

$ 324

$ 275/-

Light green Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Peach Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Blue Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Light blue Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Green Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Peach Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Cream Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Rust Kalamkari Tussar Silk & Linen Dupatta

$ 161

$ 137/-

Grey Kalamkari Organza Dupatta

$ 161

$ 137/-

Blue Kalamkari Modal Silk Dupatta

$ 161

$ 137/-

Rust Kalamkari Kanjeeveram Silk & Paithani Dupatta

$ 486

$ 389/-

Kalamkari Silk Dupatta

$ 161/-

Out of Stock

Peach Kalamkari Silk Dupatta

$ 161/-

Sold Out

Yellow Tussar Silk & Linen Dupatta

$ 386/-

Green Tussar Silk & Linen Dupatta

$ 386/-

Blue Tussar Silk & Linen Dupatta

$ 386/-

Rust Tussar Silk &Linen Dupatta

$ 386/-

Yellow-Green Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Pink Tussar Silk &Linen Dupatta

$ 86

$ 60/-

Dark Brown Tussar Silk &Linen Dupatta

$ 86/-

Out of Stock

Blue Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Light Purple Tussar Silk &Linen Dupatta

$ 86

$ 60/-

Blue Tussar Silk & Linen Dupatta

$ 86

$ 60/-

Pink Tussar Silk & Linen Dupatta

$ 86

$ 60/-