4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Argelia Argelia 6 25 4 14
2 Burkina Faso Burkina Faso 6 12 4 12
3 Níger Níger 6 13 17 7
4 Yibuti Yibuti 6 4 29 0
5 Túnez Túnez 6 11 2 13
6 Guinea Ecuatorial Guinea 6 6 5 11
7 Zambia Zambia 6 8 9 7
8 Mauritania Mauritania 6 2 11 2
9 Nigeria Nigeria 6 9 3 13
10 Cabo Verde Cabo Verde 6 8 6 11
11 Liberia Liberia 6 5 8 6
12 República Centroafricana República 6 4 9 4
13 Camerún Camerún 6 12 3 15
14 Costa de Marfil Costa Marfil 6 10 3 13
15 Mozambique Mozambique 6 2 8 4
16 Malawi Malawi 6 2 12 3
17 Mali Mali 6 11 0 16
18 Uganda Uganda 6 3 2 9
19 Kenia Kenia 6 4 9 6
20 Ruanda Ruanda 6 2 9 1
21 Egipto Egipto 6 10 4 14
22 Gabón Gabón 6 7 8 7
23 Libia Libia 6 4 7 7
24 Angola Angola 6 6 8 5
25 Ghana Ghana 6 7 3 13
26 Sudáfrica Sudáfrica 6 6 2 13
27 Etiopía Etiopía 6 4 7 5
28 Zimbabue Zimbabue 6 2 7 2
29 Senegal Senegal 6 15 4 16
30 Togo Togo 6 5 6 8
31 Namibia Namibia 6 5 10 5
32 Congo Congo 6 5 10 3
33 Marruecos Marruecos 6 20 1 18
34 Guinea-Bissau Guinea-Bissa 6 5 11 6
35 Guinea Guinea 6 5 11 4
36 Sudán Sudán 6 5 12 3
37 RD Congo RD Congo 6 9 3 11
38 Benín Benín 6 5 4 10
39 Tanzania Tanzania 6 6 8 8
40 Madagascar Madagascar 6 4 9 4
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Túnez Túnez 6 11 4 14
2 RD Congo RD Congo 6 14 7 13
3 Libia Libia 6 4 10 4
4 Guinea Guinea 6 6 14 3
5 Nigeria Nigeria 6 12 4 14
6 Zambia Zambia 6 8 7 8
7 Camerún Camerún 6 7 9 7
8 Argelia Argelia 6 4 11 2
9 Marruecos Marruecos 6 11 0 12
10 Costa de Marfil Costa Marfil 6 7 5 8
11 Gabón Gabón 6 2 7 6
12 Mali Mali 6 1 9 4
13 Senegal Senegal 6 10 3 14
14 Burkina Faso Burkina Faso 6 10 6 9
15 Cabo Verde Cabo Verde 6 4 12 6
16 Sudáfrica Sudáfrica 6 7 10 4
17 Egipto Egipto 6 8 4 13
18 Uganda Uganda 6 3 2 9
19 Ghana Ghana 6 7 5 7
20 Congo Congo 6 5 12 2
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Etiopía Etiopía 6 8 6 13
2 Sudáfrica Sudáfrica 6 12 5 11
3 Botsuana Botsuana 6 8 10 7
4 República Centroafricana República 6 5 12 3
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Camerún Camerún 6 14 2 16
2 Cabo Verde Cabo Verde 6 7 8 9
3 Tanzania Tanzania 6 9 6 8
4 Mauricio Mauricio 6 3 17 1
5 Guinea Guinea 6 9 5 11
6 Kenia Kenia 6 8 5 10
7 Zimbabue Zimbabue 6 4 6 6
8 Namibia Namibia 6 7 12 6
9 Benín Benín 6 12 8 12
10 Angola Angola 6 11 8 10
11 Uganda Uganda 6 8 9 10
12 Níger Níger 6 5 11 3
13 Nigeria Nigeria 6 11 1 18
14 Sudáfrica Sudáfrica 6 5 5 7
15 Sierra Leona Sierra Leona 6 4 8 7
16 Guinea Ecuatorial Guinea 6 4 10 3
17 Ghana Ghana 6 11 5 12
18 Gabón Gabón 6 8 3 12
19 Libia Libia 6 7 4 12
20 Lesoto Lesoto 6 2 16 0
21 Argelia Argelia 6 7 4 10
22 Gambia Gambia 6 6 3 9
23 Senegal Senegal 6 9 7 9
24 Liberia Liberia 6 4 12 3
25 Costa de Marfil Costa Marfil 6 10 2 12
26 Mozambique Mozambique 6 7 5 8
27 Madagascar Madagascar 6 2 7 6
28 Botsuana Botsuana 6 3 8 5
29 Marruecos Marruecos 4 11 5 9
30 Ruanda Ruanda 4 7 3 9
31 Etiopía Etiopía 0 0 0 0
32 Mauritania Mauritania 4 2 12 0
33 Burkina Faso Burkina Faso 6 14 5 16
34 Túnez Túnez 6 11 3 13
35 Burundi Burundi 6 5 9 6
36 Seychelles Seychelles 6 4 17 0
37 Mali Mali 6 13 8 12
38 Sudán Sudán 6 9 9 9
39 Congo Congo 6 7 8 9
40 Chad Chad 6 7 11 6
41 Zambia Zambia 4 2 1 7
42 Togo Togo 4 8 3 6
43 Eswatini Eswatini 4 2 8 4
44 Egipto Egipto 6 13 2 15
45 Malawi Malawi 6 14 5 12
46 RD Congo RD Congo 6 14 6 9
47 Yibuti Yibuti 6 2 30 0
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Togo Togo 10 19 8 23
2 Senegal Senegal 10 21 8 21
3 Zambia Zambia 10 16 10 19
4 Congo Congo 10 10 13 10
5 Mali Mali 10 11 14 8
6 Liberia Liberia 10 3 27 4
7 Ghana Ghana 10 17 4 21
8 RD Congo RD Congo 10 14 10 16
9 Sudáfrica Sudáfrica 10 12 14 16
10 Burkina Faso Burkina Faso 10 14 13 13
11 Cabo Verde Cabo Verde 10 8 15 10
12 Uganda Uganda 10 6 15 8
13 Costa de Marfil Costa Marfil 10 20 7 22
14 Camerún Camerún 10 18 10 21
15 Egipto Egipto 10 26 15 17
16 Libia Libia 10 8 10 12
17 Sudán Sudán 10 6 22 6
18 Benín Benín 10 9 23 5
19 Nigeria Nigeria 10 21 7 21
20 Angola Angola 10 12 6 21
21 Zimbabue Zimbabue 10 13 14 15
22 Gabón Gabón 10 11 13 10
23 Argelia Argelia 10 8 15 8
24 Ruanda Ruanda 10 6 16 5
25 Túnez Túnez 10 25 9 21
26 Marruecos Marruecos 10 17 7 20
27 Guinea Guinea 10 15 10 17
28 Kenia Kenia 10 8 17 10
29 Botsuana Botsuana 10 10 18 9
30 Malawi Malawi 10 12 26 6
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Camerún Camerún 8 14 4 19
2 Angola Angola 8 11 9 13
3 Zambia Zambia 8 14 11 11
4 Togo Togo 8 10 13 9
5 Libia Libia 8 7 19 2
Ver
TEMPORADA 1996/1997
Equipo PJ GF GC Puntos
1 Túnez Túnez 6 10 1 16
2 Egipto Egipto 6 15 5 10
3 Liberia Liberia 6 2 10 4
4 Namibia Namibia 6 6 17 4
Ver
TEMPORADA 1992/1993
Equipo PJ GF GC Puntos
1 Camerún Camerún 4 7 1 8
2 Eswatini Eswatini 3 1 5 4
3 RD Congo RD Congo 3 1 3 1
4 Liberia Liberia 0 0 0 0

  USO DE MEMORIA  
6,906,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.5300
Total Execution Time  0.5321
  CADENA URL  
/clasificacion_mundial_africa2020/grupo2/historico
  GET DATOS  
$_GET['/clasificacion_mundial_africa2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0127  SELECT type FROM routes WHERE alias = 'clasificacion_mundial_africa2020'
0.0257  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_mundial_africa' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121 AND type_rel = 3
0.0155  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 121 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 (1313188,1307711,1307709,1307639,1307017) ORDER BY n.cover_points DESC, update_date DESC
0.0131  SELECT id,name,alias,stepParent FROM categories WHERE parentId=121 ORDER BY order_id ASC
0.0141  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 = 55096 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 121 AND group_code = 2 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0155  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 `tables2020` 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 = 55096 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 `tables2016` 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 = 33375 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 1887 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 39530 AND t.round = 14 ORDER BY team.conference 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 `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 = 39533 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2000` 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 = 66669 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables1997` 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 = 63545 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables1993` 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 = 63558 AND t.round = 1 ORDER BY team.conference 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-05-05 07:31:09' 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-05-05 07:31:09' 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-05-05 07:31:09' 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-05-05 07:31:09' 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 = 'clasificacion_mundial_africa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 121 AND l.year = 2020
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50735,55096,66531) 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, e.player_id ASC LIMIT 10
0.0130  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50735,55096,66531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (162094,149354,286864,369006,414553,431892,29753,156365,212542,286679) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 121 AND l.year = 2020
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50735,55096,66531) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0130  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50735,55096,66531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (183203,241450,111563,193751,240735,246126,286865,350814,366611,646749) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 121 AND l.year = 2020
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50735,55096,66531) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0129  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50735,55096,66531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (111563,223139,227218,241450,278223,286885,287197,304975,366611,426907) ORDER BY rp.in_squad = 1 DESC
0.0143  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 55096 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC