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

Tops