query-a4282cd8bc3926ce740744c5cd2bc61a

rq turtle/ttl

added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias added before 2016-10 SELECT ?property ?alias ?occurences WHERE { hint:Query hint:optimizer "None" .

{ SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {
?tmp rdf:type wikibase:Property . ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en") } GROUP BY ?alias }

?property rdf:type wikibase:Property . ?property skos:altLabel ?alias FILTER (?occurences > 1) . } ORDER BY ?alias

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
#added before 2016-10
SELECT ?property ?alias ?occurences
WHERE
{


  {
    SELECT ?alias (COUNT (?alias) as ?occurences) WHERE {   
      ?tmp rdf:type wikibase:Property .
      ?tmp skos:altLabel ?alias FILTER (LANG (?alias) = "en")
    } GROUP BY ?alias
  }

  ?property rdf:type wikibase:Property .
  ?property skos:altLabel ?alias FILTER (?occurences > 1) .
}
ORDER BY ?alias

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?alias"):::projected v4("?occurences"):::projected v4("?property"):::projected v3("?tmp") c4(["wikibase:Property"]):::iri f0[["?occurences > '1^^xsd:integer'"]] f0 --> v4 f1[["?alias = 'en'"]] f1 --> v1 v3 --"a"--> c4 v3 --"skos:altLabel"--> v1 bind3[/"count(?alias)"/] v1 --o bind3 bind3 --as--o v4 v4 --"a"--> c4 v4 --"skos:altLabel"--> v1