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: https://bitbucket.org/mikepeel/wikicode/src/master/query_enwp_articles_no_wikidata.py Specifically by running this query: SELECT page_title FROM page WHERE page_namespace=0 AND page_is_redirect=0 AND page_id NOT IN (SELECT page_id FROM page JOIN page_props ON page_id=pp_page WHERE page_namespace=0 AND pp_propname='wikibase_item') I recently learnt that __EXPECTED_UNCONNECTED_PAGE__ exists as a magic word, seemingly introduced by T97577 <https://phabricator.wikimedia.org/T97577>. I would like to exclude pages that use this magic word from the database query, so that the bot runs more optimally - is this possible somehow? 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, maantietaja, Akuckartz, Iflorez, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected]
