SELECT imie, miot from swinki where data_ur like '%-07-%'; SELECT DISTINCT s.data_ur, s.miot from swinki as s join rasy r on r.id=s.rasy_id where s.rasy_id=1;