User:YULdigitalpreservation/moreSPARQL

Edition or translation of usage for operating systems

The following query uses these:

• Items: operating system (Q9135)   

• Properties: instance of (P31)   , edition or translation of (P629)   

  SELECT ?item ?itemLabel ?of ?ofLabel
  WHERE 
  {
    ?item wdt:P31 wd:Q9135.
    ?item wdt:P629 ?of.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have a FFWid and no other statements

The following query uses these:

• Properties: File Format Wiki page ID (P3381)   

  SELECT ?item ?itemLabel ?value 
  {
    {
         SELECT *
         {
            ?item wdt:P3381 ?value ; wikibase:statements 1
         }
    }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software titles and their fandom ids

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , Fandom wiki ID (P4073)   

  SELECT ?item ?itemLabel ?fandomId
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P4073 ?fandomId.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

essoteric programming languages

The following query uses these:

• Items: esoteric programming language (Q610140)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q610140.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

sdks

The following query uses these:

• Items: software development kit (Q467707)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q467707.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

based on Markdown

The following query uses these:

• Items: Markdown (Q1193600)   

• Properties: based on (P144)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P144 wd:Q1193600.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

member of NSCAI

The following query uses these:

• Items: National Security Commission on Artificial Intelligence (Q66087960)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q66087960.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

member of NSCAI and employer

The following query uses these:

• Items: National Security Commission on Artificial Intelligence (Q66087960)   

• Properties: member of (P463)   , employer (P108)   

  SELECT ?item ?itemLabel ?employer ?employerLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q66087960.
    ?item wdt:P108 ?employer.
    
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

members of NSCAI and where they were educated

The following query uses these:

• Items: National Security Commission on Artificial Intelligence (Q66087960)   

• Properties: member of (P463)   , educated at (P69)   

  SELECT ?item ?itemLabel ?inst ?instLabel
  WHERE 
  {
    ?item wdt:P463 wd:Q66087960.
    ?item wdt:P69 ?inst.
    
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Companies Y Combinator has invested in

The following query uses these:

• Items: Y Combinator (Q2616400)   

• Properties: investor (P1951)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P1951 wd:Q2616400.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Bubble chart showing count of readable ff

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , readable file format (P1072)   

  SELECT ?item ?itemLabel (COUNT(?format) as ?count)
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P1072 ?format.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?item ?itemLabel
  
  ORDER BY DESC(?count)
  

Try it!

Easter eggs

The following query uses these:

• Items: Easter egg (Q330574)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q330574.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Devs of software who have Know Your Meme ids

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , developer (P178)   , Know Your Meme ID (P6760)   

  SELECT DISTINCT  ?dev ?devLabel ?id
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P178 ?dev.
    ?dev wdt:P6760 ?id.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

File formats w Wolfram Lang code ID

The following query uses these:

• Items: file format (Q235557)   

• Properties: instance of (P31)   , subclass of (P279)   , Wolfram Language entity code (P4839)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q235557.
    ?item wdt:P4839 ?value
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

ITU-T recommendations

The following query uses these:

• Properties: ITU-T Recommendation (P5688)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P5688 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

File formats with colons in them

The following query uses these:

• Items: file format (Q235557)   

• Properties: instance of (P31)   , subclass of (P279)   , file extension (P1195)   

  SELECT DISTINCT ?format ?formatLabel ?ext 
  WHERE {
    ?format (wdt:P31/wdt:P279*) wd:Q235557.
    ?format wdt:P1195 ?ext.
     FILTER(REGEX(?ext, ":", "i")).
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

File formats with symbols

The following query uses these:

• Items: file format (Q235557)   

• Properties: instance of (P31)   , subclass of (P279)   , file extension (P1195)   

  SELECT DISTINCT ?format ?formatLabel ?ext 
  WHERE {
    ?format (wdt:P31/wdt:P279*) wd:Q235557.
    ?format wdt:P1195 ?ext.
     FILTER(REGEX(?ext, "[:!@#$%^&]", "i")).
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

file formats based on other formats

The following query uses these:

• Items: file format (Q235557)   

• Properties: instance of (P31)   , subclass of (P279)   , based on (P144)   

  SELECT ?item ?itemLabel ?format ?formatLabel
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q235557.
    ?item wdt:P144 ?format.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

list of all language codes used in WMF projects

The following query uses these:

• Items: Wikimedia projects (Q14827288)   , Wikimedia internal item (Q17442446)   

• Properties: Wikimedia language code (P424)   , instance of (P31)   , subclass of (P279)   

  SELECT ?item ?itemLabel ?c
  (CONCAT("{","{#language:",?c,"}","}") as ?display)
  
  {
    ?item wdt:P424 ?c .
    MINUS{?item wdt:P31/wdt:P279* wd:Q14827288} #exclude Wikimedia projects
    MINUS{?item wdt:P31/wdt:P279* wd:Q17442446} #exclude Wikimedia internal stuff
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

members of OPF, countries, langs and lang codes

The following query uses these:

• Items: Open Preservation Foundation (Q27981723)   

• Properties: member of (P463)   , country (P17)   , official language (P37)   , Wikimedia language code (P424)   

  SELECT ?member ?memberLabel ?country ?countryLabel ?lang ?langLabel ?code ?codeLabel
  
  WHERE {
     	?member	wdt:P463 wd:Q27981723 .
      ?member wdt:P17 ?country.
      ?country wdt:P37 ?lang. 
      ?lang wdt:P424 ?code.
              
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
      
  }
    }
  

Try it!

members of DPC, countries, langs, lang codes

The following query uses these:

• Items: Digital Preservation Coalition (Q5275956)   

• Properties: member of (P463)   , country (P17)   , official language (P37)   , Wikimedia language code (P424)   

  SELECT ?member ?memberLabel ?country ?countryLabel ?lang ?langLabel ?code ?codeLabel
  
  WHERE {
     	?member	wdt:P463 wd:Q5275956.
      ?member wdt:P17 ?country.
      ?country wdt:P37 ?lang. 
      ?lang wdt:P424 ?code.
              
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
      
  
    }
  

Try it!

members of CVE numbering authorities group

The following query uses these:

• Items: CVE Numbering Authority (Q67904121)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q67904121.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

map plotted w HQ locations of CVE numbering authorities

The following query uses these:

• Items: CVE Numbering Authority (Q67904121)   

• Properties: member of (P463)   , headquarters location (P159)   , coordinate location (P625)   

  SELECT ?item ?itemLabel ?coords
  WHERE 
  {
    ?item wdt:P463 wd:Q67904121.
    ?item wdt:P159 ?hq.
    ?hq wdt:P625 ?coords.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

key value databases

The following query uses these:

• Items: key–value database (Q20706915)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q20706915.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Sites described by Downdetector

The following query uses these:

• Properties: Downdetector ID (P7306)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P7306 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Inductees Internet Hall of Fame

The following query uses these:

• Items: Internet Hall of Fame (Q6055547)   

• Properties: award received (P166)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P166 wd:Q6055547.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

File formats w link to standard

The following query uses these:

• Items: file format (Q235557)   , technical standard (Q317623)   

• Properties: subclass of (P279)   , ISO standard (P503)   , described by source (P1343)   , instance of (P31)   , standards body (P1462)   

  SELECT ?format ?formatLabel ?standardLabel ?sourceLabel ?bodyLabel
  WHERE 
  {
    
     { ?format  (p:P31/ps:P31/wdt:P279*) wd:Q235557 .
    ?format wdt:P503 ?standard.}
    UNION 
    {?format  (p:P31/ps:P31/wdt:P279*) wd:Q235557 .
    ?format wdt:P1343 ?source.
    ?source wdt:P31 wd:Q317623.}
    OPTIONAL {?source wdt:P1462 ?body.}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

award recd sloan fellowship

The following query uses these:

• Items: Sloan Fellowship (Q7541057)   

• Properties: award received (P166)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
     ?item wdt:P166 wd:Q7541057.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Timeline of founding dates of orgs/ companies that are members of the Linux FOundation

The following query uses these:

• Items: Linux Foundation (Q858851)   

• Properties: member of (P463)   , inception (P571)   

  #defaultView:Timeline
  SELECT ?item ?itemLabel ?date
  WHERE 
  {
    ?item wdt:P463 wd:Q858851.
    ?item wdt:P571 ?date.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

American Football players who also have other employers

The following query uses these:

• Items: American football player (Q19204627)   

• Properties: occupation (P106)   , employer (P108)   

  SELECT ?item ?itemLabel ?emp ?empLabel
  WHERE 
  {
    ?item wdt:P106 wd:Q19204627.
    ?item wdt:P108 ?emp.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

FFID patterns and encoding quals

The following query uses these:

• Properties: file format identification pattern (P4152)   , encoding (P3294)   

  SELECT ?item ?itemLabel ?pattern ?encodingLabel
  WHERE 
  {
    ?item wdt:P4152 ?pattern;
          p:P4152 [pq:P3294 ?encoding].
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items with IMDB id where a main subject is a one-of-akind computer

The following query uses these:

• Items: one-of-a-kind computer (Q28542014)   

• Properties: IMDb ID (P345)   , main subject (P921)   , instance of (P31)   

  SELECT ?item ?itemLabel ?subjectLabel 
  WHERE 
  {
    ?item wdt:P345 ?imdb.
    ?item wdt:P921 ?subject. 
    ?subject wdt:P31 wd:Q28542014.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items with IMDB id where a main subject is a software title

The following query uses these:

• Items: software (Q7397)   

• Properties: IMDb ID (P345)   , main subject (P921)   , instance of (P31)   , subclass of (P279)   

  SELECT ?item ?itemLabel ?subjectLabel 
  WHERE 
  {
    ?item wdt:P345 ?imdb.
    ?item wdt:P921 ?subject. 
    ?subject wdt:P31 ?software. 
    ?software wdt:P31/wdt:P279* wd:Q7397.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Participants of the Dartmouth Summer Research Project on AI with optional date of passing

The following query uses these:

• Items: Dartmouth workshop (Q2453355)   

• Properties: participant in (P1344)   , date of death (P570)   

  SELECT ?item ?itemLabel ?date
  WHERE 
  {
    ?item wdt:P1344 wd:Q2453355.
    OPTIONAL {?item wdt:P570 ?date. }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Companies owned by Baidu using property paths

The following query uses these:

• Properties: parent organization (P749)   

  SELECT DISTINCT ?item ?itemLabel 
  WHERE 
  {
    {?item (wdt:P749
  

Try it!

File formats developed by Corel w PUID

The following query uses these:

• Items: file format (Q235557)   , Alludo (Q835702)   

• Properties: instance of (P31)   , developer (P178)   , PRONOM file format ID (P2748)   

  SELECT ?item ?itemLabel ?puid
  WHERE 
  {
    ?item wdt:P31 wd:Q235557.
    ?item wdt:P178 wd:Q835702.
    ?item wdt:P2748 ?puid.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software that lists a file format family as a readable format, and formats that are subclasses of those families

The following query uses these:

• Items: file format family (Q26085352)   

• Properties: readable file format (P1072)   , instance of (P31)   , subclass of (P279)   

  SELECT DISTINCT ?software ?softwareLabel ?family ?familyLabel ?format ?formatLabel
  WHERE 
  {
    ?software wdt:P1072 ?family. 
    ?family wdt:P31 wd:Q26085352.
    ?format wdt:P279 ?family.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software w CVE info

SELECT ?item ?itemLabel ?id
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q7397.
  ?item wdt:P3587 ?id.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Ast bodies orbiting sun and their child ast bodies

The following query uses these:

• Items: Sun (Q525)   

• Properties: parent astronomical body (P397)   , child astronomical body (P398)   

  SELECT ?item ?itemLabel ?moon ?moonLabel
  WHERE 
  {
    ?item wdt:P397 wd:Q525.
    ?item wdt:P398 ?moon.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Expansion packs and their series

The following query uses these:

• Items: expansion pack (Q209163)   

• Properties: instance of (P31)   , part of the series (P179)   

  SELECT ?item ?itemLabel ?series ?seriesLabel
  WHERE 
  {
    ?item wdt:P31 wd:Q209163.
    ?item wdt:P179 ?series.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Projects w Sloan Grants DB id

The following query uses these:

• Properties: Alfred P. Sloan Foundation grant ID (P7513)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P7513 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

webcam url

The following query uses these:

• Properties: webcam page URL (P4238)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P4238 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Count of statements on patents

The following query uses these:

• Items: patent (Q253623)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel ?statementscount WHERE {
    ?item wdt:P31 wd:Q253623;
      wikibase:statements ?statementscount.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software w patent

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , patent number (P1246)   

  SELECT ?item ?itemLabel ?patent
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P1246 ?patent.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

What categories of things have patent ids currently

The following query uses these:

• Properties: instance of (P31)   , patent number (P1246)   

  SELECT DISTINCT ?thing ?thingLabel 
  WHERE 
  {
    ?item wdt:P31 ?thing.
    ?item wdt:P1246 ?patent.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Browser extensions

The following query uses these:

• Items: browser extension (Q874411)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q874411.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Mod of

The following query uses these:

• Properties: mod of (P7075)   

  SELECT ?item ?itemLabel ?value ?valueLabel
  WHERE 
  {
    ?item wdt:P7075 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Old Computers id

The following query uses these:

• Properties: old-computers.com ID (P5936)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P5936 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

uses of programmer

The following query uses these:

• Properties: programmer (P943)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P943 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

block size

The following query uses these:

• Properties: block size (P2599)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P2599 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

lunar rover

The following query uses these:

• Items: lunar rover (Q1007767)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q1007767.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Orgs that are members of the Bytecode Alliance

The following query uses these:

• Items: Bytecode Alliance (Q75097496)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q75097496.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Orgs that are members of the Bytecode Alliance and CVE Numbering Authorities

The following query uses these:

• Items: Bytecode Alliance (Q75097496)   , CVE Numbering Authority (Q67904121)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q75097496.
    ?item wdt:P463 wd:Q67904121.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

List of ff items with multiple puids ranked

The following query uses these:

• Properties: PRONOM file format ID (P2748)   

  SELECT ?item ?itemLabel (COUNT(?puid) AS ?count)
  WHERE 
  {
    ?item wdt:P2748 ?puid.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?item ?itemLabel
  ORDER BY DESC (?count)
  

Try it!

Software that can read tiff and the formats they can write

The following query uses these:

• Items: TIFF (Q215106)   

• Properties: readable file format (P1072)   , writable file format (P1073)   

  SELECT ?canRead ?canReadLabel ?canWriteLabel
  WHERE 
  {
    ?canRead wdt:P1072 wd:Q215106.
    ?canRead wdt:P1073 ?canWriteLabel.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

string search for file extension

The following query uses these:

• Properties: file extension (P1195)   

  SELECT DISTINCT ?files ?filesLabel ?extension WHERE {
    ?files wdt:P1195 ?extension.
    FILTER(CONTAINS(?extension, "v"))
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

applications by date optional user manual

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , inception (P571)   , user manual URL (P2078)   

  SELECT DISTINCT ?app ?appLabel ?date ?manual
  WHERE {
    ?app wdt:P31/wdt:P279* wd:Q7397.
    ?app wdt:P571 ?date.
   OPTIONAL { ?app wdt:P2078 ?manual.}
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Readable file formats for presentation software titles w extension

The following query uses these:

• Items: presentation program (Q2115026)   

• Properties: instance of (P31)   , subclass of (P279)   , has use (P366)   , readable file format (P1072)   , file extension (P1195)   

  SELECT DISTINCT ?format ?formatLabel ?ext
  WHERE 
  {
    {?item wdt:P31/wdt:P279* wd:Q2115026.}
    UNION {?item wdt:P366 wd:Q2115026.}
    ?item wdt:P1072 ?format.
    OPTIONAL {?format wdt:P1195 ?ext.}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Readable file formats for presentation software titles w extension puid and fdd

The following query uses these:

• Items: presentation program (Q2115026)   

• Properties: instance of (P31)   , subclass of (P279)   , has use (P366)   , readable file format (P1072)   , file extension (P1195)   , PRONOM file format ID (P2748)   , Library of Congress Format Description Document ID (P3266)   

  SELECT DISTINCT ?format ?formatLabel ?ext ?puid ?fdd
  WHERE 
  {
    {?item wdt:P31/wdt:P279* wd:Q2115026.}
    UNION {?item wdt:P366 wd:Q2115026.}
    ?item wdt:P1072 ?format.
    OPTIONAL {?format wdt:P1195 ?ext.}
     OPTIONAL {?format wdt:P2748 ?puid.}
     OPTIONAL {?format wdt:P3266 ?fdd.}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software categories

The following query uses these:

• Items: software category (Q17155032)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q17155032.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items with a file extension and any alternate labels

The following query uses these:

• Properties: file extension (P1195)   

  SELECT ?item ?itemLabel ?itemAltLabel ?ext
  WHERE 
  {
    ?item wdt:P1195 ?ext.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

usage of curator emeritus

The following query uses these:

• Items: curator emeritus (Q76756718)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item ?p wd:Q76756718.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!