User:YULdigitalpreservation/moreSPARQL

Edition or translation of usage for operating systemsEdit

The following query uses these:

Items that have a FFWid and no other statementsEdit

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". }
    }
    

Software titles and their fandom idsEdit

The following query uses these:

essoteric programming languagesEdit

The following query uses these:

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

sdksEdit

The following query uses these:

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

based on MarkdownEdit

The following query uses these:

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

member of NSCAIEdit

The following query uses these:

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

member of NSCAI and employerEdit

The following query uses these:

  • 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". }
    }
    

members of NSCAI and where they were educatedEdit

The following query uses these:

  • 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". }
    }
    

Companies Y Combinator has invested inEdit

The following query uses these:

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

Bubble chart showing count of readable ffEdit

The following query uses these:

Easter eggsEdit

The following query uses these:

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

Devs of software who have Know Your Meme idsEdit

The following query uses these:

File formats w Wolfram Lang code IDEdit

The following query uses these:

ITU-T recommendationsEdit

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". }
    }
    

File formats with colons in themEdit

The following query uses these:

File formats with symbolsEdit

The following query uses these:

  • 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". }
    }
    

file formats based on other formatsEdit

The following query uses these:

list of all language codes used in WMF projectsEdit

The following query uses these:

  • 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". }
    }
    

members of OPF, countries, langs and lang codesEdit

The following query uses these:

members of DPC, countries, langs, lang codesEdit

The following query uses these:

members of CVE numbering authorities groupEdit

The following query uses these:

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

map plotted w HQ locations of CVE numbering authoritiesEdit

The following query uses these:

key value databasesEdit

The following query uses these:

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

Sites described by DowndetectorEdit

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". }
    }
    

Inductees Internet Hall of FameEdit

The following query uses these:

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

File formats w link to standardEdit

The following query uses these:

award recd sloan fellowshipEdit

The following query uses these:

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

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

The following query uses these:

  • 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". }
    }
    

American Football players who also have other employersEdit

The following query uses these:

  • 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". }
    }
    

FFID patterns and encoding qualsEdit

The following query uses these:

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

The following query uses these:

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

The following query uses these:

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

The following query uses these:

  • 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". }
    }
    

Companies owned by Baidu using property pathsEdit

The following query uses these:

File formats developed by Corel w PUIDEdit

The following query uses these:

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

The following query uses these:

Software w CVE infoEdit

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 bodiesEdit

The following query uses these:

Expansion packs and their seriesEdit

The following query uses these:

  • 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". }
    }
    

Projects w Sloan Grants DB idEdit

The following query uses these:

webcam urlEdit

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". }
    }
    

Count of statements on patentsEdit

The following query uses these:

  • 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". }
    }
    

Software w patentEdit

The following query uses these:

What categories of things have patent ids currentlyEdit

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". }
    }
    

Browser extensionsEdit

The following query uses these:

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

Mod ofEdit

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". }
    }
    

Old Computers idEdit

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". }
    }
    

uses of programmerEdit

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". }
    }
    

block sizeEdit

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". }
    }
    

lunar roverEdit

The following query uses these:

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

Orgs that are members of the Bytecode AllianceEdit

The following query uses these:

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

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

The following query uses these:

  • 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". }
    }
    

List of ff items with multiple puids rankedEdit

The following query uses these:

  • Properties: PRONOM file format identifier (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)
    

Software that can read tiff and the formats they can writeEdit

The following query uses these:

string search for file extensionEdit

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". }
    }
    

applications by date optional user manualEdit

The following query uses these:

Readable file formats for presentation software titles w extensionEdit

The following query uses these:

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

The following query uses these:

Software categoriesEdit

The following query uses these:

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

Items with a file extension and any alternate labelsEdit

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". }
    }
    

usage of curator emeritusEdit

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". }
    }