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

• Related properties

Last update : Sunday 1 September 2024 03:14:00

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:Q36 . 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 E28	Q314656	Germany Poland Russia Lithuania Belarus	E28		E28
2	European route E30	Q160249	Ireland United Kingdom Netherlands Germany Poland Belarus Russia	E30		E30
3	European route E36	Q240696	Germany Poland	E36		E36
4	European route E40	Q327162	France Belgium Germany Poland Ukraine Russia Kazakhstan Uzbekistan Turkmenistan Kyrgyzstan	E40		E40
5	European route E65	Q911135	Sweden Poland Czech Republic Slovakia Hungary Croatia Bosnia and Herzegovina Montenegro Serbia Kosovo North Macedonia Greece	E65		E65
6	European route E67	Q754430	Finland Estonia Latvia Lithuania Poland Czech Republic	E67		E67
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 E261	Q1375834	Poland	E261		E261
10	European route E371	Q2436200	Poland Slovakia	E371		E371
11	European route E372	Q2418651	Ukraine Poland	E372		E372
12	European route E373	Q1978383	Poland Ukraine	E373		E373
13	European route E462	Q1375896	Czech Republic Poland	E462		E462

End of automatically generated list.