Selact * from table group by (id, view_id) a
Cepten yazdim kusura bakma
Yani iki kere group by yapmalisin