Delete a notification for a page via script?

[Mihai Mihai]

Hello,

Due to https://jira.atlassian.com/browse/CONFSERVER-15964 we cannot purge a page as we get an error:

delete on table "content" violates foreign key constraint "fk594acc88c38fbea" on table "notifications"
  Detail: Key (contentid)=(182682701) is still referenced from table "notifications".

As we would like to not stop the database for something as small as this, would it be possible to delete that notification through a script? We do have scriptrunner for confluence.

DELETE FROM NOTIFICATIONS WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT WHERE (CONTENT_STATUS = 'deleted' AND SPACEID = <SPACEID>) OR PREVVER IN (SELECT CONTENTID FROM CONTENT WHERE CONTENT_STATUS = 'deleted' AND SPACEID = <SPACEID>));

It would replace the above query.

Thank you!