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,229,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0824
Total Execution Time  0.0843
  CADENA URL  
/amistosos_selecciones2024/grupo1/historico
  GET DATOS  
$_GET['/amistosos_selecciones2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT type FROM routes WHERE alias = 'amistosos_selecciones2024'
0.0042  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=307 ORDER BY order_id ASC
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 307 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0053  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.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 08:39:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 08:39:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 08:39:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 08:39:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 2024
0.0029  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (70632) 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.0023  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 (70632) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (306650,448584,66696,122602,162094,275712,295505,313131,314802,323391) ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 2024
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (70632) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0025  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 (70632) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (138565,843148,849418,867653,921616,139111,159428,202152,206218,207002) ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 307 AND l.year = 2024
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (70632) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0024  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 (70632) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (193253,206443,210784,284967,287211,296477,328751,347929,348133,354176) ORDER BY rp.in_squad = 1 DESC