Torry/Ferryhill by-election result (Aberdeen City Council):
SNP 43.2% (+11.8)
Conservatives 26.0% (+2.1)
Labour 10.6% (-12.8)
Liberal Democrats 8.4% (+3.3)
Greens 8.1% (+3.3)
UKIP 1.4% (+0.5)
The percentage changes are uncannily similar to last week's three by-elections - the SNP are up, the Tories are up but not by as much, and Labour are down. It looks like voters are highly motivated to turn out for the SNP, which hopefully makes it less likely that the opinion polls will overestimate the SNP's general election support this time. I don't think we should jump to the conclusion that the Tories' vote is likely to increase from 2017 - they tend to benefit from differential turnout in local by-elections, and a drop in the Independent vote may also have been a factor.
Bear in mind that not all of the votes in Torry/Ferryhill were cast after the rigged debate - most postal votes will have been completed before then. But it's a highly reassuring result all the same.