User:Gz260/Roads/E/Wikidata/Countries/RS

Related properties

Last update : Tuesday 14 February 2023 19:04:07

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

SELECT DISTINCT ?item ?p1824 ?longnum ?count WHERE { { ?item wdt:P16 wd:Q106123 . } UNION { ?item wdt:P31 wd:Q106123 . } . MINUS { ?item wdt:P361 ?part . ?part wdt:P16 wd:Q106123 } . ?item wdt:P17 wd:Q403 . OPTIONAL { ?item wdt:P1824 ?p1824 } BIND(STRLEN(str(?p1824)) as ?longp1824) BIND(SUBSTR(str(?p1824),1,1) as ?statut) BIND(SUBSTR(str(?p1824),2,(?longp1824 - 1)) as ?numero) BIND(REPLACE(SUBSTR(str(?numero),1,4),"[A-Za-z]","") as ?num) BIND(STRLEN(str(?num)) as ?longnum) BIND(CONCAT(IF(?longnum=1,"000",IF(?longnum=2,"00",IF(?longnum=3,"0",""))), str(?num)) as ?numz) BIND(CONCAT(str(?statut),str(?num)) as ?numsp) BIND(STRLEN(str(?numsp)) as ?longnumsp) BIND((?longp1824 - ?longnumsp) as ?longprefixe) BIND(SUBSTR(str(?p1824),(?longnumsp + 1),?longprefixe) as ?prefixe) BIND(CONCAT(str(?statut),str(?numz),str(?prefixe)) as ?cledetri) .  OPTIONAL { SELECT DISTINCT ?item (COUNT(?pays) as ?count) WHERE { { ?item wdt:P16 wd:Q106123 . } UNION { ?item wdt:P31 wd:Q106123 . } . ?item wdt:P17 ?pays . } GROUP BY ?item } . } ORDER BY ?cledetri ?longnum DESC(?count)

#	Article	Item Wikidata	country	Commons	road number
1	European route E65	Q911135	Sweden Poland Czech Republic Slovakia Hungary Croatia Bosnia and Herzegovina Montenegro Serbia Kosovo North Macedonia Greece	E65	E65
2	European route E70	Q741488	Spain France Italy Slovenia Croatia Serbia Romania Bulgaria Turkey Georgia	E70	E70
3	European route E75	Q638912	Norway Finland Poland Czech Republic Slovakia Hungary Serbia North Macedonia Greece	E75	E75
4	European route E80	Q877647	Portugal Spain France Italy Croatia Montenegro Serbia Kosovo Bulgaria Turkey	E80	E80
5	European route E662	Q2456332	Croatia Serbia	E662	E662
6	European route E761	Q745873	Bosnia and Herzegovina Serbia	E761	E761
7	European route E763	Q2425390	Serbia Montenegro	E763	E763
8	European route E771	Q2621685	Romania Serbia	E771	E771

End of automatically generated list.