logging error and offending query
adding defaults in case data is missing
adding missing gameres columns for ra and td