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

• Related properties

Last update : Monday 2 September 2024 21:56:12

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:Q145 . 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 E1	Q751771	United Kingdom Ireland Spain Portugal	E01		E1
2	European route E2	Q56326601	United Kingdom France Switzerland Italy			E2
3	European route E5	Q693493	United Kingdom France Spain	E5		E5
4	European route E13	Q1247738	United Kingdom	E13		E13
5	European route E15	Q862476	United Kingdom France Spain	E15		E15
6	European route E16	Q642043	United Kingdom Norway Sweden	E16		E16
7	European route E18	Q945810	United Kingdom Norway Sweden Finland Russia	E18		E18
8	European route E20	Q987346	Ireland United Kingdom Denmark Sweden Estonia Russia	E20		E20
9	European route E22	Q322164	United Kingdom Netherlands Germany Sweden Latvia Russia	E22		E22
10	European route E24	Q1375832	United Kingdom	E24		E24
11	European route E30	Q160249	Ireland United Kingdom Netherlands Germany Poland Belarus Russia	E30		E30
12	European route E32	Q1375862	United Kingdom	E32		E32
13	European route E104	Q60856181	United Kingdom			E104
14	European route E109	Q108114490	United Kingdom			E109
15	European route E114	Q65169436	United Kingdom			E114
16	European route E116	Q111456842	United Kingdom			E116
17	European route E118	Q108114524	United Kingdom Ireland			E118

End of automatically generated list.