Publicidad 600x120.gif
Bundesliga 1973
1972/1973

Bundesliga 1973

  • Bayern München
  • Köln
  • Fortuna Düsseldorf
  • Wuppertaler SV
  • B. Mönchengladbach
  • Stuttgart
  • Kickers Offenbach FC
  • Eintracht Frankfurt
  • Kaiserslautern
  • MSV Duisburg
  • Werder Bremen
  • VfL Bochum
  • Hertha BSC
  • Hamburger SV
  • Schalke 04
  • Hannover 96
  • Eintracht Braunschweig
  • Rot-Weiß Oberhausen

Bundesliga 1973

La temporada finalizó el Sábado, 09 Junio 1973.
 
09 Jun 73
15:30 Finalizado
Rot-Weiß Oberhausen Rot-Weiß Oberhausen 2-1 Kickers Offenbach FC Kickers Offenbach FC más información Jugadas destacadas ...
28' Reiner Hollmann 1-0
59' Friedhelm Dick 2-0
2-1 74' Erwin Kostedde
 
09 Jun 73
15:30 Finalizado
Werder Bremen Werder Bremen 5-2 VfL Bochum VfL Bochum más información Jugadas destacadas ...
10' Werner Weist 1-0
16' Heinz-Dieter Hasebrink 2-0
2-1 20' Michael Eggert
31' Werner Weist 3-1
3-2 54' Hans-Günter Etterich
73' H. Höttges 4-2
88' Werner Weist 5-2
 
09 Jun 73
15:30 Finalizado
Wuppertaler SV Wuppertaler SV 0-4 Hannover 96 Hannover 96 más información Jugadas destacadas ...
0-1 2' Rainer Stiller
0-2 35' Hans Siemensmeyer
0-3 72' W. Reimann
0-4 90' W. Reimann
 
09 Jun 73
15:30 Finalizado
Hertha BSC Hertha BSC 4-1 Kaiserslautern Kaiserslautern más información Jugadas destacadas ...
6' K. Müller 1-0
42' E. Beer 2-0
60' Erwin Hermandung 3-0
3-1 73' Fritz Fuchs
89' Holger Brück 4-1
 
09 Jun 73
15:30 Finalizado
Eintracht Braunschweig Eintracht Braunschweig 1-2 Fortuna Düsseldorf Fortuna Düsseldorf más información Jugadas destacadas ...
0-1 18' Gerd Zewe
23' Ludwig Bründl 1-1
1-2 63' Klaus Budde
 
09 Jun 73
15:30 Finalizado
Bayern München Bayern München 1-1 Köln Köln más información Jugadas destacadas ...
0-1 50' Herbert Hein
81' Uli Hoeneß 1-1
 
09 Jun 73
15:30 Finalizado
B. Mönchengladbach B. Mönchengladbach 3-4 Stuttgart Stuttgart más información Jugadas destacadas ...
1' Jupp Heynckes 1-0
1-1 3' Dieter Schwemmle
14' Jupp Heynckes 2-1
2-2 17' Karl-Heinz Handschuh
2-3 24' Buffy Ettmayer
2-4 49' Karl-Heinz Handschuh
53' G. Netzer 3-4
 
09 Jun 73
15:30 Finalizado
Eintracht Frankfurt Eintracht Frankfurt 1-3 MSV Duisburg MSV Duisburg más información Jugadas destacadas ...
0-1 5' Rudolf Seliger
34' Jürgen Kalb 1-1
1-2 51' Bernd Lehmann
1-3 90' B. Dietz
 
09 Jun 73
15:30 Finalizado
Schalke 04 Schalke 04 2-0 Hamburger SV Hamburger SV más información Jugadas destacadas ...
75' Klaus Beverungen 1-0
86' Nico Braun 2-0
Equipos Puntos J. G. E. P. F. C. Forma
1 Bayern München Bayern München 54 34 25 4 5 93 29
  • VICTORIA
  • Bayern München 6
  • Kaiserslautern 0
  • EMPATE
  • Fortuna Düsseldorf 0
  • Bayern München 0
  • VICTORIA
  • Bayern München 5
  • VfL Bochum 1
  • VICTORIA
  • Kickers Offenbach. 0
  • Bayern München 3
  • EMPATE
  • Bayern München 1
  • Köln 1
2 Köln Köln 43 34 16 11 7 66 51
  • VICTORIA
  • Köln 2
  • VfL Bochum 1
  • DERROTA
  • Eintracht Frankfur. 5
  • Köln 0
  • VICTORIA
  • Kickers Offenbach. 2
  • Köln 3
  • VICTORIA
  • Köln 3
  • B. Mönchengladbach 1
  • EMPATE
  • Bayern München 1
  • Köln 1
3 Fortuna Düsseldorf Fortuna 42 34 15 12 7 62 45
  • EMPATE
  • Kickers Offenbach. 1
  • Fortuna Düsseldorf 1
  • EMPATE
  • Fortuna Düsseldorf 0
  • Bayern München 0
  • VICTORIA
  • Rot-Weiß Oberhause. 0
  • Fortuna Düsseldorf 3
  • VICTORIA
  • Fortuna Düsseldorf 2
  • Werder Bremen 1
  • VICTORIA
  • Eintracht Braunsch. 1
  • Fortuna Düsseldorf 2
4 Wuppertaler SV Wuppertaler SV 40 34 15 10 9 62 49
  • DERROTA
  • Wuppertaler SV 0
  • B. Mönchengladbach 5
  • DERROTA
  • Stuttgart 4
  • Wuppertaler SV 2
  • VICTORIA
  • Wuppertaler SV 5
  • MSV Duisburg 0
  • EMPATE
  • Hamburger SV 2
  • Wuppertaler SV 2
  • DERROTA
  • Wuppertaler SV 0
  • Hannover 96 4
5 B. Mönchengladbach Mönchengladbach 39 34 17 5 12 82 61
  • VICTORIA
  • Wuppertaler SV 0
  • B. Mönchengladbach 5
  • VICTORIA
  • B. Mönchengladbach 4
  • Schalke 04 1
  • DERROTA
  • B. Mönchengladbach 0
  • Eintracht Frankfur. 2
  • DERROTA
  • Köln 3
  • B. Mönchengladbach 1
  • DERROTA
  • B. Mönchengladbach 3
  • Stuttgart 4
6 Stuttgart Stuttgart 37 34 17 3 14 71 65
  • DERROTA
  • Hertha BSC 5
  • Stuttgart 1
  • VICTORIA
  • Stuttgart 4
  • Wuppertaler SV 2
  • DERROTA
  • Schalke 04 2
  • Stuttgart 0
  • EMPATE
  • Stuttgart 2
  • Eintracht Frankfur. 2
  • VICTORIA
  • B. Mönchengladbach 3
  • Stuttgart 4
7 Kickers Offenbach FC Kickers 35 34 14 7 13 61 60
  • EMPATE
  • Kickers Offenbach. 1
  • Fortuna Düsseldorf 1
  • VICTORIA
  • VfL Bochum 2
  • Kickers Offenbach. 3
  • DERROTA
  • Kickers Offenbach. 2
  • Köln 3
  • DERROTA
  • Kickers Offenbach. 0
  • Bayern München 3
  • DERROTA
  • Rot-Weiß Oberhause. 2
  • Kickers Offenbach. 1
8 Eintracht Frankfurt Eintracht 34 34 15 4 15 58 54
  • DERROTA
  • Schalke 04 3
  • Eintracht Frankfur. 2
  • VICTORIA
  • Eintracht Frankfur. 5
  • Köln 0
  • VICTORIA
  • B. Mönchengladbach 0
  • Eintracht Frankfur. 2
  • EMPATE
  • Stuttgart 2
  • Eintracht Frankfur. 2
  • DERROTA
  • Eintracht Frankfur. 1
  • MSV Duisburg 3
9 Kaiserslautern Kaiserslautern 34 34 12 10 12 58 68
  • DERROTA
  • Bayern München 6
  • Kaiserslautern 0
  • VICTORIA
  • Kaiserslautern 6
  • Rot-Weiß Oberhause. 2
  • DERROTA
  • Werder Bremen 5
  • Kaiserslautern 1
  • VICTORIA
  • Kaiserslautern 3
  • Eintracht Braunsch. 0
  • DERROTA
  • Hertha BSC 4
  • Kaiserslautern 1
10 MSV Duisburg MSV Duisburg 33 34 12 9 13 53 54
  • EMPATE
  • Eintracht Braunsch. 1
  • MSV Duisburg 1
  • VICTORIA
  • MSV Duisburg 2
  • Hertha BSC 1
  • DERROTA
  • Wuppertaler SV 5
  • MSV Duisburg 0
  • DERROTA
  • MSV Duisburg 0
  • Schalke 04 1
  • VICTORIA
  • Eintracht Frankfur. 1
  • MSV Duisburg 3
11 Werder Bremen Werder Bremen 31 34 12 7 15 50 52
  • DERROTA
  • Werder Bremen 1
  • Hamburger SV 4
  • EMPATE
  • Hannover 96 2
  • Werder Bremen 2
  • VICTORIA
  • Werder Bremen 5
  • Kaiserslautern 1
  • DERROTA
  • Fortuna Düsseldorf 2
  • Werder Bremen 1
  • VICTORIA
  • Werder Bremen 5
  • VfL Bochum 2
12 VfL Bochum VfL Bochum 31 34 11 9 14 50 68
  • DERROTA
  • Köln 2
  • VfL Bochum 1
  • DERROTA
  • VfL Bochum 2
  • Kickers Offenbach. 3
  • DERROTA
  • Bayern München 5
  • VfL Bochum 1
  • EMPATE
  • VfL Bochum 2
  • Rot-Weiß Oberhause. 2
  • DERROTA
  • Werder Bremen 5
  • VfL Bochum 2
13 Hertha BSC Hertha BSC 30 34 11 8 15 53 64
  • VICTORIA
  • Hertha BSC 5
  • Stuttgart 1
  • DERROTA
  • MSV Duisburg 2
  • Hertha BSC 1
  • VICTORIA
  • Hertha BSC 2
  • Hamburger SV 1
  • DERROTA
  • Hannover 96 2
  • Hertha BSC 0
  • VICTORIA
  • Hertha BSC 4
  • Kaiserslautern 1
14 Hamburger SV Hamburger SV 28 34 10 8 16 53 59
  • VICTORIA
  • Werder Bremen 1
  • Hamburger SV 4
  • VICTORIA
  • Hamburger SV 1
  • Eintracht Braunsch. 0
  • DERROTA
  • Hertha BSC 2
  • Hamburger SV 1
  • EMPATE
  • Hamburger SV 2
  • Wuppertaler SV 2
  • DERROTA
  • Schalke 04 2
  • Hamburger SV 0
15 Schalke 04 Schalke 04 28 34 10 8 16 46 61
  • VICTORIA
  • Schalke 04 3
  • Eintracht Frankfur. 2
  • DERROTA
  • B. Mönchengladbach 4
  • Schalke 04 1
  • VICTORIA
  • Schalke 04 2
  • Stuttgart 0
  • VICTORIA
  • MSV Duisburg 0
  • Schalke 04 1
  • VICTORIA
  • Schalke 04 2
  • Hamburger SV 0
16 Hannover 96 Hannover 96 26 34 9 8 17 49 65
  • DERROTA
  • Rot-Weiß Oberhause. 1
  • Hannover 96 0
  • EMPATE
  • Hannover 96 2
  • Werder Bremen 2
  • DERROTA
  • Eintracht Braunsch. 3
  • Hannover 96 2
  • VICTORIA
  • Hannover 96 2
  • Hertha BSC 0
  • VICTORIA
  • Wuppertaler SV 0
  • Hannover 96 4
17 Eintracht Braunschweig Eintracht 25 34 9 7 18 33 56
  • EMPATE
  • Eintracht Braunsch. 1
  • MSV Duisburg 1
  • DERROTA
  • Hamburger SV 1
  • Eintracht Braunsch. 0
  • VICTORIA
  • Eintracht Braunsch. 3
  • Hannover 96 2
  • DERROTA
  • Kaiserslautern 3
  • Eintracht Braunsch. 0
  • DERROTA
  • Eintracht Braunsch. 1
  • Fortuna Düsseldorf 2
18 Rot-Weiß Oberhausen Rot-Weiß 22 34 9 4 21 45 84
  • VICTORIA
  • Rot-Weiß Oberhause. 1
  • Hannover 96 0
  • DERROTA
  • Kaiserslautern 6
  • Rot-Weiß Oberhause. 2
  • DERROTA
  • Rot-Weiß Oberhause. 0
  • Fortuna Düsseldorf 3
  • EMPATE
  • VfL Bochum 2
  • Rot-Weiß Oberhause. 2
  • VICTORIA
  • Rot-Weiß Oberhause. 2
  • Kickers Offenbach. 1
Copa de Europa : Bayern München
UEFA : Köln, Fortuna, Wuppertaler SV, Stuttgart
Recopa : Mönchengladbach
Descenso : Eintracht, Rot-Weiß

La Bundesliga es la competición entre los equipos de fútbol de la máxima categoría de Alemania.

En la Bundesliga el llamado clásico enfrenta al Bayern Munich contra el Werder Bremen. También existe otro clásico, entre el Schalke 04 contra el Borussia Dortmund, este es por razones geograficas. Otro clasico es el llamado clasico del sur y el norte, es el del Bayern Munich contra el Hamburgo SV.

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,820,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5618
Total Execution Time  0.5636
  CADENA URL  
/bundesliga1973
  GET DATOS  
$_GET['/bundesliga1973']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0109  SELECT type FROM routes WHERE alias = 'bundesliga1973'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1973 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8 AND type_rel = 3
0.0356  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 8 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (1308438,1308330,1308241,1308233,1308202) ORDER BY n.cover_points DESC, update_date DESC
0.0107  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 = 5435 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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='1973' WHERE c.parentId=8 GROUP BY c.id ORDER BY c.order_id ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 22:39:29' 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 22:39:29' 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 22:39:29' 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=3 AND last_update > '2024-03-28 22:39:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1973 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0158  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (5435) 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 (5435) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (321975,321968,440902,413952,440285,321976,372743,409274,370327,440864,322602,439906,440591,370277,440570,441027,256251,321977,372721,396645) ORDER BY rp.in_squad = 1 DESC
0.0267  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (5435) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0147  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 (5435) 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 events1973 e WHERE e.league_id IN (5435) 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 (5435) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (370327,413952,440599,440684,440998) ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (5435) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0107  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 (5435) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () 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 = 5435 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0106  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 = 5435 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
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=5435 AND rel.round=34
0.0108  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 = 5435 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0116  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 = 5435 AND esl.points > 0
0.0130  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 5435 ORDER BY creation_date DESC LIMIT 0, 10
0.0116  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 5435
0.0106  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 `calendars1973` 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` = 5435 AND c.`round` = 34 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 events1973 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1973 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 5435 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 (984,985,986,987,988,989,990,991,992) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0119  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 `events1973` e INNER JOIN calendars1973 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 = 5435 ORDER BY total DESC LIMIT 40
0.0113  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 `events1973` e INNER JOIN calendars1973 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 = 5435 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0109  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 `tables1973` 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 = 5435 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1973` 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 = 5435 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  SELECT distinct(shedule), round FROM `calendars1973` as c WHERE c.`league_id` = 5435 AND shedule >= '1973/06/01' AND shedule < '1973/07/01' ORDER BY shedule ASC
0.0112  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-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 5435 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0112  SELECT data1, data2 FROM services_tags WHERE categoryId=8
0.0112  SELECT group_code, extraName from `leagues` WHERE categoryId=8 AND year=1973