select count(*) from hrad
select h.*, s.nazev from hrad h inner join strasidlo s on s.hrad = h.id
update hrad set nazev='Radyně' where id='1'
select h.i_d, count(s.*) as pocet_strasidel from hrad h inner join strasidlo s on s.hrad = h.id group by h.id