4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Knockbreda Knockbreda 30 106 25 77
2 Ballyclare Comrades Ballyclare 30 77 28 71
3 Armagh City Armagh City 30 81 34 66
4 Lurgan Celtic Lurgan 30 71 43 63
5 Glebe Rangers Glebe 30 58 41 52
6 Wakehurst Wakehurst 30 61 50 52
7 Queens University Belfast Queens 30 65 43 45
8 PSNI PSNI 30 60 48 43
9 Banbridge Town Banbridge 30 57 58 40
10 Ballymoney United Ballymoney 30 53 67 37
11 Annagh United Annagh 30 39 53 34
12 Moyola Park Moyola Park 30 35 51 28
13 Portstewart Portstewart 30 37 70 22
14 Sport & Leisure Sport 30 41 101 20
15 Killymoon Rangers Killymoon 30 38 85 19
16 Chimney Corner FC Chimney 30 26 108 11
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Coagh United Coagh United 30 81 41 63
2 Dundela Dundela 30 79 46 62
3 Knockbreda Knockbreda 30 70 31 61
4 Lurgan Celtic Lurgan 30 73 40 57
5 Queens University Belfast Queens 30 63 38 55
6 Ballyclare Comrades Ballyclare 30 60 46 52
7 Annagh United Annagh 30 59 51 51
8 Wakehurst Wakehurst 30 59 48 47
9 Ballymoney United Ballymoney 30 51 45 39
10 Portstewart Portstewart 30 43 56 37
11 Armagh City Armagh City 30 39 52 33
12 Sport & Leisure Sport 30 46 59 32
13 PSNI PSNI 30 36 67 29
14 Moyola Park Moyola Park 30 34 71 29
15 Killymoon Rangers Killymoon 30 34 72 24
16 Chimney Corner FC Chimney 30 26 90 17
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Warrenpoint Town Warrenpoint 30 84 26 73
2 Tobermore United Tobermore 30 67 36 64
3 Knockbreda Knockbreda 30 59 32 62
4 Dundela Dundela 30 74 41 57
5 Queens University Belfast Queens 30 61 35 55
6 Coagh United Coagh United 30 66 48 54
7 Wakehurst Wakehurst 30 62 54 46
8 Sport & Leisure Sport 30 52 58 42
9 Portstewart Portstewart 30 51 52 38
10 PSNI PSNI 30 56 58 37
11 Lurgan Celtic Lurgan 30 48 62 33
12 Armagh City Armagh City 30 43 60 33
13 Annagh United Annagh 30 34 66 26
14 Killymoon Rangers Killymoon 30 37 64 24
15 Moyola Park Moyola Park 30 31 67 23
16 Chimney Corner FC Chimney 30 35 101 7
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Harland & Wolff Welders Harland 27 72 27 71
2 Dergview FC Dergview FC 26 67 18 58
3 Dundela Dundela 26 62 28 57
4 PSNI PSNI 26 48 35 47
5 Tobermore United Tobermore 26 43 34 45
6 Knockbreda Knockbreda 26 36 30 42
7 Queens University Belfast Queens 27 42 40 34
8 Portstewart Portstewart 26 34 37 34
9 Lurgan Celtic Lurgan 26 37 45 34
10 Sport & Leisure Sport 26 38 56 31
11 Moyola Park Moyola Park 26 36 40 29
12 Annagh United Annagh 26 27 60 23
13 Killymoon Rangers Killymoon 26 36 54 22
14 Wakehurst Wakehurst 26 30 49 19
15 Chimney Corner FC Chimney 26 29 84 10
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Harland & Wolff Welders Harland 22 55 18 59
2 Dundela Dundela 22 70 19 56
3 PSNI PSNI 22 38 27 40
4 Queens University Belfast Queens 22 36 24 35
5 Lurgan Celtic Lurgan 22 44 36 35
6 Annagh United Annagh 22 33 30 30
7 Oxford United Stars Oxford 22 26 31 29
8 Portstewart Portstewart 22 23 38 25
9 Moyola Park Moyola Park 22 24 37 24
10 Wakehurst Wakehurst 22 22 36 17
11 Brantwood Brantwood 22 23 56 14
12 Chimney Corner FC Chimney 22 19 61 11
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Dergview FC Dergview FC 22 65 18 54
2 Ballymoney United Ballymoney 22 44 20 48
3 Ballinamallard United Ballinamalla 23 47 15 43
4 Glebe Rangers Glebe 21 40 24 39
5 Annagh United Annagh 22 33 24 39
6 PSNI PSNI 21 36 28 30
7 Wakehurst Wakehurst 22 32 27 30
8 Oxford United Stars Oxford 22 33 37 29
9 Brantwood Brantwood 23 26 44 22
10 Queens University Belfast Queens 22 25 45 17
11 Chimney Corner FC Chimney 22 25 75 15
12 Moyola Park Moyola Park 22 18 67 7
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Ballyclare Comrades Ballyclare 21 45 13 55
2 Lurgan Celtic Lurgan 23 46 21 46
3 Wakehurst Wakehurst 22 40 31 35
4 Oxford United Stars Oxford 22 26 28 33
5 Ballymoney United Ballymoney 22 31 27 32
6 PSNI PSNI 21 35 39 29
7 Brantwood Brantwood 22 38 36 27
8 Annagh United Annagh 22 21 21 26
9 Chimney Corner FC Chimney 23 28 54 24
10 Dergview FC Dergview FC 22 20 36 21
11 Queens University Belfast Queens 22 25 40 20
12 Glebe Rangers Glebe 22 17 26 19
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Ballinamallard United Ballinamalla 18 44 17 38
2 PSNI PSNI 19 34 25 35
3 Portstewart Portstewart 16 25 10 31
4 Lurgan Celtic Lurgan 17 33 27 29
5 Annagh United Annagh 18 27 22 26
6 Wakehurst Wakehurst 19 27 24 26
7 Chimney Corner FC Chimney 19 24 29 25
8 Brantwood Brantwood 20 24 30 23
9 Dergview FC Dergview FC 18 25 34 20
10 Oxford United Stars Oxford 19 19 42 15
11 Queens University Belfast Queens 17 20 42 9
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Banbridge Town Banbridge 23 51 22 47
2 Tobermore United Tobermore 21 45 26 43
3 Lurgan Celtic Lurgan 22 45 34 34
4 Wakehurst Wakehurst 22 33 25 33
5 Annagh United Annagh 22 32 32 33
6 Portstewart Portstewart 21 26 23 30
7 PSNI PSNI 23 27 31 30
8 Dergview FC Dergview FC 23 41 45 29
9 Chimney Corner FC Chimney 22 31 36 29
10 Oxford United Stars Oxford 23 25 39 24
11 Brantwood Brantwood 21 27 43 18
12 Queens University Belfast Queens 21 22 49 10
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Coagh United Coagh United 22 60 28 50
2 Dundela Dundela 22 49 23 46
3 Dergview FC Dergview FC 22 45 26 43
4 Tobermore United Tobermore 22 42 27 42
5 Wakehurst Wakehurst 22 39 26 37
6 PSNI PSNI 22 49 47 37
7 Banbridge Town Banbridge 22 42 49 26
8 Portstewart Portstewart 22 25 26 25
9 Chimney Corner FC Chimney 22 28 35 24
10 Queens University Belfast Queens 22 36 43 22
11 Annagh United Annagh 22 25 51 16
12 Crewe Crewe 22 10 69 4
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Newry City Newry City 2 2 1 4
2 Bangor Bangor 2 1 2 1

  USO DE MEMORIA  
5,883,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.5258
Total Execution Time  0.5279
  CADENA URL  
/tercera_irlanda_del_norte2013/grupo1/historico
  GET DATOS  
$_GET['/tercera_irlanda_del_norte2013/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0148  SELECT type FROM routes WHERE alias = 'tercera_irlanda_del_norte2013'
0.0303  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_irlanda_del_norte' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1816 AND type_rel = 3
0.0148  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1816 ORDER BY order_id ASC
0.0148  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 = 24019 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1816 AND group_code = 1 and tables = 1 AND year <= 2013 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0153  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 = 24019 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 24022 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 24023 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 24028 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 24030 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 24032 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 24034 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 24035 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 24041 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 27741 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 27743 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 02:38:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 02:38:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 02:38:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 02:38:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0153  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_irlanda_del_norte' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0153  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 events2013 e ON e.player_id = p.id AND e.league_id = 24019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24019 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.0151  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 events2013 e ON e.player_id = p.id AND e.league_id = 24019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24019 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 events2013 e ON e.player_id = p.id AND e.league_id = 24019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24019 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0206  SELECT *,(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 = 24019 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC