4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1907
Temporada Siguiente »
Publicidad 600x120.gif
Liga Profesional Argentina 1907
1906/1907

Liga Profesional Argentina 1907

Información Histórica 
						Championship Cup - 1907 

Table:

No. Team                      G    W    D    L    Gf    Ga    P
---------------------------------------------------------------
 1. Alumni                   20   17    3    0    76    13   37 (Champion)
 2. Atlético Estudiantes     20   13    5    2    51    25   31
 3. San Isidro               20   11    3    6    51    31   25
 4. Quilmes                  20   11    2    7    44    31   24
 5. Belgrano Athletic        20   10    3    7    26    26   23
 6. Porteño                  20    8    6    6    42    41   22
 7. Reformer                 20    8    1   11    36    53   17
 8. Argentino de Quilmes     20    6    4   10    23    50   16
 9. Lomas Athletic           20    4    3   13    21    50   11
10. San Martín Athletic      20    4    2   14    24    70   10
11. Barracas Athletic        20    2    0   18    17    21    4

Notes:
 
. Barracas Athletic played 7 matches, withdrew 3 ones and forfeited the championship.
. Quilmes forfeited the championship and did not play 2 matches.

[Apr 21]					
San Martín Athletic   0:4  San Isidro               	

[Apr 28]					
Atlético Estudiantes  3:0  San Isidro               	
San Martín Athletic   2:2  Porteño                  	

[May 5]				 	
Alumni                5:1  Argentino de Quilmes [at Sportiva Argentina]
Reformer             wp:lp Lomas Athletic       [Lomas Athletic withdrew]
San Isidro            3:3  Porteño                  	

[May 9]					
Barracas Athletic     9:1  San Martín Athletic  [at Ferro Carril Oeste (BUE)]
Reformer              5:3  Porteño                  	
San Isidro            1:3  Quilmes                  	

[May 12]				 	
Argentino de Quilmes  4:2  Reformer                 	
Atlético Estudiantes  6:1  Quilmes                  	
Barracas Athletic     0:3  San Isidro           [at Ferro Carril Oeste (BUE)]
Belgrano Athletic     8:1  San Martín Athletic      	
Lomas Athletic        0:4  Alumni                   	

[May 19]				 	
Barracas Athletic     3:2  Lomas Athletic       [at Ferro Carril Oeste (BUE)]
Belgrano Athletic     5:0  Argentino de Quilmes     	
Porteño               0:4  Atlético Estudiantes          	
Reformer              0:4  Alumni                   	
San Martín Athletic   0:4  Quilmes                  	

[May 25]				 	
Alumni                7:0  San Martín Athletic  [at San Martín Athletic]
Argentino de Quilmes  2:2  Quilmes                  	
Porteño               0:0  Belgrano Athletic        	
Reformer              4:3  Barracas Athletic        	
San Isidro            3:2  Atlético Estudiantes          	

[May 26]					
Atlético Estudiantes  5:3  Reformer                 	

[May 30]				 	
Alumni                2:0  Quilmes              [at Sportiva Argentina]
Argentino de Quilmes  2:1  Barracas Athletic        	
Atlético Estudiantes wp:lp San Martín Athletic  [San Martín Athletic withdrew]
Reformer              1:2  Belgrano Athletic        	
					
[Jun 2]				 	
Atlético Estudiantes  1:1  Belgrano Athletic        	
Barracas Athletic     0:5  Alumni               [at Ferro Carril Oeste (BUE)]
Porteño               4:1  Quilmes                  	
San Martín Athletic   6:0  Reformer                 	

[Jun 9]				 	
Atlético Estudiantes  2:2  Alumni                   	
Barracas Athletic     1:4  Quilmes              [at Ferro Carril Oeste (BUE)]
Lomas Athletic        ann  Belgrano Athletic    [0:2, annulled, see Nov 11]
Porteño               2:1  Argentino de Quilmes     	
Reformer              1:4  San Isidro               	

[Jun 23]				 	
Argentino de Quilmes  2:2  San Isidro               	
Lomas Athletic        1:4  Reformer                 	
Porteño               0:2  Alumni                   	

[Jun 24]					
Belgrano Athletic     1:4  Atlético Estudiantes          	
Lomas Athletic        2:1  San Martín Athletic      	

[Jun 29]					
Atlético Estudiantes  4:1  Argentino de Quilmes     	
Belgrano Athletic    wp:lp Barracas Athletic    [Barracas Athletic withdrew]
Lomas Athletic        0:5  Quilmes                  	
San Isidro            6:0  San Martín Athletic      	

[Jun 30]				 	
Alumni                5:0  Lomas Athletic       [at Sportiva Argentina]
Belgrano Athletic     3:0  Reformer                 	
Porteño              wp:lp Barracas Athletic    [Barracas Athletic withdrew]
Quilmes               7:1  San Martín Athletic      	

[Jul 7]				 	
Alumni                4:0  Belgrano Athletic    [at Sportiva Argentina]
Lomas Athletic        2:2  Porteño                  	

[Jul 9]				 	
Lomas Athletic       wp:lp Barracas Athletic    [Barracas Athletic withdrew]
Quilmes               3:0  Argentino de Quilmes     	
San Isidro            1:2  Alumni                   	
San Martín Athletic   1:5  Belgrano Athletic

Barracas Athletic forfeited the championship. So, the following scorers were computed:

Alumni               wp:lp Barracas Athletic
Atlético Estudiantes wp:lp Barracas Athletic
Barracas Athletic    lp:wp Atlético Estudiantes
Barracas Athletic    lp:wp Belgrano Athletic
Barracas Athletic    lp:wp Porteño
Barracas Athletic    lp:wp Reformer
Barracas Athletic    lp:wp Argentino de Quilmes
Quilmes              wp:lp Barracas Athletic
San Isidro           wp:lp Barracas Athletic
San Martín Athletic  wp:lp Barracas Athletic

[Jul 14]				 	 
Alumni                7:0  Reformer             [at Sportiva Argentina]
Argentino de Quilmes  2:2  San Martín Athletic      	
Belgrano Athletic     1:3  Quilmes                  	
Lomas Athletic        2:1  San Isidro               	

[Jul 21]					
Argentino de Quilmes  0:3  Atlético Estudiantes [at Atlético Estudiantes]

[Aug 4]				 
Belgrano Athletic     0:0  Alumni                   
Porteño               2:3  San Martín Athletic      
Reformer              4:0  Argentino de Quilmes     
San Isidro            4:1  Lomas Athletic           

[Aug 11]				
Lomas Athletic        2:2  Atlético Estudiantes          
Quilmes               2:2  Porteño                  
Reformer              3:0  San Martín Athletic      

[Aug 18]				
Quilmes               3:1  San Isidro               

[Aug 25]				 
Alumni                3:2  Atlético Estudiantes [at Ferro Carril Oeste (BUE)]
Argentino de Quilmes  1:5  Porteño                  	
Reformer              2:0  Quilmes                  	
San Martín Athletic   3:2  Lomas Athletic           	

[Aug 30]				 	
Atlético Estudiantes  6:2  Porteño                  	
Belgrano Athletic     0:1  San Isidro               	
Quilmes               4:1  Lomas Athletic       [abandoned at 70]
San Martín Athletic   1:4  Alumni                   	

[Sep 1]					
Porteño               5:0  Lomas Athletic           	

[Sep 8]					
Atlético Estudiantes  1:1  Lomas Athletic           	
San Isidro            4:3  Reformer                 	

[Sep 15]				 	
Argentino de Quilmes  1:5  Alumni               [abandoned at 70]
Porteño               4:1  Reformer                 	

[Sep 22]				 	
Alumni                5:0  San Isidro           [at Ferro Carril Oeste (BUE)]
   [J. A. Brown 21, 31, 72, Eliseo Brown 26, Alfredo Brown 27]					
Belgrano Athletic     0:2  Porteño                  	
Quilmes              wp:lp Reformer             [Reformer withdrew]
San Martín Athletic   2:3  Atlético Estudiantes          	

Alumni won the championship in this round with the following line-ups:					

Alumni:	             T. Duncan; Juan Domingo Brown, Jorge Gibson Brown; 
                     Guillermo R. Ross, Carlos A. Lett, Ernesto Alejandro Brown;
                     Gottlob Eduardo Weiss, Alfredo Carrow Brown, Juan A. Brown, 
                     Eliseo Brown, J. Henry Lawrie.
                     				
San Isidro:          Carlos T. Wilson; J. S. Valle, Santiago Pío Gallino; J. A. 
                     Goodfellow, H. O. Goodfellow, Luis M. Vernet Amadeo; Lucio 
                     Burgos, W. J. Jones, Juan Olegario Gil, Juan S. Rossi, 
                     Ricardo S. Malbrán.
                     				
Referee:             W. J. Williams.				
					
[Sep 29]					
Reformer              3:3  Atlético Estudiantes          	
San Isidro            0:0  Argentino de Quilmes     	

[Oct 6]					
San Martín Athletic   n/p  Argentino de Quilmes [not played, awarded lp-wp]

[Oct 13]					
Argentino de Quilmes  3:0  Lomas Athletic           	

[Oct 20]				 	
Porteño               1:5  San Isidro               	
Quilmes               2:7  Alumni               [at Ferro Carril Oeste (BUE)]

[Oct 27]				 	
Alumni                3:3  Porteño              [at Ferro Carril Oeste (BUE)]
Lomas Athletic        5:3  Argentino de Quilmes [at Banfield]

Quilmes forfeited the championship. So the following scorers were computed:

Quilmes              lp:wp Belgrano Athletic
Quilmes              lp:wp Atlético Estudiantes

[Nov 1]					
Belgrano Athletic    wp:lp Lomas Athletic       [Lomas Athletic withdrew]

[Nov 3]					
Argentino de Quilmes wp:lp Belgrano Athletic    [Belgrano Athletic withdrew]

[Nov 10]					
San Isidro            8:0  Belgrano Athletic    [at Atlético Estudiantes]

[Nov 11]					
Lomas Athletic       lp:wp Belgrano Athletic    [Lomas Athletic withdrew, see Jun 9]
 
Table:

No. Team                      G    W    D    L    Gf    Ga    P
---------------------------------------------------------------
 1. Alumni                   20   17    3    0    76    13   37 (Champion)
 2. Atlético Estudiantes     20   13    5    2    51    25   31
 3. San Isidro               20   11    3    6    51    31   25
 4. Quilmes                  20   11    2    7    44    31   24
 5. Belgrano Athletic        20   10    3    7    26    26   23
 6. Porteño                  20    8    6    6    42    41   22
 7. Reformer                 20    8    1   11    36    53   17
 8. Argentino de Quilmes     20    6    4   10    23    50   16
 9. Lomas Athletic           20    4    3   13    21    50   11
10. San Martín Athletic      20    4    2   14    24    70   10
11. Barracas Athletic        20    2    0   18    17    21    4
 



Author:
 Osvaldo José Gorgazzi 
(osvaldogorgazzi@yahoo.com.ar)

Last updated: 26 Jun 2004

(C) Copyright Osvaldo José Gorgazzi 
and RSSSF 2004

INFORMACIÓN


La Primera división del fútbol argentino es organizada por la Asociación del Fútbol Argentino en dos torneos por temporada: el Torneo Apertura (disputado en la segunda mitad del año) y el Torneo Clausura (disputado en la primera mitad del año siguiente), en los que participan veinte equipos. Los 20 equipos juegan dos torneos por temporada a una sola vuelta: el Apertura (entre agosto y diciembre), y el Clausura (generalmente entre los meses de febrero y junio), de forma que existen dos campeones por temporada.


  USO DE MEMORIA  
4,344,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0035
Controller Execution Time ( Home / Category )  0.1353
Total Execution Time  0.1388
  CADENA URL  
/primera_division_argentina1907
  GET DATOS  
$_GET['/primera_division_argentina1907']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0047  SELECT type FROM routes WHERE alias = 'primera_division_argentina1907'
0.0067  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_argentina' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1907 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=85
0.0023  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 = 28135 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=675 ORDER BY l.group_code ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 675 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:05:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:05:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 17:05:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 17:05:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_argentina' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1907 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1907 e WHERE e.league_id IN (28135) 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.0018  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 (28135) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1907 e WHERE e.league_id IN (28135) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (28135) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events1907 e WHERE e.league_id IN (28135) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  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 (28135) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1907 e WHERE e.league_id IN (28135) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (28135) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  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 = 28135 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 28135 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  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=28135 AND rel.round=20
0.0019  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 = 28135 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0030  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 = 28135 AND esl.points > 0
0.0021  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` = 28135 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 28135
0.0019  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 `calendars1907` 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` = 28135 AND c.`round` = 20 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events1907` e INNER JOIN calendars1907 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 = 20 AND e.real_date IS NOT NULL AND e.league_id = 28135 ORDER BY total DESC LIMIT 40
0.0020  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 `events1907` e INNER JOIN calendars1907 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 = 28135 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0020  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 `tables1907` 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 = 28135 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1907` 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 = 28135 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 28135 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=675
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 675 AND l.year = 1907 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=675 AND year=1907