Open main menu

User:YULdigitalpreservation/moreSPARQL

Contents

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)    
     1 SELECT ?item ?itemLabel ?value 
     2 {
     3   {
     4        SELECT *
     5        {
     6           ?item wdt:P3381 ?value ; wikibase:statements 1
     7        }
     8   }
     9   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    10 }
    

Software titles and their fandom idsEdit

The following query uses these:

essoteric programming languagesEdit

The following query uses these:

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

sdksEdit

The following query uses these:

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

based on MarkdownEdit

The following query uses these:

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

member of NSCAIEdit

The following query uses these:

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

member of NSCAI and employerEdit

The following query uses these:

  • Properties: member of (P463)    , employer (P108)    
    1 SELECT ?item ?itemLabel ?employer ?employerLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P463 wd:Q66087960.
    5   ?item wdt:P108 ?employer.
    6   
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

members of NSCAI and where they were educatedEdit

The following query uses these:

  • Properties: member of (P463)    , educated at (P69)    
    1 SELECT ?item ?itemLabel ?inst ?instLabel
    2 WHERE 
    3 {
    4   ?item wdt:P463 wd:Q66087960.
    5   ?item wdt:P69 ?inst.
    6   
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Companies Y Combinator has invested inEdit

The following query uses these:

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

Bubble chart showing count of readable ffEdit

The following query uses these:

  • Properties: instance of (P31)    , subclass of (P279)    , readable file format (P1072)    
     1 SELECT ?item ?itemLabel (COUNT(?format) as ?count)
     2 WHERE 
     3 {
     4   ?item wdt:P31/wdt:P279* wd:Q7397.
     5   ?item wdt:P1072 ?format.
     6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
     7 }
     8 GROUP BY ?item ?itemLabel
     9 
    10 ORDER BY DESC(?count)
    

Easter eggsEdit

The following query uses these:

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

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)    
    1 SELECT ?item ?itemLabel ?value
    2 WHERE 
    3 {
    4   ?item wdt:P5688 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

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)    
    1 SELECT DISTINCT ?format ?formatLabel ?ext 
    2 WHERE {
    3   ?format (wdt:P31/wdt:P279*) wd:Q235557.
    4   ?format wdt:P1195 ?ext.
    5    FILTER(REGEX(?ext, "[:!@#$%^&]", "i")).
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

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)    
    1 SELECT ?item ?itemLabel ?c
    2 (CONCAT("{","{#language:",?c,"}","}") as ?display)
    3 
    4 {
    5   ?item wdt:P424 ?c .
    6   MINUS{?item wdt:P31/wdt:P279* wd:Q14827288} #exclude Wikimedia projects
    7   MINUS{?item wdt:P31/wdt:P279* wd:Q17442446} #exclude Wikimedia internal stuff
    8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    9 }
    

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)    
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P463 wd:Q67904121.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

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)    
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q20706915.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Sites described by DowndetectorEdit

The following query uses these:

  • Properties: Downdetector ID (P7306)    
    1 SELECT ?item ?itemLabel ?value
    2 WHERE 
    3 {
    4   ?item wdt:P7306 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Inductees Internet Hall of FameEdit

The following query uses these:

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

File formats w link to standardEdit

The following query uses these:

award recd sloan fellowshipEdit

The following query uses these:

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

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)    
    1 #defaultView:Timeline
    2 SELECT ?item ?itemLabel ?date
    3 WHERE 
    4 {
    5   ?item wdt:P463 wd:Q858851.
    6   ?item wdt:P571 ?date.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

American Football players who also have other employersEdit

The following query uses these:

  • Properties: occupation (P106)    , employer (P108)    
    1 SELECT ?item ?itemLabel ?emp ?empLabel
    2 WHERE 
    3 {
    4   ?item wdt:P106 wd:Q19204627.
    5   ?item wdt:P108 ?emp.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

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:

  • Properties: IMDb ID (P345)    , main subject (P921)    , instance of (P31)    
    1 SELECT ?item ?itemLabel ?subjectLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P345 ?imdb.
    5   ?item wdt:P921 ?subject. 
    6   ?subject wdt:P31 wd:Q28542014.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

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 of (P1344)    , date of death (P570)    
    1 SELECT ?item ?itemLabel ?date
    2 WHERE 
    3 {
    4   ?item wdt:P1344 wd:Q2453355.
    5   OPTIONAL {?item wdt:P570 ?date. }
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

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:

  • Properties: readable file format (P1072)    , instance of (P31)    , subclass of (P279)    
    1 SELECT DISTINCT ?software ?softwareLabel ?family ?familyLabel ?format ?formatLabel
    2 WHERE 
    3 {
    4   ?software wdt:P1072 ?family. 
    5   ?family wdt:P31 wd:Q26085352.
    6   ?format wdt:P279 ?family.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

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)    
    1 SELECT ?item ?itemLabel ?series ?seriesLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q209163.
    5   ?item wdt:P179 ?series.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Projects w Sloan Grants DB idEdit

The following query uses these:

webcam urlEdit

The following query uses these:

  • Properties: webcam page URL (P4238)    
    1 SELECT ?item ?itemLabel ?value
    2 WHERE 
    3 {
    4   ?item wdt:P4238 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Count of statements on patentsEdit

The following query uses these:

  • Properties: instance of (P31)    
    1 SELECT ?item ?itemLabel ?statementscount WHERE {
    2   ?item wdt:P31 wd:Q253623;
    3     wikibase:statements ?statementscount.
    4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    5 }
    

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)    
    1 SELECT DISTINCT ?thing ?thingLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31 ?thing.
    5   ?item wdt:P1246 ?patent.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Browser extensionsEdit

The following query uses these:

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

Mod ofEdit

The following query uses these:

  • Properties: mod of (P7075)    
    1 SELECT ?item ?itemLabel ?value ?valueLabel
    2 WHERE 
    3 {
    4   ?item wdt:P7075 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Old Computers idEdit

The following query uses these:

  • Properties: old-computers.com ID (P5936)    
    1 SELECT ?item ?itemLabel ?value
    2 WHERE 
    3 {
    4   ?item wdt:P5936 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

uses of programmerEdit

The following query uses these:

  • Properties: programmer (P943)    
    1 SELECT ?item ?itemLabel ?value
    2 WHERE 
    3 {
    4   ?item wdt:P943 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

block sizeEdit

The following query uses these:

  • Properties: block size (P2599)    
    1 SELECT ?item ?itemLabel ?value
    2 WHERE 
    3 {
    4   ?item wdt:P2599 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

lunar roverEdit

The following query uses these:

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

Orgs that are members of the Bytecode AllianceEdit

The following query uses these:

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

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

The following query uses these:

  • Properties: member of (P463)    
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P463 wd:Q75097496.
    5   ?item wdt:P463 wd:Q67904121.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }