User:Daniel Mietchen/Sandbox4URLshortening

This page is used in conjunction with m:Special:UrlShortener as a workaround to https://phabricator.wikimedia.org/T220703 . URL shortening can also be triggered via the MediaWiki API.

The following query uses these:

• Items: Zika virus: a report on three cases of human infection during an epidemic of jaundice in Nigeria (Q22330904)   , Zika b. Marković, M.D. (19 September 1889--3 September 1970) (Q22330879)   , scholarly article (Q13442814)   

• Properties: instance of (P31)   , title (P1476)   

  SELECT 
  #  DISTINCT ?item ?title
    (REPLACE(STR(?item), ".*Q", "Q") AS ?qid) 
    ("P921" AS ?property)
    ("Q202864" AS ?ReplaceWithYourTargetID)
    ("S887" AS ?heuristic)
    ("Q69652283" AS ?deduced)
  
  WHERE {
    hint:Query hint:optimizer "None".
    
  {  SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:api "Search";
                      wikibase:endpoint "www.wikidata.org";
                      mwapi:srsearch "zika and haswbstatement:P31=Q13442814 -haswbstatement:P921=Q202864".
        ?page_title wikibase:apiOutput mwapi:title.
    }
   }
  UNION
  {  SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:api "Search";
                      wikibase:endpoint "www.wikidata.org";
                      mwapi:srsearch "zika -and haswbstatement:P31=Q13442814 -haswbstatement:P921=Q202864".
        ?page_title wikibase:apiOutput mwapi:title.
    }
   }
  UNION
  {  SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:api "Search";
                      wikibase:endpoint "www.wikidata.org";
                      mwapi:srsearch "zikv haswbstatement:P31=Q13442814 -haswbstatement:P921=Q202864".
        ?page_title wikibase:apiOutput mwapi:title.
    }
   }
    BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
  
    FILTER ( ?item != wd:Q22330904 ) # actually about Spondweni virus, as per Q28733424 
    FILTER ( ?item != wd:Q22330879 ) # actually about Zika B. Marković (Q93428722)
    # Also check for items falsely tagged with the family name Zika (Q56245778) 
    
    ?item wdt:P31 wd:Q13442814;
          wdt:P1476 ?title.
    FILTER (REGEX(LCASE(?title), "zik(a
  

Try it!