4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Universidad de Alicante
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 3
Equipo PJ GF GC Puntos
1 Universidad de Alicante Universidad 26 82 38 49
2 CD Leganés CD Leganés 25 89 87 40
3 AD Sala Zaragoza Sala 24 74 65 38
4 Rayo Majadahonda FS Rayo 23 58 62 28
5 AE Penya Esplugues Penya 23 40 52 25
6 Viaxes Amarelle Viaxes 23 35 63 23
7 Intersala Zaragoza Intersala 25 42 101 17
8 AD Teldeportivo Teldeportivo 25 45 92 14
9 Cidade de As Burgas Cidade 25 50 95 14
10 Xaloc Alacant Xaloc 26 26 135 5
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

  USO DE MEMORIA  
6,229,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1693
Total Execution Time  0.1705
  CADENA URL  
/historico/Universidad-Alicante-Futsal
  GET DATOS  
$_GET['/historico/Universidad-Alicante-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (60)  
0.0029  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 = 'Universidad-Alicante-Futsal' 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.0039  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 = 'Universidad-Alicante-Futsal' 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.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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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=8260 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 = 63429
0.0023  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 = 64958
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8260 AND type_rel = 2
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 = '8260' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '8260' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '8260' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 63429 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 64958 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=8260 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (64958,63429) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 63429 AND teamId = 8260
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 64958 AND teamId = 8260
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 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 = 63429 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '8260' 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 = '8260' 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 = '8260' 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 events2022 e ON e.player_id = p.id AND e.league_id = 63429 WHERE rp.league_id = 63429 AND rp.teamId = 8260 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 events2022 e ON e.player_id = p.id AND e.league_id = 63429 WHERE rp.league_id = 63429 AND rp.teamId = 8260 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2022 e ON e.player_id = p.id AND e.league_id = 63429 WHERE rp.league_id = 63429 AND rp.teamId = 8260 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 8260 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 63429 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.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 `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.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 = 61993 AND t.round = 10 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 `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.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 = 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.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 = 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.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 `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.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 `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.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 = 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.0028  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.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 `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.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 `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 = 1808 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 `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.0019  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 = 63429 ORDER BY nameShow LIMIT 100