Wikidata

User:YULdigitalpreservation/moreSPARQL

< User:YULdigitalpreservation

Edition or translation of usage for operating systems edit

The following query uses these:

Try it!

Items that have a FFWid and no other statements edit

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 edit

The following query uses these:

Try it!

essoteric programming languages edit

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". }
}
Try it!

sdks edit

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". }
}
Try it!

based on Markdown edit

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". }
}
Try it!

member of NSCAI edit

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". }
}
Try it!

member of NSCAI and employer edit

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". }
}
Try it!

members of NSCAI and where they were educated edit

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". }
}
Try it!

Companies Y Combinator has invested in edit

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". }
}
Try it!

Bubble chart showing count of readable ff edit

The following query uses these:

Try it!

Easter eggs edit

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". }
}
Try it!

Devs of software who have Know Your Meme ids edit

The following query uses these:

Try it!

File formats w Wolfram Lang code ID edit

The following query uses these:

Try it!

ITU-T recommendations edit

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 edit

The following query uses these:

Try it!

File formats with symbols edit

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". }
}
Try it!

file formats based on other formats edit

The following query uses these:

Try it!

list of all language codes used in WMF projects edit

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". }
}
Try it!

members of OPF, countries, langs and lang codes edit

The following query uses these:

Try it!

members of DPC, countries, langs, lang codes edit

The following query uses these:

Try it!

members of CVE numbering authorities group edit

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". }
}
Try it!

map plotted w HQ locations of CVE numbering authorities edit

The following query uses these:

Try it!

key value databases edit

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". }
}
Try it!

Sites described by Downdetector edit

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 edit

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". }
}
Try it!

File formats w link to standard edit

The following query uses these:

Try it!

award recd sloan fellowship edit

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". }
}
Try it!

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

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". }
}
Try it!

American Football players who also have other employers edit

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". }
}
Try it!

FFID patterns and encoding quals edit

The following query uses these:

Try it!

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

The following query uses these:

Try it!

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

The following query uses these:

Try it!

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

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". }
}
Try it!

Companies owned by Baidu using property paths edit

The following query uses these:

Try it!

File formats developed by Corel w PUID edit

The following query uses these:

Try it!

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

The following query uses these:

Try it!

Software w CVE info edit 

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 edit

The following query uses these:

Try it!

Expansion packs and their series edit

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". }
}
Try it!

Projects w Sloan Grants DB id edit

The following query uses these:

Try it!

webcam url edit

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 edit

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". }
}
Try it!

Software w patent edit

The following query uses these:

Try it!

What categories of things have patent ids currently edit

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 edit

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". }
}
Try it!

Mod of edit

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 edit

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 edit

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 edit

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 edit

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". }
}
Try it!

Orgs that are members of the Bytecode Alliance edit

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". }
}
Try it!

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

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". }
}
Try it!

List of ff items with multiple puids ranked edit

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 edit

The following query uses these:

Try it!

string search for file extension edit

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 edit

The following query uses these:

Try it!

Readable file formats for presentation software titles w extension edit

The following query uses these:

Try it!

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

The following query uses these:

Try it!

Software categories edit

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". }
}
Try it!

Items with a file extension and any alternate labels edit

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 edit

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!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:YULdigitalpreservation/moreSPARQL&oldid=1069870869"