[12:39:08] <MisterSynergy>	 Hey all, which table(s) do I have to query on Tool Labs to find unconnected Wikipedia pages?
[12:40:38] <multichill>	 MisterSynergy: You know we have a special page for that?
[12:40:52] <multichill>	 https://en.wikipedia.org/wiki/Special:UnconnectedPages
[12:41:38] <multichill>	 Be careful with mass creating these, you might disrupt some process by a local wiki
[12:41:46] <MisterSynergy>	 Yes, I know. But it is restricted to 10.000 items, and always sorted by page_id desc
[12:42:06] <multichill>	 That should be enough for most wiki´s
[12:42:17] <MisterSynergy>	 there is a question in dewiki how to find particularly old unconnected pages. they don't show up in this list
[12:43:27] <Stryn>	 https://tools.wmflabs.org/wikidata-todo/duplicity.php?wiki=dewiki&mode=list, but shows only articles
[12:43:42] <multichill>	 MisterSynergy: Oh, that´s not that hard to query on the toollabs database
[12:43:55] <multichill>	 I have a query example for you
[12:44:01] <MisterSynergy>	 thanks Stryn
[12:44:13] <MisterSynergy>	 very helpful
[12:44:21] <multichill>	 That webtool is even easier
[12:44:31] <MisterSynergy>	 still I'm interested how this can be queried at tool labs
[12:45:38] <MisterSynergy>	 I just need to know which tables are important
[12:45:54] <multichill>	 MisterSynergy: https://tools.wmflabs.org/multichill/queries/nlwp/unconnected_not_nominated.sql
[12:47:04] <multichill>	 Just remove the "LEFT JOIN categorylinks" part to get them all
[12:47:18] <multichill>	 Or you might want to filter out the nominated for deletion ones on the dewp too
[12:47:22] <MisterSynergy>	 yepp, I'm familiar with SQL
[12:48:00] <MisterSynergy>	 looks like the information I'm looking for can be found in the page_props table
[12:48:36] <MisterSynergy>	 with pp_propname="wikibase_item"
[12:48:40] <paaln>	 I need some help on the property proposal/generic page. I entered a suggestion and did something wrong but have no idea what.
[12:48:53] <multichill>	 MisterSynergy: Yup, you might be interested in https://www.wikidata.org/wiki/Wikidata:Database_reports/removed_sitelinks/dewiki too
[12:50:05] <MisterSynergy>	 I'm going to offer Stryn's tool link first. If they request more at dewiki, I'm probably going to create some Quarry queries for them. 
[12:50:21] <paaln>	 https://www.wikidata.org/wiki/Wikidata:Property_proposal/Generic
[12:50:53] <MisterSynergy>	 page_props with pp_propname=wikibase_item is everything I need to know. 
[12:50:58] <multichill>	 MisterSynergy: On the Dutch Wikipedia we cleared out the unconnected items and I run a bot that waits a couple of links and creates the missing items
[12:51:09] <MisterSynergy>	 Thanks for you help ;-)
[12:55:46] <paaln>	 and the property I wanted to propose was this https://www.wikidata.org/wiki/Wikidata:Property_proposal/Ladies_European_Tour_ID
[12:57:04] <Stryn>	 looking
[12:57:28] <multichill>	 paaln: Everything between <!----> is comments
[12:57:34] <multichill>	 So if you change that, nothing happens
[12:57:55] <Stryn>	 fixed
[12:58:35] <multichill>	 (or is that also in other languages these days?)
[12:59:22] <Stryn>	 paaln: "(avsnitt)" can be removed, right?
[13:03:52] <paaln>	 yes, i have no idea how that ended there
[13:06:02] <paaln>	 stryn, multichill, thanks a bunch to both,