User:Jklamo/Czech companies
Revenue
[edit]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 ?item ?revenueCZK ?hq ?date ?prof ?emp WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?item p:P2139 ?revenueSt . ?revenueSt a wikibase:BestRank; ps:P2139 ?revenue . OPTIONAL { ?revenueSt pq:P585 ?date } . OPTIONAL { ?item wdt:P2295 ?prof } . OPTIONAL { ?item wdt:P1128 ?emp } . FILTER(?item NOT IN (wd:Q11878499, wd:Q58197019, wd:Q54983885, wd:Q58197026, wd:Q60161033, wd:Q11878927, wd:Q58623100, wd:Q98930883, wd:Q58219764, wd:Q15123994, wd:Q45252891, wd:Q12017963, wd:Q121625804, wd:Q11089971, wd:Q3500121)) { ?revenueSt psv:P2139 [ wikibase:quantityAmount ?revenue; wikibase:quantityUnit wd:Q131016 ] . BIND( ?revenue AS ?revenueCZK ) . } UNION { ?revenueSt psv:P2139 [ wikibase:quantityAmount ?revenue; wikibase:quantityUnit ?unit ] . FILTER( ?unit != wd:Q131016 ) . BIND( ?revenue * 25 AS ?revenueCZK ) . } . } ORDER BY DESC(?revenueCZK) LIMIT 119
Profit
[edit]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 ?item ?profit ?hq ?date WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?item p:P2295 ?profitSt . ?profitSt a wikibase:BestRank; ps:P2295 ?profit . OPTIONAL { ?profitSt pq:P585 ?date } . FILTER( ?item not in (wd:Q11878499,wd:Q12021167,wd:Q28920259,wd:Q5201737,wd:Q12022160,wd:Q15123994)) SERVICE wikibase:label { bd:serviceParam wikibase:language "cs, en" } } ORDER BY DESC(?profit) LIMIT 40
# | Company | HQ | Profit (CZK) | Year |
---|---|---|---|---|
1 | ČEZ Group | Prague | 80705000000 | 2022-01-01 |
2 | PaBa Software | Prague | 25020795000 | 2022-01-01 |
3 | EP Corporate Group | Prague | 21907513000 | 2022-01-01 |
4 | Česká spořitelna | Prague | 20188000000 | 2022-12-31 |
5 | Československá obchodní banka | Prague | 16160000000 | 2021-01-01 |
6 | Škoda Auto | Mladá Boleslav | 15175000000 | 2020-01-01 |
7 | Komerční banka | Prague | 15172000000 | 2019-01-01 |
8 | GasNet | Ústí nad Labem | 14987232000 | 2019-01-01 |
9 | Allwyn International | Prague | 447500000 10977175000 |
2021-01-01 |
10 | Kooperativa pojišťovna | Prague | 10631421000 | 2021-01-01 |
11 | UniCredit Bank Czech Republic and Slovakia | Prague | 6981000000 | 2021-01-01 |
12 | Czech Property Investments | Prague | 6839742000 | 2021-01-01 |
13 | O2 Czech Republic | Prague | 6454000000 | 2021-01-01 |
14 | T-Mobile Czech Republic | Prague | 6256000000 | 2021-01-01 |
15 | Lidl Česká republika | Prague | 6111306000 | 2021-01-01 |
16 | Liberty Ostrava | Ostrava | 6109224000 | 2022-01-01 |
17 | Agrofert | Prague | 5784070000 | 2021-01-01 |
18 | Czechoslovak Group | Prague | 5000000000 | 2023-01-01 |
19 | Plzeňský Prazdroj | Plzeň | 4769000000 | 2019-01-01 |
20 | Energetický a průmyslový holding | Prague | 4715000000 | 2023-01-01 |
21 | Generali Česká pojišťovna | Prague | 4530000000 | 2022-01-01 |
22 | Avast Software | Prague | 4482705000 | 2021-01-01 |
23 | Hyundai Motor Manufacturing Czech | Nižní Lhoty | 4202903000 | 2020-01-01 |
24 | Raiffeisenbank (Czechia) | Prague | 4187741000 | 2019-01-01 |
25 | Continental HT Tyres | Otrokovice | 4109558000 | 2019-01-01 |
26 | Moneta Money Bank | Prague | 4019000000 | 2019-01-01 |
27 | Philip Morris ČR | Kutná Hora | 3636000000 | 2022-01-01 |
28 | Czech Grid Holding | Prague | 3493193000 | 2021-01-01 |
29 | NET4GAS | Prague | 3330000000 | 2019-01-01 |
30 | EG.D | České Budějovice | 3216963000 | 2019-01-01 |
31 | Moravia Steel | Třinec | 3037000000 | 2021-01-01 |
32 | Kaufland Česká republika | Prague | 2933098000 | 2021-01-01 |
33 | Pražská energetika | Prague | 2851103000 | 2019-01-01 |
34 | CETIN | Prague | 2811000000 | 2019-01-01 |
35 | J&T Finance Group | Prague | 104285000 2688467000 |
2018-01-01 |
36 | Teva Czech Industries | Opava | 2574319000 | 2019-01-01 |
37 | Continental Barum | Otrokovice | 2491878000 | 2021-01-01 |
38 | innogy Česká republika | Prague | 2427000000 | 2021-01-01 |
39 | PPF Banka | Prague | 2352000000 | 2018-01-01 |
40 | E.ON Energie | České Budějovice | 2285481000 | 2021-01-01 |
Loss
[edit]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 ?item ?profit ?hq ?date WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?item p:P2295 ?profitSt . ?profitSt a wikibase:BestRank; ps:P2295 ?profit . OPTIONAL { ?profitSt pq:P585 ?date } . FILTER( ?item not in (wd:Q11878499,wd:Q12021167,wd:Q28920259,wd:Q12021780,wd:Q43912780)) SERVICE wikibase:label { bd:serviceParam wikibase:language "cs, en" } } ORDER BY ASC(?profit) LIMIT 16
# | Company | HQ | Profit (CZK) | Year |
---|---|---|---|---|
1 | Orlen Unipetrol | Prague | -5947000000 | 2020-01-01 |
2 | CITIC Europe Holdings | Prague | -4221297000 | 2019-01-01 |
3 | Continental Automotive Czech Republic | Jičín | -3562433000 | 2021-01-01 |
4 | Zentiva Group | Prague | -2995414000 | 2020-01-01 |
5 | SCTbio | Prague | -2360838000 | 2020-01-01 |
6 | Letiště Praha | Prague | -2294654000 | 2020-01-01 |
7 | Pilsen Steel | Plzeň | -2282243000 | 2018-01-01 |
8 | Česká pošta | Prague | -1730000000 | 2022-01-01 |
9 | Mall Group | Prague | -1713320000 | 2019-01-01 |
10 | České dráhy | Prague | -1636000000 | 2021-01-01 |
11 | Mall Group | Prague | -1621737000 | 2020-01-01 |
12 | Carrefour Česká republika | Prague | -1419562000 -586096000 |
2005-01-01 |
13 | Nexen Tire Europe | Bitozeves | -1404262000 | 2020-01-01 |
14 | Teplárna Kladno | Kladno | -1154205000 | 2019-01-01 |
15 | PO Lighting Czech | Šenov u Nového Jičína | -998025000 | 2022-01-01 |
16 | MAFRA | Prague | -867755000 | 2020-01-01 |
Operating Income
[edit]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 ?item ?profit ?hq ?date WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?item p:P3362 ?profitSt . ?profitSt a wikibase:BestRank; ps:P3362 ?profit . OPTIONAL { ?profitSt pq:P585 ?date } . FILTER( ?item not in (wd:Q11878499,wd:Q12022160,wd:Q5201737,wd:Q15123994)) SERVICE wikibase:label { bd:serviceParam wikibase:language "cs, en" } } ORDER BY DESC(?profit) LIMIT 40
# | Company | HQ | Operating Income (CZK) | Year |
---|---|---|---|---|
1 | ČEZ Group | Prague | 101927000000 | 2022-01-01 |
2 | Česká spořitelna | Prague | 28541000000 | 2022-01-01 |
3 | GasNet | Ústí nad Labem | 19524658000 | 2019-01-01 |
4 | Škoda Auto | Mladá Boleslav | 17316000000 | 2020-01-01 |
5 | Allwyn International | Prague | 17291197000 | 2021-01-01 |
6 | Czechoslovak Group | Prague | 10500000000 | 2023-01-01 |
7 | O2 Czech Republic | Prague | 8544000000 | 2021-01-01 |
8 | Agrofert | Prague | 8258029000 | 2021-01-01 |
9 | T-Mobile Czech Republic | Prague | 8045000000 | 2021-01-01 |
10 | České dráhy | Prague | 7993000000 | 2021-01-01 |
11 | Liberty Ostrava | Ostrava | 7209537000 | 2022-01-01 |
12 | Czech Property Investments | Prague | 6791011000 | 2021-01-01 |
13 | Lidl Česká republika | Prague | 6407301000 | 2021-01-01 |
14 | Avast Software | Prague | 6267334000 | 2021-01-01 |
15 | Plzeňský Prazdroj | Plzeň | 5893000000 | 2019-01-01 |
16 | NET4GAS | Prague | 5030000000 | 2019-01-01 |
17 | Continental HT Tyres | Otrokovice | 5008143000 | 2019-01-01 |
18 | Hyundai Motor Manufacturing Czech | Nižní Lhoty | 4912760000 | 2020-01-01 |
19 | Spolchemie | Ústí nad Labem | 4540009000 | 2019-01-01 |
20 | Continental Barum | Otrokovice | 4448446000 | 2021-01-01 |
21 | Philip Morris ČR | Kutná Hora | 4243000000 | 2022-01-01 |
22 | Moravia Steel | Třinec | 4228000000 | 2021-01-01 |
23 | CETIN | Prague | 3917000000 | 2019-01-01 |
24 | EG.D | České Budějovice | 3796969000 | 2019-01-01 |
25 | J&T Finance Group | Prague | 3557279000 | 2018-01-01 |
26 | Heimstaden Czech | Ostrava | 3449110000 | 2019-01-01 |
27 | Kaufland Česká republika | Prague | 3281087000 | 2021-01-01 |
28 | EP Industries | Prague | 3215000000 | 2022-01-01 |
29 | Alza.cz | Prague | 2802641000 | 2020-01-01 |
30 | ČEPS | Prague | 2786000000 | 2020-01-01 |
31 | Energetický a průmyslový holding | Prague | 2763000000 | 2023-01-01 |
32 | Iveco Czech Republic | Vysoké Mýto | 2749575000 | 2020-01-01 |
33 | E.ON Energie | České Budějovice | 2707005000 | 2021-01-01 |
34 | Teva Czech Industries | Opava | 2647918000 | 2019-01-01 |
35 | RWE Supply & Trading CZ | Prague | 2642000000 | 2020-01-01 |
36 | Albert Česká republika | Prague | 2515640000 | 2020-01-01 |
37 | Continental výroba pneumatik | Otrokovice | 2233869000 | 2019-01-01 |
38 | Tipsport Holding | Beroun | 2228439000 | 2020-01-01 |
39 | FTMO | Prague | 2056136000 | 2021-01-01 |
40 | Správa pohledávek OKD | Karviná | 2024121000 | 2018-01-01 |
Assets
[edit]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 ?item ?assets ?hq ?date WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?item p:P2403 ?assetsSt . ?assetsSt a wikibase:BestRank; ps:P2403 ?assets . OPTIONAL { ?assetsSt pq:P585 ?date } . FILTER( ?item not in (wd:Q12021167,wd:Q11177413,wd:Q11878499,wd:Q12022160,wd:Q26884311,wd:Q5201737,wd:Q12038439,wd:Q15123994)) SERVICE wikibase:label { bd:serviceParam wikibase:language "cs, en" } } ORDER BY DESC(?assets) LIMIT 40
# | Company | HQ | Assets (CZK) | Year |
---|---|---|---|---|
1 | Československá obchodní banka | Prague | 1805479000000 | 2021-12-31 |
2 | Česká spořitelna | Prague | 1639938000000 | 2022-12-31 |
3 | ČEZ Group | Prague | 1107380000000 | 2022-12-31 |
4 | Komerční banka | Prague | 1077334000000 | 2019-12-31 |
5 | UniCredit Bank Czech Republic and Slovakia | Prague | 693464000000 | 2021-12-31 |
6 | Raiffeisenbank (Czechia) | Prague | 370714816000 | 2019-12-31 |
7 | J&T Finance Group | Prague | 10911221000 281291277000 |
2018-12-31 |
8 | PPF Banka | Prague | 235067000000 | 2018-12-31 |
9 | Škoda Auto | Mladá Boleslav | 227983000000 | 2020-12-31 |
10 | Moneta Money Bank | Prague | 219053000000 | 2019-12-31 |
11 | Agrofert | Prague | 169479310000 | 2021-12-31 |
12 | Allwyn International | Prague | 6350300000 155772859000 |
2021-12-31 |
13 | Air Bank | Prague | 137369000000 | 2020-12-31 |
14 | Generali Česká pojišťovna | Prague | 124578000000 | 2022-12-31 |
15 | Fio banka | Prague | 124499585000 | 2018-12-31 |
16 | EP Corporate Group | Prague | 112278975000 | 2022-12-31 |
17 | České dráhy | Prague | 103524000000 | 2021-12-31 |
18 | Kooperativa pojišťovna | Prague | 100246407000 | 2021-12-31 |
19 | Sberbank CZ | Prague | 89404000000 | 2020-12-31 |
20 | Czech Property Investments | Prague | 86734637000 | 2021-12-31 |
21 | Orlen Unipetrol | Prague | 84589000000 | 2020-12-31 |
22 | Prague Public Transit Company | Prague | 83488053000 | 2019-12-31 |
23 | Hyundai Motor Manufacturing Czech | Nižní Lhoty | 79030850000 | 2020-12-31 |
24 | EG.D | České Budějovice | 74199995000 | 2019-12-31 |
25 | GasNet | Ústí nad Labem | 72440499000 | 2019-12-31 |
26 | Raiffeisen stavební spořitelna | Prague | 69056000000 | 2018-12-31 |
27 | CETIN | Prague | 62062000000 | 2019-12-31 |
28 | Moravia Steel | Třinec | 61788234000 | 2021-12-31 |
29 | Czechoslovak Group | Prague | 60117962000 | 2022-12-31 |
30 | Česká exportní banka | Prague | 57446000000 | 2018-12-31 |
31 | Equa bank | Prague | 55585000000 | 2018-12-31 |
32 | ŠkoFIN | Prague | 55415000000 | 2023-12-31 |
33 | NET4GAS | Prague | 53473000000 | 2019-12-31 |
34 | T-Mobile Czech Republic | Prague | 48773000000 | 2021-12-31 |
35 | Continental Barum | Otrokovice | 46848219000 | 2021-12-31 |
36 | ČEPS | Prague | 44503000000 | 2020-12-31 |
37 | Zentiva Group | Prague | 43511437000 | 2020-12-31 |
38 | Lidl Česká republika | Prague | 41107680000 | 2021-02-28 |
39 | Liberty Ostrava | Ostrava | 41001906000 | 2022-03-31 |
40 | Banka Creditas | Prague | 40968300000 | 2018-12-31 |
Equity
[edit]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 ?item ?assets ?hq ?date WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?item p:P2137 ?assetsSt . ?assetsSt a wikibase:BestRank; ps:P2137 ?assets . OPTIONAL { ?assetsSt pq:P585 ?date } . FILTER( ?item not in (wd:Q12021167,wd:Q11177413,wd:Q12022160,wd:Q12021780,wd:Q15123994)) SERVICE wikibase:label { bd:serviceParam wikibase:language "cs, en" } } ORDER BY DESC(?assets) LIMIT 42
# | Company | HQ | Equity (CZK) | Year |
---|---|---|---|---|
1 | ČEZ Group | Prague | 260261000000 | 2022-12-31 |
2 | Česká spořitelna | Prague | 137711000000 | 2022-12-31 |
3 | Československá obchodní banka | Prague | 117378000000 | 2021-12-31 |
4 | EP Corporate Group | Prague | 112202889000 | 2022-12-31 |
5 | Komerční banka | Prague | 108635000000 | 2019-12-31 |
6 | Škoda Auto | Mladá Boleslav | 94920000000 | 2020-12-31 |
7 | Agrofert | Prague | 93177889000 | 2021-12-31 |
8 | UniCredit Bank Czech Republic and Slovakia | Prague | 81881000000 | 2021-12-31 |
9 | Prague Public Transit Company | Prague | 68267898000 | 2019-12-31 |
10 | Czech Property Investments | Prague | 67235413000 | 2021-12-31 |
11 | Orlen Unipetrol | Prague | 53242000000 | 2020-12-31 |
12 | EG.D | České Budějovice | 51429036000 | 2019-12-31 |
13 | Hyundai Motor Manufacturing Czech | Nižní Lhoty | 44779977000 | 2020-12-31 |
14 | Allwyn International | Prague | 1803300000 44234949000 |
2021-12-31 |
15 | Moravia Steel | Třinec | 43121000000 | 2021-12-31 |
16 | J&T Finance Group | Prague | 1628455000 41981570000 |
2018-12-31 |
17 | PaBa Software | Prague | 39176355000 | 2022-12-31 |
18 | České dráhy | Prague | 36870000000 | 2021-12-31 |
19 | GasNet | Ústí nad Labem | 35165287000 | 2019-12-31 |
20 | Continental Barum | Otrokovice | 34788422000 | 2021-12-31 |
21 | Letiště Praha | Prague | 33934261000 | 2020-12-31 |
22 | T-Mobile Czech Republic | Prague | 33375000000 | 2021-12-31 |
23 | Raiffeisenbank (Czechia) | Prague | 32702936000 | 2019-12-31 |
24 | ČEPS | Prague | 31609000000 | 2020-12-31 |
25 | Czech Grid Holding | Prague | 25936532000 | 2021-12-31 |
26 | Moneta Money Bank | Prague | 24411000000 | 2019-12-31 |
27 | Severočeské doly | Chomutov | 23017000000 | 2018-12-31 |
28 | innogy Česká republika | Prague | 21305401000 | 2021-12-31 |
29 | CETIN | Prague | 21043000000 | 2019-12-31 |
30 | Severočeská vodárenská společnost | Teplice | 20969474000 | 2021-12-31 |
31 | Pivovary Staropramen | Prague | 20265000000 | 2019-12-31 |
32 | Generali Česká pojišťovna | Prague | 19055000000 | 2022-12-31 |
33 | Liberty Ostrava | Ostrava | 18945699000 | 2022-03-31 |
34 | Pražská energetika | Prague | 18495399000 | 2019-12-31 |
35 | Kooperativa pojišťovna | Prague | 16965076000 | 2021-12-31 |
36 | Tesco Stores ČR | Prague | 16506000000 | 2021-02-28 |
37 | Overkill Alpha | Prague | 16326472000 | 2022-12-31 |
38 | Czechoslovak Group | Prague | 15800041000 | 2022-12-31 |
39 | Iveco Czech Republic | Vysoké Mýto | 14173153000 | 2020-12-31 |
40 | O2 Czech Republic | Prague | 14048000000 | 2021-12-31 |
41 | Lidl Česká republika | Prague | 13827371000 | 2021-02-28 |
42 | RWE Gas Storage | Prague | 13601801000 | 2018-12-31 |
Profit Margin
[edit]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 ?item ?revenue ?hq ?date ?profit (ROUND(?profmar*1000)/1000 AS ?profmar_rounded) WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?item p:P2139 ?revenueSt . ?revenueSt a wikibase:BestRank; ps:P2139 ?revenue . OPTIONAL { ?revenueSt pq:P585 ?date } . ?item p:P2295 ?profSt . ?profSt a wikibase:BestRank; ps:P2295 ?profit . BIND(?revenue / ?profit AS ?profmar) . FILTER(?profmar>0) FILTER( ?item not in (wd:Q100707321,wd:Q12021780)) } ORDER BY ASC(?profmar) LIMIT 20
# | Company | HQ | Revenue (CZK) | Year | Profit (CZK) | Profit margin |
---|---|---|---|---|---|---|
1 | Czech Property Investments | Prague | 141011000 | 2021-01-01 | 6839742000 | 0.021 |
2 | AB - Credit | Prague | 3506000 | 2018-01-01 | 143726000 | 0.024 |
3 | J&T Finance Group | Prague | 495831000 | 2018-01-01 | 104285000 2688467000 |
0.184 |
4 | Promet Tools | Ostrava | 23926000 | 2017-01-01 | 122253000 | 0.196 |
5 | ALTA Invest | Brno | 9260000 | 2017-01-01 | 45442000 | 0.204 |
6 | Tipsport | Beroun | 511557000 | 2022-01-01 | 1748619000 | 0.293 |
7 | Allwyn International | Prague | 3220800000 | 2021-01-01 | 447500000 10977175000 |
0.293 |
8 | Czech Ocean Shipping | Prague | 15053000 | 2019-01-01 | 49928000 | 0.301 |
9 | Central Group | Prague | 310494000 | 2020-01-01 | 905639000 | 0.343 |
10 | PSN | Prague | 115996000 | 2017-01-01 | 318973000 | 0.364 |
11 | UPC Czech Republic | Prague | 1014327000 | 2020-01-01 | 1941623000 | 0.522 |
12 | innogy Česká republika | Prague | 1301000000 | 2021-01-01 | 2427000000 | 0.536 |
13 | Praha Real | Prague | 440916000 | 2017-01-01 | 774627000 | 0.569 |
14 | Cimex Invest | Prague | 147566000 | 2019-01-01 | 217309000 | 0.679 |
15 | DK Holding Investments | Prague | 794244000 | 2019-01-01 | 33828000 859569480 |
0.924 |
16 | GasNet | Ústí nad Labem | 14196717000 | 2019-01-01 | 14987232000 | 0.947 |
17 | Prague Stock Exchange | Prague | 290343000 | 2022-01-01 | 283778000 | 1.023 |
18 | Ren Power Investment | Prague | 797000000 | 2021-01-01 | 692000000 | 1.152 |
19 | Budějovická investiční fond s proměnným základním kapitálem | Prague | 172875000 | 2017-01-01 | 143976000 | 1.201 |
20 | IOCB TECH | Prague | 702657000 | 2020-01-01 | 538005000 | 1.306 |
Employees
[edit]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 ?item ?empl ?hq ?date WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?item p:P1128 ?emplSt . ?emplSt a wikibase:BestRank; ps:P1128 ?empl . OPTIONAL { ?emplSt pq:P585 ?date } . FILTER( ?item not in (wd:Q5201737,wd:Q58623100,wd:Q12051564,wd:Q43912780,wd:Q3500121,wd:Q11089971,wd:Q11878927,wd:Q15123994)) SERVICE wikibase:label { bd:serviceParam wikibase:language "cs, en" } } ORDER BY DESC(?empl) LIMIT 40
Sitelinks
[edit]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 ?item ?en (COUNT(distinct ?sitelink) as ?count) WHERE { ?item wdt:P31 wd:Q4830453 . ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?sitelink <http://schema.org/about> ?item . optional { ?wen schema:about ?item . ?wen schema:name ?article_en . ?wen schema:isPartOf <https://en.wikipedia.org/>} bind(if(bound(?article_en),"Yes","") as ?en) } GROUP BY ?item ?en HAVING (?count>11) ORDER BY DESC(?count)
bez sportu
[edit]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 ?item ?en (COUNT(distinct ?sitelink) as ?count) WHERE { ?item wdt:P31 wd:Q4830453 . MINUS {?item wdt:P31 wd:Q476028.} MINUS {?item wdt:P31 wd:Q4498974.} ?item wdt:P159 ?hq . ?hq wdt:P17 wd:Q213 . ?sitelink <http://schema.org/about> ?item . optional { ?wen schema:about ?item . ?wen schema:name ?article_en . ?wen schema:isPartOf <https://en.wikipedia.org/>} bind(if(bound(?article_en),"Yes","") as ?en) } GROUP BY ?item ?en HAVING (?count>9) ORDER BY DESC(?count)