4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del RSB Berkane

RSB Berkane

Entrenador: Moïn Chaabani

Temporada 2023/2024
TEMPORADA 2023/2024
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 27 58 19 64
2 Raja Casablanca Raja 26 43 14 60
3 RSB Berkane RSB Berkane 25 30 15 43
4 Wydad Casablanca Wydad 26 29 24 40
5 FUS Rabat FUS Rabat 26 27 24 39
6 Olympic Safi Olympic Safi 27 26 23 38
7 UTS Rabat UTS Rabat 27 29 29 37
8 Moghreb Tetouan Moghreb 25 23 21 33
9 Renaissance Zemamra Renaissance 26 29 32 31
10 Hassania Agadir Hassania 27 26 37 30
11 Maghreb Fes Maghreb Fes 26 29 31 29
12 Ittihad Tanger Ittihad 27 27 36 29
13 JS Soualem JS Soualem 27 26 39 27
14 SCC Mohammédia Mohammédia 27 19 36 24
15 Mouloudia Oujda Mouloudia 27 19 41 24
16 Youssoufia Berrechid Youssoufia 26 18 37 19
TEMPORADA 2022/2023
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 30 50 19 67
2 Wydad Casablanca Wydad 30 47 21 66
3 FUS Rabat FUS Rabat 30 36 16 55
4 Olympic Safi Olympic Safi 30 34 28 47
5 Raja Casablanca Raja 30 31 26 44
6 RSB Berkane RSB Berkane 30 31 29 44
7 Hassania Agadir Hassania 30 30 29 39
8 UTS Rabat UTS Rabat 30 34 40 36
9 JS Soualem JS Soualem 30 31 40 36
10 Maghreb Fes Maghreb Fes 30 27 33 34
11 Mouloudia Oujda Mouloudia 30 30 35 32
12 SCC Mohammédia Mohammédia 30 27 36 31
13 Moghreb Tetouan Moghreb 30 28 41 30
14 Ittihad Tanger Ittihad 30 23 39 29
15 Olympique Khouribga Olympique 30 29 36 28
16 Difaâ El Jadida Difaâ 30 24 44 25
TEMPORADA 2021/2022
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 46 24 63
2 Raja Casablanca Raja 30 41 21 60
3 FAR Rabat FAR Rabat 30 38 29 48
4 Maghreb Fes Maghreb Fes 30 28 17 45
5 FUS Rabat FUS Rabat 30 34 30 43
6 RSB Berkane RSB Berkane 30 39 33 41
7 Olympic Safi Olympic Safi 30 29 27 39
8 Difaâ El Jadida Difaâ 30 32 40 38
9 JS Soualem JS Soualem 30 37 38 36
10 Olympique Khouribga Olympique 30 32 37 36
11 SCC Mohammédia Mohammédia 30 27 32 34
12 Hassania Agadir Hassania 30 26 30 34
13 Ittihad Tanger Ittihad 30 31 41 33
14 Mouloudia Oujda Mouloudia 30 35 38 33
15 Rapide Oued Zem Rapide Oued 30 19 39 29
16 Youssoufia Berrechid Youssoufia 30 25 43 26
TEMPORADA 2020/2021
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 58 26 67
2 Raja Casablanca Raja 30 48 26 59
3 FAR Rabat FAR Rabat 30 39 29 51
4 RSB Berkane RSB Berkane 30 37 36 45
5 Mouloudia Oujda Mouloudia 30 38 35 42
6 Hassania Agadir Hassania 30 23 24 37
7 Maghreb Fes Maghreb Fes 30 30 34 36
8 Ittihad Tanger Ittihad 30 29 36 36
9 SCC Mohammédia Mohammédia 30 26 25 35
10 FUS Rabat FUS Rabat 30 32 36 35
11 Difaâ El Jadida Difaâ 30 32 40 35
12 Olympic Safi Olympic Safi 30 30 41 35
13 Youssoufia Berrechid Youssoufia 30 23 33 33
14 Rapide Oued Zem Rapide Oued 30 28 36 33
15 Moghreb Tetouan Moghreb 30 36 43 32
16 Renaissance Zemamra Renaissance 30 31 40 30
TEMPORADA 2019/2020
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 30 43 23 60
2 Wydad Casablanca Wydad 30 52 28 59
3 RSB Berkane RSB Berkane 30 35 23 57
4 FUS Rabat FUS Rabat 30 39 30 49
5 Mouloudia Oujda Mouloudia 30 35 28 48
6 FAR Rabat FAR Rabat 30 45 34 45
7 Moghreb Tetouan Moghreb 30 30 27 40
8 Rapide Oued Zem Rapide Oued 30 30 30 36
9 Youssoufia Berrechid Youssoufia 30 33 44 36
10 Hassania Agadir Hassania 30 34 38 36
11 Difaâ El Jadida Difaâ 30 26 28 35
12 Renaissance Zemamra Renaissance 30 40 41 34
13 Olympic Safi Olympic Safi 30 25 34 33
14 Ittihad Tanger Ittihad 30 20 36 32
15 Olympique Khouribga Olympique 30 24 38 28
16 Raja Beni Mellal Raja Beni M. 30 13 42 12
TEMPORADA 2018/2019
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 56 30 59
2 Raja Casablanca Raja 30 56 36 55
3 Hassania Agadir Hassania 30 30 22 45
4 Olympic Safi Olympic Safi 30 37 38 45
5 Ittihad Tanger Ittihad 30 27 30 40
6 RSB Berkane RSB Berkane 30 34 34 39
7 Youssoufia Berrechid Youssoufia 30 36 37 39
8 Difaâ El Jadida Difaâ 30 30 32 39
9 FUS Rabat FUS Rabat 30 25 25 38
10 Rapide Oued Zem Rapide Oued 30 28 31 37
11 Olympique Khouribga Olympique 30 38 42 36
12 Mouloudia Oujda Mouloudia 30 31 38 35
13 Moghreb Tetouan Moghreb 30 29 32 34
14 FAR Rabat FAR Rabat 30 32 32 33
15 Kawkab Marrakech Kawkab 30 34 40 30
16 Chabab Rif Hoceima Chabab 30 27 51 27
TEMPORADA 2017/2018
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Ittihad Tanger Ittihad 30 34 23 52
2 Hassania Agadir Hassania 30 40 22 51
3 Wydad Casablanca Wydad 30 44 26 51
4 FUS Rabat FUS Rabat 30 34 26 49
5 Difaâ El Jadida Difaâ 30 49 33 48
6 Raja Casablanca Raja 30 45 33 48
7 Olympic Safi Olympic Safi 30 32 28 43
8 FAR Rabat FAR Rabat 30 35 34 43
9 RSB Berkane RSB Berkane 30 37 34 41
10 Rapide Oued Zem Rapide Oued 30 27 31 37
11 Moghreb Tetouan Moghreb 30 24 35 36
12 Olympique Khouribga Olympique 30 37 47 35
13 Chabab Rif Hoceima Chabab 30 27 31 33
14 Kawkab Marrakech Kawkab 30 29 48 32
15 Chabab Atlas Khenifra Chabab Atlas 30 30 41 29
16 Racing de Casablanca Racing 30 23 55 17
TEMPORADA 2016/2017
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 50 24 66
2 Difaâ El Jadida Difaâ 30 45 23 59
3 Raja Casablanca Raja 30 42 17 57
4 RSB Berkane RSB Berkane 30 30 16 51
5 Ittihad Tanger Ittihad 30 33 25 45
6 FAR Rabat FAR Rabat 30 42 39 44
7 FUS Rabat FUS Rabat 30 32 32 40
8 Hassania Agadir Hassania 30 32 40 38
9 Olympic Safi Olympic Safi 30 25 32 36
10 Chabab Atlas Khenifra Chabab Atlas 30 26 25 34
11 Olympique Khouribga Olympique 30 34 40 34
12 Moghreb Tetouan Moghreb 30 30 37 34
13 Kawkab Marrakech Kawkab 30 36 42 33
14 Chabab Rif Hoceima Chabab 30 26 46 31
15 Kasba Tadla Kasba Tadla 30 25 47 28
16 KAC Kenitra KAC Kenitra 30 27 50 23
TEMPORADA 2015/2016
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 30 40 21 58
2 Wydad Casablanca Wydad 30 34 19 56
3 Ittihad Tanger Ittihad 30 36 23 50
4 Raja Casablanca Raja 30 48 30 47
5 FAR Rabat FAR Rabat 30 40 35 47
6 RSB Berkane RSB Berkane 30 24 19 43
7 Moghreb Tetouan Moghreb 30 34 43 43
8 Hassania Agadir Hassania 30 44 46 41
9 Olympic Safi Olympic Safi 30 23 27 37
10 Chabab Rif Hoceima Chabab 30 27 34 36
11 KAC Kenitra KAC Kenitra 30 26 37 35
12 Difaâ El Jadida Difaâ 30 26 30 34
13 Olympique Khouribga Olympique 30 26 35 34
14 Kawkab Marrakech Kawkab 30 23 30 30
15 Maghreb Fes Maghreb Fes 30 24 31 29
16 Mouloudia Oujda Mouloudia 30 26 41 29
TEMPORADA 2014/2015
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 48 21 59
2 Olympique Khouribga Olympique 30 29 17 56
3 Kawkab Marrakech Kawkab 30 31 26 47
4 Moghreb Tetouan Moghreb 30 36 29 45
5 FUS Rabat FUS Rabat 30 34 28 45
6 Hassania Agadir Hassania 30 42 46 40
7 Difaâ El Jadida Difaâ 30 26 23 39
8 Raja Casablanca Raja 30 37 34 38
9 Maghreb Fes Maghreb Fes 30 34 35 36
10 RSB Berkane RSB Berkane 30 25 25 35
11 FAR Rabat FAR Rabat 30 31 26 34
12 Olympic Safi Olympic Safi 30 20 35 34
13 KAC Kenitra KAC Kenitra 30 25 29 33
14 Chabab Atlas Khenifra Chabab Atlas 30 23 37 32
15 Chabab Rif Hoceima Chabab 30 26 43 32
16 Ittihad Khemisset Ittihad 30 27 40 29
TEMPORADA 2013/2014
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Moghreb Tetouan Moghreb 30 36 25 58
2 Raja Casablanca Raja 30 40 15 55
3 FUS Rabat FUS Rabat 30 31 21 48
4 Kawkab Marrakech Kawkab 30 30 19 48
5 Difaâ El Jadida Difaâ 30 29 20 45
6 Wydad Casablanca Wydad 30 34 29 43
7 FAR Rabat FAR Rabat 30 30 30 39
8 Hassania Agadir Hassania 30 36 43 38
9 RSB Berkane RSB Berkane 30 24 22 35
10 Chabab Rif Hoceima Chabab 30 24 31 35
11 Olympic Safi Olympic Safi 30 28 30 33
12 KAC Kenitra KAC Kenitra 30 21 31 32
13 Maghreb Fes Maghreb Fes 30 27 36 31
14 Olympique Khouribga Olympique 30 20 35 31
15 AS Salé AS Salé 30 25 33 29
16 Wydad Fès Wydad Fès 30 26 41 26
TEMPORADA 2012/2013
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 30 56 24 66
2 FAR Rabat FAR Rabat 30 34 18 62
3 Maghreb Fes Maghreb Fes 30 36 27 48
4 Wydad Casablanca Wydad 30 31 22 48
5 Moghreb Tetouan Moghreb 30 40 28 46
6 FUS Rabat FUS Rabat 30 31 27 41
7 RSB Berkane RSB Berkane 30 30 31 40
8 Chabab Rif Hoceima Chabab 30 28 31 36
9 Difaâ El Jadida Difaâ 30 28 32 35
10 Hassania Agadir Hassania 30 24 26 34
11 Wydad Fès Wydad Fès 30 25 32 33
12 Olympic Safi Olympic Safi 30 36 48 32
13 Olympique Khouribga Olympique 30 27 33 30
14 KAC Kenitra KAC Kenitra 30 23 35 27
15 CODM Meknes CODM Meknes 30 25 40 25
16 Raja Beni Mellal Raja Beni M. 30 22 42 24
TEMPORADA 2011/2012
BOTOLA 2
Equipo PJ GF GC Puntos
1 Raja Beni Mellal Raja Beni M. 30 25 15 48
2 RSB Berkane RSB Berkane 30 29 27 47
3 TAS Casablanca Casablanca 30 32 27 46
4 Union Mohammedia Union 30 38 27 43
5 Kawkab Marrakech Kawkab 30 29 19 42
6 AS Salé AS Salé 30 32 24 41
7 USM Ait Melloul Melloul 30 37 40 40
8 Racing de Casablanca Racing 30 27 24 39
9 Youssoufia Berrechid Youssoufia 30 33 34 39
10 Mouloudia Oujda Mouloudia 30 26 31 39
11 Kasba Tadla Kasba Tadla 30 22 27 35
12 Ittihad Tanger Ittihad 30 21 26 34
13 Rachad Bernoussi Rachad 30 26 33 33
14 US Temara US Temara 30 15 20 32
15 Chabab Houara Chabab 30 22 32 31
16 Stade Marocain Stade 30 26 34 29
TEMPORADA 2006/2007
BOTOLA 2
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 30 32 14 55
2 KAC Kenitra KAC Kenitra 30 37 21 53
3 Chabab Houara Chabab 30 26 18 47
4 UTS Rabat UTS Rabat 30 27 21 43
5 Sidi Kacem Sidi Kacem 30 27 27 42
6 Rachad Bernoussi Rachad 30 22 14 41
7 SCCM Mohamedia SCCM 30 20 24 39
8 US Temara US Temara 30 30 27 37
9 Racing de Casablanca Racing 30 27 27 37
10 Youssoufia Berrechid Youssoufia 30 18 21 36
11 Union Mohammedia Union 30 23 28 36
12 Settat Settat 30 25 30 35
13 CWW Casablanca Casablanca 30 26 38 33
14 Hilal Nador Hilal Nador 30 19 29 32
15 Stade Marocain Stade 30 19 28 31
16 RSB Berkane RSB Berkane 30 22 33 28

  USO DE MEMORIA  
7,268,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7485
Total Execution Time  0.7498
  CADENA URL  
/historico/Rsb-Berkane
  GET DATOS  
$_GET['/historico/Rsb-Berkane']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0148  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 = 'Rsb-Berkane' 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.0127  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=11217 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=11217 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=11217 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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=11217 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=11217 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=11217 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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 = 73592
0.0134  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 = 74279
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11217 AND type_rel = 2
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11217 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138  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 (477007,587517,593697,618983,787455) ORDER BY n.cover_points DESC, update_date DESC
0.0162  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 = '11217' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0141  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 = '11217' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73592 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 74279 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=11217 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (75624,75598,73605,73592,68152,67320) 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.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 73592 AND teamId = 11217
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 75624 AND teamId = 11217
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 68152 AND teamId = 11217
0.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 73605 AND teamId = 11217
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 11217
0.0430  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 11217
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73592 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 = '11217' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11217' and rp.type = 4
0.0128  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 = '11217' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 11217 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.0141  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 11217 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 11217 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 11217 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 73592 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 68951 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.0129  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 = 64194 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.0129  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 = 60252 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.0129  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 = 43575 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 38664 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 34134 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 15633 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 3857 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 3455 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 2213 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 8702 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 8687 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC