UPDATE: replaced various "select system_id" statements with "select *" statements in order to fill the orm cache right before creating object instances