Deadlocked by a SELECT Query

Most engineers believe one simple rule: