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

• Related properties

Last update : Wednesday 7 June 2023 08:07:42

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:Q213 . 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 E48	Q819705	Germany Czech Republic	E48		E48
2	European route E49	Q667743	Germany Czech Republic Austria	E49		E49
3	European route E50	Q687438	France Germany Czech Republic Slovakia Ukraine Russia	E50		E50
4	European route E53	Q701208	Czech Republic Germany	E53		E53
5	European route E55	Q313410	Sweden Denmark Germany Czech Republic Austria Italy Greece	E55		E55
6	European route E59	Q674617	Czech Republic Austria Slovenia Croatia	E59		E59
7	European route E65	Q911135	Sweden Poland Czech Republic Slovakia Hungary Croatia Bosnia and Herzegovina Montenegro Serbia Kosovo North Macedonia Greece	E65		E65
8	European route E67	Q754430	Finland Estonia Latvia Lithuania Poland Czech Republic	E67		E67
9	European route E75	Q638912	Norway Finland Poland Czech Republic Slovakia Hungary Serbia North Macedonia Greece	E75		E75
10	European route E442	Q1375889	Czech Republic Slovakia	E442		E442
11	European route E461	Q662928	Austria Czech Republic	E461		E461
12	European route E462	Q1375896	Czech Republic Poland	E462		E462
13	European route E551	Q2743430	Czech Republic	E551		E551

End of automatically generated list.