4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Dubnica Dubnica 34 83 10 86
2 Borčice Borčice 34 78 35 71
3 Nové Zámky Nové Zámky 34 58 31 71
4 Lednické Rovne Lednické 34 61 33 66
5 Slovan Galanta Slovan 34 58 42 53
6 DAC II DAC II 34 51 38 52
7 Zlaté Moravce - Vrablé II Zlaté 34 60 53 52
8 Spartak Trnava II Spartak 34 59 46 50
9 MŠK Púchov MŠK Púchov 34 68 49 48
10 Nitra II Nitra II 34 57 47 48
11 Veľké Ludince Veľké 34 50 57 47
12 Gabčíkovo Gabčíkovo 34 55 47 46
13 Slovan Duslo Sala Slovan Duslo 34 49 65 45
14 Slovan Nemsova Slovan 34 46 59 42
15 Beluša Beluša 34 50 62 38
16 Baník Horná Nitra Baník 34 36 75 25
17 Spartak Bánovce Spartak 34 23 90 20
18 Topoľčany Topoľčany 34 25 128 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Inter Bratislava Inter 30 93 11 76
2 Rohoznik Rohoznik 30 102 23 75
3 Tomášov Tomášov 30 78 48 58
4 Dunajská Lužná Dunajská 30 67 42 51
5 Vajnory Vajnory 30 57 41 49
6 Slovan Ivanka pri Dunaji Slovan 30 51 55 47
7 Lokomotiva DNV Lokomotiva 30 73 51 44
8 FK Rača FK Rača 30 51 41 40
9 Rovinka Rovinka 30 53 59 39
10 Báhoň Báhoň 30 45 56 36
11 Slovan Most Slovan Most 30 37 50 34
12 Lozorno Lozorno 30 41 59 34
13 Pezinok Pezinok 30 35 65 34
14 FC Malacky FC Malacky 30 51 66 33
15 Bernolákovo Bernolákovo 30 39 67 33
16 Kráľová pri Senci Kráľová 30 19 158 1
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Šamorín Šamorín 32 61 32 66
2 MŠK Púchov MŠK Púchov 32 53 29 60
3 Horses Surovce Horses 33 69 41 59
4 Veľký Meder Veľký 33 52 39 58
5 DAC II DAC II 33 41 30 52
6 Slovan Nemsova Slovan 32 46 34 51
7 Veľké Ludince Veľké 33 46 40 50
8 Baník Horná Nitra Baník 32 51 45 47
9 Komárno Komárno 32 51 51 46
10 Slovan Galanta Slovan 33 54 62 45
11 Nové Zámky Nové Zámky 32 43 39 42
12 Lednické Rovne Lednické 32 37 44 42
13 Spartak Vráble Spartak 33 31 45 39
14 Topoľčany Topoľčany 33 33 57 35
15 Dubnica Dubnica 33 30 46 31
16 Neded Neded 32 40 62 27
17 Palárikovo Palárikovo 33 25 64 16
18 Gabčíkovo Gabčíkovo 9 11 14 6
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Borčice Borčice 32 72 18 75
2 Veľký Meder Veľký 32 63 19 70
3 Gabčíkovo Gabčíkovo 32 63 30 58
4 Neded Neded 32 40 32 55
5 Veľké Ludince Veľké 32 46 31 52
6 Palárikovo Palárikovo 32 37 32 45
7 Spartak Vráble Spartak 32 32 34 45
8 Horses Surovce Horses 32 51 49 44
9 Slovan Nemsova Slovan 32 33 37 42
10 Topoľčany Topoľčany 32 38 55 40
11 DAC II DAC II 32 38 41 39
12 Komárno Komárno 32 39 46 39
13 Nové Zámky Nové Zámky 32 38 51 37
14 MŠK Púchov MŠK Púchov 32 26 35 36
15 Lednické Rovne Lednické 32 27 59 29
16 Vrbové Vrbové 32 20 49 22
17 Slovan Levice Slovan 32 28 73 21
18 Piešťany Piešťany 0 0 0 0

  USO DE MEMORIA  
5,409,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0645
Total Execution Time  0.0664
  CADENA URL  
/tercera_eslovaquia2018/grupo4/historico
  GET DATOS  
$_GET['/tercera_eslovaquia2018/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = 'tercera_eslovaquia2018'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_eslovaquia' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1607 AND group_code = 4 and tables = 1 AND year <= 2018 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 34133 AND t.round = 30 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 `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 = 15818 AND t.round = 34 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 `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 = 9377 AND t.round = 34 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-05-01 23:43:53' 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-05-01 23:43:53' 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-05-01 23:43:53' 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=3 AND last_update > '2024-05-01 23:43:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_eslovaquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2018 e ON e.player_id = p.id AND e.league_id = 39128 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39128 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.0019  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 events2018 e ON e.player_id = p.id AND e.league_id = 39128 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39128 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events2018 e ON e.player_id = p.id AND e.league_id = 39128 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39128 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(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 = 39128 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC