The cause of this bug is that FlaggedRevs work in template and main namesspaces and does not work in project namespace.
when the page (A) created in template namespace so FlaggedRevs tracked it revisions and the page has record in flaggedpages table.
the bug occuered when page (A) moved to project namespace which is not tracked by FlaggedRevs.
new revisions created for page (A) but untracked by FlaggedRevs.
when page (A) transcluded in page (B) which is main namespace and controled by FlaggedRevs, so FlaggedRevs checks page (A) last reviewed revision witch is outdated before page (A) moved to project namespace.

for example see ويكيبيديا:ملاحظة اليوم/97 history
and its record in flaggedpages table

suggested fixing
create hook in moving page from monitored FlaggedRevs namespace to unmonitored namespace, this hook deletes the page record in flaggedpages table and any other tables.

@Ladsgroup We need to run SQL queries in arwiki to clean this bug outputs until it fixed

Sure. With enough bribe, I can do it. (just kidding)

What queries do you want me to run?

FYI, a production error needs to display an error code rather than just being a bug. Is there an error code? If not, let's change this ticket back to being a bug report.

@Novem_Linguae no error code, I changed ticket tag

In T432509#12149723, @hubaishan wrote:

DELETE from flaggedpages 
WHERE (SELECT page_namespace FROM page WHERE page_id=fp_page_id) not in (0,6,10,100,828);

@Ladsgroup

Thanks. Looking.

I double check everything and do it on Monday.

@Ladsgroup today in Wednesday!

Yup. Sorry. This is a bit scary so I need to spend some time to make sure I don't cause data corruption. On it.

Mentioned in SAL (#wikimedia-operations) [2026-07-29T10:39:23Z] <Amir1> ran https://phabricator.wikimedia.org/T432509#12149723 in production (T432509)