UPDATE
thanks for the patience everyone, it seems that around 8 hours ago our database had a critical failure,
which caused a tables indexes to become corrupted. because of the size of this table it is taking a really long time to clean it,
im not sure how long it will take