query-6ae01954226f3decce2d4bd712acacb2

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

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

Query found at