4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Slavoj Trebišov Slavoj 27 65 12 65
2 Vyšné Opátske Vyšné 27 63 21 59
3 Svit Svit 27 57 35 45
4 Svidník Svidník 27 46 37 45
5 Snina Snina 27 51 30 42
6 Vranov nad Topľou Vranov 27 36 31 41
7 Slovan Giraltovce Slovan 27 41 30 39
8 Družstevník Plavnica Družstevní 27 42 43 37
9 Milénium Milénium 27 43 55 35
10 Slovan Sabinov Slovan 27 40 44 32
11 Veľké Revištia Veľké 27 36 43 30
12 MSK Tesla Stropkov Tesla 27 38 42 29
13 Tatran Prešov II Tatran 27 37 48 24
14 Družstevník Veľký Horeš Družstevní 14 23 19 21
15 Rozvoj Pušovce Rozvoj 27 7 135 4
16 Krásna Krásna 0 0 0 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Fomat Martin Fomat Martin 30 76 17 76
2 Kremnička Kremnička 30 62 28 62
3 Liptovský Hrádok Liptovský 30 62 25 60
4 Žarnovica Žarnovica 30 61 52 58
5 Námestovo Námestovo 30 52 30 53
6 Javorník Makov Javorník 30 64 58 46
7 Baník Kalinovo Baník 30 55 44 44
8 Podbrezová II Podbrezová 30 49 44 42
9 Čadca Čadca 30 45 51 42
10 Liptovská Štiavnica Liptovská 30 47 52 39
11 Tatran Krásno Tatran 30 39 42 37
12 MFK Detva MFK Detva 30 46 57 34
13 LAFC Lučenec LAFC 30 43 55 32
14 Nová Bana Nová Bana 30 43 56 31
15 Bytča Bytča 30 40 84 29
16 Pohronie II Pohronie II 30 20 109 2
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Dunajská Lužná Dunajská 30 81 22 74
2 Rohoznik Rohoznik 30 61 19 69
3 FK Rača FK Rača 30 64 29 57
4 Kráľová pri Senci Kráľová 30 42 25 50
5 Slovan Most Slovan Most 30 37 31 48
6 Inter Bratislava Inter 30 46 41 47
7 Svätý Jur Svätý Jur 30 52 35 43
8 Rovinka Rovinka 30 41 41 42
9 Lozorno Lozorno 30 34 37 41
10 Tomášov Tomášov 30 33 38 41
11 Báhoň Báhoň 30 33 47 36
12 Bernolákovo Bernolákovo 30 42 57 35
13 Slovenský Grob Slovenský 30 36 69 25
14 Viničné Viničné 30 28 69 21
15 Slovan Ivanka pri Dunaji Slovan 30 19 60 21
16 Stupava Stupava 30 22 51 19
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Sered Sered 30 86 27 70
2 Skalica Skalica 30 70 26 68
3 Nove Mesto Nad Vahom Nove Mesto. 30 50 26 62
4 Slovan Bratislava II Slovan 30 83 35 59
5 Topoľčany Topoľčany 30 45 22 56
6 Dunajská Lužná Dunajská 30 60 35 51
7 Horses Surovce Horses 30 59 49 46
8 Slovan Nemsova Slovan 30 36 39 40
9 Spartak Vráble Spartak 30 33 38 37
10 Nové Zámky Nové Zámky 30 35 52 35
11 Vrbové Vrbové 30 33 47 34
12 FC Petržalka Petržalka 30 40 52 32
13 FK Rača FK Rača 30 34 48 29
14 Púchov Púchov 30 34 51 28
15 Slovan Levice Slovan 30 30 69 23
16 Piešťany Piešťany 30 8 120 7
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Spartak Trnava II Spartak 30 59 30 55
2 Slovan Bratislava II Slovan 30 55 40 50
3 Sered Sered 30 62 48 50
4 Slovan Levice Slovan 30 40 30 49
5 Piešťany Piešťany 30 46 37 49
6 Topoľčany Topoľčany 30 51 51 46
7 Nové Zámky Nové Zámky 30 51 38 45
8 Spartak Vráble Spartak 30 47 47 44
9 Dunajská Lužná Dunajská 30 30 28 41
10 Nove Mesto Nad Vahom Nove Mesto. 30 37 37 39
11 FC Petržalka Petržalka 30 30 43 36
12 OSK Moravany nad Váhom Moravany 30 40 55 35
13 Slovan Nemsova Slovan 30 30 37 34
14 Domino Bratislava Domino 30 29 44 34
15 Vrbové Vrbové 30 21 38 34
16 Nitra II Nitra II 30 27 52 29
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Slovan Duslo Sala Slovan Duslo 28 62 25 59
2 Šamorín Šamorín 28 48 21 52
3 Nove Mesto Nad Vahom Nove Mesto. 28 45 36 51
4 Sered Sered 28 45 28 48
5 Spartak Vráble Spartak 28 43 35 41
6 Slovan Bratislava II Slovan 28 49 45 41
7 Spartak Trnava II Spartak 28 60 55 39
8 Dunajská Lužná Dunajská 28 29 39 39
9 Vrbové Vrbové 28 27 40 36
10 Nové Zámky Nové Zámky 28 34 34 34
11 Nitra II Nitra II 28 39 43 34
12 Pezinok Pezinok 28 23 35 34
13 OSK Moravany nad Váhom Moravany 28 32 52 30
14 Slovan Nemsova Slovan 28 38 52 29
15 Topoľčany Topoľčany 28 29 63 18
16 Púchov Púchov 0 0 0 0
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Spartak Myjava Spartak 30 63 14 67
2 Slovan Nemsova Slovan 30 55 23 60
3 Spartak Vráble Spartak 30 38 36 52
4 Nove Mesto Nad Vahom Nove Mesto. 30 55 33 51
5 Nitra II Nitra II 30 51 45 47
6 Slovan Bratislava II Slovan 30 45 32 46
7 Vrbové Vrbové 30 38 39 45
8 Spartak Trnava II Spartak 30 47 42 41
9 Nové Zámky Nové Zámky 30 37 47 37
10 Topoľčany Topoľčany 30 36 46 37
11 OSK Moravany nad Váhom Moravany 30 31 51 37
12 Pezinok Pezinok 30 33 43 36
13 Šamorín Šamorín 30 45 39 35
14 FK Rača FK Rača 30 32 59 29
15 Jaslovské Bohunice Jaslovské 30 35 64 27
16 Bernolákovo Bernolákovo 30 31 59 25
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Senec Senec 30 51 21 71
2 OSK Moravany nad Váhom Moravany 30 49 32 52
3 Spartak Trnava II Spartak 30 47 40 46
4 Spartak Myjava Spartak 30 27 22 46
5 Nové Zámky Nové Zámky 30 33 29 46
6 Bernolákovo Bernolákovo 30 42 40 43
7 Slovan Bratislava II Slovan 30 41 32 42
8 Nitra II Nitra II 30 52 43 41
9 Nove Mesto Nad Vahom Nove Mesto. 30 42 42 41
10 Slovan Nemsova Slovan 30 36 37 41
11 Spartak Vráble Spartak 30 36 32 40
12 Jaslovské Bohunice Jaslovské 30 34 38 40
13 Vrbové Vrbové 30 25 34 34
14 FK Rača FK Rača 30 36 42 33
15 Topoľčany Topoľčany 30 37 54 28
16 DAC II DAC II 30 26 76 17
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Púchov Púchov 29 63 20 64
2 Senec Senec 30 61 33 61
3 Spartak Vráble Spartak 30 52 23 58
4 Slovan Bratislava II Slovan 30 65 38 58
5 OSK Moravany nad Váhom Moravany 29 38 40 46
6 Nitra II Nitra II 30 52 39 44
7 Spartak Trnava II Spartak 30 60 53 44
8 Slovan Nemsova Slovan 30 42 42 40
9 Petržalka II Petržalka 30 34 34 39
10 Vrbové Vrbové 30 32 38 38
11 Jaslovské Bohunice Jaslovské 30 32 51 37
12 Nove Mesto Nad Vahom Nove Mesto. 30 32 47 35
13 Topoľčany Topoľčany 30 32 48 34
14 FK Rača FK Rača 30 35 48 31
15 Dúbravka Bratislava Dúbravka 30 35 52 31
16 Iskra Petržalka Iskra 30 19 78 8

  USO DE MEMORIA  
5,931,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4508
Total Execution Time  0.4527
  CADENA URL  
/tercera_eslovaquia2017/grupo2/historico
  GET DATOS  
$_GET['/tercera_eslovaquia2017/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0124  SELECT type FROM routes WHERE alias = 'tercera_eslovaquia2017'
0.0252  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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1607 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1607 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (16697,1411) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1607 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 = 34131 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1607 AND group_code = 2 and tables = 1 AND year <= 2017 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0131  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 = 34131 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 15813 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 9375 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 24448 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 24456 AND t.round = 30 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 `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 = 24468 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 24476 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 24481 AND t.round = 30 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 `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 = 24490 AND t.round = 30 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-05-01 11:05:19' 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-05-01 11:05:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 11:05:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 11:05:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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 = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0130  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 events2017 e ON e.player_id = p.id AND e.league_id = 34131 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34131 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.0126  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 events2017 e ON e.player_id = p.id AND e.league_id = 34131 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34131 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  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 events2017 e ON e.player_id = p.id AND e.league_id = 34131 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34131 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT *,(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 = 34131 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC