fix: Fix inactive project scan to prevent duplicate issues

Relates to #260 (closed)

This MR addresses the failure to validate if the latest issue in a project's queue is a deletion one. Also, more meaningful logging statements.