I was querying Fa WP replica on labs today looking for article that are not in any categories, and noticed that the results included three articles which had been deleted on Fa WP on July 12, 2015 but the replica still treats them as if they were not deleted, i.e. the records are in the page and revision tables, not in the archive table. The pages are w:fa:محیط_عملیاتی , w:fa:محمدسجاد_بداغی , and w:fa:آمیتیس
Here is my SQL query, which is expected NOT to include those pages:
select page_title from page left join categorylinks on page_id = cl_from where page_namespace = 0 and page_is_redirect = 0 and cl_from is null
Reporting here to allow investigating for replication errors.