Correction:

select parent.keyid, parent.field1, ..., parent.fieldN, count(child1.*) Kount1, count(child2.*) Kount2 from parent left join child1 on parent.keyid = child1.parent_id left join child2 on parent.keyid = child2.parent_id where somefilterhere group by parent.keyid