Difference between revisions of "Project:Adtech/Cleanup"

From Wikibase Personal data
Jump to navigation Jump to search
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{SPARQL|label=adtech companies with concern adtech
+
{{Project:Adtech/Cleanup/Template|basis=pdiot:P3 pdio:Q110|extra=pdiot:P110 pdio:Q107|basis_label=instance of - adtech company|extra_label=concern - adtech}}
|query=SELECT ?item WHERE  
+
 
 +
{{Project:Adtech/Cleanup/Template|basis=pdiot:P3 pdio:Q110|extra=pdiot:P110 pdio:Q107|basis_label=instance of - adtech company|extra_label=concern - adtech}}
 +
 
 +
{{Project:Adtech/Cleanup/Template|basis=pdiot:P3 pdio:Q110|extra=pdiot:P3 pdio:Q64|basis_label=instance of - adtech company|extra_label=instance of - company}}
 +
 
 +
{{Project:Adtech/Cleanup/Template|basis=pdiot:P3 pdio:Q834|extra=pdiot:P110 pdio:Q107|basis_label=instance of - adtech product|extra_label=concern - adtech}}
 +
 
 +
{{Project:Adtech/Cleanup/Template|basis=pdiot:P3 ?class. VALUES ?class {pdio:Q834 pdio:Q110}|extra=pdiot:P110 pdio:Q107|basis_label=instance of - adtech product or company|extra_label=concern - adtech}}
 +
 
 +
{{SPARQL|query=SELECT ?item ?itemLabel ?class ?classLabel ?pred WHERE
 
{
 
{
   ?item pdiot:P3 pdio:Q110.      # instance of - adtech company
+
   ?item pdiot:P3 ?class. VALUES ?class {pdio:Q834 pdio:Q110}.      # instance of - adtech product or company
   ?item pdiot:P110 pdio:Q117.    # concern - adtech
+
   OPTIONAL {
 +
      ?item ?pred pdio:Q107.    # concern - adtech
 +
  }.
 +
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 
}
 
}
}}
 
 
{{Project:Adtech/Cleanup/Template|basis=pdiot:P3 pdio:Q110
 
|extra=pdiot:P110 pdio:Q117
 
|basis_label=instance of - adtech company
 
|extra_label=concern - adtech
 
 
}}
 
}}

Latest revision as of 20:54, 6 January 2020

PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 pdio:Q110.      # instance of - adtech company
   ?item pdiot:P110 pdio:Q107.    # concern - adtech
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech company AND concern - adtech (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 pdio:Q110.      # instance of - adtech company
   MINUS {
       ?item pdiot:P110 pdio:Q107.    # concern - adtech
   }.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech company MINUS concern - adtech (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 pdio:Q110.      # instance of - adtech company
   ?item pdiot:P110 pdio:Q107.    # concern - adtech
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech company AND concern - adtech (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 pdio:Q110.      # instance of - adtech company
   MINUS {
       ?item pdiot:P110 pdio:Q107.    # concern - adtech
   }.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech company MINUS concern - adtech (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 pdio:Q110.      # instance of - adtech company
   ?item pdiot:P3 pdio:Q64.    # instance of - company
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech company AND instance of - company (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 pdio:Q110.      # instance of - adtech company
   MINUS {
       ?item pdiot:P3 pdio:Q64.    # instance of - company
   }.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech company MINUS instance of - company (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 pdio:Q834.      # instance of - adtech product
   ?item pdiot:P110 pdio:Q107.    # concern - adtech
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech product AND concern - adtech (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 pdio:Q834.      # instance of - adtech product
   MINUS {
       ?item pdiot:P110 pdio:Q107.    # concern - adtech
   }.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech product MINUS concern - adtech (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 ?class. VALUES ?class {pdio:Q834 pdio:Q110}.      # instance of - adtech product or company
   ?item pdiot:P110 pdio:Q107.    # concern - adtech
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech product or company AND concern - adtech (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel WHERE
{
   ?item pdiot:P3 ?class. VALUES ?class {pdio:Q834 pdio:Q110}.      # instance of - adtech product or company
   MINUS {
       ?item pdiot:P110 pdio:Q107.    # concern - adtech
   }.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

instance of - adtech product or company MINUS concern - adtech (embedded)


PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel ?class ?classLabel ?pred WHERE
{
   ?item pdiot:P3 ?class. VALUES ?class {pdio:Q834 pdio:Q110}.      # instance of - adtech product or company
   OPTIONAL {
       ?item ?pred pdio:Q107.    # concern - adtech
   }.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it (embedded)