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

• Related properties

Last update : Wednesday 7 June 2023 00:22:53

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:Q40 . 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 E43	Q662603	Switzerland Austria Germany	E43		E43
2	European route E45	Q276570	Norway Finland Sweden Denmark Germany Austria Italy	E45		E45
3	European route E49	Q667743	Germany Czech Republic Austria	E49		E49
4	European route E52	Q691059	Austria Germany France	E52		E52
5	European route E55	Q313410	Sweden Denmark Germany Czech Republic Austria Italy Greece	E55		E55
6	European route E56	Q690065	Austria Germany	E56		E56
7	European route E57	Q592509	Austria Slovenia	E57		E57
8	European route E58	Q180384	Austria Slovakia Ukraine Romania Moldova Russia Transnistria	E58		E58
9	European route E59	Q674617	Czech Republic Austria Slovenia Croatia	E59		E59
10	European route E60	Q168020	France Switzerland Austria Germany Hungary Romania Georgia Azerbaijan Turkmenistan Uzbekistan Tajikistan Kyrgyzstan People's Republic of China	E60		E60
11	European route E61	Q695537	Austria Slovenia Italy Croatia	E61		E61
12	European route E66	Q689827	Italy Austria Hungary	E66		E66
13	European route E461	Q662928	Austria Czech Republic	E461		E461
14	European route E532	Q324855	Germany Austria	E532		E532
15	European route E533	Q745665	Germany Austria	Bundesautobahn 95		E533
16	European route E552	Q1792888	Austria Germany	E552		E552
17	European route E641	Q514182	Austria Germany	E641		E641
18	European route E651	Q688368	Austria	Ennstal-Straße		E651
19	European route E652	Q2150243	Austria Slovenia	E652		E652

End of automatically generated list.