SQL / SQLite：尽管使用了DISTINCT，但结果意外

I have ~8000 entries in table "adr" and want to join it with some other tables. However, this leads to 200k+ results despite using DISTINCT. The culprit here is "stort", as the second query works as expected. However, I can't figure out what I'm doing wrong with the first one. Is it the double gemeinde_id?I have ~8000 entries in table "adr" and want to