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

Related properties

Last update : Sunday 3 December 2023 14:05:16

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

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:Q232 . 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	road number
1	European route E004	Q2253476	Kazakhstan Uzbekistan	E004	E004
2	European route E011	Q536536	Kazakhstan Kyrgyzstan		E011
3	European route E012	Q1375783	Kazakhstan People's Republic of China		E012
4	European route E013	Q1375778	Kazakhstan		E013
5	European route E014	Q1375781	Kazakhstan		E014
6	European route E015	Q662647	Kazakhstan	E015	E015
7	European route E016	Q2329549	Kazakhstan	E016	E016
8	European route E018	Q1945568	Kazakhstan	E018	E018
9	European route E019	Q2194280	Kazakhstan	E019	E019
10	European route E38	Q289474	Ukraine Russia Kazakhstan	E38	E38
11	European route E40	Q327162	France Belgium Germany Poland Ukraine Russia Kazakhstan Uzbekistan Turkmenistan Kyrgyzstan	E40	E40
12	European route E121	Q649131	Russia Kazakhstan Turkmenistan	E121	E121
13	European route E123	Q1821054	Russia Kazakhstan Uzbekistan Tajikistan	E123	E123
14	European route E125	Q2625376	Russia Kazakhstan Kyrgyzstan	E125	E125
15	European route E127	Q2078255	Russia Kazakhstan	E127	E127

End of automatically generated list.