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

SALE

Pink Paithani Cotton Handpainted Dupatta

$ 161/-

Out of Stock

Lemon Kalamkari Tussar Silk & Linen Dupatta

$ 161

$ 137/-

Blue Kalamkari Modal Silk Dupatta

$ 161/-

Sold Out

Red Tussar Linen Handwoven Saree

$ 225/-

Out of Stock

Beige Katiya Handwoven Saree

$ 225

$ 158/-

Grey Tussar Cotton Handwoven Saree

$ 225/-

Out of Stock

Organza Ahir Embroidered Pichwai Saree

$ 336/-

Out of Stock

Pichwai Jamdaani Organza Saree

$ 261/-

Out of Stock

Handwoven Tussar Cotton Batik Pichwai Saree

$ 161/-

Sold Out

Tussar Handpainted Pichwai Saree

$ 424

$ 297/-

Handwoven Linen Batik Pichwai Saree

$ 161/-

Sold Out