Account for Pacific time, stop using MySQL functions, such as CURDATE()
and GROUP_CONCAT