4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Serie D - Brasil
2023/2024

Serie D - Brasil

  • Humaitá
  • Manauara
  • Manaus
  • Porto Velho
  • Princesa Solimões
  • Rio Branco Acre
  • São Raimundo RR
  • Trem DC
  • Aguia de Maraba
  • Altos
  • Cametá
  • Fluminense PI
  • Maranhão
  • Moto Club MA
  • Ríver
  • Tocantinópolis
  • América RN
  • Atlético Cearense
  • Iguatu
  • Maracanã
  • Potiguar Mossoró
  • Santa Cruz RN
  • Sousa
  • Treze
  • ASA Arapiraquense
  • CSE
  • Itabaiana
  • Jacuipense
  • Petrolina
  • Retro FC
  • SD Juazeirense
  • Sergipe
  • Anápolis
 
22 Jun 24
Sin comenzar
CRAC CRAC x-x Capital Capital más información ...
 
22 Jun 24
Sin comenzar
Hercílio Luz Hercílio Luz x-x Barra FC Barra FC más información ...
 
22 Jun 24
Sin comenzar
Cascavel FC Cascavel FC x-x Concórdia Concórdia más información ...
 
22 Jun 24
Sin comenzar
Novo Hamburgo Novo Hamburgo x-x Cianorte Cianorte más información ...
 
22 Jun 24
Sin comenzar
EC Avenida EC Avenida x-x Brasil de Pelotas Brasil de Pelotas más información ...
 
22 Jun 24
Sin comenzar
São José São José x-x Água Santa Água Santa más información ...
 
22 Jun 24
Sin comenzar
Pouso Alegre Pouso Alegre x-x Maringá Maringá más información ...
 
22 Jun 24
Sin comenzar
Santo André Santo André x-x Inter de Limeira Inter de Limeira más información ...
 
22 Jun 24
Sin comenzar
Costa Rica Costa Rica x-x Patrocinense Patrocinense más información ...
 
22 Jun 24
Sin comenzar
Real Noroeste Real Noroeste x-x Democrata SL Democrata SL más información ...
 
22 Jun 24
Sin comenzar
Nova Iguaçu Nova Iguaçu x-x Itabuna Itabuna más información ...
 
22 Jun 24
Sin comenzar
Ipatinga FC Ipatinga FC x-x Serra FC Serra FC más información ...
 
22 Jun 24
Sin comenzar
Portuguesa RJ Portuguesa RJ x-x Audax Rio Audax Rio más información ...
 
22 Jun 24
Sin comenzar
União Rondonópolis União Rondonópolis x-x Brasiliense Brasiliense más información ...
 
22 Jun 24
Sin comenzar
Real Brasília Real Brasília x-x Mixto Mixto más información ...
 
22 Jun 24
Sin comenzar
Iporá Iporá x-x Anápolis Anápolis más información ...
 
22 Jun 24
Sin comenzar
Manauara Manauara x-x Manaus Manaus más información ...
 
22 Jun 24
Sin comenzar
Retro FC Retro FC x-x Petrolina Petrolina más información ...
 
22 Jun 24
Sin comenzar
Jacuipense Jacuipense x-x CSE CSE más información ...
 
22 Jun 24
Sin comenzar
Sergipe Sergipe x-x Itabaiana Itabaiana más información ...
 
22 Jun 24
Sin comenzar
ASA Arapiraquense ASA Arapiraquense x-x SD Juazeirense SD Juazeirense más información ...
 
22 Jun 24
Sin comenzar
Treze Treze x-x Atlético Cearense Atlético Cearense más información ...
 
22 Jun 24
Sin comenzar
Santa Cruz RN Santa Cruz RN x-x Potiguar Mossoró Potiguar Mossoró más información ...
 
22 Jun 24
Sin comenzar
Iguatu Iguatu x-x Maracanã Maracanã más información ...
 
22 Jun 24
Sin comenzar
América RN América RN x-x Sousa Sousa más información ...
 
22 Jun 24
Sin comenzar
Aguia de Maraba Aguia de Maraba x-x Moto Club MA Moto Club MA más información ...
 
22 Jun 24
Sin comenzar
Tocantinópolis Tocantinópolis x-x Ríver Ríver más información ...
 
22 Jun 24
Sin comenzar
Maranhão Maranhão x-x Cametá Cametá más información ...
 
22 Jun 24
Sin comenzar
Fluminense PI Fluminense PI x-x Altos Altos más información ...
 
22 Jun 24
Sin comenzar
São Raimundo RR São Raimundo RR x-x Humaitá Humaitá más información ...
 
22 Jun 24
Sin comenzar
Rio Branco Acre Rio Branco Acre x-x Trem DC Trem DC más información ...
 
22 Jun 24
Sin comenzar
Porto Velho Porto Velho x-x Princesa Solimões Princesa Solimões más información ...
Grupo 1 Puntos J. G. E. P. F. C.
1 Humaitá Humaitá 0 0 0 0 0 0 0
2 Manauara Manauara 0 0 0 0 0 0 0
3 Manaus Manaus 0 0 0 0 0 0 0
4 Porto Velho Porto Velho 0 0 0 0 0 0 0
5 Princesa Solimões Princesa 0 0 0 0 0 0 0
6 Rio Branco Acre Rio Branco Acre 0 0 0 0 0 0 0
7 São Raimundo RR São Raimundo 0 0 0 0 0 0 0
8 Trem DC Trem DC 0 0 0 0 0 0 0
Grupo 2 Puntos J. G. E. P. F. C.
1 Aguia de Maraba Aguia de Maraba 0 0 0 0 0 0 0
2 Altos Altos 0 0 0 0 0 0 0
3 Cametá Cametá 0 0 0 0 0 0 0
4 Fluminense PI Fluminense PI 0 0 0 0 0 0 0
5 Maranhão Maranhão 0 0 0 0 0 0 0
6 Moto Club MA Moto Club MA 0 0 0 0 0 0 0
7 Ríver Ríver 0 0 0 0 0 0 0
8 Tocantinópolis Tocantinópolis 0 0 0 0 0 0 0
Grupo 3 Puntos J. G. E. P. F. C.
1 América RN América RN 0 0 0 0 0 0 0
2 Atlético Cearense Atlético 0 0 0 0 0 0 0
3 Iguatu Iguatu 0 0 0 0 0 0 0
4 Maracanã Maracanã 0 0 0 0 0 0 0
5 Potiguar Mossoró Potiguar 0 0 0 0 0 0 0
6 Santa Cruz RN Santa Cruz RN 0 0 0 0 0 0 0
7 Sousa Sousa 0 0 0 0 0 0 0
8 Treze Treze 0 0 0 0 0 0 0
Grupo 4 Puntos J. G. E. P. F. C.
1 ASA Arapiraquense Arapiraquense 0 0 0 0 0 0 0
2 CSE CSE 0 0 0 0 0 0 0
3 Itabaiana Itabaiana 0 0 0 0 0 0 0
4 Jacuipense Jacuipense 0 0 0 0 0 0 0
5 Petrolina Petrolina 0 0 0 0 0 0 0
6 Retro FC Retro FC 0 0 0 0 0 0 0
7 SD Juazeirense SD Juazeirense 0 0 0 0 0 0 0
8 Sergipe Sergipe 0 0 0 0 0 0 0
Grupo 5 Puntos J. G. E. P. F. C.
1 Anápolis Anápolis 0 0 0 0 0 0 0
2 Brasiliense Brasiliense 0 0 0 0 0 0 0
3 Capital Capital 0 0 0 0 0 0 0
4 CRAC CRAC 0 0 0 0 0 0 0
5 Iporá Iporá 0 0 0 0 0 0 0
6 Mixto Mixto 0 0 0 0 0 0 0
7 Real Brasília Real Brasília 0 0 0 0 0 0 0
8 União Rondonópolis União 0 0 0 0 0 0 0
Grupo 6 Puntos J. G. E. P. F. C.
1 Audax Rio Audax Rio 0 0 0 0 0 0 0
2 Democrata SL Democrata SL 0 0 0 0 0 0 0
3 Ipatinga FC Ipatinga FC 0 0 0 0 0 0 0
4 Itabuna Itabuna 0 0 0 0 0 0 0
5 Nova Iguaçu Nova Iguaçu 0 0 0 0 0 0 0
6 Portuguesa RJ Portuguesa RJ 0 0 0 0 0 0 0
7 Real Noroeste Real Noroeste 0 0 0 0 0 0 0
8 Serra FC Serra FC 0 0 0 0 0 0 0
Grupo 7 Puntos J. G. E. P. F. C.
1 Água Santa Água Santa 0 0 0 0 0 0 0
2 Costa Rica Costa Rica 0 0 0 0 0 0 0
3 Inter de Limeira Inter Limeira 0 0 0 0 0 0 0
4 Maringá Maringá 0 0 0 0 0 0 0
5 Patrocinense Patrocinense 0 0 0 0 0 0 0
6 Pouso Alegre Pouso Alegre 0 0 0 0 0 0 0
7 Santo André Santo André 0 0 0 0 0 0 0
8 São José São José 0 0 0 0 0 0 0
Grupo 8 Puntos J. G. E. P. F. C.
1 Barra FC Barra FC 0 0 0 0 0 0 0
2 Brasil de Pelotas Brasil Pelotas 0 0 0 0 0 0 0
3 Cascavel FC Cascavel FC 0 0 0 0 0 0 0
4 Cianorte Cianorte 0 0 0 0 0 0 0
5 Concórdia Concórdia 0 0 0 0 0 0 0
6 EC Avenida EC Avenida 0 0 0 0 0 0 0
7 Hercílio Luz Hercílio Luz 0 0 0 0 0 0 0
8 Novo Hamburgo Novo Hamburgo 0 0 0 0 0 0 0
Series Finales : Humaitá, Manauara, Manaus, Porto Velho, Aguia de Maraba, Altos, Cametá, Fluminense PI, América RN, Atlético, Iguatu, Maracanã, Arapiraquense, CSE, Itabaiana, Jacuipense, Anápolis, Brasiliense, Capital, CRAC, Audax Rio, Democrata SL, Ipatinga FC, Itabuna, Água Santa, Costa Rica, Inter Limeira, Maringá, Barra FC, Brasil Pelotas, Cascavel FC, Cianorte
JUGADORES DESTACADOS

INFORMACIÓN

El Campeonato Brasileño de Serie D equivale a la cuarta división del Campeonato Brasileño de Fútbol.

Serie D - Brasil

28 Abr 24 00:01
28 Abr 24 20:30
Estadio Elmo Serejo Farias
28 Abr 24 21:00

  USO DE MEMORIA  
7,904,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6510
Total Execution Time  0.6529
  CADENA URL  
/serie_d_brasil/grupo1/jornada10
  GET DATOS  
$_GET['/serie_d_brasil/grupo1/jornada10']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0255  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_d_brasil' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  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=719 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 719 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 20:10:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 20:10:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 20:10:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 20:10:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0136  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_d_brasil' 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.0137  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75630) 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.0131  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 (75630) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (251349,416122,535624,104435,134139,165625,217870,228372,244144,251496,275909,276480,284683,287757,317457,321879,324953,329967,361976,362062) ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75630) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (75630) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75630) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (75630) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (369426,917649) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75630) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (75630) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT 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.league_id = 75630 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0126  SELECT 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.league_id = 75630 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0126  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 719 GROUP BY l.categoryId
0.0126  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=719 GROUP BY l.year ORDER BY l.year DESC
0.0125  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=75630 AND rel.round=10
0.0139  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 = 75630 AND esl.points > 0
0.0129  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-03-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 75630 ORDER BY creation_date DESC LIMIT 0, 10
0.0128  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-03-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 75630
0.0134  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` = 75630 AND c.`round` = 10 ORDER BY shedule ASC LIMIT 200
0.0132  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 = 75630 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 (715735,715750,715749,715748,715747,715746,715745,715744,715743,715742,715741,715740,715739,715738,715737,715736,715719,715734,715733,715732,715731,715730,715729,715728,715727,715726,715725,715724,715723,715722,715721,715720) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0151  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 = 10 AND e.real_date IS NOT NULL AND e.league_id = 75630 ORDER BY total DESC LIMIT 40
0.0132  SELECT 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.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 75630 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 75630 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 75630 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 75630 AND shedule >= '2024/06/01' AND shedule < '2024/07/01' ORDER BY shedule ASC
0.0139  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-04-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 75630 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0137  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 715443
0.0138  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 715440
0.0125  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 715447
0.0126  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 715459
0.0126  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 715435
0.0126  SELECT data1, data2 FROM services_tags WHERE categoryId=719
0.0126  SELECT group_code, extraName from `leagues` WHERE categoryId=719 AND year=2024