User:Gz260/Roads/E/Wikidata/ro

• ?

? : Friday 7 June 2024 20:41:54

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 } . 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 "ro" ; schema:isPartOf <https://ro.wikipedia.org/> } SERVICE wikibase:label { bd:serviceParam wikibase:language "ro" . } } ORDER BY ?cledetri ?longnum DESC(?count)

#	Article	(ro)	Item Wikidata	țară	Commons	simbol al drumului	indicativ drum
1	drumul european E01	drumul european E01	Q751771	Regatul Unit Irlanda Spania Portugalia	E01		E1
2	drumul european E001		Q2621085	Georgia Armenia	E001		E001
3	European route E2		Q56326601	Regatul Unit Franța Elveția Italia			E2
4	drumul european E002		Q2620531	Armenia Azerbaidjan	E002		E002
5	drumul european E007		Q2129887	Uzbekistan Kârgâzstan	E007		E007
6	drumul european E10		Q586592	Norvegia Suedia	E10		E10
7	drumul european E012		Q1375783	Kazahstan Republica Populară Chineză			E012
8	drumul european E013		Q1375778	Kazahstan			E013
9	drumul european E015		Q662647	Kazahstan	E015		E015
10	drumul european E016		Q2329549	Kazahstan	E016		E016
11	drumul european E017		Q746156	Rusia	E017		E017
12	drumul european E18		Q945810	Regatul Unit Norvegia Suedia Finlanda Rusia	E18		E18
13	drumul european E018		Q1945568	Kazahstan	E018		E018
14	drumul european E019		Q2194280	Kazahstan	E019		E019
15	drumul european E24		Q1375832	Regatul Unit	E24		E24
16	drumul european E30		Q160249	Irlanda Regatul Unit Țările de Jos Germania Polonia Belarus Rusia	E30		E30
17	drumul european E34		Q819141	Belgia Țările de Jos Germania	E34		E34
18	drumul european E41		Q662616	Germania Elveția	E41		E41
19	drumul european E46		Q1375900	Belgia Franța	E46		E46
20	drumul european E47		Q692012	Germania Danemarca Suedia	E47		E47
21	drumul european E51		Q692108	Germania	E51		E51
22	drumul european E59		Q674617	Cehia Austria Slovenia Croația	E59		E59
23	drumul european E61		Q695537	Austria Slovenia Italia Croația	E61		E61
24	drumul european E64		Q736643	Italia	E64		E64
25	drumul european E68	drumul european E68	Q1375951	Ungaria România	E68		E68
26	drumul european E69		Q1375971	Norvegia	E69		E69
27	drumul european E73		Q1375987	Ungaria Croația Bosnia și Herțegovina	E73		E73
28	drumul european E74		Q600011	Franța Italia	E74		E74
29	drumul european E77		Q918092	Rusia Estonia Letonia Lituania Polonia Slovacia Ungaria	E77		E77
30	drumul european E81	drumul european E81	Q987350	România Ucraina	E81		E81
31	drumul european E83		Q955939	Bulgaria	E83		E83
32	drumul european E84		Q612223	Turcia	E84		E84
33	drumul european E90	drumul european E90	Q370080	Portugalia Spania Italia Grecia Turcia	E90		E90
34	drumul european E101		Q2283567	Rusia Ucraina	E101		E101
35	drumul european E105		Q1321545	Norvegia Rusia Ucraina	E105		E105
36	European route E118		Q108114524	Regatul Unit Irlanda			E118
37	drumul european E121		Q649131	Rusia Kazahstan Turkmenistan	E121		E121
38	drumul european E125		Q2625376	Rusia Kazahstan Kârgâzstan	E125		E125
39	drumul european E134		Q1589334	Norvegia	E134		E134
40	drumul european E136		Q2345677	Norvegia	E136		E136
41	drumul european E201		Q3444668	Irlanda	E201		E201
42	drumul european E263		Q1375845	Estonia	E263		E263
43	drumul european E312		Q2138240	Țările de Jos	E312		E312
44	drumul european E313		Q1375855	Belgia	E313		E313
45	drumul european E314		Q669854	Belgia Țările de Jos Germania	E314		E314
46	drumul european E331		Q669799	Germania	E331		E331
47	drumul european E373		Q1978383	Polonia Ucraina	E373		E373
48	drumul european E402		Q644844	Franța	E402		E402
49	drumul european E411		Q1920250	Belgia Franța	E411		E411
50	drumul european E420		Q3177582	Belgia Franța	E420		E420
51	drumul european E422		Q637443	Germania	E422		E422
52	drumul european E471		Q2013618	Ucraina	E471		E471
53	drumul european E551		Q2743430	Cehia	E551		E551
54	drumul european E552		Q1792888	Austria Germania	E552		E552
55	drumul european E571		Q2438196	Slovacia	E571		E571
56	drumul european E575		Q2078433	Slovacia Ungaria	E575		E575
57	drumul european E579		Q10478772	Ungaria			E579
58	drumul european E581	https://ro.wikipedia.org/wiki/Drumul_european_E581	Q2243600	România Republica Moldova Ucraina	E581		E581
59	drumul european E592		Q2137859	Rusia	E592		E592
60	drumul european E606		Q2333741	Franța	E606		E606
61	drumul european E652		Q2150243	Austria Slovenia	E652		E652
62	drumul european E662		Q2456332	Croația Serbia	E662		E662
63	drumul european E675		Q2579632	România Bulgaria	E675		E675
64	drumul european E692		Q1960959	Georgia	E692		E692
65	drumul european E751		Q1871269	Croația Slovenia	E751		E751
66	drumul european E763		Q2425390	Serbia Muntenegru	E763		E763
67	drumul european E772		Q2303347	Bulgaria	E772		E772
68	drumul european E801		Q2154690	Spania Portugalia	E801		E801
69	drumul european E804		Q2741026	Spania	E804		E804
70	drumul european E806		Q129067	Portugalia	E806		E806
71	drumul european E821		Q1641750	Italia	E821		E821
72	drumul european E851		Q947951	Muntenegru Albania Kosovo	E851		E851
73	drumul european E881		Q2521873	Turcia	E881		E881

End of automatically generated list.