CREATE TRIGGER insert_media_sortorder  AFTER insert ON media 
begin

update media set sortorder = (select ifnull( 0, max(sortorder)) + 10 from media x, media_person y where x.id = y.person_id and y.id =    1   ) 
where id = new.id and sortorder is null;

end;