query-689ce616d50e1a23f48c1c1d478c394c

rq turtle/ttl

Propertiestitle (P1476)

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT 
  DISTINCT
    ?method ?N (COUNT(?item) AS ?count)
WHERE {
  hint:Query hint:optimizer "None".

{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch ""using" and haswbstatement:P31=Q13442814 -haswbstatement:P4510 haswbstatement:P6104=Q56241615". 
      ?page_title wikibase:apiOutput mwapi:title.
  }
 }
UNION
{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch ""using" -and haswbstatement:P31=Q13442814 -haswbstatement:P4510 haswbstatement:P6104=Q56241615".
      ?page_title wikibase:apiOutput mwapi:title.
  }
 }
  BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)

  ?item wdt:P1476 ?title.
  BIND(STRAFTER(LCASE(?title), "using ") AS ?method) 
  FILTER (STRLEN(?method) > 0 )
  BIND(STRLEN(REPLACE(?method, "\\S", "")) + 1 as ?N)
}
GROUP BY ?method ?N ?count
ORDER BY DESC(?count)

Query found at