4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Auckland City Auckland 14 27 13 28
2 Team Wellington Team 14 35 21 26
3 Hamilton Wanderers Hamilton 14 23 21 20
4 Eastern Suburbs AFC Eastern 14 25 23 19
5 Waitakere United Waitakere 14 28 26 18
6 Canterbury United Canterbury 14 21 24 18
7 Hawkes Bay United Hawkes 14 17 29 13
8 Wellington Phoenix Reserves Wellington 14 18 37 10
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Auckland City Auckland 16 42 15 37
2 Team Wellington Team 16 36 15 34
3 Waitakere United Waitakere 16 35 32 27
4 Eastern Suburbs AFC Eastern 16 33 26 22
5 Tasman United Tasman 16 27 26 20
6 Hamilton Wanderers Hamilton 16 24 39 20
7 Southern United Southern 16 25 38 19
8 Wellington Phoenix Reserves Wellington 16 30 32 18
9 Hawkes Bay United Hawkes 16 32 44 15
10 Canterbury United Canterbury 16 19 36 10
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Auckland City Auckland 18 46 18 52
2 Eastern Suburbs AFC Eastern 18 53 16 40
3 Canterbury United Canterbury 18 34 29 34
4 Team Wellington Team 18 43 25 34
5 Southern United Southern 18 24 30 23
6 Hamilton Wanderers Hamilton 18 34 44 17
7 Hawkes Bay United Hawkes 18 38 55 17
8 Tasman United Tasman 18 22 36 14
9 Waitakere United Waitakere 18 29 46 13
10 Wellington Phoenix Reserves Wellington 18 22 46 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Auckland City Auckland 18 41 12 40
2 Team Wellington Team 18 39 20 37
3 Canterbury United Canterbury 18 35 20 36
4 Eastern Suburbs AFC Eastern 18 37 24 32
5 Southern United Southern 18 28 27 24
6 Tasman United Tasman 18 34 39 23
7 Waitakere United Waitakere 18 30 34 19
8 Hawkes Bay United Hawkes 18 21 36 19
9 Wellington Phoenix Reserves Wellington 18 27 53 15
10 Hamilton Wanderers Hamilton 18 23 50 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Auckland City Auckland 18 35 15 36
2 Team Wellington Team 18 51 32 36
3 Waitakere United Waitakere 18 31 25 34
4 Hawkes Bay United Hawkes 18 46 30 32
5 Eastern Suburbs AFC Eastern 18 28 25 30
6 Canterbury United Canterbury 18 32 28 24
7 Wellington Phoenix Reserves Wellington 18 25 33 22
8 Tasman United Tasman 18 29 42 17
9 Hamilton Wanderers Hamilton 18 24 50 13
10 Southern United Southern 18 20 41 10
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Auckland City Auckland 14 43 12 38
2 Hawkes Bay United Hawkes 14 29 16 30
3 Team Wellington Team 14 36 21 27
4 Canterbury United Canterbury 14 28 23 26
5 WaiBOP WaiBOP 14 29 27 18
6 Waitakere United Waitakere 14 23 36 13
7 Wellington Phoenix Reserves Wellington 14 24 46 7
8 Southern United Southern 14 11 42 3
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Auckland City Auckland 16 39 14 42
2 Team Wellington Team 16 32 24 30
3 Hawkes Bay United Hawkes 16 34 29 27
4 Waitakere United Waitakere 16 29 23 26
5 WaiBOP WaiBOP 16 24 29 22
6 Wellington Phoenix Reserves Wellington 16 37 42 21
7 Wanderers SC Wanderers 16 24 29 17
8 Canterbury United Canterbury 16 22 32 14
9 Southern United Southern 16 20 39 10
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Auckland City Auckland 14 40 12 33
2 Team Wellington Team 14 37 25 26
3 Hawkes Bay United Hawkes 14 32 26 26
4 Waitakere United Waitakere 14 30 19 23
5 Canterbury United Canterbury 14 22 16 22
6 WaiBOP WaiBOP 14 24 31 14
7 Southern United Southern 14 19 50 10
8 Wanderers SC Wanderers 14 17 42 2
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Waitakere United Waitakere 14 48 12 37
2 Auckland City Auckland 14 44 18 33
3 Canterbury United Canterbury 14 34 19 28
4 Hawkes Bay United Hawkes 14 29 21 24
5 Team Wellington Team 14 27 21 21
6 Waikato FC Waikato FC 14 18 48 9
7 Otago United Otago United 14 14 40 6
8 Manawatu Manawatu 14 15 50 6
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Auckland City Auckland 14 43 11 36
2 Canterbury United Canterbury 14 38 12 29
3 Waitakere United Waitakere 14 44 17 27
4 Team Wellington Team 14 33 20 24
5 Hawkes Bay United Hawkes 14 28 35 19
6 Otago United Otago United 14 17 37 12
7 Waikato FC Waikato FC 14 17 39 9
8 Manawatu Manawatu 14 12 61 3
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Waitakere United Waitakere 14 39 12 36
2 Auckland City Auckland 14 29 12 30
3 Team Wellington Team 14 28 23 23
4 Canterbury United Canterbury 14 20 19 20
5 Hawkes Bay United Hawkes 14 18 22 19
6 Waikato FC Waikato FC 14 21 33 15
7 Otago United Otago United 14 15 30 12
8 Manawatu Manawatu 14 19 38 4
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Auckland City Auckland 14 33 13 31
2 Waitakere United Waitakere 14 31 22 29
3 Team Wellington Team 14 22 24 21
4 Canterbury United Canterbury 14 23 16 18
5 Otago United Otago United 14 16 22 18
6 Manawatu Manawatu 14 19 24 16
7 Hawkes Bay United Hawkes 14 18 27 15
8 Waikato FC Waikato FC 14 19 33 10
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Waitakere United Waitakere 14 30 12 33
2 Auckland City Auckland 14 27 15 25
3 Manawatu Manawatu 14 22 19 23
4 Team Wellington Team 14 28 28 23
5 Hawkes Bay United Hawkes 14 24 17 22
6 Waikato FC Waikato FC 14 19 22 19
7 Otago United Otago United 14 16 32 8
8 Canterbury United Canterbury 14 11 32 8
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Waitakere United Waitakere 21 51 14 51
2 Auckland City Auckland 21 44 16 50
3 Team Wellington Team 21 51 21 47
4 Hawkes Bay United Hawkes 21 29 33 29
5 Waikato FC Waikato FC 21 24 34 20
6 Manawatu Manawatu 21 32 57 17
7 Otago United Otago United 21 13 43 13
8 Canterbury United Canterbury 21 22 48 12
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Manawatu Manawatu 21 58 30 45
2 Waitakere United Waitakere 21 47 23 45
3 Auckland City Auckland 21 50 30 43
4 Canterbury United Canterbury 21 33 30 31
5 Team Wellington Team 21 37 34 27
6 Hawkes Bay United Hawkes 21 29 49 16
7 Waikato FC Waikato FC 21 19 45 14
8 Otago United Otago United 21 19 51 12
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Auckland City Auckland 21 63 28 48
2 Manawatu Manawatu 21 50 29 46
3 Canterbury United Canterbury 21 36 22 41
4 Team Wellington Team 21 43 53 28
5 Southern United Southern 21 27 25 27
6 Waitakere United Waitakere 21 38 41 22
7 WaiBOP WaiBOP 21 31 44 22
8 Hawkes Bay United Hawkes 21 17 63 5
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Auckland City Auckland 21 53 24 46
2 Waitakere United Waitakere 21 39 19 40
3 WaiBOP WaiBOP 21 27 25 31
4 Canterbury United Canterbury 21 31 38 27
5 Napier City Rovers Napier City 21 39 48 26
6 Team Wellington Team 21 35 40 23
7 Southern United Southern 21 26 46 20
8 Manawatu Manawatu 21 26 36 18
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Miramar Miramar 18 46 29 33
2 East Auckland East 18 34 24 33
3 Central United Central 18 44 29 31
4 Napier City Rovers Napier City 18 29 28 29
5 Manawatu Manawatu 18 32 29 27
6 Canterbury United Canterbury 18 34 34 26
7 North Shore North Shore 18 30 34 23
8 Caversham Caversham 18 19 26 20
9 Dunedin Dunedin 18 24 38 20
10 Tauranga Tauranga 18 20 41 14
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Napier City Rovers Napier City 18 50 27 42
2 Miramar Miramar 18 51 22 37
3 North Shore North Shore 18 33 18 37
4 Tauranga Tauranga 18 36 18 32
5 Canterbury United Canterbury 18 31 30 28
6 Manawatu Manawatu 18 32 43 22
7 Central United Central 18 25 46 17
8 Dunedin Dunedin 18 19 32 15
9 Mt. Wellington Wellington 18 21 36 15
10 Waitakere United Waitakere 18 18 44 8
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Miramar Miramar 18 53 24 43
2 Central United Central 18 49 27 35
3 Manawatu Manawatu 18 37 28 34
4 Mt. Wellington Wellington 18 30 24 34
5 Napier City Rovers Napier City 18 41 41 28
6 Waitakere United Waitakere 18 46 37 25
7 Tauranga Tauranga 18 33 39 20
8 Dunedin Dunedin 18 32 40 20
9 Christchurch C Christchurch 18 21 39 11
10 Metro Metro 18 15 58 4
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Mt. Wellington Wellington 20 38 23 40
2 Napier City Rovers Napier City 20 41 20 37
3 Dunedin Dunedin 19 32 29 27
4 Manawatu Manawatu 19 31 31 27
5 Waitakere City Waitakere 18 37 34 24
6 Nelson Nelson 18 32 37 24
7 Central United Central 18 29 28 23
8 Miramar Miramar 18 28 33 23
9 Metro Metro 19 26 46 20
10 Christchurch C Christchurch 18 23 35 18
11 Caversham Caversham 1 2 3 0

  USO DE MEMORIA  
6,163,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6194
Total Execution Time  0.6213
  CADENA URL  
/liga_nueva_zelanda2021/grupo1/historico
  GET DATOS  
$_GET['/liga_nueva_zelanda2021/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0126  SELECT type FROM routes WHERE alias = 'liga_nueva_zelanda2021'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_nueva_zelanda' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=517 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 517 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (940177,894718,810553,663122,649044) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=517 ORDER BY order_id ASC
0.0126  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 = 59656 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 517 AND group_code = 1 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 59656 AND t.round = 14 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 `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 = 51511 AND t.round = 20 ORDER BY team.conference ASC,t.position 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 `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 = 45471 AND t.round = 18 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 `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 = 40647 AND t.round = 18 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 = 35802 AND t.round = 18 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 `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 = 15489 AND t.round = 14 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 = 9191 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 3705 AND t.round = 14 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 `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 = 3297 AND t.round = 14 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 = 10810 AND t.round = 14 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 `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 = 10809 AND t.round = 14 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 `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 = 10808 AND t.round = 14 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 `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 = 10807 AND t.round = 14 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 `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 = 10816 AND t.round = 21 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 `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 = 10815 AND t.round = 21 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 `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 = 16253 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 16254 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 16255 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 16256 AND t.round = 18 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 `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 = 16257 AND t.round = 18 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 `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 = 23741 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 11:53:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 11:53:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 11:53:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 11:53:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0135  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_nueva_zelanda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0204  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 events2021 e ON e.player_id = p.id AND e.league_id = 59656 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59656 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.0189  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 events2021 e ON e.player_id = p.id AND e.league_id = 59656 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59656 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0129  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 events2021 e ON e.player_id = p.id AND e.league_id = 59656 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59656 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134  SELECT *,(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 = 59656 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC