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

BELT

Brown Pichwai Hand Embroidered Belt

$ 86/-

Sold Out

Maroon Pichwai Hand Embroidered Belt

$ 86/-

Sold Out

Green Pichwai Hand Embroidered Belt

$ 86/-

Out of Stock

Pink Pichwai Hand Embroidered Belt

$ 86/-

Out of Stock

Multi Colour Pichwai Hand Embroidered Belt

$ 86/-

Out of Stock

Brown Pichwai Hand Embroidered Belt

$ 86/-

Sold Out

Mustard Pichwai Hand Embroidered Belt

$ 86/-

Pink Pichwai Hand Embroidered Belt

$ 86/-

Out of Stock

Mustard Pichwai Hand Embroidered Belt

$ 86/-

Out of Stock

Mustard Pichwai Hand Embroidered Belt

$ 86/-

Out of Stock

Green Pichwai Hand Embroidered Belt

$ 86/-

Sold Out