mysql join duplicates - 在table2上正常工作，但添加table3重复table2s行

so, I'm using proprietary data, so I can't just cut paste my code in here. and, I'm sorry this is probably trivial, but for some reason I can't wrap my head around why it's duplicating.so, I'm using proprietary data, so I can't just