#
#  This query properly handles calls that span from the
#  previous reset period into the current period but
#  involves more work for the SQL server than those
#  below
#
query = "\
	SELECT SUM(acctsessiontime - GREATEST((%%b - strftime('%%s', acctstarttime)), 0)) \
	FROM radacct \
	WHERE username = '%{${key}}' \
	AND (strftime('%%s', acctstarttime) + acctsessiontime) > %%b"