User:Jklamo/Czech companies
Jump to navigation
Jump to search
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 ?revenue ?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)) } ORDER BY DESC(?revenue) LIMIT 119End of automatically generated list.
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 | Česká spořitelna | Prague | 20188000000 | 2022-12-31 |
| 4 | Československá obchodní banka | Prague | 16160000000 | 2021-01-01 |
| 5 | Škoda Auto | Mladá Boleslav | 15175000000 | 2020-01-01 |
| 6 | Komerční banka | Prague | 15172000000 | 2019-01-01 |
| 7 | GasNet | Ústí nad Labem | 14987232000 | 2019-01-01 |
| 8 | EP Corporate Group | Prague | 11515491000 | 2021-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 | Plzeňský Prazdroj | Plzeň | 4769000000 | 2019-01-01 |
| 19 | Generali Česká pojišťovna | Prague | 4530000000 | 2022-01-01 |
| 20 | Avast Software | Prague | 4482705000 | 2021-01-01 |
| 21 | Hyundai Motor Manufacturing Czech | Nižní Lhoty | 4202903000 | 2020-01-01 |
| 22 | Raiffeisenbank (Czechia) | Prague | 4187741000 | 2019-01-01 |
| 23 | Continental HT Tyres | Otrokovice | 4109558000 | 2019-01-01 |
| 24 | Moneta Money Bank | Prague | 4019000000 | 2019-01-01 |
| 25 | Energetický a průmyslový holding | Prague | 3791000000 | 2022-01-01 |
| 26 | Philip Morris ČR | Kutná Hora | 3636000000 | 2022-01-01 |
| 27 | Czech Grid Holding | Prague | 3493193000 | 2021-01-01 |
| 28 | NET4GAS | Prague | 3330000000 | 2019-01-01 |
| 29 | EG.D | České Budějovice | 3216963000 | 2019-01-01 |
| 30 | Moravia Steel | Třinec | 3037000000 | 2021-01-01 |
| 31 | Kaufland Česká republika | Prague | 2933098000 | 2021-01-01 |
| 32 | Pražská energetika | Prague | 2851103000 | 2019-01-01 |
| 33 | CETIN | Prague | 2811000000 | 2019-01-01 |
| 34 | J&T Finance Group | Prague | 104285000 2688467000 |
2018-01-01 |
| 35 | Teva Czech Industries | Opava | 2574319000 | 2019-01-01 |
| 36 | Continental Barum | Otrokovice | 2491878000 | 2021-01-01 |
| 37 | innogy Česká republika | Prague | 2427000000 | 2021-01-01 |
| 38 | PPF Banka | Prague | 2352000000 | 2018-01-01 |
| 39 | E.ON Energie | České Budějovice | 2285481000 | 2021-01-01 |
| 40 | ČEPS | Prague | 2235000000 | 2020-01-01 |
End of automatically generated list.
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 |
End of automatically generated list.
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 | O2 Czech Republic | Prague | 8544000000 | 2021-01-01 |
| 7 | Agrofert | Prague | 8258029000 | 2021-01-01 |
| 8 | T-Mobile Czech Republic | Prague | 8045000000 | 2021-01-01 |
| 9 | České dráhy | Prague | 7993000000 | 2021-01-01 |
| 10 | Liberty Ostrava | Ostrava | 7209537000 | 2022-01-01 |
| 11 | Czech Property Investments | Prague | 6791011000 | 2021-01-01 |
| 12 | Lidl Česká republika | Prague | 6407301000 | 2021-01-01 |
| 13 | Avast Software | Prague | 6267334000 | 2021-01-01 |
| 14 | Plzeňský Prazdroj | Plzeň | 5893000000 | 2019-01-01 |
| 15 | NET4GAS | Prague | 5030000000 | 2019-01-01 |
| 16 | Continental HT Tyres | Otrokovice | 5008143000 | 2019-01-01 |
| 17 | Hyundai Motor Manufacturing Czech | Nižní Lhoty | 4912760000 | 2020-01-01 |
| 18 | Spolchemie | Ústí nad Labem | 4540009000 | 2019-01-01 |
| 19 | Continental Barum | Otrokovice | 4448446000 | 2021-01-01 |
| 20 | Philip Morris ČR | Kutná Hora | 4243000000 | 2022-01-01 |
| 21 | Moravia Steel | Třinec | 4228000000 | 2021-01-01 |
| 22 | CETIN | Prague | 3917000000 | 2019-01-01 |
| 23 | EG.D | České Budějovice | 3796969000 | 2019-01-01 |
| 24 | J&T Finance Group | Prague | 3557279000 | 2018-01-01 |
| 25 | Energetický a průmyslový holding | Prague | 3472000000 | 2022-01-01 |
| 26 | Heimstaden Czech | Ostrava | 3449110000 | 2019-01-01 |
| 27 | Kaufland Česká republika | Prague | 3281087000 | 2021-01-01 |
| 28 | Alza.cz | Prague | 2802641000 | 2020-01-01 |
| 29 | ČEPS | Prague | 2786000000 | 2020-01-01 |
| 30 | Iveco Czech Republic | Vysoké Mýto | 2749575000 | 2020-01-01 |
| 31 | E.ON Energie | České Budějovice | 2707005000 | 2021-01-01 |
| 32 | Teva Czech Industries | Opava | 2647918000 | 2019-01-01 |
| 33 | RWE Supply & Trading CZ | Prague | 2642000000 | 2020-01-01 |
| 34 | Albert Česká republika | Prague | 2515640000 | 2020-01-01 |
| 35 | Continental výroba pneumatik | Otrokovice | 2233869000 | 2019-01-01 |
| 36 | Tipsport Holding | Beroun | 2228439000 | 2020-01-01 |
| 37 | FTMO | Prague | 2056136000 | 2021-01-01 |
| 38 | Správa pohledávek OKD | Karviná | 2024121000 | 2018-01-01 |
| 39 | DK Holding Investments | Prague | 2019358110 | 2019-01-01 |
| 40 | Čepro | Prague | 1981000000 | 2020-01-01 |
End of automatically generated list.
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 | Energetický a průmyslový holding | Prague | 473774740000 18052000000 |
2020-12-31 |
| 7 | Raiffeisenbank (Czechia) | Prague | 370714816000 | 2019-12-31 |
| 8 | J&T Finance Group | Prague | 10911221000 281291277000 |
2018-12-31 |
| 9 | PPF Banka | Prague | 235067000000 | 2018-12-31 |
| 10 | Škoda Auto | Mladá Boleslav | 227983000000 | 2020-12-31 |
| 11 | Moneta Money Bank | Prague | 219053000000 | 2019-12-31 |
| 12 | Agrofert | Prague | 169479310000 | 2021-12-31 |
| 13 | Allwyn International | Prague | 6350300000 155772859000 |
2021-12-31 |
| 14 | Air Bank | Prague | 137369000000 | 2020-12-31 |
| 15 | Generali Česká pojišťovna | Prague | 124578000000 | 2022-12-31 |
| 16 | Fio banka | Prague | 124499585000 | 2018-12-31 |
| 17 | EP Corporate Group | Prague | 112278975000 | 2022-12-31 |
| 18 | České dráhy | Prague | 103524000000 | 2021-12-31 |
| 19 | Kooperativa pojišťovna | Prague | 100246407000 | 2021-12-31 |
| 20 | Sberbank CZ | Prague | 89404000000 | 2020-12-31 |
| 21 | Czech Property Investments | Prague | 86734637000 | 2021-12-31 |
| 22 | Orlen Unipetrol | Prague | 84589000000 | 2020-12-31 |
| 23 | Prague Public Transit Company | Prague | 83488053000 | 2019-12-31 |
| 24 | Hyundai Motor Manufacturing Czech | Nižní Lhoty | 79030850000 | 2020-12-31 |
| 25 | EG.D | České Budějovice | 74199995000 | 2019-12-31 |
| 26 | GasNet | Ústí nad Labem | 72440499000 | 2019-12-31 |
| 27 | Raiffeisen stavební spořitelna | Prague | 69056000000 | 2018-12-31 |
| 28 | CETIN | Prague | 62062000000 | 2019-12-31 |
| 29 | Moravia Steel | Třinec | 61788234000 | 2021-12-31 |
| 30 | Česká exportní banka | Prague | 57446000000 | 2018-12-31 |
| 31 | Equa bank | Prague | 55585000000 | 2018-12-31 |
| 32 | NET4GAS | Prague | 53473000000 | 2019-12-31 |
| 33 | T-Mobile Czech Republic | Prague | 48773000000 | 2021-12-31 |
| 34 | Continental Barum | Otrokovice | 46848219000 | 2021-12-31 |
| 35 | ČEPS | Prague | 44503000000 | 2020-12-31 |
| 36 | Zentiva Group | Prague | 43511437000 | 2020-12-31 |
| 37 | Lidl Česká republika | Prague | 41107680000 | 2021-02-28 |
| 38 | Liberty Ostrava | Ostrava | 41001906000 | 2022-03-31 |
| 39 | Banka Creditas | Prague | 40968300000 | 2018-12-31 |
| 40 | O2 Czech Republic | Prague | 40032000000 | 2021-12-31 |
End of automatically generated list.
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 | Energetický a průmyslový holding | Prague | 141381815000 5387000000 |
2020-12-31 |
| 3 | Česká spořitelna | Prague | 137711000000 | 2022-12-31 |
| 4 | Československá obchodní banka | Prague | 117378000000 | 2021-12-31 |
| 5 | EP Corporate Group | Prague | 112202889000 | 2022-12-31 |
| 6 | Komerční banka | Prague | 108635000000 | 2019-12-31 |
| 7 | Škoda Auto | Mladá Boleslav | 94920000000 | 2020-12-31 |
| 8 | Agrofert | Prague | 93177889000 | 2021-12-31 |
| 9 | UniCredit Bank Czech Republic and Slovakia | Prague | 81881000000 | 2021-12-31 |
| 10 | Prague Public Transit Company | Prague | 68267898000 | 2019-12-31 |
| 11 | Czech Property Investments | Prague | 67235413000 | 2021-12-31 |
| 12 | Orlen Unipetrol | Prague | 53242000000 | 2020-12-31 |
| 13 | EG.D | České Budějovice | 51429036000 | 2019-12-31 |
| 14 | Hyundai Motor Manufacturing Czech | Nižní Lhoty | 44779977000 | 2020-12-31 |
| 15 | Allwyn International | Prague | 1803300000 44234949000 |
2021-12-31 |
| 16 | Moravia Steel | Třinec | 43121000000 | 2021-12-31 |
| 17 | J&T Finance Group | Prague | 1628455000 41981570000 |
2018-12-31 |
| 18 | PaBa Software | Prague | 39176355000 | 2022-12-31 |
| 19 | České dráhy | Prague | 36870000000 | 2021-12-31 |
| 20 | GasNet | Ústí nad Labem | 35165287000 | 2019-12-31 |
| 21 | Continental Barum | Otrokovice | 34788422000 | 2021-12-31 |
| 22 | Letiště Praha | Prague | 33934261000 | 2020-12-31 |
| 23 | T-Mobile Czech Republic | Prague | 33375000000 | 2021-12-31 |
| 24 | Raiffeisenbank (Czechia) | Prague | 32702936000 | 2019-12-31 |
| 25 | ČEPS | Prague | 31609000000 | 2020-12-31 |
| 26 | Czech Grid Holding | Prague | 25936532000 | 2021-12-31 |
| 27 | Moneta Money Bank | Prague | 24411000000 | 2019-12-31 |
| 28 | Severočeské doly | Chomutov | 23017000000 | 2018-12-31 |
| 29 | innogy Česká republika | Prague | 21305401000 | 2021-12-31 |
| 30 | CETIN | Prague | 21043000000 | 2019-12-31 |
| 31 | Severočeská vodárenská společnost | Teplice | 20969474000 | 2021-12-31 |
| 32 | Pivovary Staropramen | Prague | 20265000000 | 2019-12-31 |
| 33 | Generali Česká pojišťovna | Prague | 19055000000 | 2022-12-31 |
| 34 | Liberty Ostrava | Ostrava | 18945699000 | 2022-03-31 |
| 35 | Pražská energetika | Prague | 18495399000 | 2019-12-31 |
| 36 | Kooperativa pojišťovna | Prague | 16965076000 | 2021-12-31 |
| 37 | Tesco Stores ČR | Prague | 16506000000 | 2021-02-28 |
| 38 | Overkill Alpha | Prague | 16326472000 | 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 |
End of automatically generated list.
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 | Warhorse Studios | Prague | 1130000 | 2016-01-01 | 28233000 | 0.04 |
| 4 | J&T Finance Group | Prague | 495831000 | 2018-01-01 | 104285000 2688467000 |
0.184 |
| 5 | Promet Tools | Ostrava | 23926000 | 2017-01-01 | 122253000 | 0.196 |
| 6 | ALTA Invest | Brno | 9260000 | 2017-01-01 | 45442000 | 0.204 |
| 7 | Tipsport | Beroun | 511557000 | 2022-01-01 | 1748619000 | 0.293 |
| 8 | Allwyn International | Prague | 3220800000 | 2021-01-01 | 447500000 10977175000 |
0.293 |
| 9 | Czech Ocean Shipping | Prague | 15053000 | 2019-01-01 | 49928000 | 0.301 |
| 10 | Central Group | Prague | 310494000 | 2020-01-01 | 905639000 | 0.343 |
| 11 | PSN | Prague | 115996000 | 2017-01-01 | 318973000 | 0.364 |
| 12 | UPC Czech Republic | Prague | 1014327000 | 2020-01-01 | 1941623000 | 0.522 |
| 13 | innogy Česká republika | Prague | 1301000000 | 2021-01-01 | 2427000000 | 0.536 |
| 14 | Praha Real | Prague | 440916000 | 2017-01-01 | 774627000 | 0.569 |
| 15 | Cimex Invest | Prague | 147566000 | 2019-01-01 | 217309000 | 0.679 |
| 16 | DK Holding Investments | Prague | 794244000 | 2019-01-01 | 33828000 859569480 |
0.924 |
| 17 | GasNet | Ústí nad Labem | 14196717000 | 2019-01-01 | 14987232000 | 0.947 |
| 18 | Prague Stock Exchange | Prague | 290343000 | 2022-01-01 | 283778000 | 1.023 |
| 19 | Ren Power Investment | Prague | 797000000 | 2021-01-01 | 692000000 | 1.152 |
| 20 | Budějovická investiční fond s proměnným základním kapitálem | Prague | 172875000 | 2017-01-01 | 143976000 | 1.201 |
End of automatically generated list.
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 40End of automatically generated list.
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)End of automatically generated list.
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)End of automatically generated list.