[Wikidata-bugs] [Maniphest] [Commented On] T129037: Wikidata Query Service should provide a way to retrieve all items without a statement on a certain wiki

2016-09-16 Thread Multichill 
Multichill added a comment.
Thank you very much @Smalyshev . To complete this ticket, the original query:

https://tools.wmflabs.org/autolist/?language=nl=wikipedia=Motorfietstechniek=0===SELECT%20%3Fitem%20WHERE%20%7B%0A%20%3Flink%20schema%3Aabout%20%3Fitem%20.%0A%20%3Flink%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fnl.wikipedia.org%2F%3E%20.%0A%20%3Fitem%20wikibase%3Astatements%200%20.%0A%7D=P=Run_manual=or_cat=and_wdq=not_wdqs=and_find=or_size=1

Getting pages in category tree... 263 pages found.

Getting corresponding Wikidata items... 263 items found.

Getting WDQS data... 131 items loaded.

Combining datasets...
After OR : 0 items.
After AND : 2 items.
2 items in combination.

Query took 0.44470715522766 seconds. 0.5 MB memory used.

Much faster!TASK DETAILhttps://phabricator.wikimedia.org/T129037EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Smalyshev, MultichillCc: Edgars2007, Jonas, Smalyshev, Nikki, Sjoerddebruin, hoo, Aklapper, Multichill, mschwarzer, Avner, debt, Gehel, D3r1ck01, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, TheDJ, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T129037: Wikidata Query Service should provide a way to retrieve all items without a statement on a certain wiki

2016-08-31 Thread Multichill 
Multichill added a comment.

In T129037#2597211, @Smalyshev wrote:
This will be possible as soon as T129046 deploys and we reload the data.


Awesome job! Looking forward to the new possibilities.TASK DETAILhttps://phabricator.wikimedia.org/T129037EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MultichillCc: Jonas, Smalyshev, Nikki, Sjoerddebruin, hoo, Aklapper, Multichill, mschwarzer, MelodyKramer, Avner, debt, Gehel, D3r1ck01, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, TheDJ, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T129037: Wikidata Query Service should provide a way to retrieve all items without a statement on a certain wiki

2016-08-24 Thread Smalyshev 
Smalyshev added a comment.
This works:

SELECT * WHERE {
 ?link schema:about ?item .
 ?link schema:isPartOf  .
 FILTER NOT EXISTS {
   ?item ?p [] .
   FILTER(?p != rdfs:label && ?p != schema:description && ?p != schema:version && ?p != schema:dateModified && ?p != skos:altLabel)
 }
} LIMIT 100

But unfortunately will time out without a limit, since there's more than 400K of those and the full query would time out.TASK DETAILhttps://phabricator.wikimedia.org/T129037EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Nikki, Sjoerddebruin, hoo, Aklapper, Multichill, mschwarzer, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs