Don't join on rows who's translation ids are zero, thus eliminating duplicates.