User:Gz260/Roads/E/Wikidata/Countries/BG
Last update : Tuesday 14 February 2023 20:56:30
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:Q219 . 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 E70 | Q741488 | Spain France Italy Slovenia Croatia Serbia Romania Bulgaria Turkey Georgia |
E70 | E70 | |
2 | European route E79 | Q580571 | Hungary Romania Bulgaria Greece |
E79 | E79 | |
3 | European route E80 | Q877647 | Portugal Spain France Italy Croatia Montenegro Serbia Kosovo Bulgaria Turkey |
E80 | E80 | |
4 | European route E83 | Q955939 | Bulgaria | E83 | E83 | |
5 | European route E85 | Q926976 | Lithuania Belarus Ukraine Romania Bulgaria Greece |
E85 | E85 | |
6 | European route E87 | Q1376032 | Ukraine Moldova Romania Bulgaria Turkey |
E87 | E87 | |
7 | European route E675 | Q2579632 | Romania Bulgaria |
E675 | E675 | |
8 | European route E772 | Q2303347 | Bulgaria | E772 | E772 | |
9 | European route E773 | Q3041141 | Bulgaria | E773 | E773 | |
10 | European route E871 | Q2694282 | Bulgaria North Macedonia |
E871 | E871 |
End of automatically generated list.