Publicidad 600x120.gif
Copa Checa
2023/2024

Copa Checa

 
09 Ago 23
18:00 Finalizado
FK Caslav FK Caslav 1-2 Admira Praha Admira Praha más información Jugadas destacadas 1
0-1 18' T. Lauko
68' V. Basek 1-1
1-2 100' V. Burýšek
 
09 Ago 23
18:00 Finalizado
Brandýs nad Labem Brandýs nad Labem 0-2 Chlumec nad Cidlinou Chlumec nad Cidlinou más información Jugadas destacadas ...
0-1 51' J. Slavik
0-2 67' T. Bastin
 
09 Ago 23
18:00 Finalizado
Neratovice-Byškovice Neratovice-Byškovice 0-1 Banik Most - Sous Banik Most - Sous más información Jugadas destacadas ...
0-1 11' D. Krukowski
 
15 Ago 23
17:00 Finalizado
Jiskra Rýmařov Jiskra Rýmařov 0-4 Hlučín Hlučín más información Jugadas destacadas 4
0-1 26' T. Kovala
0-2 62' Tomas Buchvaldek
0-3 67' O. Moucka
0-4 73' Dominik Smékal
 
09 Ago 23
18:00 Finalizado
Holešov Holešov 4-1 Nove Sady Nove Sady más información Jugadas destacadas ...
40' Radim Jadrnicek 1-0
1-1 43' A. Rus
74' M. Kovar 2-1
82' M. Kovar 3-1
84' I. Semenyna 4-1
 
09 Ago 23
18:00 Finalizado
Katovice Katovice 1-2 Pribram Pribram más información Jugadas destacadas ...
0-1 46' Jan Vokrinek
0-2 56' J. Necas
79' M. Pozarek 1-2
 
09 Ago 23
18:00 Finalizado
Cesky Krumlov Cesky Krumlov 0-7 Vlašim Vlašim más información Jugadas destacadas ...
0-1 14' Adam Toula
0-2 32' Adam Toula
0-3 35' Erik Biegon
0-4 45' Erik Biegon
0-5 49' P. Heppner
0-6 60' Erik Biegon
0-7 81' E. Singhateh
 
09 Ago 23
18:00 Finalizado
Petrin Plzen Petrin Plzen 2-1 Robstav Přeštice Robstav Přeštice más información Jugadas destacadas 2
9' V. Lisy 1-0
1-1 81' I. Sow
85' A. Demeter 2-1
 
22 Ago 23
18:00 Finalizado
Hranice Hranice 0-1 Uničov Uničov más información Jugadas destacadas 8
0-1 88' J. Vichta
 
09 Ago 23
18:00 Finalizado
Havířov Havířov 0-2 Unie Hlubina Unie Hlubina más información Jugadas destacadas ...
0-1 5' G. Badalyan
0-2 30' G. Badalyan
 
16 Ago 23
17:30 Finalizado
Kosmonosy Kosmonosy 1-4 Varnsdorf Varnsdorf más información Jugadas destacadas 1
0-1 10' P. Rudnytskyy
44' T. Fabián 1-1
1-2 72' Roman Zalesak
81' M. Šimáček
1-3 82' D. Kriz
1-4 86' F. Firbacher
 
08 Ago 23
18:00 Finalizado
Sokol Lanzhot Sokol Lanzhot (5) 2-2 (3) Start Brno Start Brno más información Jugadas destacadas 1
20' J. Krc 1-0
1-1 58' D. Havlín
1-2 101' R. Matulka
106' M. Avdić
107' P. Balazik 2-2
 
23 Ago 23
17:00 Finalizado
Ústí nad Orlicí Ústí nad Orlicí 0-5 Viktoria Žižkov Viktoria Žižkov más información Jugadas destacadas 6
0-1 24' D. Strombach
0-2 39' D. Strombach
0-3 70' D. Strombach
0-4 75' M. Honig
0-5 81' B. Rosa
 
16 Ago 23
17:00 Finalizado
FC Strani FC Strani 1-0 Slovan Rosice Slovan Rosice más información Jugadas destacadas 7
87' L. Miklovic 1-0
 
09 Ago 23
18:00 Finalizado
FC Vsetín FC Vsetín 3-1 Kozlovice Kozlovice más información Jugadas destacadas ...
23' J. Stuchlik 1-0
1-1 62' Štěpán Smolka
68' O. Otepka 2-1
91' Ondrej Strachon 3-1
 
15 Ago 23
17:30 Finalizado
FC Zlínsko FC Zlínsko 3-1 Frýdek-Místek Frýdek-Místek más información Jugadas destacadas 2
0-1 17' Teodor Janjus
37' O. Pernatskyi 1-1
43' Maxim Obuch
53' P. Chovan 2-1
62' P. Chovan 3-1
 
16 Ago 23
17:00 Finalizado
Žďár nad Sázavou Žďár nad Sázavou 0-3 Znojmo Znojmo más información Jugadas destacadas 1
0-1 2' D. Ferreira
0-2 16' D. Ferreira
0-3 74' K. Grgic
88' C. Vitasek
 
09 Ago 23
18:00 Finalizado
Benátky nad Jizerou Benátky nad Jizerou 0-3 Sokol Zápy Sokol Zápy más información Jugadas destacadas ...
0-1 9' Nikita Khrolenok
0-2 16' J. Duben
0-3 91' M. Kubu
 
09 Ago 23
18:00 Finalizado
Český Brod Český Brod 0-3 Loko Vltavin Loko Vltavin más información Jugadas destacadas ...
0-1 42' Daniel Michl
0-2 61' Adam Bocek
0-3 86' Carlo Maione
 
09 Ago 23
18:00 Finalizado
Havlíčkův Brod Havlíčkův Brod 0-8 Vysocina Jihlava Vysocina Jihlava más información Jugadas destacadas ...
0-1 23' M. Tall
0-2 32' M. Tall
0-3 53' F. Vedral
0-4 65' F. Vedral
0-5 76' M. Miska
0-6 82' M. Tall
0-7 88' T. Franek
0-8 90' M. Ogiomade
 
16 Ago 23
18:00 Finalizado
Benešov Benešov 1-2 Povltavská FA Povltavská FA más información Jugadas destacadas 1
0-1 17' F. Drobilek
22' T. Pilik 1-1
1-2 27' M. Novák
 
09 Ago 23
18:00 Finalizado
Klatovy Klatovy 1-6 FC Táborsko FC Táborsko más información Jugadas destacadas 1
0-1 5' P. Svatek
0-2 56' P. Svatek
0-3 59' M. Kalousek
0-4 63' J. Mach
0-5 71' P. Svatek
0-6 76' M. Kalousek
81' A. Presl 1-6
 
09 Ago 23
18:00 Finalizado
Chomutov Chomutov 0-2 Sokol Brozany Sokol Brozany más información Jugadas destacadas ...
0-1 16' M. Strada
0-2 91' C. Chukwuma
 
09 Ago 23
18:00 Finalizado
Hlinsko Hlinsko 1-0 Sokol Živanice Sokol Živanice más información Jugadas destacadas ...
71' S. Krizak 1-0
 
02 Ago 23
18:00 Finalizado
Pěnčín-Turnov Pěnčín-Turnov 1-2 Ceská Lípa Ceská Lípa más información Jugadas destacadas ...
0-1 77' M. Nosek
0-2 82' M. Bulejko
85' O. Tobiaš 1-2
 
16 Ago 23
18:00 Finalizado
Novy Bydzov Novy Bydzov 0-1 FK Kolín FK Kolín más información Jugadas destacadas 1
84' J. Lehky
 
09 Ago 23
18:00 Finalizado
Hodonín-Šardice Hodonín-Šardice (3) 2-2 (5) Vyškov Vyškov más información Jugadas destacadas 2
0-1 73' B. Kanakimana
88' M. Holek 1-1
1-2 98' I. Metsoko
105' M. Mihál 2-2
 
09 Ago 23
18:00 Finalizado
SK Kladno SK Kladno 1-0 Králův Dvůr Králův Dvůr más información Jugadas destacadas ...
84' P. Hampl 1-0
 
09 Ago 23
18:00 Finalizado
Mariánské Lázně Mariánské Lázně 4-0 Karlovy Vary Karlovy Vary más información Jugadas destacadas ...
9' A. Beranek 1-0
38' Jan Hosek 2-0
67' M. Kapolka 3-0
82' M. Kapolka 4-0
 
09 Ago 23
18:00 Finalizado
Štětí Štětí 2-3 Ústí nad Labem Ústí nad Labem más información Jugadas destacadas ...
0-1 13' Ismael Dao
0-2 27' Ismael Dao
42' J. Alberovský 1-2
71' V. Sailer
84' J. Neuman
87' Josef Štercl
88' V. Pokorny 2-2
2-3 92' Filip Gedeon
 
09 Ago 23
18:00 Finalizado
Sokol Hostouň Sokol Hostouň 1-4 FK Dukla Praha FK Dukla Praha más información Jugadas destacadas ...
0-1 20' M. Cervenka
0-2 38' M. Škoda
0-3 45' Martin Doudera
0-4 53' D. Kozel
81' L. Kosik 1-4
 
16 Ago 23
18:00 Finalizado
Spartak Sobeslav Spartak Sobeslav 1-0 Písek Písek más información Jugadas destacadas 4
74' T. Hajek 1-0
 
09 Ago 23
18:00 Finalizado
Ždírec nad Droubravou Ždírec nad Droubravou 1-4 Zbrojovka Brno Zbrojovka Brno más información Jugadas destacadas 7
0-1 3' Pavel Gaszczyk
0-2 23' J. Hladik
41' M. Svoboda 1-2
1-3 71' D. Granecny
1-4 78' W. Alli
 
16 Ago 23
17:30 Finalizado
Velke Hamry Velke Hamry 2-1 Prepere Prepere más información Jugadas destacadas 12
5' Patrik Zitka 1-0
1-1 82' M. Pavlata
99' J. Linka 2-1
 
09 Ago 23
18:00 Finalizado
Slavia HK Slavia HK 0-2 Chrudim Chrudim más información Jugadas destacadas ...
0-1 56' J. Zaviska
0-2 63' Filip Novotny
 
09 Ago 23
17:00 Finalizado
TJ Repiste TJ Repiste 0-26 Prostějov Prostějov más información Jugadas destacadas 36
0-1 10' J. Koudelka
0-2 15' J. Silny
0-3 17' J. Silny
0-4 18' L. Cienciala
0-5 31' Vojtech Bartos
0-6 32' P. Slamena
0-7 34' J. Silny
0-8 35' J. Silny
0-9 36' L. Cienciala
0-10 40' Petr Jaron
0-11 42' Petr Jaron
0-12 43' J. Silny
0-13 47' J. Silny
0-14 51' J. Silny
0-15 55' R. Bartolomeu
0-16 59' D. Moucka
0-17 60' L. Cienciala
0-18 64' J. Silny
0-19 68' M. Zapletal
0-20 71' J. Silny
0-21 74' R. Bartolomeu
0-22 82' D. Moucka
0-23 84' J. Silny
0-24 86' R. Bartolomeu
0-25 87' J. Silny
0-26 90' D. Moucka
 
08 Ago 23
18:00 Finalizado
Doubravka Doubravka 1-4 Jiskra Domažlice Jiskra Domažlice más información Jugadas destacadas 1
0-1 41' M. Fillo
0-2 45' S. Fedak
47' M. Patrovsky 1-2
1-3 56' Robert Aubrecht
1-4 86' V. Svoboda
 
09 Ago 23
18:00 Finalizado
TJ Sokol Nespeky TJ Sokol Nespeky 6-3 Motorlet Praha Motorlet Praha más información Jugadas destacadas 1
0-1 31' D. Natr
39' L. Marsoun 1-1
1-2 43' Bernardo Frizoni
48' Petr Čaloun 2-2
62' M. Turek 3-2
3-3 72' M. Stoch
97' M. Skalicky 4-3
100' T. Maca 5-3
112' Petr Čaloun 6-3
 
09 Ago 23
18:00 Finalizado
Újezd Praha 4 Újezd Praha 4 0-1 Velvary Velvary más información Jugadas destacadas ...
0-1 59' T. Kott
 
15 Ago 23
17:30 Finalizado
Šumperk Šumperk 1-5 SFC Opava SFC Opava más información Jugadas destacadas 1
0-1 15' D. Vaněček
0-2 22' J. Kadlec
0-3 37' Radim Dostal
53' Tomáš Stašák 1-3
1-4 57' D. Vaněček
1-5 66' Tomas Rataj
 
09 Ago 23
18:00 Finalizado
Vitkovice Vitkovice 0-4 Třinec Třinec más información Jugadas destacadas ...
0-1 7' R. Dedic
0-2 41' N. Zinhasovic
0-3 56' O. Machuca
56' O. Machuca 1-3
78' Timofej Barkov 2-3
2-4 78' Timofej Barkov
 
16 Ago 23
17:00 Finalizado
Vrchovina Vrchovina 1-3 SK Líšeň SK Líšeň más información Jugadas destacadas 3
0-1 20' M. Lutonský
0-2 22' Adam Vlasak
38' J. Batelka 1-2
1-3 72' M. Matocha
 
16 Ago 23
18:00 Finalizado
Tatran Brno Bohunice Tatran Brno Bohunice 2-4 SK Hanácká SK Hanácká más información Jugadas destacadas 1
0-1 41' M. Votava
43' Matheus Goncalves
0-2 66' T. Machalek
68' Marek Sehnal 1-2
73' O. Doubravsky 2-2
2-3 102' S. Charles
2-4 120' S. Charles

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
7,192,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.6856
Total Execution Time  0.6880
  CADENA URL  
/copa_republica_checa/grupo0/jornada3
  GET DATOS  
$_GET['/copa_republica_checa/grupo0/jornada3']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0122  SELECT type FROM routes WHERE alias = 'copa_republica_checa'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_republica_checa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=642 AND type_rel = 3
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 642 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1194015,1140203,962816,854403,851992) ORDER BY n.cover_points DESC, update_date DESC
0.0123  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72506 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2024' WHERE c.parentId=642 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT type,rule FROM rules WHERE categoryId = 642 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 12:28:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 12:28:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 12:28:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 12:28:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_republica_checa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0106  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 642 AND l.year = 2024
0.0112  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72506) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72506) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (291755,914651,3185861,222542,283088,296891,318847,822404,874275,3335333,3434603,53935,218731,240586,291720,300340,316555,323451,329070,330845) ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 642 AND l.year = 2024
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72506) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72506) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (214877,328483,3448352,3462022,14812,80687,154685,172005,172749,172978,173000,210859,213324,232425,243546,284095,287796,288431,291721,294040) ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 642 AND l.year = 2024
0.0108  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72506) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0122  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72506) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (80687,172978,173000,287317,291721,305694,317317,317486,328483,329453,374102,374209,539234,650670,810038,866786,914453,961878,962775,973390) ORDER BY rp.in_squad = 1 DESC
0.0108  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 642 AND l.year = 2024
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72506) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0123  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72506) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (822404,205950,276245,305977,335505,345019,71336,112301,172956,197826,206364,291521,318181,353579,430846,666000,739525,853314,866922,868646) ORDER BY rp.in_squad = 1 DESC
0.0584  SELECT SUM(rp.lineup) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 642 AND rp.year = 2024 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0440  SELECT SUM(rp.events) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 642 AND rp.year = 2024 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0105  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 642 GROUP BY l.categoryId
0.0110  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=642 GROUP BY l.year ORDER BY l.year DESC
0.0109  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=72506 AND rel.round=3
0.0109  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 72506 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0109  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 72506 AND esl.points > 0
0.0106  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 72506 ORDER BY creation_date DESC LIMIT 0, 10
0.0136  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 72506
0.0194  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72506 AND c.`round` = 3 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0140  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 72506 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (161746,161745,161750,451717,451740,161748,161747,451722,451736,451711,161749,451720,161751,495729,451707,495726,451735,451715,451724,451714,495735,451706,451734,451728,451705,495734,451737,451710,451733,451708,451716,495733,451719,451732,451729,451730,451721,451726,451739,495725,451725,495728,495732) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0110  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 3 AND e.real_date IS NOT NULL AND e.league_id = 72506 ORDER BY total DESC LIMIT 40
0.0109  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72506 AND shedule >= '2023/08/01' AND shedule < '2023/09/01' ORDER BY shedule ASC
0.0105  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 72506 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0110  SELECT data1, data2 FROM services_tags WHERE categoryId=642
0.0110  SELECT group_code, extraName from `leagues` WHERE categoryId=642 AND year=2024