4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Stockport County Stockport 42 77 36 82
2 Chorley Chorley 42 83 41 81
3 Brackley Town Brackley 42 72 40 77
4 Spennymoor Town Spennymoor 42 78 48 76
5 Altrincham Altrincham 42 85 56 71
6 Blyth Spartans Blyth 42 74 62 69
7 Bradford Park Avenue Bradford 42 71 61 65
8 AFC Telford United Telford 42 64 55 65
9 Chester Chester 42 60 62 62
10 Kidderminster Harriers Kidderminste 42 68 62 60
11 Boston United Boston 42 62 60 58
12 York City York City 42 58 63 58
13 Leamington Leamington 42 57 60 54
14 Southport Southport 42 58 55 53
15 Alfreton Town Alfreton 42 53 67 51
16 Darlington FC Darlington 42 56 62 50
17 Hereford Hereford 42 47 58 49
18 Curzon Ashton Curzon 42 44 71 49
19 Guiseley Guiseley 42 46 60 44
20 Ashton United Ashton 42 43 86 35
21 United of Manchester United 42 49 82 34
22 Nuneaton Town Nuneaton 42 38 96 19

  USO DE MEMORIA  
5,403,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.3998
Total Execution Time  0.4031
  CADENA URL  
/conference_north2019/grupo1/resumen/42
  GET DATOS  
$_GET['/conference_north2019/grupo1/resumen/42']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0126  SELECT type FROM routes WHERE alias = 'conference_north2019'
0.0255  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'conference_north' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=172 AND type_rel = 3
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 172 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0139  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 (1118647,957265,792822,730963,607236) ORDER BY n.cover_points DESC, update_date DESC
0.0132  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=171 ORDER BY l.group_code ASC
0.0128  SELECT id,name,alias,stepParent FROM categories WHERE parentId=171 ORDER BY order_id ASC
0.0131  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 = 44237 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2019` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 44237 AND c.`round` = 42 ORDER BY shedule ASC LIMIT 200
0.0193  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2019` e INNER JOIN calendars2019 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 42 AND e.real_date IS NOT NULL AND e.league_id = 44237 ORDER BY total DESC LIMIT 100
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 16:40:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 16:40:33' 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=4 AND last_update > '2024-05-06 16:40:33' 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-06 16:40:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'conference_north' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0319  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 events2019 e ON e.player_id = p.id AND e.league_id = 44237 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44237 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 events2019 e ON e.player_id = p.id AND e.league_id = 44237 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44237 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 events2019 e ON e.player_id = p.id AND e.league_id = 44237 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44237 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0262  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 44237 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC