[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-24 Thread Salgo60 
Salgo60 added a comment.
List Contemporary constraint check errors  http://tinyurl.com/y8pjk5ux

SELECT DISTINCT ?item ?itemLabel WHERE {
	?statement wikibase:hasViolationForConstraint wds:P27-ad2c85a5-49ba-6748-4302-77b44a268ed5 .
	?item ?p ?statement .
	FILTER( ?item NOT IN ( wd:Q4115189, wd:Q13406268, wd:Q15397819 ) ) .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, Salgo60Cc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-24 Thread Lucas_Werkmeister_WMDE 
Lucas_Werkmeister_WMDE added a comment.

In T141859#4595822, @Lydia_Pintscher wrote:
Is there a place already where I can see it working?


I updated wikidata-constraints as well, but it’s probably easiest to test it on Wikidata with @abian’s example item.TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, Lucas_Werkmeister_WMDECc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-21 Thread Salgo60 
Salgo60 added a comment.
Ok ping @Ivan_A_KrestininTASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, Salgo60Cc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-20 Thread abian 
abian added a comment.

In T141859#4603658, @Salgo60 wrote:
Wikidata:Database_reports/Constraint_violations/P27 reports

ERROR: Unknown constraint type: Q25796498.


Right, that's a bug in KrBot2. Only its operator has access to the source code, so we sadly can't contribute to it.TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abianCc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-20 Thread Salgo60 
Salgo60 added a comment.
Wikidata:Database_reports/Constraint_violations/P27 reports

ERROR: Unknown constraint type: Q25796498.TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, Salgo60Cc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Re: [Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task]Contemporary constraint check

2018-09-20 Thread 80hnhtv4agou 

IP’s are not aloud to fix anything, we are people too.
 
From: abian
Sent: Thursday, September 20, 2018 8:59 AM
To: wikidata-bugs@lists.wikimedia.org
Subject: [Wikidata-bugs] [Maniphest] [Commented On] T141859: 
[Task]Contemporary constraint check
 
abian added a comment. 
Now deployed on Wikidata. You can find a violation on  
http://www.wikidata.org/entity/Q628365 ... until someone fixes 
it.
 
TASK DETAIL
https://phabricator.wikimedia.org/T141859
 
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
 
To:  abian
Cc:  gerritbot, Salgo60, 
Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, 
Wikibase-Quality-Constraints, abian, Aklapper, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, 
Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, 
Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, 
Wikidata-bugs, aude, Mbch331
--
___
Wikidata-bugs mailing 
list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-20 Thread abian 
abian added a comment.
Now deployed on Wikidata. You can find a violation on http://www.wikidata.org/entity/Q628365... until someone fixes it.TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abianCc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-19 Thread abian 
abian added a comment.

In T141859#4595822, @Lydia_Pintscher wrote:
Is there a place already where I can see it working?


I see WikibaseQualityConstraints is already updated on https://test.wikidata.org/, but maybe the config variables of the contemporary constraint should still be set. Otherwise, https://wikidata-constraints.wmflabs.org/ should be updated before defining these config variables.TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abianCc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-18 Thread Lydia_Pintscher 
Lydia_Pintscher added a comment.
Is there a place already where I can see it working?TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, Lydia_PintscherCc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-10 Thread gerritbot 
gerritbot added a comment.
Change 458522 merged by jenkins-bot:
[mediawiki/extensions/WikibaseQualityConstraints@master] Implement contemporary constraint check

https://gerrit.wikimedia.org/r/458522TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, gerritbotCc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-09-06 Thread gerritbot 
gerritbot added a comment.
Change 458522 had a related patch set uploaded (by Abián; owner: Abián):
[mediawiki/extensions/WikibaseQualityConstraints@master] Implement contemporary constraint check

https://gerrit.wikimedia.org/r/458522TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, gerritbotCc: gerritbot, Salgo60, Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary constraint check

2018-02-02 Thread abian 
abian added a comment.
Update: I have finished formalizing this constraint as a part of my final degree project, and I will start implementing it at some point in the coming weeks so that this can be finished around May. I will keep you informed. :-)TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abianCc: Jklamo, Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Agabi10, Wikidata-bugs, aude, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary Constraint check

2017-08-25 Thread abian 
abian added a comment.
Do we actually have an efficient way to find subproperties of a property without using the query service?

No idea. But couldn't we retrieve those subproperties asynchronously, from time to time? They aren't expected to change very often.TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abianCc: Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, GoranSMilovanovic, Soteriaspace, JakeTheDeveloper, QZanden, Agabi10, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary Constraint check

2017-08-25 Thread Lucas_Werkmeister_WMDE 
Lucas_Werkmeister_WMDE added a comment.
Okay, those are some good points :) I’m still skeptical about one thing:

An algorithm that gives us the same outputs as another in almost the same time

Do we actually have an efficient way to find subproperties of a property without using the query service? Because finding the subproperties via SPARQL seems to take about 80 ms from within the Eqiad cluster (tested from a Cloud VPS server), which isn’t that cheap IMHO. Is there something within Wikibase to find statements with a particular value? (Special:WhatLinksHere, I suppose…)TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, Lucas_Werkmeister_WMDECc: Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, GoranSMilovanovic, Soteriaspace, JakeTheDeveloper, QZanden, Agabi10, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary Constraint check

2017-08-24 Thread abian 
abian added a comment.

In T141859#3549363, @Lucas_Werkmeister_WMDE wrote:
(Aside: that first query should probably include “work period (start)”. It seems to be missing a P​279 statement.)

I’m not convinced that this is the best approach. Do we really need all the properties for every constraint? I feel like it might make more sense to define the properties to be used on the constraint, and to limit them to a smaller set: for instance, perhaps a contemporary constraint check for “spouse” should only take into account “date of birth” and “date of death”, not “service entry” or “date of official closure”.


Indeed, but, on the one hand, this constraint is applied to many different properties, even P31 and P279. On the other hand, I see no undesirable effects when considering more subproperties than necessary if the difference in computational cost is negligible (no idea for now, but it shouldn't be huge). By defining what subproperties should be considered for the constraint for each property, we are also introducing redundancies and potential inconsistencies with other constraints, mainly with conflicts-with constraint, apart from all the problems mentioned above.

An algorithm that gives us the same outputs as another in almost the same time and with fewer inputs is a better algorithm. If the difference in computational cost wasn't relevant here (no idea if it will finally be or not) and, in addition, the algorithm with more inputs (qualifiers) brings us all the considered problems, I have clear which is the best option.

But consensus should decide, not my point of view... 😇TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abianCc: Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, GoranSMilovanovic, Soteriaspace, JakeTheDeveloper, QZanden, Agabi10, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary Constraint check

2017-08-24 Thread Lucas_Werkmeister_WMDE 
Lucas_Werkmeister_WMDE added a comment.
(Aside: that first query should probably include “work period (start)”. It seems to be lacking a P​279 statement.)

I’m not convinced that this is the best approach. Do we really need all the properties for every constraint? I feel like it might make more sense to define the properties to be used on the constraint, and to limit them to a smaller set: for instance, perhaps a contemporary constraint check for “spouse” should only take into account “date of birth” and “date of death”, not “service entry” or “date of official closure”.TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, Lucas_Werkmeister_WMDECc: Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, GoranSMilovanovic, Soteriaspace, JakeTheDeveloper, QZanden, Agabi10, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary Constraint check

2017-08-23 Thread Ivan_A_Krestinin 
Ivan_A_Krestinin added a comment.
All other constraints store settings as qualifiers on property page. I think it is good practice make all constraints as similar as possible. This makes implementation and understanding of full constraints system easier.TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abian, Ivan_A_KrestininCc: Ivan_A_Krestinin, PokestarFan, Lucas_Werkmeister_WMDE, Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, GoranSMilovanovic, Soteriaspace, JakeTheDeveloper, QZanden, Agabi10, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary Constraint check

2016-09-12 Thread abian 
abian added a comment.
This task was added to #Need-volunteer. Could I help with it in some way?TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: abianCc: Lydia_Pintscher, Wikibase-Quality-Constraints, abian, Aklapper, D3r1ck01, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T141859: [Task] Contemporary Constraint check

2016-09-02 Thread abian 
abian added a comment.
Example of query that detects Constraint:Contemporary violations:

SELECT ?subject ?value
WHERE {
  ?subject wdt:P${THEPROPERTY} ?value .
  OPTIONAL { ?subject p:P569/psv:P569 [ wikibase:timeValue ?subject_birth ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?value p:P569/psv:P569 [ wikibase:timeValue ?value_birth ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?subject p:P571/psv:P571 [ wikibase:timeValue ?subject_inception ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?value p:P571/psv:P571 [ wikibase:timeValue ?value_inception ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?subject p:P580/psv:P580 [ wikibase:timeValue ?subject_start ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?value p:P580/psv:P580 [ wikibase:timeValue ?value_start ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?subject p:P570/psv:P570 [ wikibase:timeValue ?subject_death ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?value p:P570/psv:P570 [ wikibase:timeValue ?value_death ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?subject p:P576/psv:P576 [ wikibase:timeValue ?subject_dissolution ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?value p:P576/psv:P576 [ wikibase:timeValue ?value_dissolution ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?subject p:P582/psv:P582 [ wikibase:timeValue ?subject_end ; wikibase:timePrecision "11"^^xsd:integer ] . }
  OPTIONAL { ?value p:P582/psv:P582 [ wikibase:timeValue ?value_end ; wikibase:timePrecision "11"^^xsd:integer ] . }
  FILTER (
(
  !BOUND(?subject_birth) ||
  (
(
  !BOUND(?value_death) ||
  ?subject_birth>?value_death
) &&
(
  !BOUND(?value_dissolution) ||
  ?subject_birth>?value_dissolution
) &&
(
  !BOUND(?value_end) ||
  ?subject_birth>?value_end
)
  )
) &&
(
  !BOUND(?value_birth) ||
  (
(
  !BOUND(?subject_death) || 
  ?value_birth>?subject_death
) &&
(
  !BOUND(?subject_dissolution) || 
  ?value_birth>?subject_dissolution
) &&
(
  !BOUND(?subject_end) || 
  ?value_birth>?subject_end
)
  )
) && 
(
  !BOUND(?subject_inception) ||
  (
(
  !BOUND(?value_death) || 
  ?subject_inception>?value_death
) &&
(
  !BOUND(?value_dissolution) || 
  ?subject_inception>?value_dissolution
) &&
(
  !BOUND(?value_end) || 
  ?subject_inception>?value_end
)
  )
) && 
(
  !BOUND(?value_inception) || 
  (
(
  !BOUND(?subject_death) || 
  ?value_inception>?subject_death
) &&
(
  !BOUND(?subject_dissolution) || 
  ?value_inception>?subject_dissolution
) &&
(
  !BOUND(?subject_end) || 
  ?value_inception>?subject_end
)
  )
) && 
(
  !BOUND(?subject_start) || 
  (
(
  !BOUND(?value_death) || 
  ?subject_start>?value_death
) &&
(
  !BOUND(?value_dissolution) || 
  ?subject_start>?value_dissolution
) &&
(
  !BOUND(?value_end) || 
  ?subject_start>?value_end
)
  )
) && 
(
  !BOUND(?value_start) || 
  (
(
  !BOUND(?subject_death) || 
  ?value_start>?subject_death
) &&
(
  !BOUND(?subject_dissolution) || 
  ?value_start>?subject_dissolution
) &&
(
  !BOUND(?subject_end) || 
  ?value_start>?subject_end
)
  )
) && 
( 
  ( 
BOUND(?subject_birth) && 
( 
  BOUND(?value_death) || 
  BOUND(?value_dissolution) || 
  BOUND(?value_end) 
)
  ) || 
  ( 
BOUND(?value_birth) && 
( 
  BOUND(?subject_death) || 
  BOUND(?subject_dissolution) ||
  BOUND(?subject_end) 
)
  ) || 
  ( 
BOUND(?subject_inception) && 
( 
  BOUND(?value_death) || 
  BOUND(?value_dissolution) || 
  BOUND(?value_end) 
)
  ) || 
  ( 
BOUND(?value_inception) &&
( 
  BOUND(?subject_death) ||
  BOUND(?subject_dissolution) ||
  BOUND(?subject_end) 
)
  ) ||
  ( 
BOUND(?subject_start) &&
( 
  BOUND(?value_death) ||
  BOUND(?value_dissolution) ||
  BOUND(?value_end) 
)
  ) ||
  ( 
BOUND(?value_start) &&
( 
  BOUND(?subject_death) ||
  BOUND(?subject_dissolution) ||
  BOUND(?subject_end) 
)
  )
)
  ) 
} LIMIT 500TASK DETAILhttps://phabricator.wikimedia.org/T141859EMAIL PREFERENC