Prova

select t.id,t.name,t.imgpath,t.description,t.owner,count( j.id) as tot from tabella t left join tabella j on t.id = j.owner group by t.id