4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mamer
TEMPORADA 2023/2024
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Alisontia Steinsel Alisontia 0 0 0 0
2 Avenir Beggen Avenir 0 0 0 0
3 Berdenia Berbourg Berdenia 0 0 0 0
4 Bettembourg Bettembourg 0 0 0 0
5 Blô-Weiss Medernach Blô-Weiss 0 0 0 0
6 Etzella Ettelbruck Etzella 0 0 0 0
7 FC Rodange 91 Rodange 0 0 0 0
8 Grevenmacher Grevenmacher 0 0 0 0
9 Jeunesse Canach Jeunesse 0 0 0 0
10 Koeppchen Koeppchen 0 0 0 0
11 Lorentzweiler Lorentzweile 0 0 0 0
12 Mamer Mamer 0 0 0 0
13 Résidence Walferdange Résidence 0 0 0 0
14 Rumelange Rumelange 0 0 0 0
15 US Hostert US Hostert 0 0 0 0
16 Yellow Boys Weiler Yellow Boys 0 0 0 0
TEMPORADA 2022/2023
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Schifflangen Schifflangen 30 62 37 64
2 Marisca Mersch Marisca 30 65 43 58
3 Bettembourg Bettembourg 30 69 52 52
4 Jeunesse Canach Jeunesse 30 68 47 51
5 FC Rodange 91 Rodange 30 63 50 51
6 Rumelange Rumelange 30 54 49 47
7 Mamer Mamer 30 63 46 44
8 Alisontia Steinsel Alisontia 30 44 44 43
9 Berdenia Berbourg Berdenia 30 48 47 42
10 Blô-Weiss Medernach Blô-Weiss 30 39 48 39
11 Yellow Boys Weiler Yellow Boys 30 59 55 38
12 Grevenmacher Grevenmacher 30 52 55 37
13 Jeunesse Junglinster Jeunesse 30 41 52 37
14 FC Luxembourg City Luxembourg 30 42 56 32
15 Atert Bissen Atert Bissen 30 40 76 24
16 Jeunesse Schieren Jeunesse 30 36 88 13
TEMPORADA 2021/2022
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Mondercange Mondercange 30 60 29 62
2 Käerjéng 97 Käerjéng 30 70 36 61
3 Jeunesse Junglinster Jeunesse 30 56 33 57
4 Mamer Mamer 30 60 33 54
5 Rumelange Rumelange 30 73 48 49
6 Bettembourg Bettembourg 30 74 54 46
7 Schifflangen Schifflangen 30 63 55 42
8 Berdenia Berbourg Berdenia 30 49 55 42
9 Yellow Boys Weiler Yellow Boys 30 61 63 41
10 Jeunesse Canach Jeunesse 30 54 53 39
11 Blô-Weiss Medernach Blô-Weiss 30 47 56 38
12 Marisca Mersch Marisca 30 45 54 38
13 Atert Bissen Atert Bissen 30 50 67 31
14 Alisontia Steinsel Alisontia 30 56 76 30
15 US Esch US Esch 30 48 77 27
16 Union Mertert Union 30 33 110 11
TEMPORADA 2020/2021
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Rumelange Rumelange 7 23 8 18
2 US Esch US Esch 7 18 7 17
3 Mondercange Mondercange 7 14 8 15
4 Jeunesse Canach Jeunesse 6 18 9 13
5 Marisca Mersch Marisca 7 12 9 12
6 Yellow Boys Weiler Yellow Boys 7 14 9 11
7 Alisontia Steinsel Alisontia 6 11 6 11
8 Jeunesse Junglinster Jeunesse 7 10 12 10
9 Blô-Weiss Medernach Blô-Weiss 6 12 13 8
10 Bettembourg Bettembourg 7 12 17 7
11 Atert Bissen Atert Bissen 7 13 21 7
12 Mamer Mamer 7 12 14 5
13 Schifflangen Schifflangen 7 10 15 5
14 Union Mertert Union 6 5 15 5
15 Berdenia Berbourg Berdenia 7 9 20 5
16 Käerjéng 97 Käerjéng 7 9 19 3
TEMPORADA 2019/2020
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Swift Hesperange Swift 15 52 17 32
2 Wiltz 71 Wiltz 71 15 48 24 32
3 US Esch US Esch 15 32 20 28
4 Käerjéng 97 Käerjéng 15 41 28 27
5 Rumelange Rumelange 15 36 23 27
6 FC Luxembourg City Luxembourg 15 26 14 26
7 Mondercange Mondercange 15 20 18 22
8 Jeunesse Canach Jeunesse 15 28 32 21
9 Alisontia Steinsel Alisontia 15 22 34 21
10 Mamer Mamer 15 24 33 19
11 Yellow Boys Weiler Yellow Boys 15 13 24 14
12 Union Mertert Union 15 21 30 12
13 Jeunesse Junglinster Jeunesse 15 14 35 9
14 Blô-Weiss Medernach Blô-Weiss 15 8 53 3
TEMPORADA 2018/2019
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 FC Rodange 91 Rodange 26 58 18 61
2 Blue Boys Muhlenbach Blue Boys M. 26 55 25 59
3 Swift Hesperange Swift 26 73 27 55
4 US Esch US Esch 26 47 28 52
5 Käerjéng 97 Käerjéng 26 47 31 44
6 Wiltz 71 Wiltz 71 26 45 34 39
7 Union Mertert Union 26 41 41 35
8 Mamer Mamer 26 41 59 30
9 Jeunesse Junglinster Jeunesse 26 25 42 27
10 Jeunesse Canach Jeunesse 26 42 45 26
11 Erpeldange Erpeldange 26 42 63 26
12 Atert Bissen Atert Bissen 26 31 52 25
13 Koeppchen Koeppchen 26 24 65 15
14 US Sandweiler Sandweiler 26 31 72 14
TEMPORADA 2017/2018
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Etzella Ettelbruck Etzella 26 63 24 64
2 Rumelange Rumelange 26 57 28 62
3 Käerjéng 97 Käerjéng 26 71 38 53
4 Swift Hesperange Swift 26 55 46 44
5 Wiltz 71 Wiltz 71 26 62 35 42
6 Union Mertert Union 26 42 37 39
7 Blue Boys Muhlenbach Blue Boys M. 26 39 47 35
8 Jeunesse Canach Jeunesse 26 45 57 34
9 US Sandweiler Sandweiler 26 36 42 32
10 Erpeldange Erpeldange 26 39 50 30
11 Mamer Mamer 26 42 56 25
12 Norden Norden 26 38 62 24
13 Grevenmacher Grevenmacher 26 24 50 23
14 Union Kayl-Tétange Union 26 33 74 14
TEMPORADA 2016/2017
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 US Esch US Esch 26 57 31 58
2 FC Rodange 91 Rodange 26 61 40 55
3 US Hostert US Hostert 26 64 31 50
4 Etzella Ettelbruck Etzella 26 56 30 48
5 Swift Hesperange Swift 26 49 41 42
6 Wiltz 71 Wiltz 71 26 41 34 42
7 US Sandweiler Sandweiler 26 46 45 38
8 Mamer Mamer 26 41 43 36
9 Norden Norden 26 41 44 34
10 Union Mertert Union 26 41 53 34
11 Grevenmacher Grevenmacher 26 31 36 27
12 Mondercange Mondercange 26 31 54 27
13 Atert Bissen Atert Bissen 26 29 55 18
14 Avenir Beggen Avenir 26 23 74 6
TEMPORADA 2015/2016
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Käerjéng 97 Käerjéng 26 58 26 59
2 Union Titus Pétange Union Titus 26 60 28 58
3 Jeunesse Canach Jeunesse 26 52 29 50
4 US Hostert US Hostert 26 47 29 43
5 FC Rodange 91 Rodange 26 39 37 42
6 Norden Norden 26 41 46 40
7 Mondercange Mondercange 26 48 52 36
8 Mamer Mamer 26 34 38 33
9 Swift Hesperange Swift 26 37 37 32
10 US Sandweiler Sandweiler 26 39 49 30
11 Avenir Beggen Avenir 26 39 49 28
12 Erpeldange Erpeldange 26 32 50 26
13 Union Kayl-Tétange Union 26 37 47 23
14 Union Remich / Bous Union Remich 26 20 66 11
TEMPORADA 2014/2015
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 FC Luxembourg City Luxembourg 26 90 17 68
2 Racing Union Racing Union 26 62 23 65
3 Una Strassen Strassen 26 72 32 61
4 FC Rodange 91 Rodange 26 48 40 46
5 Mamer Mamer 26 50 49 35
6 Swift Hesperange Swift 26 42 49 35
7 CS Pétange CS Pétange 26 35 45 35
8 Union Kayl-Tétange Union 26 35 38 33
9 Erpeldange Erpeldange 26 45 54 32
10 US Sandweiler Sandweiler 26 37 54 30
11 Titus Lamadelaine Titus 26 30 55 25
12 Mondercange Mondercange 26 31 54 21
13 CS Muhlenbach Lusitanos Muhlenbach 26 35 60 16
14 Minerva Lintgen Minerva 26 22 64 16
TEMPORADA 2013/2014
TERCERA LUXEMBURGO GRUPO 1
Equipo PJ GF GC Puntos
1 Mamer Mamer 26 65 23 60
2 Minerva Lintgen Minerva 26 51 21 53
3 Avenir Beggen Avenir 26 44 22 51
4 Atert Bissen Atert Bissen 26 43 31 44
5 Résidence Walferdange Résidence 26 58 52 37
6 Kehlen Kehlen 26 36 38 35
7 Green Boys Green Boys 26 45 38 33
8 Steinfort Steinfort 26 40 52 33
9 Orania Vianden Orania 26 46 48 31
10 Lorentzweiler Lorentzweile 26 29 41 30
11 Wincrange Wincrange 26 38 63 30
12 Boevange/Attert Boevange/Att 26 36 52 26
13 Young Boys Young Boys 26 31 49 25
14 Feulen Feulen 26 31 63 16
TEMPORADA 2012/2013
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Swift Hesperange Swift 26 67 19 60
2 Rumelange Rumelange 26 55 31 56
3 Una Strassen Strassen 26 57 30 55
4 Victoria Rosport Victoria 26 64 30 52
5 US Sandweiler Sandweiler 26 64 40 46
6 US Hostert US Hostert 26 48 42 44
7 Erpeldange Erpeldange 26 54 55 38
8 Norden Norden 26 38 49 33
9 FC Alliance Aischdall HE Alliance 26 34 49 29
10 US Mondorf les Bains Mondorf 26 43 37 28
11 Obercorn Obercorn 26 38 55 26
12 Mondercange Mondercange 26 29 56 23
13 Mamer Mamer 26 29 58 20
14 Young Boys Young Boys 26 18 87 3
TEMPORADA 2011/2012
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Jeunesse Canach Jeunesse 26 57 19 57
2 Etzella Ettelbruck Etzella 26 76 26 56
3 Wiltz 71 Wiltz 71 26 67 37 52
4 Victoria Rosport Victoria 26 60 48 39
5 Mondercange Mondercange 26 51 49 38
6 Norden Norden 26 37 36 37
7 US Mondorf les Bains Mondorf 26 35 43 37
8 Mamer Mamer 26 33 41 34
9 Una Strassen Strassen 26 43 44 33
10 Erpeldange Erpeldange 26 43 47 33
11 Obercorn Obercorn 26 44 50 29
12 Young Boys Young Boys 26 26 61 26
13 CS Muhlenbach Lusitanos Muhlenbach 26 23 55 19
14 Koeppchen Koeppchen 26 25 64 19
TEMPORADA 2010/2011
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 Una Strassen Strassen 26 51 22 61
2 Mamer Mamer 26 46 18 52
3 Flaxweiler-Beyren Flaxweiler-B 26 47 22 48
4 US Sandweiler Sandweiler 26 46 31 46
5 CeBra 01 CeBra 01 26 37 46 40
6 US Esch US Esch 26 59 46 39
7 Clemency Clemency 26 47 42 35
8 The Belval Belvaux Belval 26 50 50 35
9 Union Mertert Union 26 44 35 34
10 Schifflangen Schifflangen 26 42 63 30
11 Munsbach Munsbach 26 31 48 26
12 Tricolore Gasperich Tricolore 26 39 58 25
13 Bettembourg Bettembourg 26 38 52 21
14 Sporting Bertrange Sporting 26 33 77 20
TEMPORADA 2009/2010
TERCERA LUXEMBURGO GRUPO 1
Equipo PJ GF GC Puntos
1 Green Boys Green Boys 26 69 44 51
2 Marisca Mersch Marisca 26 60 37 51
3 FC Alliance Aischdall HE Alliance 26 57 34 51
4 Sporting Mertzig Sporting 26 53 29 48
5 Atert Bissen Atert Bissen 26 65 55 42
6 Mamer Mamer 26 38 28 42
7 Blue Boys Muhlenbach Blue Boys M. 26 52 42 40
8 Norden Norden 26 47 41 38
9 Kehlen Kehlen 26 49 48 34
10 Wincrange Wincrange 26 38 57 31
11 Daring Echternach Daring 26 53 52 28
12 Bastendorf Bastendorf 26 38 61 23
13 Lorentzweiler Lorentzweile 26 35 75 16
14 Alisontia Steinsel Alisontia 26 32 83 14
TEMPORADA 2008/2009
TERCERA LUXEMBURGO GRUPO 1
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 26 56 31 57
2 Jeunesse Schieren Jeunesse 26 64 26 55
3 Mamer Mamer 26 47 24 48
4 FC Alliance Aischdall HE Alliance 26 60 47 45
5 Green Boys Green Boys 26 47 39 44
6 Daring Echternach Daring 26 51 40 42
7 Wincrange Wincrange 26 46 42 39
8 Bastendorf Bastendorf 26 49 46 34
9 Kehlen Kehlen 26 45 48 32
10 Lorentzweiler Lorentzweile 26 34 54 30
11 Blue Boys Muhlenbach Blue Boys M. 26 43 55 29
12 Jeunesse Gilsdorf Jeunesse 26 34 46 25
13 SC Ell SC Ell 25 24 59 16
14 Orania Vianden Orania 25 25 68 6
TEMPORADA 2007/2008
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Rumelange Rumelange 26 62 22 64
2 Fola Esch Fola Esch 26 72 25 58
3 Steinfort Steinfort 26 53 23 56
4 Mondercange Mondercange 26 76 41 50
5 Minerva Lintgen Minerva 26 48 43 43
6 Union Mertert Union 26 55 37 38
7 Jeunesse Canach Jeunesse 26 30 40 34
8 Erpeldange Erpeldange 26 42 44 33
9 Sporting Mertzig Sporting 26 34 50 29
10 Atert Bissen Atert Bissen 26 50 46 28
11 CeBra 01 CeBra 01 26 41 54 28
12 Mamer Mamer 26 37 45 26
13 CS Muhlenbach Lusitanos Muhlenbach 26 31 60 21
14 Obercorn Obercorn 26 16 117 5
TEMPORADA 2006/2007
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 71 20 65
2 Etzella Ettelbruck Etzella 26 60 30 52
3 Differdange 03 Differdange 26 71 41 48
4 Racing Union Racing Union 26 52 35 41
5 Swift Hesperange Swift 26 40 28 41
6 Grevenmacher Grevenmacher 26 43 34 41
7 Progrès Niederkorn Progrès 26 53 61 35
8 Käerjéng 97 Käerjéng 26 38 51 34
9 Jeunesse d'Esch Jeunesse 26 29 34 32
10 CS Pétange CS Pétange 26 29 38 32
11 Wiltz 71 Wiltz 71 26 31 38 31
12 Victoria Rosport Victoria 26 28 47 27
13 Mondercange Mondercange 26 23 59 18
14 Mamer Mamer 26 19 71 9

  USO DE MEMORIA  
7,059,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1538
Total Execution Time  0.1558
  CADENA URL  
/historico/Mamer
  GET DATOS  
$_GET['/historico/Mamer']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0037  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Mamer' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61772 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61772 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61772 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72217
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73657
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61772 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=349 AND type_rel = 3
0.0036  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '61772' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '61772' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '61772' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=61772 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73657,72217) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72217 AND teamId = 61772
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 73657 AND teamId = 61772
0.0022  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '61772' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61772' and rp.type = 4
0.0025  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '61772' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72217 WHERE rp.league_id = 72217 AND rp.teamId = 61772 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72217 WHERE rp.league_id = 72217 AND rp.teamId = 61772 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72217 WHERE rp.league_id = 72217 AND rp.teamId = 61772 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 61772 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0033  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 = 72217 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2023` 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 = 68290 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2022` 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 = 63502 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2021` 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 = 58341 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2020` 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 = 50175 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2019` 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 = 44303 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2018` 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 = 38948 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2017` 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 = 33790 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2016` 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 = 15637 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2015` 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 = 9524 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2014` 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 = 24764 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2013` 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 = 16223 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2012` 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 = 16224 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2011` 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 = 24756 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2010` 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 = 24752 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2009` 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 = 24750 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2008` 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 = 16228 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2007` 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 = 10705 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC