query-7c73d931940e62a43f94464a78bde424

All Law & Order episodes on Wikidata.

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

SELECT (SAMPLE(?seasonNumber) AS ?seasonNumber) (SAMPLE(?episodeNumber) AS ?episodeNumber) (SAMPLE(?title) AS ?title) (MIN(?pubDate) AS ?pubDate) ?episode { # All episodes should be instance of episode with series Law & Order. ?episode wdt:P31 wd:Q21191270; wdt:P179 wd:Q321423. # Many of them also have the season as series, so we can get episode and season number from qualifiers there. OPTIONAL { ?episode p:P179 [ # the season also has series Law & Order ps:P179/p:P179 [ ps:P179 wd:Q321423; pq:P1545 ?seasonNumber ] ; pq:P1545 ?episodeNumber ] } OPTIONAL { ?episode wdt:P1476 ?title. } OPTIONAL { ?episode wdt:P577 ?pubDate. } } GROUP BY ?episode # make sure we return each episode only once – a few have multiple publication dates, for example ORDER BY IF(BOUND(?seasonNumber), xsd:integer(?seasonNumber), 1000) xsd:integer(?episodeNumber) ?title All Law & Order episodes on Wikidata.

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).

As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

Use at

https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
# All Law & Order episodes on Wikidata.
# According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).
# As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

SELECT (SAMPLE(?seasonNumber) AS ?seasonNumber) (SAMPLE(?episodeNumber) AS ?episodeNumber) (SAMPLE(?title) AS ?title) (MIN(?pubDate) AS ?pubDate) ?episode
{
  # All episodes should be instance of episode with series Law & Order.
  ?episode wdt:P31 wd:Q21191270;
           wdt:P179 wd:Q321423.
  # Many of them also have the season as series, so we can get episode and season number from qualifiers there.
  OPTIONAL {
    ?episode p:P179 [
      # the season also has series Law & Order
      ps:P179/p:P179 [
        ps:P179 wd:Q321423;
                pq:P1545 ?seasonNumber
      ] ;
      pq:P1545 ?episodeNumber
    ]
  }
  OPTIONAL { ?episode wdt:P1476 ?title. }
  OPTIONAL { ?episode wdt:P577 ?pubDate. }
}
GROUP BY ?episode # make sure we return each episode only once – a few have multiple publication dates, for example
ORDER BY IF(BOUND(?seasonNumber), xsd:integer(?seasonNumber), 1000) xsd:integer(?episodeNumber) ?title

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?episode"):::projected v6("?episodeNumber"):::projected v6("?pubDate"):::projected v6("?seasonNumber"):::projected v6("?title"):::projected a2((" ")) a3((" ")) a1((" ")) c3(["wd:Q21191270"]):::iri c5(["wd:Q321423"]):::iri v4 --"p:direct/P31"--> c3 v4 --"p:direct/P179"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; a1 -."p:statement/P179".-> c5 a1 --"p:qualifier/P1545"--> v6 a2 --"p:statement/P179"--> a3 a3 --"p:P179"--> a1 a2 --"p:qualifier/P1545"--> v6 v4 --"p:P179"--> a2 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P1476".-> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P577".-> v6 end bind4[/"sample(?seasonNumber)"/] v6 --o bind4 bind4 --as--o v6 bind5[/"sample(?episodeNumber)"/] v6 --o bind5 bind5 --as--o v6 bind6[/"sample(?title)"/] v6 --o bind6 bind6 --as--o v6 bind7[/"min(?pubDate)"/] v6 --o bind7 bind7 --as--o v6