4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 LD Alajuelense Alajuelense 22 36 19 42
2 CS Herediano Herediano 22 32 19 36
3 CS Cartaginés Cartaginés 22 45 36 34
4 Deportivo Saprissa Deportivo 22 30 30 34
5 San Carlos San Carlos 22 31 31 34
6 Sporting FC Sporting FC 22 29 28 30
7 Guadalupe Guadalupe 22 32 37 29
8 Santos de Guápiles Santos 22 28 31 26
9 Municipal Grecia Municipal 22 26 31 26
10 Jicaral Sercoba Jicaral 22 25 35 25
11 Pérez Zeledón Pérez 22 25 29 23
12 Guanacasteca Guanacasteca 22 23 36 22
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 LD Alajuelense Alajuelense 22 49 12 50
2 Santos de Guápiles Santos 22 36 29 36
3 CS Herediano Herediano 22 35 29 30
4 Deportivo Saprissa Deportivo 22 31 29 29
5 San Carlos San Carlos 22 21 24 29
6 Jicaral Sercoba Jicaral 22 21 24 28
7 Pérez Zeledón Pérez 22 22 29 28
8 CS Cartaginés Cartaginés 22 23 27 26
9 Municipal Grecia Municipal 22 22 29 23
10 Sporting FC Sporting FC 22 18 31 23
11 Guadalupe Guadalupe 22 33 31 22
12 Limón Limón 22 25 42 21
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 22 41 24 45
2 CS Herediano Herediano 22 40 21 40
3 LD Alajuelense Alajuelense 22 42 26 40
4 CS Cartaginés Cartaginés 22 33 35 35
5 Guadalupe Guadalupe 22 28 22 33
6 Jicaral Sercoba Jicaral 22 33 27 32
7 San Carlos San Carlos 22 41 41 29
8 Municipal Grecia Municipal 22 33 37 29
9 Pérez Zeledón Pérez 22 26 38 21
10 Santos de Guápiles Santos 21 31 41 20
11 Limón Limón 21 19 28 16
12 U Universitarios Universitari 22 27 54 16
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 San Carlos San Carlos 22 36 20 39
2 Deportivo Saprissa Deportivo 22 41 27 38
3 Pérez Zeledón Pérez 22 35 27 37
4 CS Herediano Herediano 22 31 24 34
5 CS Cartaginés Cartaginés 22 34 28 34
6 LD Alajuelense Alajuelense 22 33 27 32
7 Municipal Grecia Municipal 22 32 32 31
8 UCR UCR 22 35 38 31
9 Santos de Guápiles Santos 22 33 39 27
10 Limón Limón 22 22 32 26
11 Guadalupe Guadalupe 22 20 37 18
12 Carmelita Carmelita 22 19 40 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 CS Herediano Herediano 22 34 14 45
2 Deportivo Saprissa Deportivo 22 43 21 44
3 LD Alajuelense Alajuelense 22 46 25 43
4 Santos de Guápiles Santos 22 30 16 39
5 Guadalupe Guadalupe 22 28 32 29
6 Limón Limón 22 31 31 28
7 Pérez Zeledón Pérez 22 27 32 28
8 UCR UCR 22 26 32 25
9 Carmelita Carmelita 22 26 39 25
10 Municipal Grecia Municipal 22 27 34 24
11 Municipal Liberia Municipal 22 18 44 15
12 CS Cartaginés Cartaginés 22 16 32 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 22 30 19 44
2 CS Herediano Herediano 22 41 24 39
3 Limón Limón 22 43 31 37
4 Santos de Guápiles Santos 22 32 26 34
5 Pérez Zeledón Pérez 22 32 30 34
6 CS Cartaginés Cartaginés 22 28 28 33
7 LD Alajuelense Alajuelense 22 27 23 31
8 Municipal Liberia Municipal 22 20 32 27
9 San Carlos San Carlos 22 26 34 24
10 UCR UCR 22 22 33 22
11 Belén Siglo XXI Belén Siglo 22 24 37 19
12 Carmelita Carmelita 22 21 29 17
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 CS Herediano Herediano 22 35 13 50
2 Deportivo Saprissa Deportivo 22 36 16 47
3 LD Alajuelense Alajuelense 22 47 22 42
4 Belén Siglo XXI Belén Siglo 22 27 14 39
5 UCR UCR 22 29 29 32
6 CS Cartaginés Cartaginés 22 25 26 31
7 Pérez Zeledón Pérez 22 28 30 29
8 Municipal Liberia Municipal 22 19 27 25
9 Carmelita Carmelita 22 25 40 23
10 Limón Limón 22 15 36 21
11 Santos de Guápiles Santos 22 18 34 18
12 CS Uruguay Coronado Uruguay 22 16 33 17
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 22 44 22 45
2 Santos de Guápiles Santos 22 32 28 40
3 CS Herediano Herediano 22 28 23 39
4 LD Alajuelense Alajuelense 22 43 23 37
5 Pérez Zeledón Pérez 22 31 31 32
6 CS Uruguay Coronado Uruguay 22 28 27 29
7 CS Cartaginés Cartaginés 22 29 27 27
8 Carmelita Carmelita 22 23 34 26
9 Limón Limón 22 26 39 24
10 Jacó FC Jacó FC 22 24 36 23
11 UCR UCR 22 27 29 22
12 Belén Siglo XXI Belén Siglo 22 25 41 21
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 22 43 18 46
2 LD Alajuelense Alajuelense 22 40 21 42
3 CS Herediano Herediano 22 41 23 41
4 UCR UCR 22 31 32 35
5 Carmelita Carmelita 22 30 27 31
6 Belén Siglo XXI Belén Siglo 22 27 36 29
7 CS Uruguay Coronado Uruguay 22 27 31 28
8 Limón Limón 22 26 31 25
9 CS Cartaginés Cartaginés 22 21 29 24
10 Pérez Zeledón Pérez 22 28 36 23
11 Santos de Guápiles Santos 22 23 37 19
12 Puntarenas FC Puntarenas 22 24 40 17
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 CS Herediano Herediano 22 47 31 43
2 CS Cartaginés Cartaginés 22 29 18 41
3 Deportivo Saprissa Deportivo 22 34 24 38
4 Pérez Zeledón Pérez 22 31 28 35
5 LD Alajuelense Alajuelense 22 38 29 34
6 Puntarenas FC Puntarenas 22 35 35 30
7 Santos de Guápiles Santos 22 22 30 29
8 CS Uruguay Coronado Uruguay 22 30 27 28
9 San Carlos San Carlos 22 23 33 22
10 Carmelita Carmelita 22 27 37 21
11 Limón Limón 22 19 31 21
12 Belén Siglo XXI Belén Siglo 22 27 39 19
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Pérez Zeledón Pérez 20 38 25 37
2 Santos de Guápiles Santos 20 32 28 37
3 Deportivo Saprissa Deportivo 20 38 23 36
4 CS Herediano Herediano 20 33 20 34
5 LD Alajuelense Alajuelense 20 34 25 33
6 CS Cartaginés Cartaginés 20 33 30 33
7 San Carlos San Carlos 20 23 26 29
8 Belén Siglo XXI Belén Siglo 20 35 28 28
9 Puntarenas FC Puntarenas 20 23 35 18
10 Limón Limón 20 18 37 16
11 Orión FC Orión FC 20 12 42 8
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 16 31 14 33
2 Limón Limón 16 31 18 29
3 CS Cartaginés Cartaginés 16 25 14 28
4 Pérez Zeledón Pérez 16 23 21 21
5 Puntarenas FC Puntarenas 16 16 27 11
6 Barrio México Barrio 16 11 36 8
7 LD Alajuelense Alajuelense 16 26 20 31
8 San Carlos San Carlos 16 23 16 30
9 CS Herediano Herediano 16 25 19 26
10 Santos de Guápiles Santos 16 17 24 16
11 Brujas FC Brujas FC 16 22 31 16
12 Orión FC Orión FC 16 18 28 15
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 16 26 12 35
2 LD Alajuelense Alajuelense 16 19 6 34
3 Santos de Guápiles Santos 16 18 19 20
4 CS Cartaginés Cartaginés 16 14 15 20
5 Pérez Zeledón Pérez 16 18 22 19
6 Municipal Liberia Municipal 16 19 24 15
7 San Carlos San Carlos 16 16 12 29
8 CS Herediano Herediano 16 20 22 20
9 Puntarenas FC Puntarenas 16 14 21 17
10 Orión FC Orión FC 16 13 14 16
11 Ramonense PO Ramonense 16 15 18 16
12 Brujas FC Brujas FC 16 11 18 13
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Brujas FC Brujas FC 16 21 14 26
2 Municipal Liberia Municipal 16 19 16 26
3 Ramonense PO Ramonense 16 22 19 23
4 Puntarenas FC Puntarenas 16 18 21 21
5 Carmelita Carmelita 16 14 24 14
6 LD Alajuelense Alajuelense 16 14 22 13
7 Deportivo Saprissa Deportivo 16 26 13 33
8 CS Herediano Herediano 16 22 15 30
9 Pérez Zeledón Pérez 16 19 17 23
10 CS Cartaginés Cartaginés 16 13 11 23
11 San Carlos San Carlos 16 18 17 18
12 UCR UCR 16 11 28 10
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 16 27 20 30
2 CS Herediano Herediano 16 20 13 23
3 UCR UCR 16 23 22 22
4 Puntarenas FC Puntarenas 16 15 19 22
5 San Carlos San Carlos 16 16 17 19
6 Carmelita Carmelita 16 17 29 15
7 LD Alajuelense Alajuelense 16 22 13 30
8 Brujas FC Brujas FC 16 23 23 22
9 Pérez Zeledón Pérez 16 14 14 22
10 Municipal Liberia Municipal 16 22 20 21
11 CS Cartaginés Cartaginés 16 14 19 17
12 Santos de Guápiles Santos 16 16 20 14
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 16 28 12 32
2 Puntarenas FC Puntarenas 16 23 16 29
3 CS Herediano Herediano 16 22 12 26
4 San Carlos San Carlos 16 19 29 16
5 Municipal Liberia Municipal 16 14 22 14
6 Santacruceña Santacruceñ 16 13 28 10
7 LD Alajuelense Alajuelense 16 22 14 30
8 CS Cartaginés Cartaginés 16 14 14 25
9 Pérez Zeledón Pérez 16 21 18 24
10 Brujas FC Brujas FC 16 18 16 23
11 Santos de Guápiles Santos 16 24 20 21
12 Carmelita Carmelita 16 16 33 11
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Puntarenas FC Puntarenas 16 27 9 37
2 Municipal Liberia Municipal 16 28 18 32
3 Deportivo Saprissa Deportivo 16 18 14 29
4 LD Alajuelense Alajuelense 16 19 13 24
5 CS Herediano Herediano 16 17 14 24
6 Brujas FC Brujas FC 16 19 17 24
7 Pérez Zeledón Pérez 16 19 15 22
8 Ramonense PO Ramonense 16 14 17 20
9 Carmelita Carmelita 16 18 20 19
10 CS Cartaginés Cartaginés 16 14 20 16
11 Santos de Guápiles Santos 16 15 29 15
12 Santacruceña Santacruceñ 16 7 29 5
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 16 21 10 28
2 CS Herediano Herediano 16 21 12 28
3 Carmelita Carmelita 16 27 21 26
4 Puntarenas FC Puntarenas 16 31 24 23
5 Municipal Liberia Municipal 16 17 26 15
6 AD Ramonense Ramonense 16 17 27 15
7 LD Alajuelense Alajuelense 16 30 21 27
8 CS Cartaginés Cartaginés 16 22 19 24
9 Brujas FC Brujas FC 16 25 28 22
10 Pérez Zeledón Pérez 16 17 25 18
11 Belén Siglo XXI Belén Siglo 16 19 26 16
12 Santos de Guápiles Santos 16 16 24 15
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 CS Herediano Herediano 22 41 16 49
2 Deportivo Saprissa Deportivo 22 38 21 47
3 LD Alajuelense Alajuelense 22 43 33 36
4 Guanacasteca Guanacasteca 22 35 33 32
5 Santos de Guápiles Santos 22 31 24 30
6 Carmelita Carmelita 22 28 35 30
7 CS Cartaginés Cartaginés 22 22 28 28
8 San Carlos San Carlos 22 16 21 26
9 Pérez Zeledón Pérez 22 19 28 25
10 AD Ramonense Ramonense 22 25 34 24
11 Municipal Liberia Municipal 22 23 32 20
12 AD Barbareña Barbareña 22 24 40 17
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 LD Alajuelense Alajuelense 22 49 22 50
2 CS Cartaginés Cartaginés 22 45 31 43
3 CS Herediano Herediano 22 49 22 40
4 Deportivo Saprissa Deportivo 22 44 33 39
5 Pérez Zeledón Pérez 22 27 30 32
6 Santos de Guápiles Santos 22 29 33 26
7 Municipal Liberia Municipal 22 23 33 25
8 AD Barbareña Barbareña 22 34 42 24
9 Carmelita Carmelita 22 30 44 23
10 Curridabat Curridabat 22 27 49 22
11 San Carlos San Carlos 22 18 24 21
12 Guanacasteca Guanacasteca 22 22 34 21
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 LD Alajuelense Alajuelense 22 46 21 51
2 CS Herediano Herediano 22 30 26 35
3 Santos de Guápiles Santos 22 35 31 32
4 Municipal Liberia Municipal 22 36 32 31
5 Deportivo Saprissa Deportivo 22 39 33 30
6 Pérez Zeledón Pérez 22 32 30 30
7 AD Barbareña Barbareña 22 31 31 29
8 CS Cartaginés Cartaginés 22 27 27 29
9 Curridabat Curridabat 22 26 30 26
10 Carmelita Carmelita 22 27 41 24
11 San Carlos San Carlos 22 23 32 23
12 Limón Limón 22 28 46 19
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 LD Alajuelense Alajuelense 10 25 10 25
2 CS Cartaginés Cartaginés 10 10 13 13
3 San Carlos San Carlos 10 10 14 13
4 Pérez Zeledón Pérez 10 18 19 12
5 Curridabat Curridabat 10 12 16 12
6 Puntarenas FC Puntarenas 10 16 19 10

  USO DE MEMORIA  
6,921,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1658
Total Execution Time  0.1677
  CADENA URL  
/verano_costa_rica2022/grupo1/historico
  GET DATOS  
$_GET['/verano_costa_rica2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'verano_costa_rica2022'
0.0037  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'verano_costa_rica' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=146 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 146 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1260009,1257105,1256319,1255432,1254298) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 66234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 146 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 66234 AND t.round = 22 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 = 60632 AND t.round = 22 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 `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 = 50575 AND t.round = 22 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 `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 = 48503 AND t.round = 22 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 `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 = 41697 AND t.round = 22 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 = 37317 AND t.round = 22 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 = 16426 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 4030 AND t.round = 22 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 `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 = 2520 AND t.round = 22 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 `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 = 2296 AND t.round = 22 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 = 1676 AND t.round = 22 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 `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 = 1675 AND t.round = 16 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 `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 = 1022 AND t.round = 16 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 `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 = 14990 AND t.round = 16 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 `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 = 14992 AND t.round = 16 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 `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 = 14993 AND t.round = 16 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 `tables2006` 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 = 14995 AND t.round = 16 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 `tables2005` 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 = 27446 AND t.round = 16 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 `tables2004` 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 = 27452 AND t.round = 22 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 `tables2003` 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 = 27456 AND t.round = 22 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 `tables2002` 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 = 27457 AND t.round = 22 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 `tables2001` 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 = 27461 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 09:41:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 09:41:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 09:41:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 09:41:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'verano_costa_rica' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0141  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 66234 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66234 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0184  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 66234 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66234 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0040  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 66234 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66234 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0043  SELECT *,(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 = 66234 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC