4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Industrias Santa Coloma
TEMPORADA 2023/2024
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 27 91 74 54
2 ElPozo Murcia Costa Cálida ElPozo 27 102 68 52
3 Inter FS Inter FS 27 103 68 50
4 Jaén FS Jaén FS 27 87 65 48
5 Palma Futsal Palma Futsal 27 100 89 47
6 Jimbee Cartagena Jimbee 27 81 73 45
7 Viña Albali Valdepeñas Viña Albali 28 94 84 42
8 Manzanares FS Manzanares 27 95 90 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 27 87 100 27
14 Ribera Navarra FS Ribera 27 71 87 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
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Murcia Costa Cálida ElPozo 34 108 79 68
2 Palma Futsal Palma Futsal 34 98 67 68
3 Barça Barça 34 109 63 66
4 Jimbee Cartagena Jimbee 34 134 93 64
5 Levante UD FS Levante 34 113 99 64
6 Inter FS Inter FS 34 121 84 57
7 Sala 10 Zaragoza Sala 34 108 104 48
8 Viña Albali Valdepeñas Viña Albali 34 107 91 47
9 Industrias Santa Coloma Industrias 34 95 89 47
10 Real Betis Futsal Real Betis. 34 86 101 46
11 Ribera Navarra FS Ribera 34 104 105 41
12 Osasuna Magna Osasuna 34 83 96 40
13 Córdoba Patrimonio Córdoba 34 80 90 40
14 Jaén FS Jaén FS 34 73 95 38
15 Burela FS Burela FS 34 102 120 38
16 Peñíscola FS Peñíscola 34 83 108 34
17 CD UMA Antequera Antequera 34 75 129 22
18 O Parrulo Ferrol Parrulo 34 80 146 20
TEMPORADA 2019/2020
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 23 96 51 56
2 Barça Barça 23 107 60 54
3 Viña Albali Valdepeñas Viña Albali 23 81 61 45
4 ElPozo Murcia Costa Cálida ElPozo 23 75 54 44
5 Palma Futsal Palma Futsal 23 64 38 43
6 Osasuna Magna Osasuna 23 83 67 39
7 Levante UD FS Levante 23 82 77 34
8 Jaén FS Jaén FS 23 66 70 33
9 Jimbee Cartagena Jimbee 23 67 74 27
10 O Parrulo Ferrol Parrulo 23 68 81 26
11 Peñíscola FS Peñíscola 23 70 72 26
12 Industrias Santa Coloma Industrias 23 61 83 25
13 Ribera Navarra FS Ribera 23 52 76 19
14 Córdoba Patrimonio Córdoba 23 51 89 17
15 Sala 10 Zaragoza Sala 23 63 86 15
16 Burela FS Burela FS 23 40 87 13
TEMPORADA 2018/2019
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 30 134 65 67
2 ElPozo Murcia Costa Cálida ElPozo 30 122 78 62
3 Osasuna Magna Osasuna 30 104 75 59
4 Inter FS Inter FS 30 125 66 57
5 Palma Futsal Palma Futsal 30 102 70 55
6 Jaén FS Jaén FS 30 94 81 49
7 Ribera Navarra FS Ribera 30 108 92 46
8 Levante UD FS Levante 30 105 99 45
9 Peñíscola FS Peñíscola 30 77 79 44
10 Jimbee Cartagena Jimbee 30 104 109 40
11 Sala 10 Zaragoza Sala 30 82 117 33
12 Industrias Santa Coloma Industrias 30 79 98 32
13 O Parrulo Ferrol Parrulo 30 80 116 27
14 Viña Albali Valdepeñas Viña Albali 30 83 136 22
15 Naturpellet Segovia Naturpellet 30 59 115 18
16 CD UMA Antequera Antequera 30 67 129 14
TEMPORADA 2017/2018
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 137 64 71
2 Barça Barça 30 149 66 70
3 ElPozo Murcia Costa Cálida ElPozo 30 131 70 68
4 Jaén FS Jaén FS 30 119 69 64
5 Osasuna Magna Osasuna 30 123 88 62
6 Palma Futsal Palma Futsal 30 94 77 46
7 Sala 10 Zaragoza Sala 30 96 110 45
8 Ribera Navarra FS Ribera 30 80 91 40
9 Jimbee Cartagena Jimbee 30 107 111 39
10 Levante UD FS Levante 30 104 111 31
11 Naturpellet Segovia Naturpellet 30 94 142 31
12 Industrias Santa Coloma Industrias 30 90 108 29
13 Peñíscola FS Peñíscola 30 67 92 26
14 O Parrulo Ferrol Parrulo 30 80 116 24
15 Santiago Futsal Santiago 30 84 121 19
16 Gran Canaria Gran Canaria 30 66 185 10
TEMPORADA 2016/2017
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 151 59 75
2 ElPozo Murcia Costa Cálida ElPozo 30 148 61 71
3 Barça Barça 30 135 70 70
4 Jaén FS Jaén FS 30 103 72 53
5 Palma Futsal Palma Futsal 30 106 72 51
6 Osasuna Magna Osasuna 30 96 73 51
7 Peñíscola FS Peñíscola 30 105 94 48
8 Industrias Santa Coloma Industrias 30 106 104 40
9 Ribera Navarra FS Ribera 30 70 85 34
10 Sala 10 Zaragoza Sala 30 94 119 32
11 Santiago Futsal Santiago 30 89 118 31
12 Levante UD FS Levante 30 82 110 30
13 Gran Canaria Gran Canaria 30 85 130 30
14 Jimbee Cartagena Jimbee 30 80 115 26
15 Burela FS Burela FS 30 88 132 25
16 Jumilla B. Carchelo Jumilla 30 69 193 9
TEMPORADA 2015/2016
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 158 57 83
2 Barça Barça 30 157 78 74
3 ElPozo Murcia Costa Cálida ElPozo 30 130 81 63
4 Palma Futsal Palma Futsal 30 107 80 57
5 Ribera Navarra FS Ribera 30 91 75 52
6 Osasuna Magna Osasuna 30 111 85 48
7 Industrias Santa Coloma Industrias 30 129 125 44
8 Peñíscola FS Peñíscola 30 117 116 41
9 Burela FS Burela FS 30 92 108 40
10 Santiago Futsal Santiago 30 99 117 31
11 Sala 10 Zaragoza Sala 30 109 125 31
12 Jaén FS Jaén FS 30 86 111 28
13 Levante UD FS Levante 30 72 128 23
14 Jumilla B. Carchelo Jumilla 30 85 135 21
15 Elche CF Sala Elche Sala 30 75 156 17
16 CD UMA Antequera Antequera 30 97 138 17
TEMPORADA 2014/2015
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 152 60 79
2 Barça Barça 30 149 67 74
3 ElPozo Murcia Costa Cálida ElPozo 30 152 71 73
4 Jaén FS Jaén FS 30 113 79 54
5 Palma Futsal Palma Futsal 30 122 105 53
6 Osasuna Magna Osasuna 30 115 98 52
7 Ribera Navarra FS Ribera 30 101 91 51
8 Peñíscola FS Peñíscola 30 116 93 47
9 Burela FS Burela FS 30 97 100 37
10 Sala 10 Zaragoza Sala 30 105 119 36
11 Industrias Santa Coloma Industrias 30 140 134 32
12 Santiago Futsal Santiago 30 80 103 32
13 Jumilla B. Carchelo Jumilla 30 119 135 28
14 Levante UD FS Levante 30 75 124 26
15 Uruguay Tenerife Uruguay 30 72 205 9
16 Prone Lugo FS Prone Lugo 30 59 183 5
TEMPORADA 2013/2014
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 28 148 58 76
2 ElPozo Murcia Costa Cálida ElPozo 28 139 69 68
3 Barça Barça 28 115 46 68
4 Industrias Santa Coloma Industrias 28 115 98 50
5 Osasuna Magna Osasuna 28 92 95 44
6 Jumilla B. Carchelo Jumilla 28 90 92 41
7 Ribera Navarra FS Ribera 28 74 80 39
8 Santiago Futsal Santiago 28 76 79 37
9 Burela FS Burela FS 28 71 77 37
10 Jaén FS Jaén FS 28 59 83 27
11 Palma Futsal Palma Futsal 28 87 117 26
12 Peñíscola FS Peñíscola 28 57 90 25
13 Sala 10 Zaragoza Sala 28 74 108 23
14 Prone Lugo FS Prone Lugo 28 70 108 22
15 C. A Gran Canaria Gran Canaria 28 64 131 11
TEMPORADA 2012/2013
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 26 133 45 67
2 ElPozo Murcia Costa Cálida ElPozo 26 117 62 59
3 Inter FS Inter FS 26 103 50 57
4 Naturpellet Segovia Naturpellet 26 103 79 53
5 Sala 10 Zaragoza Sala 26 83 75 47
6 Osasuna Magna Osasuna 26 91 82 45
7 Santiago Futsal Santiago 26 85 71 43
8 Ribera Navarra FS Ribera 26 88 96 36
9 Industrias Santa Coloma Industrias 26 110 123 32
10 Palma Futsal Palma Futsal 26 64 81 21
11 Prone Lugo FS Prone Lugo 26 75 115 21
12 Burela FS Burela FS 26 48 87 19
13 FSD Puertollano Puertollano 26 37 116 11
14 C. A Gran Canaria Gran Canaria 26 54 109 8
TEMPORADA 2011/2012
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Murcia Costa Cálida ElPozo 30 153 69 79
2 Barça Barça 30 149 65 74
3 Inter FS Inter FS 30 123 61 64
4 Naturpellet Segovia Naturpellet 30 98 81 49
5 Santiago Futsal Santiago 30 85 75 47
6 Carnicer Torrejón Carnicer 30 101 95 45
7 Osasuna Magna Osasuna 30 92 100 45
8 Sala 10 Zaragoza Sala 30 95 96 43
9 FSD Puertollano Puertollano 30 88 98 39
10 Palma Futsal Palma Futsal 30 98 108 37
11 Talavera Talavera 30 83 112 36
12 Ribera Navarra FS Ribera 30 84 106 33
13 Prone Lugo FS Prone Lugo 30 93 125 29
14 Industrias Santa Coloma Industrias 30 71 106 28
15 FS Cartagena Cartagena 30 80 142 24
16 Benicarló Aeroport Castelló Benicarló 30 41 95 11
TEMPORADA 2010/2011
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 30 127 63 70
2 ElPozo Murcia Costa Cálida ElPozo 30 138 90 65
3 Inter FS Inter FS 30 111 75 61
4 Santiago Futsal Santiago 30 133 94 59
5 Palma Futsal Palma Futsal 30 107 87 56
6 Benicarló Aeroport Castelló Benicarló 32 87 80 50
7 Naturpellet Segovia Naturpellet 30 104 95 48
8 Osasuna Magna Osasuna 30 100 96 42
9 Sala 10 Zaragoza Sala 30 93 91 40
10 Carnicer Torrejón Carnicer 30 95 101 35
11 Prone Lugo FS Prone Lugo 30 98 105 35
12 Talavera Talavera 30 78 96 35
13 FS Cartagena Cartagena 30 102 116 34
14 Industrias Santa Coloma Industrias 32 85 107 30
15 Playas de Castellón FS Playas 30 59 108 28
16 Gestesa Guadalajara Gestesa 30 55 168 3
TEMPORADA 2009/2010
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Murcia Costa Cálida ElPozo 30 143 84 72
2 Inter FS Inter FS 30 103 68 64
3 Naturpellet Segovia Naturpellet 30 112 77 61
4 Santiago Futsal Santiago 30 120 86 60
5 Barça Barça 30 97 57 57
6 Industrias Santa Coloma Industrias 30 106 107 43
7 Osasuna Magna Osasuna 30 94 92 42
8 Carnicer Torrejón Carnicer 30 117 124 40
9 Prone Lugo FS Prone Lugo 30 92 113 40
10 Gestesa Guadalajara Gestesa 30 106 119 38
11 Playas de Castellón FS Playas 30 61 84 33
12 Sala 10 Zaragoza Sala 30 93 103 32
13 FS Cartagena Cartagena 30 103 120 32
14 Benicarló Aeroport Castelló Benicarló 30 70 90 23
15 Arcebansa Chint Zamora Arcebansa 30 92 122 22
16 Punctum Millenium Pinto Punctum 30 67 130 15
TEMPORADA 2008/2009
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Murcia Costa Cálida ElPozo 28 120 76 65
2 Inter FS Inter FS 28 107 70 60
3 Barça Barça 28 92 56 53
4 Autos Lobelle Fs Autos 28 98 89 47
5 Benicarlo FS Benicarlo 28 72 62 45
6 Millenium Pinto Tien 21 Millenium 28 93 90 45
7 Naturpellet Segovia Naturpellet 28 90 72 43
8 Osasuna Magna Osasuna 28 91 88 38
9 Prone Lugo FS Prone Lugo 28 80 95 37
10 FS Cartagena Cartagena 28 92 95 36
11 Carnicer Torrejón Carnicer 28 97 115 29
12 Playas de Castellón FS Playas 28 63 93 28
13 Gestesa Guadalajara Gestesa 28 85 103 27
14 Industrias Santa Coloma Industrias 28 70 101 24
15 Palma Futsal Palma Futsal 28 83 128 21

  USO DE MEMORIA  
7,136,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7286
Total Execution Time  0.7298
  CADENA URL  
/historico/Marfil-Santa-Coloma
  GET DATOS  
$_GET['/historico/Marfil-Santa-Coloma']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0156  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 = 'Marfil-Santa-Coloma' 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=3082 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=3082 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=3082 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0291  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.0152  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.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3082 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3082 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (515740,522310,522854,546874,554180) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '3082' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '3082' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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.0146  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.0149  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=3082 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73234 AND teamId = 3082
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 3082
0.0152  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 = 73234 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155  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 = 3082 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.0159  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 = 3082 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 3082 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 3082 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0173  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.0152  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.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 `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 = 63424 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.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 `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 = 58753 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 50469 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.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 `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 = 44361 AND t.round = 30 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 = 39112 AND t.round = 30 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 = 33893 AND t.round = 30 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 `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 = 16598 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 4455 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 3019 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 1935 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 1527 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 = 1159 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 = 923 AND t.round = 30 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 `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 = 734 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73234 ORDER BY nameShow LIMIT 100