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

• Related properties

Last update : Tuesday 14 February 2023 18:53:38

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:Q28 . 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 E60	Q168020	France Switzerland Austria Germany Hungary Romania Georgia Azerbaijan Turkmenistan Uzbekistan Tajikistan Kyrgyzstan People's Republic of China	E60		E60
2	European route E65	Q911135	Sweden Poland Czech Republic Slovakia Hungary Croatia Bosnia and Herzegovina Montenegro Serbia Kosovo North Macedonia Greece	E65		E65
3	European route E66	Q689827	Italy Austria Hungary	E66		E66
4	European route E68	Q1375951	Hungary Romania	E68		E68
5	European route E71	Q1375976	Slovakia Hungary Croatia Bosnia and Herzegovina	E71		E71
6	European route E73	Q1375987	Hungary Croatia Bosnia and Herzegovina	E73		E73
7	European route E75	Q638912	Norway Finland Poland Czech Republic Slovakia Hungary Serbia North Macedonia Greece	E75		E75
8	European route E77	Q918092	Russia Estonia Latvia Lithuania Poland Slovakia Hungary	E77		E77
9	European route E79	Q580571	Hungary Romania Bulgaria Greece	E79		E79
10	European route E573	Q928483	Hungary Ukraine	E573		E573
11	European route E575	Q2078433	Slovakia Hungary	E575		E575
12	European route E579	Q10478772	Hungary			E579
13	European route E653	Q2604283	Hungary Slovenia	E653		E653
14	European route E661	Q676174	Hungary Croatia Bosnia and Herzegovina	E661		E661

End of automatically generated list.