User:Gz260/Roads/E/Wikidata/Countries/NO
Last update : Tuesday 14 February 2023 22:24:07
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query: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:Q20 . 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 | traffic sign | road number |
|---|---|---|---|---|---|---|
| 1 | European route E6 | Q921422 | Norway Sweden |
E6 |  |
E6 |
| 2 | European route E8 | Q1129207 | Norway Finland |
E8 |  |
E8 |
| 3 | European route E10 | Q586592 | Norway Sweden |
E10 |  |
E10 |
| 4 | European route E12 | Q1346648 | Norway Sweden Finland |
E12 |  |
E12 |
| 5 | European route E14 | Q1164832 | Norway Sweden |
E14 |  |
E14 |
| 6 | European route E16 | Q642043 | United Kingdom Norway Sweden |
E16 |  |
E16 |
| 7 | European route E18 | Q945810 | United Kingdom Norway Sweden Finland Russia |
E18 |  |
E18 |
| 8 | European route E39 | Q1375888 | Norway Denmark |
E39 |  |
E39 |
| 9 | European route E45 | Q276570 | Norway Finland Sweden Denmark Germany Austria Italy |
E45 |  |
E45 |
| 10 | European route E69 | Q1375971 | Norway | E69 |  |
E69 |
| 11 | European route E75 | Q638912 | Norway Finland Poland Czech Republic Slovakia Hungary Serbia North Macedonia Greece |
E75 |  |
E75 |
| 12 | European route E105 | Q1321545 | Norway Russia Ukraine |
E105 |  |
E105 |
| 13 | European route E134 | Q1589334 | Norway | E134 |  |
E134 |
| 14 | European route E136 | Q2345677 | Norway | E136 |  |
E136 |
End of automatically generated list.