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

• Related properties

Last update : Tuesday 14 February 2023 19:03:29

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:Q38 . 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 E2	Q56326601	United Kingdom France Switzerland Italy			E2
2	European route E25	Q659345	Netherlands Belgium Luxembourg France Switzerland Italy	E25		E25
3	European route E27	Q688946	France Switzerland Italy	E27		E27
4	European route E33	Q1375866	Italy	E33		E33
5	European route E35	Q313416	Netherlands Germany Switzerland Italy	E35		E35
6	European route E45	Q276570	Norway Finland Sweden Denmark Germany Austria Italy	E45		E45
7	European route E55	Q313410	Sweden Denmark Germany Czech Republic Austria Italy Greece	E55		E55
8	European route E61	Q695537	Austria Slovenia Italy Croatia	E61		E61
9	European route E62	Q665254	France Switzerland Italy	E62		E62
10	European route E64	Q736643	Italy	E64		E64
11	European route E66	Q689827	Italy Austria Hungary	E66		E66
12	European route E70	Q741488	Spain France Italy Slovenia Croatia Serbia Romania Bulgaria Turkey Georgia	E70		E70
13	European route E74	Q600011	France Italy	E74		E74
14	European route E76	Q768830	Italy	E76		E76
15	European route E78	Q1376002	Italy	E78		E78
16	European route E80	Q877647	Portugal Spain France Italy Croatia Montenegro Serbia Kosovo Bulgaria Turkey	E80		E80
17	European route E90	Q370080	Portugal Spain Italy Greece Turkey	E90		E90
18	European route E612	Q1637858	Italy	E612		E612
19	European route E717	Q2099373	Italy	E717		E717
20	European route E821	Q1641750	Italy	E821		E821
21	European route E840	Q2564356	Italy	E840		E840
22	European route E841	Q1375993	Italy	E841		E841
23	European route E842	Q2444194	Italy	E842		E842
24	European route E843	Q744600	Italy	E843		E843
25	European route E844	Q2707357	Italy	E844		E844
26	European route E846	Q2446271	Italy	E846		E846
27	European route E847	Q972968	Italy	E847		E847
28	European route E848	Q2266100	Italy	E848		E848
29	European route E931	Q2106476	Italy	E931		E931
30	European route E932	Q2033565	Italy	E932		E932
31	European route E933	Q2497220	Italy	E933		E933

End of automatically generated list.