[Wikidata-bugs] [Maniphest] T297515: Improving the database query for unconnected pages

Ladsgroup added a comment. Should we call this resolved @Mike_Peel? TASK DETAIL https://phabricator.wikimedia.org/T297515 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: Aklapper, Addshore, Ladsgroup, Lydia_Pintscher, Mike_Peel,

[Wikidata-bugs] [Maniphest] T297515: Improving the database query for unconnected pages

Ladsgroup added a comment. The query that special page makes is: SELECT page_id AS `value`,page_namespace AS `namespace`,page_title AS `title`,0 AS `page_num_iwlinks` FROM `page` LEFT JOIN `page_props` ON ((page_id = pp_page) AND pp_propname IN

[Wikidata-bugs] [Maniphest] T297515: Improving the database query for unconnected pages

Mike_Peel added a comment. In T297515#7563893 , @Ladsgroup wrote: > Have you checked how the SpecialUnconnectedPages work? To be precise:

[Wikidata-bugs] [Maniphest] T297515: Improving the database query for unconnected pages

Ladsgroup edited projects, added Data-Persistence (Consultation); removed DBA. Ladsgroup added a comment. Have you checked how the SpecialUnconnectedPages work? To be precise:

[Wikidata-bugs] [Maniphest] T297515: Improving the database query for unconnected pages

Mike_Peel updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T297515 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Mike_Peel Cc: Aklapper, Addshore, Ladsgroup, Lydia_Pintscher, Mike_Peel, Invadibot, Devnull, LSobanski,

[Wikidata-bugs] [Maniphest] T297515: Improving the database query for unconnected pages

Mike_Peel created this task. Mike_Peel added projects: DBA, Wikidata. Restricted Application added a subscriber: Aklapper. Restricted Application added a project: wdwb-tech. TASK DESCRIPTION I run regular SQL queries for unconnected pages on a few wikis, per: