Mike_Peel closed this task as "Resolved".
Mike_Peel claimed this task.
Mike_Peel added a comment.
Thanks, implemented now, and this seems to be working well!
TASK DETAIL
https://phabricator.wikimedia.org/T297515
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailprefe
Lucas_Werkmeister_WMDE added a comment.
I think it can be a simpler JOIN. and also, you should use the `pp_sortkey`
so that the namespace filtering can already take place within the `page_props`
index:
SELECT page_title FROM page JOIN page_props ON page_id = pp_page WHERE
pp_propname
Mike_Peel added a subscriber: Lucas_Werkmeister_WMDE.
Mike_Peel added a comment.
@Ladsgroup @Lucas_Werkmeister_WMDE OK, reading through the other task (and
quickly renaming this one, sorry for that confusion!), the big change is the
new page_prop 'unexpectedUnconnectedPage', which I could sim
Mike_Peel renamed this task from "Improving the database query for unconnected
pages" to "Improving Pi bot's database query for unconnected pages".
TASK DETAIL
https://phabricator.wikimedia.org/T297515
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To:
