4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Manzanares FS
TEMPORADA 2023/2024
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 28 94 76 57
2 ElPozo Murcia Costa Cálida ElPozo 28 105 70 55
3 Jaén FS Jaén FS 28 89 66 51
4 Inter FS Inter FS 28 105 71 50
5 Palma Futsal Palma Futsal 28 101 91 47
6 Jimbee Cartagena Jimbee 27 81 73 45
7 Manzanares FS Manzanares 28 101 95 45
8 Viña Albali Valdepeñas Viña Albali 28 94 84 42
9 Industrias Santa Coloma Industrias 28 96 94 41
10 Peñíscola FS Peñíscola 27 100 95 32
11 Osasuna Magna Osasuna 27 71 83 31
12 Córdoba Patrimonio Córdoba 27 75 89 31
13 Noia Portus Apostoli Noia Portus 28 92 106 27
14 Ribera Navarra FS Ribera 28 73 90 24
15 Real Betis Futsal Real Betis. 28 73 122 24
16 Alzira FS Alzira FS 28 58 103 20
TEMPORADA 2022/2023
PRIMERA DIVISIÓN FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Palma Futsal Palma Futsal 30 120 81 65
2 Barça Barça 30 120 77 64
3 Jimbee Cartagena Jimbee 30 105 83 61
4 Jaén FS Jaén FS 30 110 68 60
5 ElPozo Murcia Costa Cálida ElPozo 30 92 70 52
6 Inter FS Inter FS 30 106 88 52
7 Viña Albali Valdepeñas Viña Albali 30 97 96 45
8 Noia Portus Apostoli Noia Portus 30 84 93 38
9 Industrias Santa Coloma Industrias 30 87 94 35
10 Manzanares FS Manzanares 30 80 98 34
11 Ribera Navarra FS Ribera 30 78 101 30
12 Real Betis Futsal Real Betis. 30 84 104 29
13 Córdoba Patrimonio Córdoba 30 87 111 29
14 Osasuna Magna Osasuna 30 59 82 29
15 CD UMA Antequera Antequera 30 74 100 29
16 Levante UD FS Levante 30 74 111 23
TEMPORADA 2021/2022
PRIMERA DIVISIÓN FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Barça Barça 30 122 63 68
2 Inter FS Inter FS 30 87 68 58
3 Palma Futsal Palma Futsal 30 78 55 58
4 Viña Albali Valdepeñas Viña Albali 30 91 81 56
5 Jimbee Cartagena Jimbee 30 99 70 55
6 Ribera Navarra FS Ribera 30 88 96 45
7 Jaén FS Jaén FS 30 85 73 44
8 ElPozo Murcia Costa Cálida ElPozo 30 87 72 43
9 Industrias Santa Coloma Industrias 30 90 78 42
10 Levante UD FS Levante 30 84 91 37
11 Córdoba Patrimonio Córdoba 30 90 91 36
12 Manzanares FS Manzanares 30 82 100 30
13 Osasuna Magna Osasuna 30 65 98 30
14 Real Betis Futsal Real Betis. 30 67 100 26
15 Sala 10 Zaragoza Sala 30 85 112 24
16 Burela FS Burela FS 30 62 114 14
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 Noia Portus Apostoli Noia Portus 22 77 47 53
2 Manzanares FS Manzanares 24 71 53 42
3 Union África Ceutí Union 22 75 59 38
4 Inagroup El Ejido Inagroup 24 92 90 39
5 Atlético Mengíbar FS Atlético 24 74 61 37
6 Barça Atlétic Barça 24 85 81 34
7 Soliss FS Talavera Soliss 22 62 68 29
8 Atletico Benavente FS Atletico 22 65 69 24
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Real Betis Futsal Real Betis. 23 83 47 50
2 CD UMA Antequera Antequera 23 82 43 45
3 Soliss FS Talavera Soliss 23 74 52 43
4 Manzanares FS Manzanares 23 67 56 43
5 Elche CF Sala Elche Sala 23 78 78 40
6 Ciudad de Móstoles Ciudad 23 73 63 33
7 ElPozo Ciudad de Murcia ElPozo 23 61 55 31
8 Noia Portus Apostoli Noia Portus 23 63 69 31
9 Atlético Mengíbar FS Atlético 23 60 61 30
10 Alzira FS Alzira FS 23 70 78 30
11 Barça Atlétic Barça 23 67 71 28
12 Union África Ceutí Union 23 58 65 26
13 Bisontes Castellón FS Bisontes 23 47 66 25
14 Santiago Futsal Santiago 23 42 59 22
15 Full Energía Zaragoza Full 23 82 103 22
16 Rivas Futsal Rivas Futsal 23 59 100 13
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 30 116 68 67
2 Real Betis Futsal Real Betis. 30 123 56 66
3 Atlético Mengíbar FS Atlético 30 109 65 62
4 Manzanares FS Manzanares 30 94 80 56
5 Barça Atlétic Barça 30 110 74 54
6 ElPozo Ciudad de Murcia ElPozo 30 111 73 53
7 Córdoba Patrimonio Córdoba 30 110 104 48
8 Santiago Futsal Santiago 30 99 88 45
9 Rivas Futsal Rivas Futsal 30 93 104 37
10 Noia Portus Apostoli Noia Portus 30 102 106 35
11 Bisontes Castellón FS Bisontes 30 66 98 33
12 Elche CF Sala Elche Sala 30 75 99 33
13 Full Energía Zaragoza Full 30 110 124 32
14 Soliss FS Talavera Soliss 30 93 129 29
15 Gran Canaria Gran Canaria 30 86 104 29
16 CD Salesianos Tenerife Salesianos 30 41 166 4
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Ciudad de Murcia ElPozo 30 131 84 61
2 Barça Atlétic Barça 30 122 70 60
3 Viña Albali Valdepeñas Viña Albali 30 114 72 60
4 Burela FS Burela FS 30 102 63 55
5 CD UMA Antequera Antequera 30 106 80 51
6 FSD Puertollano Puertollano 30 118 94 51
7 Real Betis Futsal Real Betis. 30 108 88 51
8 Rivas Futsal Rivas Futsal 30 110 91 48
9 Córdoba Patrimonio Córdoba 30 112 108 47
10 Bisontes Castellón FS Bisontes 30 82 99 40
11 Manzanares FS Manzanares 30 83 103 39
12 Atlético Mengíbar FS Atlético 30 81 90 38
13 Elche CF Sala Elche Sala 30 84 102 33
14 Noia Portus Apostoli Noia Portus 30 64 123 22
15 Prone Lugo FS Prone Lugo 30 64 125 18
16 Tenerife Iberia Toscal Tenerife 30 60 149 6
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Manzanares FS Manzanares 28 160 52 75
2 Soliss FS Talavera Soliss 28 146 79 60
3 CD Leganes FS Leganes 28 92 74 47
4 CD Dénia Futsal Dénia 28 98 103 47
5 Navalmoral FS Navalmoral 28 106 112 46
6 Zambu Pinatar Zambu 28 84 75 43
7 Bargas CD Bargas CD 28 98 106 41
8 Silver Novanca FS Silver 28 83 89 35
9 CDE Mejorada Mejorada 28 95 103 33
10 Torrejón Sala Five-Play Torrejón 28 94 114 32
11 Caceres Malpartida FS Caceres 28 88 112 32
12 Inter Movistar B Inter 28 75 100 30
13 Simancas FS Simancas FS 28 72 107 28
14 Gelovision Ciudad de Toledo Gelovision 28 83 113 23
15 Buhersa Talayuela Buhersa 28 71 106 21
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Rivas Futsal Rivas Futsal 33 161 69 77
2 Soliss FS Talavera Soliss 34 158 86 73
3 CD Leganes FS Leganes 34 113 93 60
4 CD Dénia Futsal Dénia 34 138 120 59
5 Manzanares FS Manzanares 34 118 79 59
6 Silver Novanca FS Silver 34 107 106 53
7 Bargas CD Bargas CD 34 109 95 52
8 Torrejón Sala Five-Play Torrejón 34 125 112 50
9 Buhersa Talayuela Buhersa 34 115 135 47
10 Gran Peña FS Gran Peña 34 129 137 44
11 Navalmoral FS Navalmoral 34 101 118 44
12 Xaloc Alacant Fs Xaloc 34 110 123 43
13 Simancas FS Simancas FS 34 118 131 42
14 Inter Movistar B Inter 34 93 94 39
15 San Clemente Futsal Clemente 34 106 145 35
16 AA Pilaristas Flex Futsal Pilaristas 34 82 117 33
17 Torres De La Alameda Fs Torres 33 70 133 20
18 AD Alcorcón FS Alcorcón 34 88 148 18
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Rivas Futsal Rivas Futsal 30 178 83 80
2 Soliss FS Talavera Soliss 30 171 92 70
3 Silver Novanca FS Silver 30 130 98 60
4 CD Leganes FS Leganes 30 116 94 57
5 Gran Peña FS Gran Peña 30 131 102 52
6 Inter Movistar B Inter 30 148 109 50
7 Caceres Malpartida FS Caceres 30 129 125 44
8 Manzanares FS Manzanares 30 109 119 42
9 San Clemente Futsal Clemente 30 113 130 38
10 Navalmoral FS Navalmoral 30 116 130 37
11 Torrejón Sala Five-Play Torrejón 30 99 118 37
12 Torres De La Alameda Fs Torres 30 109 122 34
13 Torrelodones Acoor Torrelodones 30 113 154 24
14 Simancas FS Simancas FS 30 91 139 24
15 Xaloc Alacant Fs Xaloc 30 93 153 24
16 Orihuela Fs Futsal Orihuela 30 100 178 22
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Oxipharma FS Oxipharma 30 141 91 59
2 Manzanares FS Manzanares 30 111 99 56
3 ElPozo Ciudad de Murcia ElPozo 30 114 98 49
4 Fuconsa Jaén Fuconsa 30 82 85 48
5 C. A Gran Canaria Gran Canaria 30 123 112 47
6 Barça Atlétic Barça 30 118 113 46
7 CD UMA Antequera Antequera 30 104 91 45
8 Sala 5 Martorell Sala 30 130 110 44
9 Burela FS Burela FS 30 94 85 44
10 Union África Ceutí Union 30 118 128 42
11 Bp Andorra Bp Andorra 30 105 103 41
12 Maristas UPV FS Maristas 30 110 112 34
13 Hospitalet Bellsport Hospitalet 30 109 126 31
14 Melilla FS Melilla FS 30 87 108 31
15 Ibiza Gasifred Ibiza 30 105 128 30
16 Playas de Castellón FS Playas 30 91 153 25
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 SDM Illescas Illescas 29 124 56 69
2 Manzanares FS Manzanares 29 118 77 62
3 Pdm Olias Del Rey Olias 29 163 110 56
4 Fs Ciudad Del Vino Ciudad Vino 29 128 92 56
5 C.d. F.s. Alamin C.d. F.s. A. 29 139 107 55
6 C.d. Calera C.d. Calera 29 120 113 47
7 Cde Velada Fs Velada 29 111 117 47
8 Cfs Bargas Cfs Bargas 29 87 94 38
9 Hotel Gran Sol Hotel Gran 29 99 133 38
10 E.m.f.a.d. San Clemente E.m.f.a.d. 28 123 137 30
11 Navalmoral FS Navalmoral 29 102 122 30
12 Fs La Solana Futsal Solana 29 112 137 30
13 CDE Aguila FS Aguila 29 74 155 11
14 EMFS Azuqueca EMFS 28 69 119 9
TEMPORADA 2009/2010
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Ulejos Y Pavimentos Brihueg Ulejos 30 164 70 78
2 C.d. F.s. Alamin C.d. F.s. A. 30 155 81 65
3 F.s.Valdepeñas F.s.Valdepe 30 142 103 65
4 Pdm Olias Del Rey Olias 30 154 105 54
5 C.f.s. Quintanar E. Mota C.f.s. 30 108 93 52
6 Manzanares FS Manzanares 30 129 104 51
7 C.f.s. Bargas C.f.s. 30 134 106 49
8 C.d.e. Velada F.s. C.d.e. 30 127 119 43
9 Navalmoral Navalmoral 30 112 125 40
10 E.m.f.a.d. San Clemente E.m.f.a.d. 30 92 132 37
11 Hotel Gran Sol Hotel Gran 30 98 117 36
12 C.d. Calera C.d. Calera 30 105 127 33
13 Fs La Solana Futsal Solana 30 111 159 32
14 Grupo Galindo Villarrobledo Grupo 30 98 152 23
15 Recambios Dinauto Recambios 30 115 167 18
16 Toledo Toledo 30 110 194 17
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 SDM Illescas Illescas 30 154 83 74
2 Delta Badajoz Delta 30 144 111 58
3 Toledo Toledo 29 124 95 55
4 Cde Velada Fs Velada 30 136 109 53
5 Pdm Olias Del Rey Olias 30 124 102 51
6 Azu/pav Brihuega Fs Azu/pav 29 101 77 49
7 G. Galindo Villarrobledo Galindo 30 125 123 47
8 Cf Gim. Alzazar Gim. Alzazar 22 104 69 46
9 Manzanares FS Manzanares 30 122 122 46
10 Fs Alamin Fs Alamin 30 128 129 43
11 Cfs Bargas Cfs Bargas 30 107 114 43
12 Fs Ciudad Del Vino Ciudad Vino 30 132 137 39
13 Fs La Solana Futsal Solana 30 114 119 32
14 Ud Guadalajara Futsal Guadalajara 30 97 135 24
15 Gimnástico de Alcázar FS Gimnástico 8 29 25 12
16 Fs Menasalbas Menasalbas 30 84 171 10
17 Inesa Zorita Fs Inesa Zorita 30 54 158 8

  USO DE MEMORIA  
6,807,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1344
Total Execution Time  0.1358
  CADENA URL  
/historico/Fs-Manzanares
  GET DATOS  
$_GET['/historico/Fs-Manzanares']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0031  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 = 'Fs-Manzanares' 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.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=5203 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=5203 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=5203 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=5203 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 73234
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 = 74080
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 = 74879
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5203 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5203 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (506294,507070,506302,522769,523534) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '5203' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '5203' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '5203' 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,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 = 74080 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 74879 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 73234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=5203 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 (74879,74080,73234) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73234 AND teamId = 5203
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 5203
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74879 AND teamId = 5203
0.0023  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 = '5203' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5203' and rp.type = 4
0.0020  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 = '5203' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 5203 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.0020  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 5203 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 5203 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 5203 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73234 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `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 = 68486 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.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 `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 = 58755 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 61573 AND t.round = 8 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 = 50516 AND t.round = 23 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 `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 = 44362 AND t.round = 30 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 = 39113 AND t.round = 30 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 `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 = 35141 AND t.round = 30 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 `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 = 16955 AND t.round = 34 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 = 4612 AND t.round = 30 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 `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 = 1787 AND t.round = 30 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 `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 = 1230 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 932 AND t.round = 30 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 `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 = 740 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC