I am having a hell of a time getting what seems like a simple running total to work with a variable in MySQL. My original query looks like this (table/column names are simplified for readability ...