4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
13 Ago 21 Aston Villa Sub 23Aston Villa 5 - 2 Nottingham Forest Sub 23Nottingham ...
15 Ago 21 Southampton Sub 23Southampton 0 - 3 Norwich City Sub 23Norwich ...
16 Ago 21 Newcastle Sub 23Newcastle 1 - 1 Reading Sub 23Reading ...
16 Ago 21 Stoke City Sub 23Stoke City 2 - 1 Birmingham City Sub 23Birmingham ...
16 Ago 21 Sunderland Sub 23Sunderland 3 - 4 Fulham Sub 23Fulham ...
16 Ago 21 West Bromwich Albion Sub 23West 3 - 2 Burnley Sub 23Burnley ...
16 Ago 21 Wolverhampton Sub 23Wolverhampt 2 - 1 Middlesbrough Sub 23Middlesbrou 2
20 Ago 21 Fulham Sub 23Fulham 3 - 0 West Bromwich Albion Sub 23West ...
20 Ago 21 Middlesbrough Sub 23Middlesbrou 1 - 2 Aston Villa Sub 23Aston Villa ...
20 Ago 21 Norwich City Sub 23Norwich 0 - 1 Stoke City Sub 23Stoke City ...
Ver jornada
Jornada 2
23 Ago 21 Birmingham City Sub 23Birmingham 0 - 4 Newcastle Sub 23Newcastle ...
23 Ago 21 Burnley Sub 23Burnley 2 - 3 Sunderland Sub 23Sunderland ...
23 Ago 21 Nottingham Forest Sub 23Nottingham 0 - 0 Southampton Sub 23Southampton ...
23 Ago 21 Reading Sub 23Reading 3 - 0 Wolverhampton Sub 23Wolverhampt ...
27 Ago 21 Sunderland Sub 23Sunderland 3 - 4 Norwich City Sub 23Norwich ...
27 Ago 21 Aston Villa Sub 23Aston Villa 1 - 1 Fulham Sub 23Fulham ...
27 Ago 21 Newcastle Sub 23Newcastle 2 - 0 Burnley Sub 23Burnley ...
27 Ago 21 West Bromwich Albion Sub 23West 3 - 2 Birmingham City Sub 23Birmingham ...
27 Ago 21 Wolverhampton Sub 23Wolverhampt 1 - 0 Nottingham Forest Sub 23Nottingham ...
29 Ago 21 Middlesbrough Sub 23Middlesbrou 2 - 1 Southampton Sub 23Southampton ...
Ver jornada
Jornada 3
29 Ago 21 Stoke City Sub 23Stoke City 1 - 2 Reading Sub 23Reading ...
10 Sep 21 Birmingham City Sub 23Birmingham 1 - 0 Sunderland Sub 23Sunderland ...
10 Sep 21 Burnley Sub 23Burnley 1 - 1 Wolverhampton Sub 23Wolverhampt ...
10 Sep 21 Fulham Sub 23Fulham 3 - 0 Southampton Sub 23Southampton ...
10 Sep 21 Norwich City Sub 23Norwich 4 - 2 Aston Villa Sub 23Aston Villa ...
12 Sep 21 Reading Sub 23Reading 0 - 2 Nottingham Forest Sub 23Nottingham ...
13 Sep 21 Middlesbrough Sub 23Middlesbrou 2 - 0 Stoke City Sub 23Stoke City ...
13 Sep 21 West Bromwich Albion Sub 23West 2 - 0 Newcastle Sub 23Newcastle ...
17 Sep 21 Aston Villa Sub 23Aston Villa 4 - 2 West Bromwich Albion Sub 23West ...
19 Sep 21 Southampton Sub 23Southampton 0 - 2 Burnley Sub 23Burnley ...
Ver jornada
Jornada 4
20 Sep 21 Newcastle Sub 23Newcastle 2 - 3 Stoke City Sub 23Stoke City ...
20 Sep 21 Nottingham Forest Sub 23Nottingham 5 - 0 Birmingham City Sub 23Birmingham ...
20 Sep 21 Reading Sub 23Reading 3 - 3 Norwich City Sub 23Norwich ...
20 Sep 21 Sunderland Sub 23Sunderland 1 - 3 Middlesbrough Sub 23Middlesbrou ...
20 Sep 21 Wolverhampton Sub 23Wolverhampt 2 - 1 Fulham Sub 23Fulham ...
24 Sep 21 Fulham Sub 23Fulham 3 - 1 Newcastle Sub 23Newcastle ...
24 Sep 21 Middlesbrough Sub 23Middlesbrou 0 - 1 Nottingham Forest Sub 23Nottingham ...
27 Sep 21 Birmingham City Sub 23Birmingham 3 - 2 Southampton Sub 23Southampton ...
27 Sep 21 Burnley Sub 23Burnley 3 - 1 Reading Sub 23Reading ...
27 Sep 21 Norwich City Sub 23Norwich 2 - 5 West Bromwich Albion Sub 23West 1
Ver jornada
Jornada 5
27 Sep 21 Stoke City Sub 23Stoke City 0 - 8 Aston Villa Sub 23Aston Villa ...
27 Sep 21 Wolverhampton Sub 23Wolverhampt 1 - 3 Sunderland Sub 23Sunderland ...
01 Oct 21 Southampton Sub 23Southampton 1 - 1 Stoke City Sub 23Stoke City ...
01 Oct 21 Aston Villa Sub 23Aston Villa 0 - 0 Wolverhampton Sub 23Wolverhampt ...
01 Oct 21 Newcastle Sub 23Newcastle 4 - 1 Middlesbrough Sub 23Middlesbrou ...
01 Oct 21 Norwich City Sub 23Norwich 0 - 2 Fulham Sub 23Fulham ...
01 Oct 21 Nottingham Forest Sub 23Nottingham 1 - 1 Burnley Sub 23Burnley ...
04 Oct 21 Reading Sub 23Reading 1 - 1 Birmingham City Sub 23Birmingham ...
04 Oct 21 West Bromwich Albion Sub 23West 1 - 0 Sunderland Sub 23Sunderland ...
16 Oct 21 Birmingham City Sub 23Birmingham 1 - 2 Aston Villa Sub 23Aston Villa ...
Ver jornada
Jornada 6
15 Oct 21 Fulham Sub 23Fulham 3 - 0 Reading Sub 23Reading ...
17 Oct 21 Middlesbrough Sub 23Middlesbrou 1 - 2 West Bromwich Albion Sub 23West 1
18 Oct 21 Wolverhampton Sub 23Wolverhampt 0 - 1 Southampton Sub 23Southampton ...
15 Oct 21 Burnley Sub 23Burnley 4 - 3 Norwich City Sub 23Norwich ...
18 Oct 21 Stoke City Sub 23Stoke City 1 - 0 Nottingham Forest Sub 23Nottingham ...
18 Oct 21 Sunderland Sub 23Sunderland 1 - 2 Newcastle Sub 23Newcastle ...
22 Oct 21 Aston Villa Sub 23Aston Villa 2 - 3 Sunderland Sub 23Sunderland ...
22 Oct 21 Burnley Sub 23Burnley 2 - 0 Middlesbrough Sub 23Middlesbrou ...
22 Oct 21 Fulham Sub 23Fulham 2 - 1 Nottingham Forest Sub 23Nottingham ...
22 Oct 21 Norwich City Sub 23Norwich 2 - 1 Birmingham City Sub 23Birmingham ...
Ver jornada
Jornada 7
25 Oct 21 Newcastle Sub 23Newcastle 2 - 3 Wolverhampton Sub 23Wolverhampt ...
25 Oct 21 Reading Sub 23Reading 0 - 1 Southampton Sub 23Southampton ...
25 Oct 21 West Bromwich Albion Sub 23West 1 - 1 Stoke City Sub 23Stoke City ...
01 Nov 21 Birmingham City Sub 23Birmingham 1 - 2 Burnley Sub 23Burnley ...
29 Oct 21 Newcastle Sub 23Newcastle 2 - 2 Norwich City Sub 23Norwich ...
31 Oct 21 Southampton Sub 23Southampton 4 - 0 Aston Villa Sub 23Aston Villa ...
01 Nov 21 Fulham Sub 23Fulham 2 - 0 Middlesbrough Sub 23Middlesbrou ...
01 Nov 21 Nottingham Forest Sub 23Nottingham 2 - 2 West Bromwich Albion Sub 23West ...
01 Nov 21 Reading Sub 23Reading 0 - 3 Sunderland Sub 23Sunderland ...
01 Nov 21 Stoke City Sub 23Stoke City 2 - 0 Wolverhampton Sub 23Wolverhampt ...
Ver jornada
Jornada 8
05 Nov 21 Southampton Sub 23Southampton 5 - 0 Newcastle Sub 23Newcastle ...
05 Nov 21 Norwich City Sub 23Norwich 4 - 2 Nottingham Forest Sub 23Nottingham ...
05 Nov 21 Wolverhampton Sub 23Wolverhampt 1 - 1 West Bromwich Albion Sub 23West ...
07 Nov 21 Middlesbrough Sub 23Middlesbrou 0 - 3 Birmingham City Sub 23Birmingham ...
08 Nov 21 Reading Sub 23Reading 2 - 2 Aston Villa Sub 23Aston Villa 36
08 Nov 21 Burnley Sub 23Burnley 1 - 2 Fulham Sub 23Fulham 1
07 Nov 21 Stoke City Sub 23Stoke City 2 - 2 Sunderland Sub 23Sunderland ...
22 Nov 21 Aston Villa Sub 23Aston Villa 4 - 1 Burnley Sub 23Burnley ...
19 Nov 21 Birmingham City Sub 23Birmingham 1 - 2 Wolverhampton Sub 23Wolverhampt ...
19 Nov 21 Fulham Sub 23Fulham 3 - 0 Stoke City Sub 23Stoke City ...
Ver jornada
Jornada 9
21 Nov 21 Sunderland Sub 23Sunderland 3 - 2 Southampton Sub 23Southampton ...
21 Nov 21 Middlesbrough Sub 23Middlesbrou 3 - 2 Norwich City Sub 23Norwich ...
22 Nov 21 Nottingham Forest Sub 23Nottingham 1 - 3 Newcastle Sub 23Newcastle ...
22 Nov 21 West Bromwich Albion Sub 23West 1 - 1 Reading Sub 23Reading 3
28 Nov 21 Southampton Sub 23Southampton 3 - 1 West Bromwich Albion Sub 23West ...
30 Ene 22 Birmingham City Sub 23Birmingham 1 - 3 Fulham Sub 23Fulham ...
26 Nov 21 Burnley Sub 23Burnley 0 - 1 Stoke City Sub 23Stoke City ...
31 Ene 22 Newcastle Sub 23Newcastle 2 - 0 Aston Villa Sub 23Aston Villa ...
29 Nov 21 Reading Sub 23Reading 2 - 1 Middlesbrough Sub 23Middlesbrou ...
31 Ene 22 Sunderland Sub 23Sunderland 1 - 1 Nottingham Forest Sub 23Nottingham 1
Ver jornada
Jornada 10
29 Nov 21 Wolverhampton Sub 23Wolverhampt 0 - 5 Norwich City Sub 23Norwich 2
06 Dic 21 Aston Villa Sub 23Aston Villa 3 - 3 Birmingham City Sub 23Birmingham ...
03 Dic 21 Fulham Sub 23Fulham 4 - 2 Wolverhampton Sub 23Wolverhampt ...
03 Dic 21 Norwich City Sub 23Norwich 5 - 2 Reading Sub 23Reading ...
06 Dic 21 Stoke City Sub 23Stoke City 3 - 0 Southampton Sub 23Southampton ...
10 Dic 21 Burnley Sub 23Burnley 1 - 1 Nottingham Forest Sub 23Nottingham 2
06 Dic 21 Newcastle Sub 23Newcastle 2 - 0 Sunderland Sub 23Sunderland ...
06 Dic 21 West Bromwich Albion Sub 23West 3 - 2 Middlesbrough Sub 23Middlesbrou ...
06 Mar 22 Birmingham City Sub 23Birmingham 0 - 0 Reading Sub 23Reading ...
17 Dic 21 Norwich City Sub 23Norwich 4 - 3 Southampton Sub 23Southampton ...
Ver jornada
Jornada 11
04 Abr 22 Nottingham Forest Sub 23Nottingham 2 - 0 Stoke City Sub 23Stoke City 7
19 Dic 21 Middlesbrough Sub 23Middlesbrou 0 - 3 Burnley Sub 23Burnley ...
18 Abr 22 Sunderland Sub 23Sunderland 1 - 3 Aston Villa Sub 23Aston Villa ...
20 Dic 21 West Bromwich Albion Sub 23West 2 - 4 Fulham Sub 23Fulham ...
18 Abr 22 Wolverhampton Sub 23Wolverhampt 4 - 2 Newcastle Sub 23Newcastle ...
10 Ene 22 Aston Villa Sub 23Aston Villa 1 - 2 Middlesbrough Sub 23Middlesbrou 6
25 Mar 22 Southampton Sub 23Southampton 2 - 4 Wolverhampton Sub 23Wolverhampt ...
10 Ene 22 Burnley Sub 23Burnley 1 - 1 Birmingham City Sub 23Birmingham ...
28 Mar 22 Newcastle Sub 23Newcastle 4 - 3 West Bromwich Albion Sub 23West 7
10 Ene 22 Nottingham Forest Sub 23Nottingham 1 - 2 Fulham Sub 23Fulham ...
Ver jornada
Jornada 12
25 Mar 22 Stoke City Sub 23Stoke City 0 - 4 Norwich City Sub 23Norwich ...
10 Ene 22 Sunderland Sub 23Sunderland 2 - 0 Reading Sub 23Reading ...
14 Ene 22 Birmingham City Sub 23Birmingham 1 - 1 Stoke City Sub 23Stoke City ...
14 Ene 22 Nottingham Forest Sub 23Nottingham 3 - 2 Norwich City Sub 23Norwich ...
16 Ene 22 Middlesbrough Sub 23Middlesbrou 3 - 2 Sunderland Sub 23Sunderland ...
17 Ene 22 Southampton Sub 23Southampton 2 - 1 Fulham Sub 23Fulham ...
14 Ene 22 Reading Sub 23Reading 1 - 4 Newcastle Sub 23Newcastle ...
17 Ene 22 West Bromwich Albion Sub 23West 2 - 1 Aston Villa Sub 23Aston Villa ...
17 Ene 22 Wolverhampton Sub 23Wolverhampt 1 - 1 Burnley Sub 23Burnley ...
24 Ene 22 Aston Villa Sub 23Aston Villa 4 - 1 Reading Sub 23Reading ...
Ver jornada
Jornada 13
21 Ene 22 Norwich City Sub 23Norwich 2 - 1 Burnley Sub 23Burnley ...
23 Ene 22 Southampton Sub 23Southampton 1 - 0 Middlesbrough Sub 23Middlesbrou 1
24 Ene 22 Birmingham City Sub 23Birmingham 3 - 2 West Bromwich Albion Sub 23West ...
24 Ene 22 Newcastle Sub 23Newcastle 0 - 1 Nottingham Forest Sub 23Nottingham 1
24 Ene 22 Stoke City Sub 23Stoke City 0 - 1 Fulham Sub 23Fulham ...
24 Ene 22 Sunderland Sub 23Sunderland 1 - 2 Wolverhampton Sub 23Wolverhampt 2
04 Feb 22 Fulham Sub 23Fulham 2 - 0 Sunderland Sub 23Sunderland ...
04 Feb 22 Norwich City Sub 23Norwich 4 - 0 Middlesbrough Sub 23Middlesbrou 2
08 Abr 22 Burnley Sub 23Burnley 5 - 1 Newcastle Sub 23Newcastle ...
07 Feb 22 Nottingham Forest Sub 23Nottingham 4 - 1 Aston Villa Sub 23Aston Villa ...
Ver jornada
Jornada 14
07 Feb 22 Reading Sub 23Reading 1 - 1 Stoke City Sub 23Stoke City 1
07 Feb 22 West Bromwich Albion Sub 23West 0 - 1 Southampton Sub 23Southampton ...
07 Feb 22 Wolverhampton Sub 23Wolverhampt 2 - 0 Birmingham City Sub 23Birmingham ...
15 Abr 22 Middlesbrough Sub 23Middlesbrou 0 - 3 Wolverhampton Sub 23Wolverhampt ...
21 Feb 22 Southampton Sub 23Southampton 2 - 3 Birmingham City Sub 23Birmingham ...
21 Feb 22 Aston Villa Sub 23Aston Villa 2 - 0 Norwich City Sub 23Norwich 5
21 Feb 22 Newcastle Sub 23Newcastle 1 - 6 Fulham Sub 23Fulham 10
21 Feb 22 Nottingham Forest Sub 23Nottingham 7 - 0 Reading Sub 23Reading ...
22 Abr 22 Stoke City Sub 23Stoke City 0 - 0 Burnley Sub 23Burnley ...
21 Feb 22 Sunderland Sub 23Sunderland 0 - 1 West Bromwich Albion Sub 23West 4
Ver jornada
Jornada 15
25 Feb 22 Fulham Sub 23Fulham 2 - 1 Aston Villa Sub 23Aston Villa ...
26 Feb 22 Southampton Sub 23Southampton 4 - 2 Nottingham Forest Sub 23Nottingham ...
27 Feb 22 Birmingham City Sub 23Birmingham 4 - 2 Middlesbrough Sub 23Middlesbrou ...
15 Abr 22 Burnley Sub 23Burnley 3 - 2 West Bromwich Albion Sub 23West 3
28 Feb 22 Norwich City Sub 23Norwich 3 - 4 Newcastle Sub 23Newcastle 4
28 Feb 22 Sunderland Sub 23Sunderland 0 - 3 Stoke City Sub 23Stoke City ...
28 Feb 22 Wolverhampton Sub 23Wolverhampt 4 - 3 Reading Sub 23Reading 1
11 Mar 22 Aston Villa Sub 23Aston Villa 2 - 2 Southampton Sub 23Southampton 1
11 Mar 22 Fulham Sub 23Fulham 1 - 2 Norwich City Sub 23Norwich 5
14 Mar 22 Newcastle Sub 23Newcastle 1 - 0 Birmingham City Sub 23Birmingham 6
Ver jornada
Jornada 16
14 Mar 22 Nottingham Forest Sub 23Nottingham 3 - 0 Sunderland Sub 23Sunderland 4
14 Mar 22 Reading Sub 23Reading 2 - 1 Burnley Sub 23Burnley 2
14 Mar 22 Stoke City Sub 23Stoke City 1 - 0 Middlesbrough Sub 23Middlesbrou 5
14 Mar 22 West Bromwich Albion Sub 23West 0 - 4 Wolverhampton Sub 23Wolverhampt 3
18 Mar 22 Middlesbrough Sub 23Middlesbrou 0 - 0 Fulham Sub 23Fulham ...
18 Mar 22 Wolverhampton Sub 23Wolverhampt 3 - 0 Aston Villa Sub 23Aston Villa ...
20 Mar 22 Southampton Sub 23Southampton 2 - 1 Reading Sub 23Reading 1
21 Mar 22 Birmingham City Sub 23Birmingham 2 - 1 Norwich City Sub 23Norwich 10
21 Mar 22 Stoke City Sub 23Stoke City 2 - 1 Newcastle Sub 23Newcastle 5
21 Mar 22 Sunderland Sub 23Sunderland 0 - 2 Burnley Sub 23Burnley 3
Ver jornada
Jornada 17
21 Mar 22 West Bromwich Albion Sub 23West 0 - 5 Nottingham Forest Sub 23Nottingham 3
01 Abr 22 Aston Villa Sub 23Aston Villa 1 - 4 Stoke City Sub 23Stoke City ...
01 Abr 22 Fulham Sub 23Fulham 3 - 0 Birmingham City Sub 23Birmingham ...
01 Abr 22 Norwich City Sub 23Norwich 1 - 1 Sunderland Sub 23Sunderland ...
01 Abr 22 Nottingham Forest Sub 23Nottingham 1 - 0 Wolverhampton Sub 23Wolverhampt 3
01 Abr 22 Middlesbrough Sub 23Middlesbrou 4 - 2 Newcastle Sub 23Newcastle 1
01 Abr 22 Reading Sub 23Reading 1 - 1 West Bromwich Albion Sub 23West ...
02 Abr 22 Burnley Sub 23Burnley 2 - 1 Southampton Sub 23Southampton ...
22 Abr 22 Nottingham Forest Sub 23Nottingham 1 - 1 Middlesbrough Sub 23Middlesbrou 2
25 Abr 22 Burnley Sub 23Burnley 2 - 1 Aston Villa Sub 23Aston Villa 1
Ver jornada
Jornada 18
25 Abr 22 Newcastle Sub 23Newcastle 2 - 4 Southampton Sub 23Southampton 1
25 Abr 22 Reading Sub 23Reading 3 - 1 Fulham Sub 23Fulham ...
25 Abr 22 Sunderland Sub 23Sunderland 2 - 1 Birmingham City Sub 23Birmingham ...
25 Abr 22 West Bromwich Albion Sub 23West 3 - 2 Norwich City Sub 23Norwich 4
25 Abr 22 Wolverhampton Sub 23Wolverhampt 2 - 2 Stoke City Sub 23Stoke City ...
29 Abr 22 Birmingham City Sub 23Birmingham 0 - 3 Nottingham Forest Sub 23Nottingham ...
29 Abr 22 Fulham Sub 23Fulham 5 - 3 Burnley Sub 23Burnley 1
29 Abr 22 Norwich City Sub 23Norwich 0 - 2 Wolverhampton Sub 23Wolverhampt ...
01 May 22 Middlesbrough Sub 23Middlesbrou 2 - 1 Reading Sub 23Reading ...
01 May 22 Southampton Sub 23Southampton 1 - 0 Sunderland Sub 23Sunderland 1
Ver jornada
Jornada 19
02 May 22 Aston Villa Sub 23Aston Villa 1 - 2 Newcastle Sub 23Newcastle 8
29 Abr 22 Stoke City Sub 23Stoke City 2 - 1 West Bromwich Albion Sub 23West ...

Clasificación

Equipo PJ GF GC Puntos
1 Fulham Sub 23 Fulham 26 64 27 62
2 Wolverhampton Sub 23 Wolverhampto 26 46 37 47
3 Stoke City Sub 23 Stoke City 26 34 36 43
4 Nottingham Forest Sub 23 Nottingham 26 52 31 42
5 Norwich City Sub 23 Norwich City 26 64 52 39
6 Burnley Sub 23 Burnley 26 46 39 39
7 Southampton Sub 23 Southampton 26 45 42 39
8 Newcastle Sub 23 Newcastle 26 51 56 38
9 West Bromwich Albion Sub 23 West 26 44 54 35
10 Aston Villa Sub 23 Aston Villa 26 53 51 32
11 Birmingham City Sub 23 Birmingham 26 34 51 26
12 Middlesbrough Sub 23 Middlesbroug 26 31 50 26
13 Sunderland Sub 23 Sunderland 26 35 49 24
14 Reading Sub 23 Reading 26 32 56 23

  USO DE MEMORIA  
6,198,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  1.4177
Total Execution Time  1.4196
  CADENA URL  
/premier_league_2_division_two2022/grupo1/calendario
  GET DATOS  
$_GET['/premier_league_2_division_two2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0125  SELECT type FROM routes WHERE alias = 'premier_league_2_division_two2022'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_two' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1978 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1978 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1224714,1224709,1218237,1208523,1162705) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1978 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1978 GROUP BY l.categoryId
0.0127  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1978 GROUP BY l.year ORDER BY l.year DESC
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 = 63585 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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, dt1.stadium as stadium_name FROM calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63585 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 12:58:22' 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-04-26 12:58:22' 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-26 12:58:22' 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=3 AND last_update > '2024-04-26 12:58:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_two' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0241  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 events2022 e ON e.player_id = p.id AND e.league_id = 63585 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63585 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.0229  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 events2022 e ON e.player_id = p.id AND e.league_id = 63585 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63585 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0132  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 events2022 e ON e.player_id = p.id AND e.league_id = 63585 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63585 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0140  SELECT *,(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 = 63585 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC