SELECT uniq(UserID) FROM distributed_table WHERE CounterID = 101500
    AND UserID GLOBAL IN (
        SELECT UserID FROM distributed_table WHERE CounterID = 34
        )
---------------------------
SELECT uniq(UserID)
FROM distributed_table
WHERE CounterID = 101500
	AND UserID GLOBAL IN (
		SELECT UserID
		FROM distributed_table
		WHERE CounterID = 34
	)