User:BennyOnTheLoose/dylansongs


 * sparql=#Dylans songs
 * 1) added before 2023-07

SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P175 wd:Q392. ?item wdt:P7937 wd:Q7366. ?sitelink schema:about ?item. FILTER EXISTS { ?article schema:about ?item. ?article schema:isPartOf . #Targeting Wikipedia language where subjects has article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #Service to resolve labels in languages: automatic user language, English } ORDER BY DESC (?cnt) }}
 * columns=label:Article,description,item:wikidata item,?cnt
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback


 * sparql=#Dylans songs
 * 1) added before 2023-07

SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P175 wd:Q392. ?item wdt:P7937 wd:Q7366. ?sitelink schema:about ?item. FILTER EXISTS { ?article schema:about ?item. ?article schema:isPartOf . #Targeting Wikipedia language where subjects has article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #Service to resolve labels in languages: automatic user language, English } ORDER BY DESC (?cnt) }}
 * columns=label:Article,description,item:wikidata item,?cnt
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback


 * sparql=#Dylans songs
 * 1) added before 2023-07

SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P175 wd:Q392. ?item wdt:P7937 wd:Q7366. ?sitelink schema:about ?item. FILTER EXISTS { ?article schema:about ?item. ?article schema:isPartOf . #Targeting Wikipedia language where subjects has article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #Service to resolve labels in languages: automatic user language, English } ORDER BY DESC (?cnt) }}
 * columns=label:Article,description,item:wikidata item,?cnt
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback


 * sparql=#Dylans songs
 * 1) added before 2023-07

SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P175 wd:Q392. ?item wdt:P7937 wd:Q7366. ?sitelink schema:about ?item. FILTER EXISTS { ?article schema:about ?item. ?article schema:isPartOf . #Targeting Wikipedia language where subjects has article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #Service to resolve labels in languages: automatic user language, English } ORDER BY DESC (?cnt) }}
 * columns=label:Article,description,item:wikidata item,?cnt
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback


 * sparql=#Dylans songs
 * 1) added before 2023-07

SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P175 wd:Q392. ?item wdt:P7937 wd:Q7366. ?sitelink schema:about ?item. FILTER EXISTS { ?article schema:about ?item. ?article schema:isPartOf . #Targeting Wikipedia language where subjects has article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #Service to resolve labels in languages: automatic user language, English } ORDER BY DESC (?cnt) }}
 * columns=label:Article,description,item:wikidata item,?cnt
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback


 * sparql=#Dylans songs
 * 1) added before 2023-07

SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P175 wd:Q392. ?item wdt:P7937 wd:Q7366. ?sitelink schema:about ?item. FILTER EXISTS { ?article schema:about ?item. ?article schema:isPartOf . #Targeting Wikipedia language where subjects has article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #Service to resolve labels in languages: automatic user language, English } ORDER BY DESC (?cnt) }}
 * columns=label:Article,description,item:wikidata item,?cnt
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback


 * sparql=#Dylans songs
 * 1) added before 2023-07

SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P175 wd:Q392. ?item wdt:P7937 wd:Q7366. ?sitelink schema:about ?item. FILTER EXISTS { ?article schema:about ?item. ?article schema:isPartOf . #Targeting Wikipedia language where subjects has article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #Service to resolve labels in languages: automatic user language, English } ORDER BY DESC (?cnt) }}
 * columns=label:Article,description,item:wikidata item,?cnt
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback


 * sparql=#Dylans songs
 * 1) added before 2023-07

SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P175 wd:Q392. ?item wdt:P7937 wd:Q7366. ?sitelink schema:about ?item. FILTER EXISTS { ?article schema:about ?item. ?article schema:isPartOf . #Targeting Wikipedia language where subjects has article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #Service to resolve labels in languages: automatic user language, English } ORDER BY DESC (?cnt) }}
 * columns=label:Article,description,item:wikidata item,?cnt
 * section=131
 * min_section=3
 * sort=label
 * links=text
 * thumb=128
 * autolist=fallback