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

• Related properties

Last update : Wednesday 15 February 2023 00:11:23

Manually update list

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:Q34 . 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 E4	Q782249	Finland Sweden	E4		E4
2	European route E6	Q921422	Norway Sweden	E6		E6
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 E20	Q987346	Republic of Ireland United Kingdom Denmark Sweden Estonia Russia	E20		E20
9	European route E22	Q322164	United Kingdom Netherlands Germany Sweden Latvia Russia	E22		E22
10	European route E45	Q276570	Norway Finland Sweden Denmark Germany Austria Italy	E45		E45
11	European route E47	Q692012	Germany Denmark Sweden	E47		E47
12	European route E55	Q313410	Sweden Denmark Germany Czech Republic Austria Italy Greece	E55		E55
13	European route E65	Q911135	Sweden Poland Czech Republic Slovakia Hungary Croatia Bosnia and Herzegovina Montenegro Serbia Kosovo North Macedonia Greece	E65		E65
14	European route E265	Q2728829	Estonia Sweden	E265		E265

End of automatically generated list.