User:Gz260/Roads/E/Wikidata/Countries/FR/en

• Related properties

Last update : Tuesday 14 February 2023 18:56:04

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 ?itemLabel ?article (IF(bound(?article),CONCAT("{","{subst:Urltowiki\u007Curl=", str(?article), "\u007Cdisplay=", str(?itemLabel), "}","}"),str(?itemLabel)) As ?wparticle) 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:Q142 . 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 } . OPTIONAL { ?article schema:about ?item ; schema:inLanguage "en" ; schema:isPartOf <https://en.wikipedia.org/> } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } } ORDER BY ?cledetri ?longnum DESC(?count)

#	Article	(en)	Item Wikidata	country	Commons	traffic sign	road number
1	European route E2	European route E2	Q56326601	United Kingdom France Switzerland Italy			E2
2	European route E3	European route E3	Q585439	France	E3 (France)		E3
3	European route E5	European route E5	Q693493	United Kingdom France Spain	E5		E5
4	European route E7	European route E7	Q388884	France Spain	E7		E7
5	European route E9	European route E9	Q1320233	France Spain	E9		E9
6	European route E11	European route E11	Q1276480	France	E11		E11
7	European route E15	European route E15	Q862476	United Kingdom France Spain	E15		E15
8	European route E17	European route E17	Q1348422	Belgium France	E17		E17
9	European route E19	European route E19	Q1375828	Netherlands Belgium France	E19		E19
10	European route E21	European route E21	Q662587	France Switzerland	E21		E21
11	European route E23	European route E23	Q664809	France Switzerland	E23		E23
12	European route E25	European route E25	Q659345	Netherlands Belgium Luxembourg France Switzerland Italy	E25		E25
13	European route E27	European route E27	Q688946	France Switzerland Italy	E27		E27
14	European route E29	European route E29	Q688868	Germany Luxembourg France	E29		E29
15	European route E40	European route E40	Q327162	France Belgium Germany Poland Ukraine Russia Kazakhstan Uzbekistan Turkmenistan Kyrgyzstan	E40		E40
16	European route E42	European route E42	Q599910	France Belgium Germany	E42		E42
17	European route E44	European route E44	Q705125	France Luxembourg Germany	E44		E44
18	European route E46	European route E46	Q1375900	Belgium France	E46		E46
19	European route E50	European route E50	Q687438	France Germany Czech Republic Slovakia Ukraine Russia	E50		E50
20	European route E52	European route E52	Q691059	Austria Germany France	E52		E52
21	European route E54	European route E54	Q664865	France Switzerland Germany	E54		E54
22	European route E60	European route E60	Q168020	France Switzerland Austria Germany Hungary Romania Georgia Azerbaijan Turkmenistan Uzbekistan Tajikistan Kyrgyzstan People's Republic of China	E60		E60
23	European route E62	European route E62	Q665254	France Switzerland Italy	E62		E62
24	European route E70	European route E70	Q741488	Spain France Italy Slovenia Croatia Serbia Romania Bulgaria Turkey Georgia	E70		E70
25	European route E72	European route E72	Q1375978	France	E72		E72
26	European route E74	European route E74	Q600011	France Italy	E74		E74
27	European route E80	European route E80	Q877647	Portugal Spain France Italy Croatia Montenegro Serbia Kosovo Bulgaria Turkey	E80		E80
28	European route E401	European route E401	Q1922885	France	E401		E401
29	European route E402	European route E402	Q644844	France	E402		E402
30	European route E411	European route E411	Q1920250	Belgium France	E411		E411
31	European route E420	European route E420	Q3177582	Belgium France	E420		E420
32	European route E501	European route E501	Q2481606	France	E501		E501
33	European route E502	European route E502	Q2474511	France	E502		E502
34	European route E511	European route E511	Q2197886	France	E511		E511
35	European route E512	European route E512	Q572356	France	E512		E512
36	European route E601	European route E601	Q2450792	France	E601		E601
37	European route E602	European route E602	Q1797423	France	E602		E602
38	European route E603	European route E603	Q1794844	France	E603		E603
39	European route E604	European route E604	Q2091528	France	E604		E604
40	European route E606	European route E606	Q2333741	France	E606		E606
41	European route E607	European route E607	Q1795007	France	E607		E607
42	European route E611	European route E611	Q1795057	France	E611		E611
43	European route E711	European route E711	Q3120429	France	E711		E711
44	European route E712	European route E712	Q1955315	France Switzerland	E712		E712
45	European route E713	European route E713	Q746049	France	E713		E713
46	European route E714	European route E714	Q2265961	France	E714		E714

End of automatically generated list.