User:קיין ומוויסנדיק פּרעפֿערענצן/sandbox/syntax tests

From Wikidata
Jump to navigation Jump to search

PAGEID: 70045852 · links here ·LTR

subpagestalk subpagesAlkanot4ran

testing templates Q and P[edit]

Yiddish list

  1. instance of (P31) _T_ 
    1. native language (P103) _T_ , languages spoken, written or signed (P1412) _T_ , language used (P2936) _T_ , language of work or name (P407) _T_ Yiddish (Q8641) _T_ 
    2. YouTube video ID (P1651) _T_ 

testing: ?item (wdt:P103|wdt:P1412|wdt:2936|wdt:P407)* wd:Q8641.
example: Bayerische Philharmonie (Q17521517)


use variations with: Esperanto (Q143)_T_  and Facebook username (P2013)_T_ 
Banatswabian (Q806124)_T_ 


SELECT ?item (URI(CONCAT("https://tools.wmflabs.org/reasonator/?q=", ?item_FOO)) AS ?reason) (URI(CONCAT("https://invidio.us/watch?v=", ?videoid)) AS ?video) ?item_EN ?item_YI ?item_DE ?type ?type_EN ?type_YI ?type_DE
WHERE 
{
  ?item wdt:P31 ?type.
  ?item (wdt:P2936)* wd:Q8641.
  OPTIONAL { ?item wdt:P1651 ?videoid. }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
            ?item rdfs:label ?item_EN.
            ?type rdfs:label ?type_EN.
     }
     SERVICE wikibase:label { bd:serviceParam wikibase:language "yi".
            ?item rdfs:label ?item_YI.
            ?type rdfs:label ?type_YI.
     } hint:Prior hint:runLast false.
     SERVICE wikibase:label { bd:serviceParam wikibase:language "de".
            ?item rdfs:label ?item_DE.
            ?type rdfs:label ?type_DE.
     } hint:Prior hint:runLast false.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "ff".
            ?item rdfs:label ?item_FOO.
     } hint:Prior hint:runLast false.
} ORDER BY DESC(?type)
Try it!

2019.10.13[edit]

verbessert sucht auch im youtube title


SELECT ?item (URI(CONCAT("https://tools.wmflabs.org/reasonator/?q=", ?item_FOO)) AS ?reason) (URI(CONCAT("https://invidio.us/watch?v=", ?videoid)) AS ?video) ?item_EN ?item_YI ?item_DE ?type ?type_EN ?type_YI ?type_DE
WHERE 
{
  ?item wdt:P31 ?type.
  ?item (wdt:P2936|wdt:P103|wdt:P1412|wdt:P1651/wdt:P1412) wd:Q8641.
  OPTIONAL { ?item wdt:P1651 ?videoid. }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
            ?item rdfs:label ?item_EN.
            ?type rdfs:label ?type_EN.
     }
     SERVICE wikibase:label { bd:serviceParam wikibase:language "yi".
            ?item rdfs:label ?item_YI.
            ?type rdfs:label ?type_YI.
     } hint:Prior hint:runLast false.
     SERVICE wikibase:label { bd:serviceParam wikibase:language "de".
            ?item rdfs:label ?item_DE.
            ?type rdfs:label ?type_DE.
     } hint:Prior hint:runLast false.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "ff".
            ?item rdfs:label ?item_FOO.
     } hint:Prior hint:runLast false.
} ORDER BY DESC(?type)
Try it!

2019.10.13[edit]

sucht alle altgeschriebenen Namen


SELECT ?item ?name
WHERE 
{
  ?item (wdt:P734|wdt:P735|wdt:P1559|rdfs:label) ?name;
        (wdt:P2936|wdt:P103|wdt:P1412) wd:Q7913.
  FILTER(REGEX(STR(?name), "(ş|Ş|ţ|Ţ)"))
}
Try it!

geographic

SELECT ?item ?name
WHERE 
{
  ?item (wdt:P734|wdt:P735|wdt:P1559|rdfs:label) ?name;
        wdt:P27 wd:Q218.
  FILTER(REGEX(STR(?name), "(ş|Ş|ţ|Ţ)"))
}
Try it!

no bias — קיין אומוויסנדיקע פּרעפֿערענצן — keyn umvisndike preferentsn talk contribs 15:57, 13 October 2019 (UTC)