select count(t1.ID)
from t1  -- 2
left join t2  on t2.ID = t1.ID -- 104
left join t3  on t3.ID = t1.ID -- 42
left join t4  on t4.ID = t1.ID -- 149
where t1.ID = 509583314; -- 71.565.312 != 2*104*42*149 = 1.301.664

select count(t1.ID)
from t1 -- 2
left join t2 on t2.ID = t1.ID -- 104
left join t4  on t4.ID = t1.ID -- 149          !!! switched t3 and t4 !!!
left join t3  on t3.ID = t1.ID -- 42
where t1.ID = 509583314; -- 1.301.664 = 2*104*149*42 = 1.301.664