Difference between revisions of "Project:Adtech/Cleanup"

From Wikibase Personal data
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 8: Line 8:
  
 
{{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}}
 
{{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 ?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". }
 +
}
 +
}}

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)