I have a query that is repeated regularly and is pretty heavy on the database:
SELECT COUNT(id) AS count
FROM contacts
WHERE team_set_id = '1'
AND deleted = 0
AND id != '62f0e518-5d7e-8e98-f809-58d3bd75e98c'
The contact ID parameter changes, as does the team_set_id but otherwise it is fundamentally the same every time.
It just ran 68 times in the last hour and I can't think of what could possibly be doing this.
I know for a fact that it's not a Report or a List view. What else could it be?
Any thoughts?
Thanks,
FrancescaS