User:Toaem/queries

podcast programs

SELECT ?podcast ?podcastLabel ?podcastDescription ?languageLabel
WHERE
{
    ?podcast wdt:P31 wd:Q24634210
        ; wdt:P407 ?language .
    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
    }
}
ORDER BY ?podcastLabel

Try it!

podcast networks

SELECT ?network ?networkLabel ?networkDescription ?site
WHERE
{
    ?network wdt:P31 wd:Q24581379 .
    OPTIONAL{
      ?network wdt:P856 ?site .
    }
    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
    }
}
ORDER BY ?networkLabel

Try it!

radio progams that are distributed as audio podcasts

SELECT ?radioprogram ?radioprogramLabel ?radioprogramDescription ?languageLabel
WHERE
{
    ?radioprogram wdt:P31 wd:Q1555508
        ; wdt:P437 wd:Q24633474
        ; wdt:P407 ?language .
    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
    }
}
ORDER BY ?radioprogramLabel

Try it!