User:Ameisenigel/SpinachBot

Hi SpinachBot! Please build me a query to get all items that have a sitelink to nds.wikipedia but do not have a sitelink to de.wikipedia. --Ameisenigel (talk) 15:06, 13 September 2024 (UTC)

Here is the final SPARQL query and a sample of its results:

SELECT ?item WHERE {
  {
    SELECT ?item WHERE {
      ?article schema:about ?item;
        schema:isPartOf <https://nds.wikipedia.org/>.
    }
    LIMIT 1000
  }
  FILTER(NOT EXISTS {
    ?article2 schema:about ?item;
      schema:isPartOf <https://de.wikipedia.org/>.
  })
}
LIMIT 10

Sample results: - Q162187 - Q9899 - Q24227 - Q24869 - Q32362

This query retrieves items with sitelinks to nds.wikipedia but not to de.wikipedia.

Here's the trace of reasonings and actions for this request so you can see how I came to this conclusion. If you'd like to provide feedback or iterate on this query, you can tag me in a response below or continue the conversation in a chat format. SpinachBot (talk) 15:23, 13 September 2024 (UTC)

Hi SpinachBot! Please exclude disambiguation pages from the result --Ameisenigel (talk) 15:37, 13 September 2024 (UTC)

Here is the final SPARQL query and a sample of its results:

SELECT ?item WHERE {
  {
    SELECT ?item WHERE {
      ?article schema:about ?item;
        schema:isPartOf <https://nds.wikipedia.org/>.
      FILTER(NOT EXISTS { ?item wdt:P31 wd:Q4167410. })
    }
    LIMIT 1000
  }
  FILTER(NOT EXISTS {
    ?article2 schema:about ?item;
      schema:isPartOf <https://de.wikipedia.org/>.
  })
}
LIMIT 10

Sample results: - Q9899 - Q24227 - Q24869

This query retrieves items with sitelinks to nds.wikipedia but not to de.wikipedia, excluding disambiguation pages.

Here's the trace of reasonings and actions for this request so you can see how I came to this conclusion. If you'd like to provide feedback or iterate on this query, you can tag me in a response below or continue the conversation in a chat format. SpinachBot (talk) 15:38, 13 September 2024 (UTC)