4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Real Bedford Real Bedford 37 120 28 91
2 Milton Keynes Irish Milton 37 96 25 86
3 Leverstock Green Leverstock 38 75 53 72
4 Harpenden Town Harpenden 38 76 52 71
5 FC Romania FC Romania 37 78 66 62
6 Tring Athletic Tring 38 66 54 62
7 Colney Heath Colney Heath 38 58 49 60
8 Cockfosters Cockfosters 37 73 57 55
9 Potton United Potton 38 52 61 53
10 St. Panteleimon Panteleimon 30 55 40 50
11 London Lions London Lions 38 76 77 48
12 Biggleswade United Biggleswade 38 70 85 46
13 Aylesbury Aylesbury 36 58 78 46
14 Dunstable Town Dunstable 38 54 68 41
15 Stansted Stansted 37 50 71 40
16 Baldock Town Baldock Town 37 65 90 37
17 Arlesey Town Arlesey Town 37 36 70 34
18 Crawley Green Crawley 37 51 88 33
19 Shefford Town & Campton Shefford 36 50 93 33
20 Sawbridgeworth Town Sawbridgewor 38 32 86 16
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Ascot United Ascot United 13 38 7 39
2 Egham Town Egham Town 14 31 21 26
3 Reading City Reading City 13 30 17 25
4 Virginia Water Virginia 12 19 13 24
5 Edgware & Kingsbury Edgware 13 20 18 22
6 Flackwell Heath Flackwell 12 19 12 20
7 Burnham Burnham 9 28 15 19
8 London Maccabi Lions FC London 14 29 29 19
9 Wembley Wembley 14 24 27 19
10 Holyport Holyport 15 28 31 18
11 Wallingford Town AFC Wallingford 14 23 25 16
12 Windsor Windsor 13 22 30 16
13 Harefield United Harefield 14 23 30 15
14 Oxhey Jets Oxhey Jets 13 17 26 14
15 Broadfields United Broadfields 12 12 19 13
16 North Greenford United North 12 23 28 12
17 Spelthorne Sports Spelthorne 14 19 28 12
18 Wokingham and Emmbrook Wokingham 10 9 15 9
19 Hilltop Hilltop 10 17 29 9
20 Chalfont St Peter Chalfont 11 11 22 7
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Hamworthy United Hamworthy 40 102 29 99
2 Bashley Bashley 40 105 44 90
3 Shaftesbury Town Shaftesbury 40 126 51 85
4 Horndean Horndean 40 116 43 83
5 Stoneham Stoneham 40 96 51 78
6 Brockenhurst Brockenhurst 40 91 47 78
7 AFC Portchester Portchester 40 99 51 72
8 Moneyfields Moneyfields 40 92 62 64
9 Baffins Milton Rovers Baffins 39 82 61 63
10 Alton Alton 40 74 80 62
11 Hamble Club Hamble Club 40 63 79 49
12 Fareham Town Fareham Town 40 113 98 47
13 Blackfield & Langley Blackfield 39 75 72 47
14 Alresford Town Alresford 40 71 81 45
15 Portland United Portland 40 65 91 38
16 United Services United 40 50 97 37
17 Cowes Sports FC Cowes Sports 40 49 112 35
18 Bournemouth FC Bournemouth 39 66 99 32
19 Christchurch Christchurch 39 43 118 31
20 Hythe & Dibden Hythe Dibden 40 38 123 29
21 Amesbury Town Amesbury 40 30 157 13

  USO DE MEMORIA  
5,433,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3425
Total Execution Time  0.3444
  CADENA URL  
/combined-counties-football-league2024/grupo11/historico
  GET DATOS  
$_GET['/combined-counties-football-league2024/grupo11/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0125  SELECT type FROM routes WHERE alias = 'combined-counties-football-league2024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'combined-counties-football-league' AND (l.group_code = 11 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=11 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2490 ORDER BY order_id ASC
0.0127  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 = 73101 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2490 AND group_code = 11 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2024` 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 = 73101 AND t.round = 9 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 68441 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.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 `tables2022` 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 = 63788 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 07:09:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 07:09:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 07:09:11' 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=3 AND last_update > '2024-04-28 07:09:11' 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 = 'combined-counties-football-league' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2024 e ON e.player_id = p.id AND e.league_id = 73101 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73101 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 events2024 e ON e.player_id = p.id AND e.league_id = 73101 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73101 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 73101 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73101 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 73101 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC