add group_by in join 'facepalm moment'