Anomie added a comment.
In T230862#5427914 <https://phabricator.wikimedia.org/T230862#5427914>, @daniel wrote: > Perhaps the recentchanges system should be migrated to Elastic, that would help with a lot of things :) OTOH, that would break it for any MediaWiki wikis not using Elastic... In T230862#5429178 <https://phabricator.wikimedia.org/T230862#5429178>, @Tgr wrote: > In theory it would be something like `recentchanges JOIN revision ON rc_this_oldid = rev_id JOIN slots ON slot_revision_id = rev_id AND slot_role_id = whatever AND slot_origin = rev_id`. Except slot_origin is not used consistently that way; this would miss rollbacks, for example. We'd also have to watch whether that query runs efficiently enough. BTW, I think you could simplify that: `recentchanges JOIN slots ON slot_revision_id = rc_this_oldid AND slot_role_id = whatever AND slot_origin = rc_this_oldid` TASK DETAIL https://phabricator.wikimedia.org/T230862 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Anomie Cc: Anomie, daniel, Aklapper, Lydia_Pintscher, Tgr, Ramsey-WMF, Addshore, Tpt, Lucas_Werkmeister_WMDE, Smalyshev, darthmon_wmde, WDoranWMF, DannyS712, Nandana, JKSTNK, Lahi, PDrouin-WMF, Gq86, E1presidente, Cparle, Anooprao, SandraF_WMF, GoranSMilovanovic, QZanden, EBjune, Tramullas, Acer, merbst, LawExplorer, Sethakill, Salgo60, Silverfish, dg711, Poyekhali, _jensen, rosalieper, Morgankevinj, Taiwania_Justo, Jonas, Xmlizer, Susannaanas, Ixocactus, Wong128hk, Jane023, jkroll, Wikidata-bugs, Jdouglas, Base, matthiasmullie, aude, Tobias1984, El_Grafo, Dinoguy1000, Manybubbles, jayvdb, Ricordisamoa, Wesalius, Fabrice_Florin, Raymond, Steinsplitter, Mbch331, Keegan, Legoktm
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs