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

• Related properties

Last update : Sunday 17 March 2024 00:59:49

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:Q43 . 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 E70	Q741488	Spain France Italy Slovenia Croatia Serbia Romania Bulgaria Turkey Georgia	E70		E70
2	European route E80	Q877647	Portugal Spain France Italy Croatia Montenegro Serbia Kosovo Bulgaria Turkey	E80		E80
3	European route E84	Q612223	Turkey	E84		E84
4	European route E87	Q1376032	Ukraine Moldova Romania Bulgaria Turkey	E87		E87
5	European route E88	Q607197	Turkey	E88		E88
6	European route E89	Q2419632	Turkey	E89		E89
7	European route E90	Q370080	Portugal Spain Italy Greece Turkey	E90		E90
8	European route E91	Q2163648	Turkey	E91		E91
9	European route E95	Q1165682	Russia Belarus Ukraine Turkey	E95		E95
10	European route E96	Q2373964	Turkey	E96		E96
11	European route E97	Q784392	Ukraine Russia Georgia Turkey	E97		E97
12	European route E98	Q2296040	Turkey	E98		E98
13	European route E99	Q548533	Azerbaijan Turkey Syria	E99		E99
14	European route E691	Q1375961	Armenia Georgia Turkey	E691		E691
15	European route E881	Q2521873	Turkey	E881		E881
16	European route E981	Q10478786	Turkey	E981		E981
17	European route E982	Q10478788	Turkey	E982		E982

End of automatically generated list.