fixing issue where get room messages subquery was returning multiple rows