4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1941
Temporada Siguiente »
Publicidad 600x120.gif
Bundesliga 1941
1940/1941

Bundesliga 1941

Información Histórica 
						
I Ostpreussen 
-------------
1. VfB Konigsberg            12-22 (49- 7) (*)
2. Preussen Mielau           12-19 (48-12)
3. Richthofen Neukuhren      12-18 (51-15)
4. Prussia Samland           12-13 (21-29)
5. Reichsbahn Konigsberg     12- 8 (19-30)
6. SV Insterburg             12- 4 (15-53)
7. Freya Memel               12- 0 ( 6-63)
8. Ras.Preussen Konigsberg    0- 0 ( 0- 0)

II Pommern (West)
-----------------
1. LSV Stettin               14-25 (66-15) (*)
2. LSV Putniz                14-21 (61-25)
3. VfL Stettin               14-17 (39-28)
4. SC Stettin                14-17 (40-32)
5. MTV Pommerensdorf         14-13 (28-34)
6. Nordring                  14- 9 (35-47)
7. TSV Swinemunde            14- 6 (22-63)
8. Preussen Borussia         14- 4 (22-69)

II Pommern (East)
-----------------
1. Germania Stolp            10-20 (50-15)
2. Viktoria Stolp            10-12 (33-22)
3. Viktoria Kolberg          10-11 (25-22)
4. Stern Fortuna Stolp       10- 7 (17-33)
5. Phonix Koslin             10- 6 (17-34)
6. Preussen Koslin           10- 4 (13-29)

III Brandenburg
---------------
 1. Tennis Borussia Berlin   22-34 (67-41) (*)
 2. Hertha BSC Berlin        22-32 (64-44)
 3. Blau-Weiss Berlin        22-27 (49-40)
 4. Minerva'93 Berlin        22-25 (48-35)
 5. Lufthansa Berlin         22-23 (43-37)
 6. Wacker'04 Berlin         22-22 (48-52)
 7. Union Oberschoneweide    22-20 (43-39)
 8. Brandenburg SC'05        22-19 (51-47)
 9. Spandauer SV             22-19 (31-44)
10. Berliner SV'92           22-18 (37-48)
11. Elektra                  22-17 (38-51)
12. Tasmania Berlin          22- 8 (27-68)

IV Schlesien
------------
 1. Germania Konigshutte     19-33 (77-23)
 2. VfR Gleiwitz             17-31 (69-15) (*)
 3. TuS Schwientochlowitz    19-28 (42-33)
 4. FC Kattowitz             18-19 (47-39)
 5. Preussen Hindenburg      19-18 (46-44)
 6. Breslau'02               19-17 (44-49)
 7. Hertha Breslau           17-14 (32-26)
 8. Beuthen'09               18-14 (46-54)
 9. Breslau'01               18-12 (26-49)
10. Vorwarts Breslau         19- 7 (29-89)
11. VfB Liegnitz             15- 5 (17-54)

V Sachsen
---------
 1. Dresdner SC              22-43(126-22) (*)
 2. SC Planitz               22-31 (71-41)
 3. PSV Chemnitz             22-27 (98-63)
 4. Riesaer SV               22-26 (57-49) 
 5. VfB Leipzig              22-23 (55-44)
 6. Chemnitzer BC            22-23 (47-49)
 7. Tura'99 Leipzig          22-22 (60-54)
 8. Fortuna Leipzig          22-22 (52-56)
 9. BC Hartha                22-20 (62-57)
10. Sportfreunde'01          22-17 (59-81)
11. SC Wacker                22- 8 (32-97)
12. VfB Glauchau             22- 3 (20-126)

totaal: 264-265 (739-739)

VI Mitte
--------
1. Sportfreunde Jena         14-26 (54-11) (*)
2. Dessau'05                 14-19 (53-25)
3. Thuringen Weida           14-15 (29-29)
4. Kr.Viktoria Magdeburg     14-14 (30-19)
5. SV Zeitz                  14-13 (32-41)
6. VfL'96 Halle              14-11 (23-36)
7. SV Gera                   14- 9 (20-37)
8. SC Apolda                 14- 5 (20-52)

totaal: 112-112 (261-250)

VII Nordmark
------------
 1. Hamburger SV             21-42 (98-23) (*)
 2. TV Eimsbuttel            22-34 (86-35)
 3. Polizei Lubeck           22-28 (67-41)
 4. Victoria Hamburg         22-28 (68-54)
 5. Holstein Kiel            22-24 (71-52)
 6. FC Altona'93             22-21 (56-53)
 7. Barmbeck SG              21-20 (51-67)
 8. Wilhelmsburg'09          22-19 (41-47)
 9. Fortuna Gluckst.         22-16 (63-80)
10. St.George/Sperber        22-14 (42-73)
11. Borussia Harburg         22-12 (36-82)
12. Concordia Wandsb.        22- 4 (24-96)

VIII Niedersachsen (North)
--------------------------
1. VfL Osnabruck             10-17 (25-12)
2. Werder Bremen             10-12 (31-15)
3. Wilhelmshaven'05          10-11 (34-23)
4. Schinkel'04 Osnabruck     10-10 (24-25)
5. Blumenthaler SV           10- 6 (18-31)
6. Gropelingen               10- 4 (20-46)

VIII Niedersachsen (South)
--------------------------
1. Hannover'96               10-18 (48-13)
2. Eintracht Braunschweig    10-17 (48-12)
3. Arminia Hannover          10-10 (21-31)
4. Linden'07                 10- 9 (34-32)
5. Gottingen'05              10- 4 (14-42)
6. Hildesheim                10- 2 (23-58)

VIII Niedersachsen (Final)
---------------------------    
1. Hannover'96               2-3 (4-2) (*)
2. VfL Osnabruck             2-1 (2-4)

IX Westfalen 
------------
 1. FC Schalke'04 Gelsenk.   22-43(101-13) (*)
 2. Gelsenguss Gelsenkirchen 22-29 (52-29)
 3. VfB Bielefeld            22-29 (53-33)
 4. Borussia Dortmund        22-24 (62-50)
 5. Westfalia Herne          22-23 (50-37)
 6. Arminia Bielefeld        22-23 (56-53)
 7. SpVgg Rochlinghausen     22-22 (50-47)
 8. VfL Bochum               22-21 (51-54)
 9. DSC Hagen                22-19 (41-52)
10. Arminia Marten           22-15 (35-71)
11. Union Gelsenkirchen      22-13 (29-64)
12. Preussen Munster         22- 3 (28-105)

X Niederrhein
-------------
1. Helene Altenessen         18-26 (49-27) (*)
2. Rot-Weiss Essen           18-21 (49-26)
3. Hamborn'07                18-19 (43-29)
4. Fortuna Dusseldorf        18-17 (40-42)
5. Rot-Weiss Oberhausen      18-17 (39-42) 
6. Turu Dusseldorf           18-16 (38-46)
7. Duisburg'48/99            18-16 (30-45)
8. Westde.Hamborn            18-15 (32-31)
9. VfR Ohligs                18- 8 (22-83)

totaal: 162-155 (342-371)
       
XI Mittelrhein
--------------
 1. VfL'99 Koln              18-29 (97-27) (*)
 2. VfR Koln                 18-23 (50-34)
 3. Duren'99                 18-22 (47-40)
 4. SV Mulheim               18-22 (46-45)
 5. SSV Troisdorf            18-19 (62-40)
 6. Sulz'07                  18-19 (40-38)
 7. FV Bonn                  18-13 (36-43)
 8. Tura Bonn                18-12 (36-53)
 9. SV Andernach             18-12 (29-66)
10. SV Beuel                 18- 7 (27-84)

totaal: 180-178 (470-470)

XII Hessen (North)
------------------
1. Sport Kassel              8-13 (28-13)
2. SC'03 Kassel              8-11 (22-13)
3. Spielverein Kassel        8- 8 (14-12)
4. Kurhessen Kassel          8- 6 ( 9-11)
5. Hermannia Kassel          8- 2 (15-39) 

XII Hessen (South)
------------------
1. Borussia Fulda            10-16 (34- 8)
2. FC Hanau'93               10-14 (38-13)
3. VfB Grossauheim           10-13 (31-17)
4. Hanau 1860                10-12 (29-18) 
5. Dunlop Hanau              10- 5 (18-48)
6. SpVgg Langenselbold       10- 0 ( 6-52)

XII Hessen (Final)
------------------
1. Borussia Fulda            2-2 (9-5) (*)
2. Sport Kassel              2-2 (5-9) 

XIII Sudwest (Main/Hessen)
--------------------------
1. Kickers Offenbach         14-27 (54-12) (*)
2. Rot-Weiss Frankfurt       14-20 (35-15)
3. Eintracht Frankfurt       14-17 (35-23)
4. Wormatia Worms            14-12 (34-32)
5. FSV Frankfurt             14-12 (25-34)
6. Union Niederrad           14-11 (24-33)
7. SV Wiesbaden              14- 8 (20-41)
8. Germania'94 Frankfurt     14- 5 (17-24)

totaal: 112-112 (244-214)

XIII Sudwest (Saar/Pfalz)
-------------------------
1. FV Saarbrucken            14-19 (35-16)
2. FC Kaiserslautern         14-16 (41-31)
3. Borussia Neunkirchen      14-15 (48-29)
4. VfR Frankenthal           14-15 (40-39)
5. SV Mundenheim             14-15 (30-27)
6. FK Pirmasens              14-14 (46-29)
7. TSG Ludwigshafen          14-14 (24-24)
8. TSG Burbach               14- 4 (14-83)

XIII Sudwest (Final)
--------------------
1. Offenbacher Kickers       2-3 (5-4)
2. FV Saarbrucken            2-1 (4-5)

XIV Baden
---------
1. VfL Neckarau              16-27 (46-17) (*)
2. VfB Muhlburg              16-25 (54-21)
3. SV Waldhof Mannheim       16-19 (44-27)
4. VfR Mannheim              16-19 (41-31)
5. Freiburger FC             16-17 (42-36)
6. Phonix Karlsruhe          16-12 (30-53)
7. SpVgg Sandhofen           16-11 (36-51)
8. FC Pforzheim              16-10 (37-41)
9. Karlsruher FV             16- 4 (11-69)

totaal: 144-144 (341-346)

XIVa Elsass (group 1)
---------------------
1. RSC Strassburg            14-24 (36-14)
2. Schiltigheim              14-22 (43-21) 
3. SS Strassburg             14-18 (62- 3)
4. Hagenau 1900              14-14 (30-32)
5. Mars Bischh.              14-12 (26-36)
6. Schlettstadt              14-11 (32-30)
7. SV Strassburg             14- 9 (32-57)
8. VfL Bischweiler           14- 2 (22-70)

totaal: 112-112 (283-263)

XIVa Elsass (group 2) 
---------------------
1. Muhlhausen 1893           14-24 (70-15)
2. SV Kolmar                 14-21 (66-15)
3. Wittenheim                14-18 (32-28)
4. FC Kolmar                 14-17 (40-30)
5. SV Muhlhausen'41          14-14 (28-37)
6. Muhlhausen/Dornach        14- 8 (30-58)
7. Wittelsheim               14- 8 (22-51)
8. St.Ludwig                 14- 2 (19-73)

XIVa Elsass (Final)
-------------------
1. Muhlhausen 1893           2-2 (4-3) (*)
2. RSC Strassburg            2-2 (3-4) 

XV Wurttemberg
--------------
 1. Stuttgarter Kickers      22-37 (88-28) (*)
 2. VfB Stuttgart            22-37 (88-28) 
 3. Stuttgarter Sportfreunde 22-27 (62-47) 
 4. Stuttgarter Sportclub    22-26 (61-36) 
 5. Feuerbach                22-23 (50-57)
 6. VfR Aalen                22-22 (62-59)
 7. SSV Ulm 1846             22-23 (56-55)
 8. TSG'46 Ulm               22-21 (44-45)
 9. Union Bockingen          22-19 (62-68)
10. Unterturkheim            22-18 (46-64)
11. SV Bad Cannstadt         22- 7 (29-73)
12. Esslingen                22- 2 (27-114)

totaal: 264-262 (675-674)

XVI Bayern
----------
 1. TSV 1860 Munchen         22-35 (83-30) (*)
 2. FC Nurnberg              22-31 (52-24)
 3. BC Augsburg              22-29 (44-32)
 4. SpVgg Furth              22-27 (63-45)
 5. Jahn Regensburg          21-25 (45-36)
 6. WKG Neumeyer Nurnberg    22-23 (44-34)
 7. Bayern Munchen           20-19 (35-35)
 8. Schwaben Augsburg        22-19 (44-51)
 9. FC Schweinfurt'05        20-18 (38-32)
10. Wacker Munchen           22-16 (35-60)
11. VfR Schweinfurt          21- 9 (24-64)
12. Kickers Wurzburg         22- 7 (22-87)

totaal: 258-258 (529-530)

XVII Ostmark
------------
 1. Rapid Wien               18-28 (82-29) (*)
 2. Wacker Wien              18-24 (60-33) 
 3. First Vienna Wien        18-24 (52-33) 
 4. Austria Wien             18-22 (56-22) 
 5. Admira Wien              18-21 (56-46)
 6. Wiener Sportklub         18-18 (47-37) 
 7. FC Wien                  18-17 (42-40)  
 8. FAC Wien                 18-17 (40-60)
 9. Grazer SC                18- 9 (26-62)  
10. Linzer ASK               18- 0 (17-106) 

totaal: 180-180 (478-468)

XVIII Sudetenland (West)
------------------------
1. LSV Pilsen                2-4 (9-4) 
2. NSTG Brux                 2-0 (4-9)
3. Graslitz                  0-0 (0-0)
3. NSTG Karlsbad             0-0 (0-0)
3. Asch                      0-0 (0-0)
3. Eger                      0-0 (0-0)

XVIII Sudetenland (East)
------------------------
1. NSTG Prag                 6-11 (18- 4) (*)
2. NSTG Teplitz              6- 7 (19-11)
3. NSTG Prosetitz            6- 5 (10-10)
4. NSTG Aussig               6- 1 ( 4-26)
5. NSTG Gablonz              0- 0 ( 0- 0)
5. Leipa                     0- 0 ( 0- 0)

XIX Danzig-Westpreussen
-----------------------
1. Preussen Danzig           10-20 (54- 2) (*)
2. Viktoria Elbing            9- 9 (23-26)
3. SG Neufahrwasser          10-10 (19-25)
4. Hansa Elbing              10-10 (23-26)
5. BuEV Danzig                9- 6 (19-29)
6. Polizei Danzig            10- 5 (16-38)

totaal: 58-60 (154-146) 


(National play-offs):

All 19 gau-liga champions take part in the play-offs,
along with the winner of gauliga 14a (Elsass).
Germania Konigshutte is replaced by VfR Gleiwitz 
(see gauliga 4).

Group 1a:
---------
Vorwarts Gleiwitz - LSV Stettin      3-1 2-3
Vorwarts Gleiwitz - Preussen Danzig  0-0 4-1
LSV Stettin       - Preussen Danzig  3-3 1-1

1. Vorwarts Gleiwitz(Sc)     4-5 (9-5)  2 1 1
2. LSV Stettin(Po)           4-4 (8-9)  1 2 1
3. Preussen Danzig(DW)       4-3 (5-8)  0 3 1

Group 1b:
---------
Dresdner SC     - Tennis Borussia  1-0 5-2
Dresdner SC     - NSTG Prag        4-2 1-0
Tennis Borussia - NSTG Prag        3-1 0-0

1. Dresdner SC(Sa)           4-8 (11-4)  4 0 0
2. Ten.Borussia Berlin(Br)   4-3 ( 5-7)  1 1 2
3. NSTG Prag(Sl)             4-1 ( 3-8)  0 1 3

Final Group 1:
--------------
Dresdner SC(Sa)-Vorwarts Gleiwitz(Sc) 3-0 en 3-0

Group 2a:
---------
Hamburger SV - SV Jena         2-1 2-2
Hamburger SV - VfB Konigsberg  3-1 2-1
SV Jena      - VfB Konigsberg  4-0 2-4

1. Hamburger SV(Nm)          4-7 (9- 5)  3 1 0
2. SV Jena(Mi)               4-3 (9- 8)  1 1 2
3. VfB Konigsberg(Op)        4-2 (6-11)  1 0 3

Group 2b:
---------
FC Schalke'04 - Hannover'96     4-0 6-1
FC Schalke'04 - Borussia Fulda  4-0 2-1
Hannover'96   - Borussia Fulda  6-1 3-4

1. Schalke'04 Gelsenk.(We)   4-8 (16- 2)  4 0 0 
2. Hannover'96(Ns)           4-2 (10-15)  1 0 3
3. Borussia Fulda(He)        4-2 ( 6-15)  1 0 3

Final Group 2:
--------------
FC Schalke'04 Gelsenkirchen(We)-Hamburger SV(Nm) 3-0 en 0-1

Group 3:
--------
TuS Helene Altenessen - Kickers Offenbach  1-1 0-4
TuS Helene Altenessen - VfL Koln'99        1-3 6-1
TuS Helene Altenessen - FC Mulhausen'93    5-2 2-2
Kickers Offenbach     - VfL Koln'99        2-2 1-3
Kickers Offenbach     - FC Mulhausen'93    6-2 5-1
VfL Koln'99           - FC Mulhausen'93    6-1 4-1

1. VfL Koln'99(Mr)           6-9 (19-12)  4 1 1
2. Kickers Offenbach(Sw)     6-8 (19- 9)  3 2 1
3. TuS Helene Altenessen(Nr) 6-6 (15-13)  2 2 2
4. FC Mulhausen'93(El)       6-1 ( 9-28)  0 1 5

Group 4:
--------
Rapid Wien          - TSV 1860 Munchen     1-2 2-0
Rapid Wien          - Stuttgarter Kickers  1-1 5-1
Rapid Wien          - VfL Neckarau         7-0 8-1
TSV 1860 Munchen    - Stuttgarter Kickers  3-3 2-1
TSV 1860 Munchen    - VfL Neckarau         6-2 1-2
Stuttgarter Kickers - VfL Neckarau         2-0 3-5

1. Rapid Wien(Om)            6-9 (24- 5)  4 1 1
2. TSV 1860 Munchen(By)      6-7 (14-11)  3 1 2
3. Stuttgarter Kickers(Wb)   6-4 (11-16)  1 2 3
4. VfL Neckarau(Bd)          6-4 (10-27)  2 0 4


Semi-finals:
------------
Rapid Wien(Om)          - Dresdner SC(Sa)    2-1
FC Schalke'04 Gels.(We) - VfL Koln'99(Mr)    4-1

3/4 Place:
----------
Dresdner SC(Sa)         - VfL Koln'99(Mr)    4-1


Final (in Berlin):
------------------
Rapid Wien(Om)          - FC Schalke'04(We)  4-3


Champions: Rapid Wien




Author: Dinant Abbink

Last updated: 7 Mar 2013

(C) Copyright Dinant Abbink and RSSSF 2001/13

INFORMACIÓN

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 MEMORIA  
4,357,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7242
Total Execution Time  0.7262
  CADENA URL  
/bundesliga1941
  GET DATOS  
$_GET['/bundesliga1941']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0144  SELECT type FROM routes WHERE alias = 'bundesliga1941'
0.0292  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 = 1941 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0700  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.0150  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 (1312758,1312688,1312692,1312567,1312550) ORDER BY n.cover_points DESC, update_date DESC
0.0150  SELECT text_es as historical_text FROM leagues_text WHERE id=3194
0.0145  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 = 31410 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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='1941' WHERE c.parentId=8 GROUP BY c.id ORDER BY c.order_id ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 22:38:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 22:38:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 22:38:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 22:38:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  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 = 1941 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1941 e WHERE e.league_id IN (31410) 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.0144  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 (31410) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events1941 e WHERE e.league_id IN (31410) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0144  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 (31410) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events1941 e WHERE e.league_id IN (31410) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (31410) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1941 e WHERE e.league_id IN (31410) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (31410) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 31410 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0144  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 = 31410 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0144  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 8 GROUP BY l.categoryId
0.0144  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=8 GROUP BY l.year ORDER BY l.year DESC
0.0149  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=31410 AND rel.round=3
0.0145  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 = 31410 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0145  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 = 31410 AND esl.points > 0
0.0145  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-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 31410 ORDER BY creation_date DESC LIMIT 0, 10
0.0149  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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 31410
0.0145  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 `calendars1941` 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` = 31410 AND c.`round` = 3 ORDER BY shedule ASC LIMIT 200
0.0144  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 `events1941` e INNER JOIN calendars1941 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 = 31410 ORDER BY total DESC LIMIT 40
0.0145  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 `events1941` e INNER JOIN calendars1941 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 = 31410 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0145  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 `tables1941` 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 = 31410 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1941` 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 = 31410 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 31410 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0145  SELECT data1, data2 FROM services_tags WHERE categoryId=8
0.0145  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 8 AND l.year = 1941 ORDER BY l.group_code ASC
0.0145  SELECT group_code, extraName from `leagues` WHERE categoryId=8 AND year=1941