Open main menu

Máté

Joined 31 March 2015
Babel user information
hu-N Ennek a szerkesztőnek magyar az anyanyelve.
en-3 This user has advanced knowledge of English.
de-1 Dieser Benutzer beherrscht Deutsch auf grundlegendem Niveau.
es-1 Este usuario tiene un conocimiento básico del español.
nl-1 Deze gebruiker heeft elementaire kennis van het Nederlands.
ru-1 Этот участник владеет русским языком на начальном уровне.
Users by language
Wikimedia FoundationThis user has created a global account. Máté's main account is on Wikipedia.
Wikimedia FoundationThis user has created a global account. Matthew Beta's main account is on Wikipedia.
Wikidata-rollbacker.svgThis user has rollback rights on Wikidata. (verify)

Hi! I'm Máté (pronounced [ˈmaːteː]) a researcher (Q1650915) from Hungary (Q28). I studied

I have worked in market research (Q913709).

Proposed propertiesEdit

QueriesEdit

# musicals and rock operas first performed in Hungary with the list of authors
SELECT DISTINCT ?musical ?musicalLabel ?premieredate ?premiereplaceLabel
(GROUP_CONCAT(DISTINCT(?author); separator=" – ") as ?authors)
WHERE {
  { ?musical wdt:P31/wdt:P279* wd:Q2743 . }
  UNION
  { ?musical wdt:P31/wdt:P279* wd:Q253137 . }
  ?musical p:P1191 [
    ps:P1191 ?premieredate;
    pq:P276 ?premiereplace
  ] .
  ?premiereplace wdt:P131+ wd:Q28
  OPTIONAL { ?musical (wdt:P86|wdt:P676|wdt:P87)/rdfs:label ?author FILTER (lang(?author) = "hu") . }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "hu" .
  }
} GROUP BY ?musical ?musicalLabel ?premieredate ?premiereplaceLabel ORDER BY ASC(?premieredate)

Try it!

# ratings of Hungarian films
SELECT DISTINCT ?film ?filmLabel ?ratingLabel ?age ?countryLabel
WHERE {
  [] wdt:P31 wd:Q24716199; wikibase:directClaim ?p .
  ?film wdt:P31/wdt:P279* wd:Q11424;
        wdt:P495 wd:Q28;
        ?p ?rating .
  ?rating wdt:P2899 ?age; wdt:P31/wdt:P361/wdt:P17 ?country .
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "hu,en" .
  }
} ORDER BY ?filmLabel ?countryLabel

Try it!

# Russian film titles without Hungarian transcriptions
SELECT ?film ?filmLabel ?title
WHERE {
  ?film wdt:P31/wdt:P279* wd:Q11424;
        p:P1476 ?s .
  ?s ps:P1476 ?title .
  MINUS { ?s pq:P2719 [] . }
  FILTER ( lang(?title) = "ru" ) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "hu" . }
}

Try it!

# same-sex supercouples
SELECT DISTINCT ?item ?itemLabel ?workLabel ?sexLabel
WHERE {
  ?item wdt:P31 wd:Q1274180;
        wdt:P527 ?one, ?two . FILTER ( ?one != ?two )
  ?one wdt:P21 ?sex . ?two wdt:P21 ?sex .
  OPTIONAL { ?item wdt:P1441 ?work . }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}

Try it!

# languages qualifier Hungarian-style transcription (P2719) is used with by number of statements, identified by their Hungarian labels
SELECT ?lang (COUNT(?v) AS ?num)
WHERE {
  [] wikibase:propertyType wikibase:Monolingualtext;
     wikibase:statementProperty ?ps .
  ?v pq:P2719 ?trans; ?ps ?text .
  BIND (lang(?text) AS ?wmlc) .
  [] wdt:P424 ?wmlc; wdt:P31 wd:Q34770; rdfs:label ?lang .
  FILTER (lang(?lang) = "hu") .
} GROUP BY ?lang ORDER BY DESC(?num)

Try it!

Distribution of ratings
SELECT ?label (count(?film) AS ?count)
WHERE {
  [] wdt:P31 wd:Q24716199; wikibase:directClaim ?p .
  ?film wdt:P31/wdt:P279* wd:Q11424; ?p [ wdt:P2899 ?age ] .
  BIND(IF( 0 <= ?age && ?age < 3, "00-02",
          IF( 3 <= ?age && ?age < 6, "03-05",
             IF( 6 <= ?age && ?age < 9, "06-08",
                IF( 9 <= ?age && ?age < 12, "09-11",
                   IF( 12 <= ?age && ?age < 15, "12-14",
                      IF( 15 <= ?age && ?age < 18, "15-17",
                         IF( 18 <= ?age, "18+", "" ) ) ) ) ) ) )
       AS ?label)
} GROUP BY ?label ORDER BY ASC(?label)
Try it!
SELECT ?label (count(?film) AS ?count)
WHERE {
  [] wdt:P31 wd:Q24716199; wikibase:directClaim ?p .
  ?film wdt:P31/wdt:P279* wd:Q11424; ?p [ wdt:P2899 ?age ] .
  BIND(IF( 0 <= ?age && ?age < 6, "00-05",
          IF( 6 <= ?age && ?age < 12, "06-11",
             IF( 12 <= ?age && ?age < 18, "12-17",
                IF( 18 <= ?age, "18+", "" ) ) ) )
       AS ?label)
} GROUP BY ?label ORDER BY ASC(?label)
Try it!
SELECT ?film ?filmLabel (count(distinct ?p) AS ?numberOfRatingProperties)
WHERE {
  [] wdt:P31 wd:Q24716199; wikibase:claim ?p .
  ?film wdt:P31/wdt:P279* wd:Q11424; ?p [] .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "hu,en" . }
} GROUP BY ?film ?filmLabel ORDER BY DESC(?numberOfRatingProperties) LIMIT 10

Try it!

#check for RTC ratings with the same rating ID
SELECT ?item1 ?item2
WHERE {
  ?item1 p:P3834 [ pq:P2676 ?r ] .
  ?item2 p:P3834 [ pq:P2676 ?r ] .
  FILTER ( ?item1 != ?item2 )
}

Try it!

Icon of Hungarian film rating (?hun)
{ ?item wdt:P2363/wdt:P18 ?hun . } UNION { ?item wdt:P2747/wdt:P18 ?hun . FILTER NOT EXISTS { ?item wdt:P2363 ?new . } }

SubpagesEdit