4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1984/1985
Equipo PJ GF GC Puntos
1 México México 15 24 9 32
2 Túnez Túnez 9 14 3 22
3 Uruguay Uruguay 12 21 12 22
4 Senegal Senegal 8 13 3 20
5 Costa de Marfil Costa Marfil 16 13 16 20
6 Perú Perú 11 12 7 19
7 URSS URSS 7 11 3 18
8 Colombia Colombia 11 15 13 18
9 Malawi Malawi 11 14 9 17
10 Zimbabue Zimbabue 9 14 11 17
11 Singapur Singapur 7 12 3 16
12 Chile Chile 11 10 10 16
13 Arabia Saudí Arabia 7 13 5 15
14 Nigeria Nigeria 8 11 5 15
15 Mali Mali 9 16 12 14
16 Malasia Malasia 9 14 10 14
17 Guinea Guinea 9 10 11 14
18 Costa Rica Costa Rica 7 8 4 13
19 Egipto Egipto 8 6 6 13
20 Zambia Zambia 9 11 12 13
21 Gabón Gabón 4 11 0 12
22 Hungría Hungría 5 8 3 12
23 Brasil Brasil 7 10 7 12
24 Canadá Canadá 7 8 5 12
25 Polonia Polonia 11 9 16 12
26 Bangladesh Bangladesh 5 14 3 11
27 Marruecos Marruecos 6 9 3 11
28 Italia Italia 7 8 6 11
29 RD Alemania RD Alemania 8 8 12 11
30 Tailandia Tailandia 5 19 4 10
31 Suecia Suecia 4 6 1 10
32 Iraq Iraq 4 7 3 10
33 Noruega Noruega 7 10 7 10
34 Bahrein Bahrein 6 10 8 10
35 Paraguay Paraguay 11 6 12 10
36 Nueva Zelanda Nueva 3 10 0 9
37 Inglaterra Inglaterra 6 11 5 9
38 Yugoslavia Yugoslavia 4 9 4 9
39 España España 5 5 1 9
40 Corea del Sur Corea 6 10 7 9
41 Suiza Suiza 6 7 5 9
42 Gambia Gambia 7 4 5 8
43 Bulgaria Bulgaria 7 7 10 8
44 Angola Angola 5 8 6 7
45 Kenia Kenia 8 8 14 7
46 Bolivia Bolivia 7 6 14 7
47 Ecuador Ecuador 4 8 5 6
48 Dinamarca Dinamarca 3 5 4 6
49 Argentina Argentina 6 6 6 6
50 Cabo Verde Cabo Verde 5 5 5 6
51 Uganda Uganda 5 6 7 6
52 RD Congo RD Congo 5 4 5 6
53 Congo Congo 6 7 9 6
54 Pakistán Pakistán 6 9 12 6
55 Sierra Leona Sierra Leona 3 3 2 5
56 Indonesia Indonesia 6 5 12 5
57 Libia Libia 2 2 0 4
58 Guyana Guyana 2 3 2 4
59 India India 3 2 1 4
60 Escocia Escocia 2 1 0 4
61 Surinam Surinam 2 1 0 4
62 China China 3 5 5 4
63 Grecia Grecia 3 2 2 4
64 Rumanía Rumanía 3 3 4 4
65 Camerún Camerún 4 2 4 4
66 Mozambique Mozambique 5 4 8 4
67 Australia Australia 1 3 0 3
68 Venezuela Venezuela 2 6 4 3
69 Malta Malta 1 3 1 3
70 Mauricio Mauricio 1 3 1 3
71 Hong Kong Hong Kong 1 2 0 3
72 Países Bajos Países 1 1 0 3
73 Checoslovaquia Checoslovaqu 2 3 3 3
74 El Salvador El Salvador 2 2 2 3
75 Turquía Turquía 3 1 1 3
76 Somalia Somalia 3 5 6 3
77 Togo Togo 2 3 4 3
78 Yemen Yemen 2 2 3 3
79 Guatemala Guatemala 2 1 2 3
80 Nepal Nepal 3 3 5 3
81 Catar Catar 4 5 8 3
82 Alemania Occidental Alemania 5 4 8 3
83 Argelia Argelia 7 4 11 3
84 Jamaica Jamaica 2 3 3 2
85 Barbados Barbados 2 2 2 2
86 Islandia Islandia 2 1 1 2
87 Irlanda Irlanda 4 2 4 2
88 Israel Israel 3 1 3 2
89 Tanzania Tanzania 5 2 6 2
90 Estados Unidos Estados 4 2 9 2
91 Kuwait Kuwait 1 1 1 1
92 Albania Albania 1 0 0 1
93 Irlanda del Norte Irlanda 1 0 0 1
94 Luxemburgo Luxemburgo 1 0 0 1
95 Cuba Cuba 2 2 3 1
96 Papúa Nueva Guinea Papúa Nueva 2 2 5 1
97 Guinea Ecuatorial Guinea 3 0 3 1
98 Gales Gales 3 3 8 1
99 Austria Austria 3 0 5 1
100 Burundi Burundi 4 2 10 1
101 Mauritania Mauritania 9 2 22 1
102 Honduras Honduras 1 0 1 0
103 Emiratos Árabes Emiratos 2 1 3 0
104 Madagascar Madagascar 1 1 3 0
105 Macao Macao 1 0 2 0
106 Siria Siria 1 0 2 0
107 Portugal Portugal 2 2 5 0
108 Japón Japón 1 1 4 0
109 Chad Chad 1 0 3 0
110 Trinidad y Tobago Trinidad 3 2 6 0
111 Ghana Ghana 3 1 5 0
112 Irán Irán 2 1 5 0
113 República Centroafricana República 2 1 8 0
114 Jordania Jordania 3 1 9 0
115 Finlandia Finlandia 6 5 14 0
116 Maldivas Maldivas 2 1 11 0
117 Fiyi Fiyi 3 0 10 0
118 Filipinas Filipinas 2 0 13 0

  USO DE MEMORIA  
5,231,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1149
Total Execution Time  0.1169
  CADENA URL  
/amistosos_selecciones2022/grupo1/historico
  GET DATOS  
$_GET['/amistosos_selecciones2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'amistosos_selecciones2022'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=307 AND type_rel = 3
0.0116  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 307 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1311197,1308327,1308322,1308199,1308177) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = 62588 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 307 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0055  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 `tables1985` 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 = 39441 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 03:43:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 03:43:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 03:43:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 03:43:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones' 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.0036  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 2022
0.0043  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62588) 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.0028  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 (62588) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (275364,58798,1001268,23569,189893,1202,62476,312245,379523,59607) ORDER BY rp.in_squad = 1 DESC
0.0040  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 2022
0.0036  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62588) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0035  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 (62588) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (277057,278692,291307,369877,425916,742375,768892,3156537,83394,101683) ORDER BY rp.in_squad = 1 DESC
0.0047  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 2022
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62588) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0030  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 (62588) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (101683,102040,138850,153459,180820,181900,191851,197936,209150,229705) ORDER BY rp.in_squad = 1 DESC