Publicidad 600x120.gif
Eredivisie 1959
1958/1959

Eredivisie 1959

  • Sparta Rotterdam
  • Rapid JC
  • Fortuna 54
  • VV Dos
  • Feyenoord
  • Ajax
  • SC Enschede
  • MVV Maastricht
  • VVV Venlo
  • PSV
  • NAC Breda
  • Elinkwijk
  • ADO Den Haag
  • FC Blauw Wit Amsterdam
  • Amsterdam FC DWS
  • Willem II
  • TSV NOAD Tilburg
  • SHS Scheveningen Holland

Eredivisie 1959

La temporada finalizó el Domingo, 31 Mayo 1959.
 
31 May 59
Finalizado
PSV PSV 0-1 SC Enschede SC Enschede más información Jugadas destacadas ...
0-1 1' András Béres
 
31 May 59
Finalizado
Rapid JC Rapid JC 2-1 VVV Venlo VVV Venlo más información Jugadas destacadas ...
0-1 1' Herman Teeuwen
2' Wiel Smeets 1-1
46' Wiel Smeets 2-1
 
31 May 59
Finalizado
Sparta Rotterdam Sparta Rotterdam 1-1 Fortuna 54 Fortuna 54 más información Jugadas destacadas 1
0-1 28' Raymond Morand
46' Tinus Bosselaar 1-1
 
31 May 59
Finalizado
TSV NOAD Tilburg TSV NOAD Tilburg 4-3 SHS Scheveningen Holland Scheveningen Holland más información Jugadas destacadas ...
1' Jan Meijer 1-0
1-1 2' Wim Zwarts
3' Jan Meijer 2-1
4' Jan Meijer 3-1
3-2 46' Eddy Moreels
3-3 47' Wim Zwarts
48' Jan Meijer 4-3
 
31 May 59
Finalizado
VV Dos VV Dos 6-1 MVV Maastricht MVV Maastricht más información Jugadas destacadas ...
1' Tonny Van Der Linden 1-0
1-1 2' Albert Ummels
46' Victor Grootaers
47' Wim Visser 3-1
48' Martin Okhuysen 4-1
49' Martin Okhuysen 5-1
50' Wim Visser 6-1
 
31 May 59
Finalizado
ADO Den Haag ADO Den Haag 7-3 Willem II Willem II más información Jugadas destacadas ...
0-1 1' Kurt Zaro
2' Roel Timmer 1-1
3' Roel Timmer 2-1
46' Lex Rijnvis 3-1
3-2 47' Piet De Jong
48' Roel Timmer 4-2
4-3 49' Piet De Jong
50' Lex Rijnvis 5-3
51' Roel Timmer 6-3
52' Theo Timmermans 7-3
 
31 May 59
Finalizado
FC Blauw Wit Amsterdam FC Blauw Wit Amsterdam 2-2 Feyenoord Feyenoord más información Jugadas destacadas ...
0-1 1' Kees Rijvers
2' Arie Van Den Berg 1-1
46' Jan Dahrs 2-1
2-2 47' Kees Rijvers
 
31 May 59
Finalizado
Amsterdam FC DWS Amsterdam FC DWS 0-2 Elinkwijk Elinkwijk más información Jugadas destacadas ...
0-1 1' Michel Kruin
0-2 46' Eef Westers
 
31 May 59
Finalizado
NAC Breda NAC Breda 2-4 Ajax Ajax más información Jugadas destacadas ...
27' Theo Laseroms 1-0
1-1 56' Piet Van Der Kuil
57' Leo Canjels 2-1
2-2 59' Jan Seelen
2-3 64' S. Swart
2-4 80' S. Swart
Equipos Puntos J. G. E. P. F. C. Forma
1 Sparta Rotterdam Sparta Rotterdam 51 34 20 11 3 83 30
  • VICTORIA
  • NAC Breda 0
  • Sparta Rotterdam 3
  • VICTORIA
  • Sparta Rotterdam 4
  • ADO Den Haag 1
  • VICTORIA
  • Amsterdam FC DWS 0
  • Sparta Rotterdam 4
  • DERROTA
  • PSV 4
  • Sparta Rotterdam 2
  • EMPATE
  • Sparta Rotterdam 1
  • Fortuna 54 1
2 Rapid JC Rapid JC 48 34 20 8 6 64 34
  • EMPATE
  • Rapid JC 0
  • Fortuna 54 0
  • VICTORIA
  • Elinkwijk 1
  • Rapid JC 3
  • VICTORIA
  • Rapid JC 4
  • Willem II 0
  • VICTORIA
  • Ajax 0
  • Rapid JC 2
  • VICTORIA
  • Rapid JC 2
  • VVV Venlo 1
3 Fortuna 54 Fortuna 54 44 34 17 10 7 56 47
  • EMPATE
  • Rapid JC 0
  • Fortuna 54 0
  • VICTORIA
  • Fortuna 54 2
  • NAC Breda 1
  • VICTORIA
  • ADO Den Haag 2
  • Fortuna 54 4
  • VICTORIA
  • Fortuna 54 2
  • Amsterdam FC DWS 1
  • EMPATE
  • Sparta Rotterdam 1
  • Fortuna 54 1
4 VV Dos VV Dos 43 34 17 9 8 86 46
  • VICTORIA
  • VV Dos 2
  • Willem II 0
  • DERROTA
  • Ajax 2
  • VV Dos 0
  • EMPATE
  • VV Dos 1
  • VVV Venlo 1
  • EMPATE
  • SHS Scheveningen H. 3
  • VV Dos 3
  • VICTORIA
  • VV Dos 6
  • MVV Maastricht 1
5 Feyenoord Feyenoord 41 34 17 7 10 84 54
  • VICTORIA
  • Feyenoord 4
  • SHS Scheveningen H. 1
  • EMPATE
  • MVV Maastricht 1
  • Feyenoord 1
  • EMPATE
  • Feyenoord 1
  • PSV 1
  • VICTORIA
  • Feyenoord 4
  • SC Enschede 2
  • EMPATE
  • FC Blauw Wit Amste. 2
  • Feyenoord 2
6 Ajax Ajax 37 34 15 7 12 77 63
  • DERROTA
  • FC Blauw Wit Amste. 1
  • Ajax 0
  • VICTORIA
  • Ajax 2
  • VV Dos 0
  • EMPATE
  • TSV NOAD Tilburg 2
  • Ajax 2
  • DERROTA
  • Ajax 0
  • Rapid JC 2
  • VICTORIA
  • NAC Breda 2
  • Ajax 4
7 SC Enschede SC Enschede 37 34 15 7 12 67 59
  • VICTORIA
  • SC Enschede 2
  • VVV Venlo 0
  • DERROTA
  • SHS Scheveningen H. 3
  • SC Enschede 2
  • DERROTA
  • SC Enschede 0
  • MVV Maastricht 2
  • DERROTA
  • Feyenoord 4
  • SC Enschede 2
  • VICTORIA
  • PSV 0
  • SC Enschede 1
8 MVV Maastricht MVV Maastricht 37 34 12 13 9 64 59
  • EMPATE
  • MVV Maastricht 1
  • PSV 1
  • EMPATE
  • MVV Maastricht 1
  • Feyenoord 1
  • VICTORIA
  • SC Enschede 0
  • MVV Maastricht 2
  • VICTORIA
  • MVV Maastricht 4
  • FC Blauw Wit Amste. 2
  • DERROTA
  • VV Dos 6
  • MVV Maastricht 1
9 VVV Venlo VVV Venlo 36 34 13 10 11 71 65
  • DERROTA
  • SC Enschede 2
  • VVV Venlo 0
  • VICTORIA
  • VVV Venlo 6
  • FC Blauw Wit Amste. 2
  • EMPATE
  • VV Dos 1
  • VVV Venlo 1
  • VICTORIA
  • VVV Venlo 5
  • TSV NOAD Tilburg 4
  • DERROTA
  • Rapid JC 2
  • VVV Venlo 1
10 PSV PSV 33 34 12 9 13 61 60
  • EMPATE
  • MVV Maastricht 1
  • PSV 1
  • VICTORIA
  • PSV 4
  • Amsterdam FC DWS 1
  • EMPATE
  • Feyenoord 1
  • PSV 1
  • VICTORIA
  • PSV 4
  • Sparta Rotterdam 2
  • DERROTA
  • PSV 0
  • SC Enschede 1
11 NAC Breda NAC Breda 32 34 13 6 15 72 72
  • DERROTA
  • NAC Breda 0
  • Sparta Rotterdam 3
  • DERROTA
  • Fortuna 54 2
  • NAC Breda 1
  • EMPATE
  • NAC Breda 1
  • Elinkwijk 1
  • VICTORIA
  • Willem II 1
  • NAC Breda 5
  • DERROTA
  • NAC Breda 2
  • Ajax 4
12 Elinkwijk Elinkwijk 30 34 11 8 15 55 57
  • DERROTA
  • TSV NOAD Tilburg 1
  • Elinkwijk 0
  • DERROTA
  • Elinkwijk 1
  • Rapid JC 3
  • EMPATE
  • NAC Breda 1
  • Elinkwijk 1
  • VICTORIA
  • Elinkwijk 3
  • ADO Den Haag 1
  • VICTORIA
  • Amsterdam FC DWS 0
  • Elinkwijk 2
13 ADO Den Haag ADO Den Haag 28 34 9 10 15 63 84
  • EMPATE
  • ADO Den Haag 4
  • Amsterdam FC DWS 4
  • DERROTA
  • Sparta Rotterdam 4
  • ADO Den Haag 1
  • DERROTA
  • ADO Den Haag 2
  • Fortuna 54 4
  • DERROTA
  • Elinkwijk 3
  • ADO Den Haag 1
  • VICTORIA
  • ADO Den Haag 7
  • Willem II 3
14 FC Blauw Wit Amsterdam Blauw Amsterdam 26 34 9 8 17 62 79
  • VICTORIA
  • FC Blauw Wit Amste. 1
  • Ajax 0
  • DERROTA
  • VVV Venlo 6
  • FC Blauw Wit Amste. 2
  • DERROTA
  • FC Blauw Wit Amste. 2
  • SHS Scheveningen H. 3
  • DERROTA
  • MVV Maastricht 4
  • FC Blauw Wit Amste. 2
  • EMPATE
  • FC Blauw Wit Amste. 2
  • Feyenoord 2
15 Amsterdam FC DWS Amsterdam 26 34 8 10 16 54 80
  • EMPATE
  • ADO Den Haag 4
  • Amsterdam FC DWS 4
  • DERROTA
  • PSV 4
  • Amsterdam FC DWS 1
  • DERROTA
  • Amsterdam FC DWS 0
  • Sparta Rotterdam 4
  • DERROTA
  • Fortuna 54 2
  • Amsterdam FC DWS 1
  • DERROTA
  • Amsterdam FC DWS 0
  • Elinkwijk 2
16 Willem II Willem II 25 34 10 5 19 60 98
  • DERROTA
  • VV Dos 2
  • Willem II 0
  • DERROTA
  • Willem II 1
  • TSV NOAD Tilburg 2
  • DERROTA
  • Rapid JC 4
  • Willem II 0
  • DERROTA
  • Willem II 1
  • NAC Breda 5
  • DERROTA
  • ADO Den Haag 7
  • Willem II 3
17 TSV NOAD Tilburg NOAD Tilburg 20 34 6 8 20 55 90
  • VICTORIA
  • TSV NOAD Tilburg 1
  • Elinkwijk 0
  • VICTORIA
  • Willem II 1
  • TSV NOAD Tilburg 2
  • EMPATE
  • TSV NOAD Tilburg 2
  • Ajax 2
  • DERROTA
  • VVV Venlo 5
  • TSV NOAD Tilburg 4
  • VICTORIA
  • TSV NOAD Tilburg 4
  • SHS Scheveningen H. 3
18 SHS Scheveningen Holland Scheveningen 18 34 7 4 23 54 111
  • DERROTA
  • Feyenoord 4
  • SHS Scheveningen H. 1
  • VICTORIA
  • SHS Scheveningen H. 3
  • SC Enschede 2
  • VICTORIA
  • FC Blauw Wit Amste. 2
  • SHS Scheveningen H. 3
  • EMPATE
  • SHS Scheveningen H. 3
  • VV Dos 3
  • DERROTA
  • TSV NOAD Tilburg 4
  • SHS Scheveningen H. 3
Copa de Europa : Sparta Rotterdam
Descenso : NOAD Tilburg, Scheveningen
JUGADORES DESTACADOS

La liga holandesa es por motivos de patrocinio denominada "Eredivisie" (Eredivisie Holland Casino), es la máxima competición de clubes de fútbol en los Países Bajos.

El actual formato de competición lleva vigente más de 50 años y es una de las categorías más populares de Europa.

El equipo mas exitoso ha sido el Ajax Amsterdam.

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  
5,873,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4946
Total Execution Time  0.4965
  CADENA URL  
/holanda1959
  GET DATOS  
$_GET['/holanda1959']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0105  SELECT type FROM routes WHERE alias = 'holanda1959'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'holanda' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1959 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  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 = 5765 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='1959' WHERE c.parentId=9 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 18:54:17' 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=2 AND last_update > '2024-03-28 18:54:17' 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=4 AND last_update > '2024-03-28 18:54:17' 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 18:54:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'holanda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1959 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events1959 e WHERE e.league_id IN (5765) 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.0117  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 (5765) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (410872,456649,521628,521629,397765,458006,397835,988081,411297,397813,397826,410759,411046,988757,408814,411008,397761,397781,397815,411280) ORDER BY rp.in_squad = 1 DESC
0.0124  SELECT e.action, count(e.action) as total, e.player_id FROM events1959 e WHERE e.league_id IN (5765) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0124  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 (5765) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0175  SELECT e.action, count(e.action) as total, e.player_id FROM events1959 e WHERE e.league_id IN (5765) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0113  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 (5765) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events1959 e WHERE e.league_id IN (5765) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0108  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 (5765) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (397781,500241,411280,456252,456255,987934,989149,456996,694723,988931) ORDER BY rp.in_squad = 1 DESC
0.0106  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 = 5765 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0105  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 = 5765 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0105  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=5765 AND rel.round=34
0.0105  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 = 5765 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0111  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 = 5765 AND esl.points > 0
0.0114  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` = 5765 ORDER BY creation_date DESC LIMIT 0, 10
0.0107  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` = 5765
0.0105  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 `calendars1959` 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` = 5765 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0111  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 events1959 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1959 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 5765 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 (1266,1267,1268,1269,1270,1271,1272,1273,1274) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0117  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 `events1959` e INNER JOIN calendars1959 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 5765 ORDER BY total DESC LIMIT 40
0.0110  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 `events1959` e INNER JOIN calendars1959 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 = 5765 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0106  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 `tables1959` 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 = 5765 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1959` 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 = 5765 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  SELECT distinct(shedule), round FROM `calendars1959` as c WHERE c.`league_id` = 5765 AND shedule >= '1959/05/01' AND shedule < '1959/06/01' ORDER BY shedule ASC
0.0110  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 = 5765 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0110  SELECT data1, data2 FROM services_tags WHERE categoryId=9
0.0110  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 9 AND l.year = 1959 ORDER BY l.group_code ASC
0.0110  SELECT group_code, extraName from `leagues` WHERE categoryId=9 AND year=1959