4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Stoneham
TEMPORADA 2023/2024
COMBINED COUNTIES LEAGUE GRUPO 12
Equipo PJ GF GC Puntos
1 Moneyfields Moneyfields 38 141 39 102
2 Stoneham Stoneham 38 131 26 95
3 Shaftesbury Town Shaftesbury 38 117 50 90
4 AFC Portchester Portchester 38 90 44 81
5 Baffins Milton Rovers Baffins 38 88 52 67
6 Brockenhurst Brockenhurst 38 77 47 67
7 Portland United Portland 38 66 42 65
8 Laverstock Ford Laverstock 38 88 73 64
9 Sherborne Town Sherborne 38 75 67 59
10 Fareham Town Fareham Town 38 68 80 53
11 Cowes Sports FC Cowes Sports 38 83 75 51
12 Hamble Club Hamble Club 38 82 75 50
13 Petersfield Town Petersfield 38 71 81 41
14 Andover New Street Andover 38 62 92 39
15 Hythe & Dibden Hythe Dibden 38 60 87 35
16 Bournemouth FC Bournemouth 38 56 107 33
17 Blackfield & Langley Blackfield 38 40 116 32
18 Christchurch Christchurch 38 51 123 27
19 United Services United 38 53 117 25
20 Lymington Town Lymington 38 36 142 12
TEMPORADA 2022/2023
COMBINED COUNTIES LEAGUE GRUPO 15
Equipo PJ GF GC Puntos
1 Horndean Horndean 36 119 21 92
2 AFC Portchester Portchester 37 111 44 92
3 Stoneham Stoneham 36 102 36 89
4 Bemerton Heath Bemerton 35 108 34 80
5 Hamble Club Hamble Club 38 86 61 66
6 Moneyfields Moneyfields 37 76 45 65
7 Baffins Milton Rovers Baffins 37 68 51 63
8 Laverstock Ford Laverstock 36 60 64 49
9 Fareham Town Fareham Town 38 64 71 49
10 Christchurch Christchurch 37 59 73 48
11 Portland United Portland 37 64 75 47
12 Shaftesbury Town Shaftesbury 38 73 80 46
13 Hythe & Dibden Hythe Dibden 35 57 67 44
14 United Services United 37 58 83 38
15 Brockenhurst Brockenhurst 36 54 84 38
16 Blackfield & Langley Blackfield 38 53 90 38
17 Cowes Sports FC Cowes Sports 38 42 83 37
18 Bournemouth FC Bournemouth 37 49 94 37
19 Pagham Pagham 37 50 93 31
20 Alresford Town Alresford 36 24 128 5
TEMPORADA 2021/2022
COMBINED COUNTIES LEAGUE GRUPO 11
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,343,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.5159
Total Execution Time  0.5182
  CADENA URL  
/historico/Afc-Stoneham
  GET DATOS  
$_GET['/historico/Afc-Stoneham']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0156  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Afc-Stoneham' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=89445 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=89445 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=89445 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0297  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73096
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89445 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0151  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '89445' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '89445' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '89445' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73096 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=89445 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73096,72728,67320) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73096 AND teamId = 89445
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 89445
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 89445
0.0147  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '89445' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '89445' and rp.type = 4
0.0146  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '89445' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73096 WHERE rp.league_id = 73096 AND rp.teamId = 89445 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73096 WHERE rp.league_id = 73096 AND rp.teamId = 89445 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73096 WHERE rp.league_id = 73096 AND rp.teamId = 89445 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 89445 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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 = 73096 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.0151  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 = 68445 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.0151  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