User:Gz260/Roads/E/Wikidata/list

From Wikidata
Jump to navigation Jump to search

Last update : Tuesday 14 February 2023 19:12:25

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 } . 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
1 European route E1 Q751771
2 European route E001 Q2621085
3 European route E2 Q56326601
4 European route E002 Q2620531
5 European route E3 Q585439
6 European route E003 Q2295054
7 European route E4 Q782249
8 European route E004 Q2253476
9 European route E5 Q693493
10 European route E005 Q731942
11 European route E6 Q921422
12 European route E006 Q1900649
13 European route E7 Q388884
14 European route E007 Q2129887
15 European route E8 Q1129207
16 European route E008 Q666933
17 European route E9 Q1320233
18 European route E009 Q2109391
19 European route E10 Q586592
20 European route E010 Q1861681
21 European route E11 Q1276480
22 European route E011 Q536536
23 European route E12 Q1346648
24 European route E012 Q1375783
25 European route E13 Q1247738
26 European route E013 Q1375778
27 European route E14 Q1164832
28 European route E014 Q1375781
29 European route E15 Q862476
30 European route E015 Q662647
31 European route E16 Q642043
32 European route E016 Q2329549
33 European route E17 Q1348422
34 European route E017 Q746156
35 European route E18 Q945810
36 European route E018 Q1945568
37 European route E19 Q1375828
38 European route E019 Q2194280
39 European route E20 Q987346
40 European route E21 Q662587
41 European route E22 Q322164
42 European route E23 Q664809
43 European route E24 Q1375832
44 European route E25 Q659345
45 European route E26 Q694396
46 European route E27 Q688946
47 European route E28 Q314656
48 European route E29 Q688868
49 European route E30 Q160249
50 European route E31 Q699601
51 European route E32 Q1375862
52 European route E33 Q1375866
53 European route E34 Q819141
54 European route E35 Q313416
55 European route E36 Q240696
56 European route E37 Q701223
57 European route E38 Q289474
58 European route E39 Q1375888
59 European route E40 Q327162
60 European route E41 Q662616
61 European route E42 Q599910
62 European route E43 Q662603
63 European route E44 Q705125
64 European route E45 Q276570
65 European route E46 Q1375900
66 European route E47 Q692012
67 European route E48 Q819705
68 European route E49 Q667743
69 European route E50 Q687438
70 European route E51 Q692108
71 European route E52 Q691059
72 European route E53 Q701208
73 European route E54 Q664865
74 European route E55 Q313410
75 European route E56 Q690065
76 European route E57 Q592509
77 European route E58 Q180384
78 European route E59 Q674617
79 European route E60 Q168020
80 European route E61 Q695537
81 European route E62 Q665254
82 European route E63 Q1375933
83 European route E64 Q736643
84 European route E65 Q911135
85 European route E66 Q689827
86 European route E67 Q754430
87 European route E68 Q1375951
88 European route E69 Q1375971
89 European route E70 Q741488
90 European route E71 Q1375976
91 European route E72 Q1375978
92 European route E73 Q1375987
93 European route E74 Q600011
94 European route E75 Q638912
95 European route E76 Q768830
96 European route E77 Q918092
97 European route E78 Q1376002
98 European route E79 Q580571
99 European route E80 Q877647
100 European route E81 Q987350
101 European route E82 Q1376012
102 European route E83 Q955939
103 European route E84 Q612223
104 European route E85 Q926976
105 European route E86 Q1376023
106 European route E87 Q1376032
107 European route E88 Q607197
108 European route E89 Q2419632
109 European route E90 Q370080
110 European route E91 Q2163648
111 European route E92 Q2579452
112 European route E93 Q3444696
113 European route E94 Q2586090
114 European route E95 Q1165682
115 European route E96 Q2373964
116 European route E97 Q784392
117 European route E98 Q2296040
118 European route E99 Q548533
119 European route E101 Q2283567
120 European route E104 Q60856181
121 European route E105 Q1321545
122 European route E109 Q108114490
123 European route E114 Q65169436
124 European route E115 Q1375790
125 European route E116 Q111456842
126 European route E117 Q1375799
127 European route E118 Q108114524
128 European route E119 Q2535163
129 European route E121 Q649131
130 European route E123 Q1821054
131 European route E125 Q2625376
132 European route E127 Q2078255
133 European route E134 Q1589334
134 European route E136 Q2345677
135 European route E201 Q3444668
136 European route E231 Q2707350
137 European route E232 Q1375818
138 European route E233 Q658777
139 European route E234 Q2521396
140 European route E251 Q819547
141 European route E261 Q1375834
142 European route E262 Q1995013
143 European route E263 Q1375845
144 European route E264 Q2718918
145 European route E265 Q2728829
146 European route E271 Q3041902
147 European route E272 Q2477727
148 European route E311 Q613422
149 European route E312 Q2138240
150 European route E313 Q1375855
151 European route E314 Q669854
152 European route E331 Q669799
153 European route E371 Q2436200
154 European route E372 Q2418651
155 European route E373 Q1978383
156 European route E381 Q2575132
157 European route E391 Q693049
158 European route E401 Q1922885
159 European route E402 Q644844
160 European route E403 Q2679997
161 European route E404 Q2771746
162 European route E411 Q1920250
163 European route E420 Q3177582
164 European route E421 Q2023107
165 European route E422 Q637443
166 European route E429 Q2655746
167 European route E441 Q2181304
168 European route E442 Q1375889
169 European route E451 Q637808
170 European route E461 Q662928
171 European route E462 Q1375896
172 European route E471 Q2013618
173 European route E501 Q2481606
174 European route E502 Q2474511
175 European route E511 Q2197886
176 European route E512 Q572356
177 European route E531 Q555518
178 European route E532 Q324855
179 European route E533 Q745665
180 European route E551 Q2743430
181 European route E552 Q1792888
182 European route E571 Q2438196
183 European route E572 Q2791074
184 European route E573 Q928483
185 European route E574 Q987339
186 European route E575 Q2078433
187 European route E576 Q338977
188 European route E577 Q1375910
189 European route E578 Q987340
190 European route E579 Q10478772
191 European route E581 Q2243600
192 European route E583 Q1852724
193 European route E584 Q546742
194 European route E591 Q53828736
195 European route E592 Q2137859
196 European route E601 Q2450792
197 European route E602 Q1797423
198 European route E603 Q1794844
199 European route E604 Q2091528
200 European route E606 Q2333741
201 European route E607 Q1795007
202 European route E611 Q1795057
203 European route E612 Q1637858
204 European route E641 Q514182
205 European route E651 Q688368
206 European route E652 Q2150243
207 European route E653 Q2604283
208 European route E661 Q676174
209 European route E662 Q2456332
210 European route E671 Q1378637
211 European route E673 Q1375938
212 European route E675 Q2579632
213 European route E691 Q1375961
214 European route E692 Q1960959
215 European route E711 Q3120429
216 European route E712 Q1955315
217 European route E713 Q746049
218 European route E714 Q2265961
219 European route E717 Q2099373
220 European route E751 Q1871269
221 European route E761 Q745873
222 European route E762 Q2425402
223 European route E763 Q2425390
224 European route E771 Q2621685
225 European route E772 Q2303347
226 European route E773 Q3041141
227 European route E801 Q2154690
228 European route E802 Q27383
229 European route E803 Q2433065
230 European route E804 Q2741026
231 European route E805 Q129065
232 European route E806 Q129067
233 European route E821 Q1641750
234 European route E840 Q2564356
235 European route E841 Q1375993
236 European route E842 Q2444194
237 European route E843 Q744600
238 European route E844 Q2707357
239 European route E846 Q2446271
240 European route E847 Q972968
241 European route E848 Q2266100
242 European route E851 Q947951
243 European route E852 Q2041537
244 European route E853 Q374394
245 European route E871 Q2694282
246 European route E881 Q2521873
247 European route E901 Q1812428
248 European route E902 Q8353069
249 European route E903 Q17629116
250 European route E931 Q2106476
251 European route E932 Q2033565
252 European route E933 Q2497220
253 European route E951 Q2467961
254 European route E952 Q1956688
255 European route E961 Q2516367
256 European route E962 Q2182124
257 European route E981 Q10478786
258 European route E982 Q10478788
End of automatically generated list.