Fix Disappearing Totals Due to JOIN or External WHERE Conditions

Fix disappearing totals. Totals could have being filtered if query had JOIN or subquery with external WHERE condition. Fixes #10674 #10698 (Nikolai Kochetov)