4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Inter Escaldes Inter 21 37 13 47
2 FC Santa Coloma Santa Coloma 21 43 11 44
3 Sant Julià Sant Julià 21 26 23 36
4 Engordany Engordany 21 33 26 35
5 UE Santa Coloma Santa Coloma 21 25 23 32
6 Atlètic Escaldes Atlètic 21 23 27 23
7 Carroi Carroi 21 11 38 9
8 FC Ordino FC Ordino 21 15 52 9
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Sant Julià Sant Julià 21 42 16 45
2 FC Santa Coloma Santa Coloma 21 32 12 43
3 Inter Escaldes Inter 21 30 21 40
4 Engordany Engordany 21 26 24 31
5 FC Ordino FC Ordino 21 27 32 23
6 UE Santa Coloma Santa Coloma 21 25 29 21
7 Lusitanos Lusitanos 21 21 38 19
8 Encamp Encamp 21 16 47 10
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 21 55 16 48
2 Engordany Engordany 21 45 11 47
3 Sant Julià Sant Julià 21 58 15 42
4 Lusitanos Lusitanos 21 49 26 34
5 UE Santa Coloma Santa Coloma 21 35 25 29
6 Inter Escaldes Inter 21 33 29 25
7 Encamp Encamp 21 26 76 10
8 Penya Encarnada Penya 21 10 113 2
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 21 44 14 48
2 Sant Julià Sant Julià 21 49 16 44
3 UE Santa Coloma Santa Coloma 21 54 22 44
4 Lusitanos Lusitanos 21 40 20 39
5 Engordany Engordany 21 35 27 30
6 Encamp Encamp 21 18 31 15
7 FC Ordino FC Ordino 21 24 49 12
8 Jenlai Jenlai 21 10 95 1
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 14 41 7 37
2 Lusitanos Lusitanos 14 28 18 30
3 UE Santa Coloma Santa Coloma 14 31 11 27
4 Sant Julià Sant Julià 14 30 14 24
5 Engordany Engordany 14 18 22 17
6 Encamp Encamp 14 15 41 11
7 FC Ordino FC Ordino 14 15 35 10
8 Penya Encarnada Penya 14 6 36 5
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 14 53 7 31
2 Lusitanos Lusitanos 14 45 17 31
3 Sant Julià Sant Julià 14 37 10 30
4 UE Santa Coloma Santa Coloma 14 28 8 29
5 FC Ordino FC Ordino 14 19 24 17
6 Encamp Encamp 14 13 33 13
7 Engordany Engordany 14 11 62 7
8 Inter Escaldes Inter 14 7 52 4
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 UE Santa Coloma Santa Coloma 14 41 7 32
2 Lusitanos Lusitanos 14 50 11 30
3 Sant Julià Sant Julià 14 41 14 30
4 FC Santa Coloma Santa Coloma 14 35 17 29
5 FC Ordino FC Ordino 14 26 27 20
6 Encamp Encamp 14 21 47 13
7 Inter Escaldes Inter 14 11 41 7
8 Principat Principat 14 1 62 1
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Lusitanos Lusitanos 14 55 11 33
2 UE Santa Coloma Santa Coloma 14 39 14 30
3 Sant Julià Sant Julià 14 32 9 30
4 FC Santa Coloma Santa Coloma 14 25 12 29
5 Principat Principat 14 17 30 12
6 Encamp Encamp 14 14 49 10
7 Engordany Engordany 14 14 47 8
8 Inter Escaldes Inter 14 14 38 6
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 14 51 9 32
2 Lusitanos Lusitanos 14 40 12 31
3 UE Santa Coloma Santa Coloma 14 54 12 30
4 Sant Julià Sant Julià 14 47 14 28
5 Principat Principat 14 17 27 12
6 Engordany Engordany 14 17 45 12
7 Inter Escaldes Inter 14 13 51 10
8 FC Rangers FC Rangers 14 8 77 3
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Sant Julià Sant Julià 14 39 4 34
2 FC Santa Coloma Santa Coloma 14 63 7 33
3 Lusitanos Lusitanos 14 34 12 32
4 UE Santa Coloma Santa Coloma 14 51 16 27
5 Inter Escaldes Inter 14 17 46 13
6 Principat Principat 14 19 32 12
7 Casa Estrella Benfica Casa 14 10 67 5
8 Encamp Encamp 14 14 63 4
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 14 38 10 36
2 Sant Julià Sant Julià 14 59 12 32
3 UE Santa Coloma Santa Coloma 14 41 20 32
4 Lusitanos Lusitanos 14 30 17 23
5 Principat Principat 14 27 33 21
6 Encamp Encamp 14 19 50 10
7 Inter Escaldes Inter 14 10 41 4
8 Engordany Engordany 14 11 52 4
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Sant Julià Sant Julià 14 69 10 35
2 FC Santa Coloma Santa Coloma 14 58 5 33
3 Lusitanos Lusitanos 14 36 17 30
4 Principat Principat 14 32 31 25
5 UE Santa Coloma Santa Coloma 14 35 28 21
6 Engordany Engordany 14 21 75 9
7 Inter Escaldes Inter 14 12 48 7
8 FC Rangers FC Rangers 14 22 71 3
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 14 58 4 36
2 FC Rangers FC Rangers 14 37 16 33
3 Sant Julià Sant Julià 14 46 11 30
4 Lusitanos Lusitanos 14 34 13 27
5 Principat Principat 14 20 33 17
6 Engordany Engordany 14 17 61 10
7 Inter Escaldes Inter 14 11 32 7
8 Casa Estrella Benfica Casa 14 4 57 1
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 FC Rangers FC Rangers 14 42 8 37
2 FC Santa Coloma Santa Coloma 14 35 10 37
3 Sant Julià Sant Julià 14 29 12 24
4 Lusitanos Lusitanos 14 19 20 20
5 Principat Principat 14 15 33 15
6 Inter Escaldes Inter 14 14 28 12
7 Encamp Encamp 14 13 30 7
8 Atlètic Escaldes Atlètic 14 13 39 6
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 FC Rangers FC Rangers 14 62 7 37
2 Sant Julià Sant Julià 14 53 12 32
3 FC Santa Coloma Santa Coloma 14 41 12 28
4 Lusitanos Lusitanos 14 26 29 24
5 Inter Escaldes Inter 14 22 23 23
6 Atlètic Escaldes Atlètic 14 10 24 12
7 Principat Principat 14 12 45 5
8 UE Extremenya Extremenya 14 9 83 1
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Sant Julià Sant Julià 14 42 8 39
2 FC Rangers FC Rangers 14 46 13 36
3 FC Santa Coloma Santa Coloma 14 43 15 33
4 Principat Principat 14 19 21 19
5 Inter Escaldes Inter 14 27 37 17
6 Encamp Encamp 14 11 32 8
7 Lusitanos Lusitanos 14 13 37 7
8 Atlètic Escaldes Atlètic 14 11 49 6
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 14 34 13 34
2 Sant Julià Sant Julià 14 47 13 32
3 FC Rangers FC Rangers 14 30 11 27
4 Encamp Encamp 14 27 11 24
5 Principat Principat 14 29 31 20
6 Lusitanos Lusitanos 14 11 21 12
7 Inter Escaldes Inter 14 13 34 7
8 Engordany Engordany 14 10 67 4
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 FC Santa Coloma Santa Coloma 16 51 8 42
2 Encamp Encamp 16 49 10 34
3 Sant Julià Sant Julià 16 57 17 30
4 Inter Escaldes Inter 16 30 33 26
5 Principat Principat 16 32 25 23
6 Lusitanos Lusitanos 16 44 33 22
7 FC Rangers FC Rangers 16 39 39 21
8 UE Extremenya Extremenya 16 17 63 7
9 Sporting Escaldes Sporting 16 10 101 0
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Sant Julià Sant Julià 14 39 9 35
2 Encamp Encamp 14 34 12 34
3 FC Santa Coloma Santa Coloma 14 43 17 31
4 FC Rangers FC Rangers 14 23 20 19
5 Principat Principat 14 24 32 14
6 Lusitanos Lusitanos 14 19 30 12
7 Inter Escaldes Inter 14 15 39 7
8 Sporting Escaldes Sporting 14 11 49 6
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Sant Julià Sant Julià 14 47 16 36
2 FC Santa Coloma Santa Coloma 14 29 14 31
3 Inter Escaldes Inter 14 25 22 19
4 Principat Principat 14 20 24 19
5 Encamp Encamp 14 25 29 18
6 Lusitanos Lusitanos 14 21 37 12
7 Deportivo La Massana Deportivo 14 17 30 11
8 Sporting Escaldes Sporting 14 21 33 8
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Constelacio Constelacio 10 58 6 30
2 FC Santa Coloma Santa Coloma 11 30 9 25
3 Inter Escaldes Inter 11 24 23 20
4 Encamp Encamp 10 29 18 14
5 Sant Julià Sant Julià 10 21 29 10
6 Principat Principat 10 14 37 3
7 Sporting Escaldes Sporting 10 9 63 2

  USO DE MEMORIA  
6,015,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1481
Total Execution Time  0.1501
  CADENA URL  
/1_st_division_andorra2020/grupo1/historico
  GET DATOS  
$_GET['/1_st_division_andorra2020/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = '1_st_division_andorra2020'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_st_division_andorra' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 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=417 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 417 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 (1294805,1156371,1021672,835971,818960) 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 = 49906 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 417 AND group_code = 1 and tables = 1 AND year <= 2020 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 `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 = 49906 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 43670 AND t.round = 21 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 = 38797 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 33782 AND t.round = 21 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 `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 = 15469 AND t.round = 14 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 `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 = 4046 AND t.round = 14 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 `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 = 2984 AND t.round = 14 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 `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 = 2183 AND t.round = 14 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 `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 = 8835 AND t.round = 14 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 = 8834 AND t.round = 14 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 = 8831 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 8830 AND t.round = 14 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 `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 = 8828 AND t.round = 14 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 `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 = 8827 AND t.round = 14 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 `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 = 8826 AND t.round = 14 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 `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 = 8825 AND t.round = 14 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 `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 = 8823 AND t.round = 14 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 `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 = 8822 AND t.round = 18 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 `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 = 8820 AND t.round = 14 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 = 8819 AND t.round = 14 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 `tables2000` 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 = 8818 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 10:17:11' 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-27 10:17:11' 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=4 AND last_update > '2024-04-27 10:17:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 10:17:11' 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 = '1_st_division_andorra' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0111  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 events2020 e ON e.player_id = p.id AND e.league_id = 49906 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49906 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.0110  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 events2020 e ON e.player_id = p.id AND e.league_id = 49906 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49906 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 events2020 e ON e.player_id = p.id AND e.league_id = 49906 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49906 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  SELECT *,(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 = 49906 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC