You have two queries here and both have "AND art.[Status] = 'Published'" hard coded into the WHERE clause. AND... That is the same status being referenced in both SELECT lists.

So, the next question is this... Are the complainers seeing the word "Archived " in the output? OR are they simply seeing articles that they think should be in an Archived status?
As a betting man, my money is on the later...