fix query for yesterday visits