4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rumelange
TEMPORADA 2023/2024
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Bettembourg Bettembourg 26 62 34 54
2 FC Rodange 91 Rodange 26 56 40 48
3 Etzella Ettelbruck Etzella 26 36 26 40
4 Rumelange Rumelange 26 46 43 40
5 Mamer Mamer 26 50 37 38
6 US Hostert US Hostert 26 57 48 38
7 Résidence Walferdange Résidence 26 52 49 35
8 Koeppchen Koeppchen 26 35 39 34
9 Grevenmacher Grevenmacher 26 48 52 33
10 Avenir Beggen Avenir 26 35 45 33
11 Jeunesse Canach Jeunesse 26 33 43 33
12 Alisontia Steinsel Alisontia 26 41 48 32
13 Berdenia Berbourg Berdenia 26 31 39 32
14 Yellow Boys Weiler Yellow Boys 26 50 61 32
15 Lorentzweiler Lorentzweile 26 39 45 31
16 Blô-Weiss Medernach Blô-Weiss 26 36 58 22
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
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 72 33 59
2 Fola Esch Fola Esch 26 65 28 50
3 Jeunesse d'Esch Jeunesse 26 46 30 48
4 Progrès Niederkorn Progrès 26 45 35 44
5 Differdange 03 Differdange 26 35 33 44
6 Racing Union Racing Union 26 42 31 39
7 Una Strassen Strassen 26 46 43 39
8 Union Titus Pétange Union Titus 26 38 43 37
9 US Mondorf les Bains Mondorf 26 39 39 35
10 Etzella Ettelbruck Etzella 26 31 44 28
11 Victoria Rosport Victoria 26 33 49 28
12 US Hostert US Hostert 26 37 58 25
13 FC Luxembourg City Luxembourg 26 29 50 19
14 Rumelange Rumelange 26 34 76 16
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
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 68 14 65
2 Differdange 03 Differdange 26 65 21 65
3 Fola Esch Fola Esch 26 69 34 56
4 Progrès Niederkorn Progrès 26 57 38 44
5 Una Strassen Strassen 26 39 47 37
6 Union Titus Pétange Union Titus 26 38 33 35
7 US Mondorf les Bains Mondorf 26 29 45 30
8 Jeunesse d'Esch Jeunesse 26 38 49 29
9 Victoria Rosport Victoria 26 38 54 28
10 Racing Union Racing Union 26 38 52 27
11 FC Luxembourg City Luxembourg 26 29 47 26
12 Jeunesse Canach Jeunesse 26 30 54 23
13 Rumelange Rumelange 26 29 53 23
14 Käerjéng 97 Käerjéng 26 37 63 22
TEMPORADA 2015/2016
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 65 21 62
2 Fola Esch Fola Esch 26 61 23 62
3 Differdange 03 Differdange 26 63 32 55
4 Jeunesse d'Esch Jeunesse 26 48 30 46
5 Una Strassen Strassen 26 50 50 38
6 Progrès Niederkorn Progrès 26 41 30 36
7 US Mondorf les Bains Mondorf 26 36 34 36
8 Racing Union Racing Union 26 45 54 35
9 FC Luxembourg City Luxembourg 26 52 49 34
10 Rumelange Rumelange 26 38 52 28
11 Victoria Rosport Victoria 26 46 49 26
12 Wiltz 71 Wiltz 71 26 22 60 21
13 Etzella Ettelbruck Etzella 26 25 70 17
14 Grevenmacher Grevenmacher 26 15 53 13
TEMPORADA 2014/2015
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Fola Esch Fola Esch 26 63 21 61
2 Differdange 03 Differdange 26 61 31 59
3 F91 Dudelange Dudelange 26 54 20 54
4 Progrès Niederkorn Progrès 26 51 29 50
5 Jeunesse d'Esch Jeunesse 26 46 34 44
6 Victoria Rosport Victoria 26 36 46 31
7 Etzella Ettelbruck Etzella 26 36 50 30
8 US Mondorf les Bains Mondorf 26 30 40 29
9 Grevenmacher Grevenmacher 26 24 48 29
10 Rumelange Rumelange 26 29 38 28
11 Wiltz 71 Wiltz 71 26 29 38 27
12 Käerjéng 97 Käerjéng 26 33 51 27
13 US Hostert US Hostert 26 35 52 23
14 Jeunesse Canach Jeunesse 26 16 45 15
TEMPORADA 2013/2014
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 64 21 61
2 Fola Esch Fola Esch 26 53 19 59
3 Differdange 03 Differdange 26 53 23 51
4 Jeunesse d'Esch Jeunesse 26 47 35 43
5 Progrès Niederkorn Progrès 26 33 26 42
6 Etzella Ettelbruck Etzella 26 44 46 32
7 Käerjéng 97 Käerjéng 26 32 35 32
8 Grevenmacher Grevenmacher 26 27 34 32
9 Wiltz 71 Wiltz 71 26 40 53 31
10 Jeunesse Canach Jeunesse 26 27 42 30
11 Rumelange Rumelange 26 25 36 28
12 FC Luxembourg City Luxembourg 26 32 46 24
13 Swift Hesperange Swift 26 22 51 20
14 Racing Union Racing Union 26 22 54 18
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
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 67 20 54
2 Jeunesse d'Esch Jeunesse 26 56 37 51
3 Grevenmacher Grevenmacher 26 50 27 49
4 Differdange 03 Differdange 26 64 26 48
5 Käerjéng 97 Käerjéng 26 37 35 43
6 Fola Esch Fola Esch 26 41 30 38
7 FC Luxembourg City Luxembourg 26 54 47 38
8 CS Pétange CS Pétange 26 29 37 36
9 Progrès Niederkorn Progrès 26 32 35 33
10 Racing Union Racing Union 26 40 41 32
11 Union Kayl-Tétange Union 26 39 51 29
12 Swift Hesperange Swift 26 34 53 26
13 Rumelange Rumelange 26 27 71 19
14 US Hostert US Hostert 26 22 82 8
TEMPORADA 2010/2011
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Union Kayl-Tétange Union 26 59 31 62
2 Rumelange Rumelange 26 47 22 62
3 US Hostert US Hostert 26 50 32 52
4 Victoria Rosport Victoria 26 61 39 49
5 Obercorn Obercorn 26 50 30 47
6 Young Boys Young Boys 26 42 39 40
7 Erpeldange Erpeldange 26 57 46 37
8 Mondercange Mondercange 26 40 34 34
9 US Mondorf les Bains Mondorf 26 34 46 25
10 Koeppchen Koeppchen 26 32 46 25
11 Steinfort Steinfort 26 24 45 23
12 Green Boys Green Boys 26 31 67 21
13 Avenir Beggen Avenir 26 30 54 19
14 Minerva Lintgen Minerva 26 25 51 16
TEMPORADA 2009/2010
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Jeunesse d'Esch Jeunesse 26 45 20 57
2 F91 Dudelange Dudelange 26 60 23 54
3 Grevenmacher Grevenmacher 26 46 40 43
4 Differdange 03 Differdange 26 41 30 42
5 FC Luxembourg City Luxembourg 26 50 29 41
6 Fola Esch Fola Esch 26 49 38 41
7 Racing Union Racing Union 26 39 45 41
8 Etzella Ettelbruck Etzella 26 42 43 32
9 CS Pétange CS Pétange 26 36 42 32
10 Swift Hesperange Swift 26 33 42 29
11 Progrès Niederkorn Progrès 26 39 44 28
12 Käerjéng 97 Käerjéng 26 28 36 28
13 Rumelange Rumelange 26 27 63 22
14 Mondercange Mondercange 26 18 58 13
TEMPORADA 2008/2009
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 70 18 62
2 Differdange 03 Differdange 26 51 37 51
3 Grevenmacher Grevenmacher 26 55 29 46
4 Jeunesse d'Esch Jeunesse 26 45 27 46
5 Fola Esch Fola Esch 26 43 42 39
6 FC Luxembourg City Luxembourg 26 38 29 37
7 Progrès Niederkorn Progrès 26 53 44 36
8 Etzella Ettelbruck Etzella 26 43 48 32
9 Käerjéng 97 Käerjéng 26 39 42 31
10 Racing Union Racing Union 26 45 48 30
11 Swift Hesperange Swift 26 29 41 29
12 Rumelange Rumelange 26 34 48 27
13 Steinfort Steinfort 26 21 54 21
14 Avenir Beggen Avenir 26 16 75 13
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
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 FC Luxembourg City Luxembourg 26 59 23 57
2 Avenir Beggen Avenir 26 52 23 50
3 Fola Esch Fola Esch 26 38 29 45
4 Rumelange Rumelange 26 49 37 43
5 Union Mertert Union 26 42 31 43
6 Steinfort Steinfort 26 43 39 42
7 Obercorn Obercorn 26 44 38 40
8 Erpeldange Erpeldange 26 47 51 36
9 Sporting Mertzig Sporting 26 42 41 35
10 Jeunesse Canach Jeunesse 26 34 50 35
11 Koeppchen Koeppchen 26 40 53 33
12 CeBra 01 CeBra 01 26 36 47 26
13 US Hostert US Hostert 26 38 59 18
14 Jeunesse Schieren Jeunesse 26 26 69 13
TEMPORADA 2005/2006
LIGA LUXEMBURGO GRUPO 3
Equipo PJ GF GC Puntos
1 Wiltz 71 Wiltz 71 6 13 9 47
2 Racing Union Racing Union 6 9 9 41
3 Swift Hesperange Swift 6 10 7 36
4 Rumelange Rumelange 6 5 12 16

  USO DE MEMORIA  
7,213,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.0439
Total Execution Time  1.0451
  CADENA URL  
/historico/Rumelange
  GET DATOS  
$_GET['/historico/Rumelange']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0160  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 = 'Rumelange' 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.0145  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=12666 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=12666 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=12666 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=12666 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0297  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.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12666 AND type_rel = 2
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12666 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151  SELECT /*35 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 (532147) ORDER BY n.cover_points DESC, update_date DESC
0.0163  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 = '12666' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0165  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 = '12666' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73657 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72217 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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=12666 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149  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,71432) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 72217 AND teamId = 12666
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 73657 AND teamId = 12666
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12666
0.0150  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 = '12666' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12666' and rp.type = 4
0.0152  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 = '12666' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0172  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 = 12666 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.0169  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 = 12666 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162  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 = 12666 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0164  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 = 12666 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  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.0149  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.0149  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.0150  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.0148  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.0148  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 = 43573 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0151  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 = 33540 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 15496 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 3896 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 2786 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0150  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 = 10710 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 16225 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 10708 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0312  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 = 10707 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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.0156  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 = 16229 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2006` 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 = 10712 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2006` 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 = 10714 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC