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

SALE

Red Tussar Linen Handwoven Saree

₹ 18,000/-

Out of Stock

Beige Katiya Handwoven Saree

₹ 18,000

₹ 12,600/-

Grey Tussar Cotton Handwoven Saree

₹ 18,000/-

Out of Stock

Organza Ahir Embroidered Pichwai Saree

₹ 26,900/-

Out of Stock

Pichwai Jamdaani Organza Saree

₹ 20,900/-

Out of Stock

Handwoven Tussar Cotton Batik Pichwai Saree

₹ 12,900/-

Out of Stock

Tussar Handpainted Pichwai Saree

₹ 33,900

₹ 23,730/-

Handwoven Linen Batik Pichwai Saree

₹ 12,900/-

Out of Stock