4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FSF Móstoles
TEMPORADA 2023/2024
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 25 105 35 71
2 Futsi Atlético Futsi 25 109 66 57
3 MSC Torreblanca FS Torreblanca 24 82 44 55
4 Poio FS Poio FS 25 75 51 48
5 AD Alcorcón Alcorcón 25 93 60 47
6 Roldán FSF Roldán FSF 25 65 57 41
7 LBTL Alcantarilla LBTL 25 81 60 40
8 Ourense CF Ourense CF 25 70 61 35
9 FSF Móstoles Móstoles 25 71 77 35
10 Nueces de Ronda Atl. Torcal Nueces Ronda 25 83 77 28
11 FSF Castro FSF Castro 25 62 71 28
12 AE Les Corts Corts 24 58 76 28
13 Viaxes Amarelle Viaxes 25 76 104 22
14 Marín Fútsal Marín 25 61 88 19
15 Rayo Majadahonda FS Rayo 25 58 123 10
16 CD Leganés CD Leganés 25 35 134 7
TEMPORADA 2022/2023
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 156 43 77
2 Poio FS Poio FS 30 95 34 75
3 Burela FS Burela FS 30 159 59 72
4 MSC Torreblanca FS Torreblanca 30 108 69 64
5 AD Alcorcón Alcorcón 30 102 78 53
6 Roldán FSF Roldán FSF 30 85 84 49
7 LBTL Alcantarilla LBTL 30 92 70 45
8 Ourense CF Ourense CF 30 84 69 43
9 FSF Móstoles Móstoles 30 87 84 43
10 Marín Fútsal Marín 30 74 89 36
11 CD Leganés CD Leganés 30 75 120 28
12 Viaxes Amarelle Viaxes 30 59 88 26
13 Rayo Majadahonda FS Rayo 30 50 139 25
14 AD Sala Zaragoza Sala 30 94 149 22
15 AD Teldeportivo Teldeportivo 30 68 102 15
16 Joventut d'Elx FS Joventut 30 43 154 9
TEMPORADA 2021/2022
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 150 58 80
2 Burela FS Burela FS 30 108 32 74
3 Roldán FSF Roldán FSF 30 85 55 58
4 MSC Torreblanca FS Torreblanca 30 91 65 56
5 Poio FS Poio FS 30 91 58 55
6 AD Alcorcón Alcorcón 30 98 77 48
7 FSF Móstoles Móstoles 30 94 95 44
8 Marín Fútsal Marín 30 73 78 42
9 Ourense CF Ourense CF 30 81 70 40
10 Universidad de Alicante Universidad 30 62 73 38
11 CD Leganés CD Leganés 30 99 119 35
12 Rayo Majadahonda FS Rayo 30 68 102 33
13 AD Sala Zaragoza Sala 30 52 103 25
14 AE Penya Esplugues Penya 30 46 105 22
15 Nueces de Ronda Atl. Torcal Nueces Ronda 30 65 101 20
16 Joventut d'Elx FS Joventut 30 56 128 7
TEMPORADA 2020/2021
PRIMERA DIVISIÓN FEMENINO FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 23 105 24 62
2 Burela FS Burela FS 23 95 36 57
3 Roldán FSF Roldán FSF 24 78 42 47
4 AD Alcorcón Alcorcón 24 93 54 45
5 Poio FS Poio FS 24 65 43 45
6 MSC Torreblanca FS Torreblanca 23 64 42 41
7 FSF Móstoles Móstoles 24 81 82 35
8 Ourense CF Ourense CF 24 65 74 35
TEMPORADA 2019/2020
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 23 145 34 69
2 Burela FS Burela FS 23 97 32 62
3 Ourense CF Ourense CF 23 69 35 56
4 AD Alcorcón Alcorcón 23 95 47 53
5 Poio FS Poio FS 23 69 55 41
6 Universidad de Alicante Universidad 23 61 46 39
7 FSF Móstoles Móstoles 23 79 61 35
8 AE Penya Esplugues Penya 22 49 47 35
9 Roldán FSF Roldán FSF 23 47 58 31
10 UCAM Murcia FSF UCAM Murcia 22 70 73 29
11 AD Sala Zaragoza Sala 23 54 64 29
12 CD Leganés CD Leganés 23 56 82 18
13 Rayo Majadahonda FS Rayo 23 27 68 15
14 Cidade de As Burgas Cidade 23 29 85 11
15 Bilbo FS Bilbo FS 23 31 105 6
16 Xaloc Alacant Xaloc 23 20 106 3
TEMPORADA 2018/2019
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 150 43 84
2 Burela FS Burela FS 30 123 39 84
3 AD Alcorcón Alcorcón 30 113 71 58
4 Ourense CF Ourense CF 30 63 46 57
5 Roldán FSF Roldán FSF 30 96 58 53
6 Universidad de Alicante Universidad 30 92 62 53
7 Poio FS Poio FS 30 80 66 53
8 AE Penya Esplugues Penya 30 79 62 47
9 UCAM Murcia FSF UCAM Murcia 30 90 87 44
10 FSF Móstoles Móstoles 30 94 89 42
11 Rayo Majadahonda FS Rayo 30 64 99 31
12 CD Leganés CD Leganés 30 57 82 24
13 AD Sala Zaragoza Sala 30 65 118 24
14 Guadalcacín Guadalcacín 30 51 111 22
15 Viaxes Amarelle Viaxes 30 44 103 19
16 Femisport Palau Club Femisport 30 23 148 1
TEMPORADA 2017/2018
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Roldán FSF Roldán FSF 30 116 50 73
2 Futsi Atlético Futsi 30 127 40 73
3 Burela FS Burela FS 30 127 73 72
4 Universidad de Alicante Universidad 30 106 40 70
5 AD Alcorcón Alcorcón 30 106 58 58
6 Ourense CF Ourense CF 30 81 51 56
7 Poio FS Poio FS 30 91 76 49
8 AE Penya Esplugues Penya 30 67 49 48
9 CD Leganés CD Leganés 30 71 80 38
10 UCAM Murcia FSF UCAM Murcia 30 77 86 38
11 FSF Móstoles Móstoles 30 76 75 38
12 Rayo Majadahonda FS Rayo 30 72 98 27
13 Guadalcacín Guadalcacín 30 57 126 24
14 CDVP Soto del Real CDVP Soto R. 30 58 117 17
15 Cádiz FSF Cádiz FSF 30 46 165 5
16 Cidade de As Burgas Cidade 30 47 141 5
TEMPORADA 2016/2017
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 126 28 85
2 Universidad de Alicante Universidad 30 115 48 71
3 AD Alcorcón Alcorcón 30 113 46 67
4 Burela FS Burela FS 30 86 58 59
5 Ourense CF Ourense CF 30 84 48 55
6 Poio FS Poio FS 30 75 55 54
7 Roldán FSF Roldán FSF 30 111 68 51
8 Rayo Majadahonda FS Rayo 30 83 98 40
9 Cidade de As Burgas Cidade 30 85 95 38
10 FSF Móstoles Móstoles 30 84 93 37
11 AE Penya Esplugues Penya 30 69 78 37
12 UCAM Murcia FSF UCAM Murcia 30 61 95 26
13 CD Leganés CD Leganés 30 60 110 20
14 FSF Rioja Diamante Rioja 30 39 116 15
15 UDC Txantrea KKE Txantrea 30 46 125 14
16 Rubí FS Rubí FS 30 48 124 13
TEMPORADA 2015/2016
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 30 127 45 83
2 Futsi Atlético Futsi 30 175 46 82
3 AD Alcorcón Alcorcón 30 122 52 70
4 Universidad de Alicante Universidad 30 120 60 58
5 Ourense CF Ourense CF 30 101 54 57
6 Rubí FS Rubí FS 30 95 102 52
7 Cidade de As Burgas Cidade 30 109 110 45
8 Roldán FSF Roldán FSF 30 75 77 44
9 Poio FS Poio FS 30 89 83 39
10 FSF Móstoles Móstoles 30 76 111 34
11 AE Penya Esplugues Penya 30 66 92 31
12 Rayo Majadahonda FS Rayo 30 71 100 29
13 FSF Rioja Diamante Rioja 30 56 116 25
14 Valdetires Ferrol Valdetires 30 60 143 24
15 Club Deportivo Orvina Club 30 60 135 21
16 Femesala Elche Femesala 30 44 120 5
TEMPORADA 2014/2015
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 135 52 81
2 Cidade de As Burgas Cidade 30 114 58 71
3 Burela FS Burela FS 30 101 59 70
4 Universidad de Alicante Universidad 30 98 55 60
5 AD Alcorcón Alcorcón 30 101 54 57
6 Ourense CF Ourense CF 30 80 75 51
7 FSF Rioja Diamante Rioja 30 79 91 46
8 Roldán FSF Roldán FSF 30 99 93 44
9 FSF Móstoles Móstoles 30 79 72 40
10 Poio FS Poio FS 30 70 79 36
11 FS Gironella Gironella 30 63 89 28
12 Rayo Majadahonda FS Rayo 30 73 99 25
13 Club Deportivo Orvina Club 30 52 96 23
14 Ordizia Ke Ordizia Ke 30 40 103 19
15 Bilbo FS Bilbo FS 30 50 96 18
16 Viaxes Amarelle Viaxes 30 47 110 18
TEMPORADA 2013/2014
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 159 54 81
2 Burela FS Burela FS 30 129 56 70
3 AD Alcorcón Alcorcón 30 108 73 68
4 Universidad de Alicante Universidad 30 131 73 59
5 Roldán FSF Roldán FSF 30 112 86 53
6 FSF Rioja Diamante Rioja 30 81 61 51
7 Ourense CF Ourense CF 30 91 75 46
8 FS Gironella Gironella 30 83 74 46
9 Poio FS Poio FS 30 87 97 37
10 Cidade de As Burgas Cidade 30 78 93 37
11 Club Deportivo Orvina Club 30 75 95 33
12 FSF Móstoles Móstoles 30 75 90 29
13 Viaxes Amarelle Viaxes 30 62 92 29
14 CDVP Soto del Real CDVP Soto R. 30 77 107 25
15 Valdetires Ferrol Valdetires 30 67 138 23
16 AE Vallirana Vallirana 30 43 194 3
TEMPORADA 2012/2013
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 28 114 40 70
2 Futsi Atlético Futsi 28 114 52 69
3 AD Alcorcón Alcorcón 28 101 76 55
4 Universidad de Alicante Universidad 28 115 83 53
5 Valladolid FSF Valladolid 28 92 77 52
6 Club Deportivo Orvina Club 28 105 87 47
7 FS Gironella Gironella 28 70 71 40
8 CDVP Soto del Real CDVP Soto R. 28 75 84 37
9 FSF Rioja Diamante Rioja 28 73 79 35
10 Ourense CF Ourense CF 28 90 96 34
11 FSF Móstoles Móstoles 28 94 95 33
12 Roldán FSF Roldán FSF 28 68 78 28
13 Cidade de As Burgas Cidade 28 51 70 21
14 Viaxes Amarelle Viaxes 28 60 124 17
15 Cfs Femeni Centelles Femeni 28 53 163 4
TEMPORADA 2011/2012
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 133 70 70
2 FSF Móstoles Móstoles 30 137 82 66
3 Burela FS Burela FS 30 122 45 65
4 FS Gironella Gironella 30 103 58 63
5 Ourense CF Ourense CF 30 134 63 63
6 Deportivo Córdoba Deportivo 30 152 77 63
7 Femesala Elche Femesala 30 87 85 47
8 Universidad de Alicante Universidad 30 102 92 42
9 Club Deportivo Orvina Club 30 95 129 33
10 CDVP Soto del Real CDVP Soto R. 30 96 123 33
11 FSF Rioja Diamante Rioja 30 53 87 32
12 Cidade de As Burgas Cidade 30 73 96 31
13 Valladolid FSF Valladolid 30 71 104 29
14 FS Zaragoza 2002 Zaragoza 30 81 128 27
15 Rayo Majadahonda FS Rayo 30 85 200 15
16 Rubí FS Rubí FS 30 73 158 14
TEMPORADA 2010/2011
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Ourense CF Ourense CF 30 144 35 85
2 FSF Móstoles Móstoles 30 128 58 77
3 Futsi Atlético Futsi 30 135 85 55
4 Burela FS Burela FS 30 114 77 55
5 Deportivo Córdoba Deportivo 30 148 98 53
6 FSF Rioja Diamante Rioja 30 102 80 52
7 FS Gironella Gironella 30 104 76 47
8 FS Zaragoza 2002 Zaragoza 30 115 110 42
9 Valladolid FSF Valladolid 30 102 100 42
10 Cidade de As Burgas Cidade 30 98 93 42
11 Femesala Elche Femesala 30 88 96 34
12 CDVP Soto del Real CDVP Soto R. 30 82 127 30
13 Club Deportivo Orvina Club 30 75 119 29
14 UCAM Murcia FSF UCAM Murcia 30 64 100 28
15 AD Alcorcón Alcorcón 30 77 127 17
16 CD Campillos Campillos 30 17 212 3
TEMPORADA 2009/2010
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Deportivo Córdoba Deportivo 32 172 63 84
2 Femesala Elche Femesala 32 151 56 83
3 FSF Móstoles Móstoles 32 167 74 71
4 FSF Rioja Diamante Rioja 32 163 86 64
5 UCAM Murcia FSF UCAM Murcia 32 117 89 63
6 Burela FS Burela FS 32 105 97 56
7 Futsi Atlético Futsi 32 128 103 55
8 Valladolid FSF Valladolid 32 111 96 54
9 FS Gironella Gironella 32 106 98 48
10 Ourense CF Ourense CF 32 93 97 43
11 FS Zaragoza 2002 Zaragoza 32 116 133 41
12 CDVP Soto del Real CDVP Soto R. 32 82 135 29
13 CD Campillos Campillos 32 64 152 27
14 Club 4 Arcos Logroño Club Arcos. 32 73 107 24
15 AD Teldeportivo Teldeportivo 32 72 125 20
16 FS Castelldefels Castelldefel 32 86 176 15
17 Cellosa Torrejón Cellosa 32 68 187 11
TEMPORADA 2008/2009
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Deportivo Córdoba Deportivo 30 124 61 72
2 Femesala Elche Femesala 30 117 60 70
3 FSF Móstoles Móstoles 30 144 72 68
4 Futsi Atlético Futsi 30 128 73 62
5 FSF Rioja Diamante Rioja 30 124 78 55
6 Pinto FS Pinto FS 30 108 74 54
7 Ourense CF Ourense CF 30 110 94 46
8 UCAM Murcia FSF UCAM Murcia 30 109 97 45
9 FS Zaragoza 2002 Zaragoza 30 114 115 41
10 Club 4 Arcos Logroño Club Arcos. 30 83 88 40
11 Valladolid FSF Valladolid 30 101 108 38
12 CDVP Soto del Real CDVP Soto R. 30 74 114 29
13 FS Gironella Gironella 30 56 82 23
14 FS Torre Pacheco Torre 30 72 128 18
15 Valdetires Ferrol Valdetires 30 56 185 11
16 Cádiz FSF Cádiz FSF 30 37 128 9
TEMPORADA 2007/2008
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Femesala Elche Femesala 30 163 67 78
2 Futsi Atlético Futsi 30 124 54 71
3 FSF Móstoles Móstoles 30 125 77 63
4 Deportivo Córdoba Deportivo 30 143 82 62
5 UCAM Murcia FSF UCAM Murcia 30 116 101 55
6 Ourense CF Ourense CF 30 116 80 52
7 Valladolid FSF Valladolid 30 98 84 48
8 FS Gironella Gironella 30 82 77 40
9 Pinto FS Pinto FS 30 96 113 37
10 FSF Rioja Diamante Rioja 30 83 106 37
11 FS Zaragoza 2002 Zaragoza 30 82 103 33
12 CDVP Soto del Real CDVP Soto R. 30 95 127 33
13 Club 4 Arcos Logroño Club Arcos. 30 97 102 30
14 AD Teldeportivo Teldeportivo 30 82 128 28
15 Bimil·lenari Bimil·lenar 30 68 151 15
16 Kettal Fuenlabrada Kettal 30 77 195 11
TEMPORADA 2006/2007
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Femesala Elche Femesala 30 178 52 82
2 Futsi Atlético Futsi 30 157 52 81
3 FSF Móstoles Móstoles 30 171 69 76
4 UCAM Murcia FSF UCAM Murcia 30 154 101 61
5 Deportivo Córdoba Deportivo 30 124 107 50
6 AD Teldeportivo Teldeportivo 30 114 105 46
7 FSF Rioja Diamante Rioja 30 93 96 45
8 FS Gironella Gironella 30 95 91 43
9 Hegoalde KE Hegoalde KE 30 97 97 43
10 CDVP Soto del Real CDVP Soto R. 30 90 114 34
11 Valladolid FSF Valladolid 30 91 128 32
12 FS Zaragoza 2002 Zaragoza 30 95 137 28
13 Kettal Fuenlabrada Kettal 30 74 119 24
14 Cádiz FSF Cádiz FSF 30 71 131 18
15 Collado Villalba Collado 30 84 186 16
16 FSF Castelldefels Castelldefel 30 55 158 14

  USO DE MEMORIA  
7,233,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.7087
Total Execution Time  0.7101
  CADENA URL  
/historico/Fsf-Mostoles-Cospusa
  GET DATOS  
$_GET['/historico/Fsf-Mostoles-Cospusa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0139  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 = 'Fsf-Mostoles-Cospusa' 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.0129  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=5255 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=5255 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=5255 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 73236
0.0130  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 = 73405
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5255 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=157 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 157 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (1114910,1060072,931766,909409,867439) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '5255' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '5255' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '5255' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 73236 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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 = 73405 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=5255 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (73405,73236) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73236 AND teamId = 5255
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 73405 AND teamId = 5255
0.0139  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 = 73236 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '5255' 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 = '5255' and rp.type = 4
0.0127  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 = '5255' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 73236 WHERE rp.league_id = 73236 AND rp.teamId = 5255 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.0127  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 = 73236 WHERE rp.league_id = 73236 AND rp.teamId = 5255 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 73236 WHERE rp.league_id = 73236 AND rp.teamId = 5255 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 5255 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73236 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.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 = 68496 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 = 58803 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.0128  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 = 61992 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.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 `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 = 50512 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.0132  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 = 44446 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 `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 = 39790 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 35498 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 `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 = 16956 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 `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 = 7573 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 `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 = 64314 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 = 2246 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 1788 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 `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 = 1236 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 `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 = 60276 AND t.round = 34 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 `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 = 60279 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 `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 = 60436 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 `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 = 60505 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC