more playing with timezone stuff.
merge it back into one sql query.