query-c1580efa4778a995ca814a5b6ea06abd

rq turtle/ttl

title: Words and phrases frequently occurring after "using" in titles of articles without P4510 statement 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\" 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\" -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 ") AS ?using) BIND(STRLEN(REPLACE(?using, "\b", "")) + 1 as ?N) } GROUP BY ?using ?N ?count ORDER BY DESC(?count)

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#>
#title: Words and phrases frequently occurring after "using" in titles of articles without P4510 statement
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" 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" -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 ") AS ?using) 
  BIND(STRLEN(REPLACE(?using, "\\b", "")) + 1 as ?N)
}
GROUP BY ?using ?N ?count
ORDER BY DESC(?count)

Query found at