User:Gz260/Roads/E/Wikidata/Countries/ES
Last update : Sunday 1 September 2024 00:31:12
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:Q29 . 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 E1 | Q751771 | United Kingdom Ireland Spain Portugal |
E01 |  |
E1 |
| 2 | European route E5 | Q693493 | United Kingdom France Spain |
E5 |  |
E5 |
| 3 | European route E7 | Q388884 | France Spain |
E7 |  |
E7 |
| 4 | European route E9 | Q1320233 | France Spain |
E9 |  |
E9 |
| 5 | European route E15 | Q862476 | United Kingdom France Spain |
E15 |  |
E15 |
| 6 | European route E70 | Q741488 | Spain France Italy Slovenia Croatia Serbia Romania Bulgaria Turkey Georgia |
E70 |  |
E70 |
| 7 | European route E80 | Q877647 | Portugal Spain France Italy Croatia Montenegro Serbia Kosovo Bulgaria Turkey |
E80 |  |
E80 |
| 8 | European route E82 | Q1376012 | Spain Portugal |
E82 |  |
E82 |
| 9 | European route E90 | Q370080 | Portugal Spain Italy Greece Turkey |
E90 |  |
E90 |
| 10 | European route E801 | Q2154690 | Spain Portugal |
E801 |  |
E801 |
| 11 | European route E803 | Q2433065 | Spain | E803 |  |
E803 |
| 12 | European route E804 | Q2741026 | Spain | E804 |  |
E804 |
| 13 | European route E901 | Q1812428 | Spain | E901 |  |
E901 |
| 14 | European route E902 | Q8353069 | Spain | E902 |  |
E902 |
| 15 | European route E903 | Q17629116 | Spain |  |
E903 |
End of automatically generated list.