4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Alemania Sub 21 Alemania 10 39 9 28
2 Bosnia Sub 21 Bosnia 10 25 12 20
3 Grecia Sub 21 Grecia 10 14 15 13
4 Bielorrusia Sub 21 Bielorrusia 10 11 17 13
5 Chipre Sub 21 Chipre 10 16 20 12
6 San Marino Sub 21 Marino 10 2 34 1
7 Suecia Sub 21 Suecia 10 18 10 22
8 Eslovenia Sub 21 Eslovenia 10 15 8 20
9 Ucrania Sub 21 Ucrania 10 21 10 17
10 Finlandia Sub 21 Finlandia 10 12 14 12
11 Lituania Sub 21 Lituania 10 9 18 9
12 Malta Sub 21 Malta 10 8 23 5
13 República Checa Sub 21 República 8 24 3 20
14 Armenia Sub 21 Armenia 8 11 5 15
15 Montenegro Sub 21 Montenegro 8 14 8 11
16 Gales Sub 21 Gales 8 7 10 10
17 Andorra Sub 21 Andorra 8 2 32 0
18 Serbia Sub 21 Serbia 8 17 4 18
19 Dinamarca Sub 21 Dinamarca 8 19 8 16
20 Macedonia del Norte Sub 21 Macedonia 8 14 15 12
21 Irlanda del Norte Sub 21 Irlanda 8 5 13 4
22 Islas Feroe Sub 21 Islas Feroe 8 3 18 3
23 España Sub 21 España 8 27 2 22
24 Suiza Sub 21 Suiza 8 15 4 17
25 Georgia Sub 21 Georgia 8 8 18 10
26 Croacia Sub 21 Croacia 8 7 16 7
27 Estonia Sub 21 Estonia 8 2 19 1
28 Rusia Sub 21 Rusia 8 17 5 17
29 Portugal Sub 21 Portugal 8 15 6 15
30 Polonia Sub 21 Polonia 8 13 13 11
31 Moldavia Sub 21 Moldavia 8 10 24 7
32 Albania Sub 21 Albania 8 11 18 5
33 Italia Sub 21 Italia 8 27 8 19
34 Turquía Sub 21 Turquía 8 13 7 15
35 Irlanda Sub 21 Irlanda 8 15 10 13
36 Hungría Sub 21 Hungría 8 11 10 12
37 Liechtenstein Sub 21 Liechtenstei 8 4 35 0
38 Inglaterra Sub 21 Inglaterra 8 24 3 21
39 Noruega Sub 21 Noruega 8 13 7 16
40 Bélgica Sub 21 Bélgica 8 17 15 11
41 Azerbaiyán Sub 21 Azerbaiyán 8 6 18 7
42 Islandia Sub 21 Islandia 8 4 21 3
43 Francia Sub 21 Francia 8 19 2 21
44 Eslovaquia Sub 21 Eslovaquia 7 11 7 12
45 Rumanía Sub 21 Rumanía 7 7 6 11
46 Kazajistán Sub 21 Kazajistán 7 2 8 4
47 Letonia Sub 21 Letonia 7 1 17 2
48 Países Bajos Sub 21 Países 8 21 3 19
49 Escocia Sub 21 Escocia 8 16 9 13
50 Bulgaria Sub 21 Bulgaria 8 11 12 12
51 Austria Sub 21 Austria 8 15 14 11
52 Luxemburgo Sub 21 Luxemburgo 8 6 31 0
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Rumanía Sub 21 Rumanía 11 23 6 26
2 Rusia Sub 21 Rusia 11 22 6 23
3 Moldavia Sub 21 Moldavia 10 9 13 14
4 Letonia Sub 21 Letonia 10 16 15 13
5 Islas Feroe Sub 21 Islas Feroe 10 8 16 11
6 Andorra Sub 21 Andorra 10 3 25 1
7 Suiza Sub 21 Suiza 10 15 8 20
8 Turquía Sub 21 Turquía 10 13 11 16
9 Georgia Sub 21 Georgia 10 12 9 15
10 Armenia Sub 21 Armenia 10 18 19 13
11 Estonia Sub 21 Estonia 10 9 16 12
12 Irlanda Sub 21 Irlanda 10 11 15 7
13 Italia Sub 21 Italia 9 13 5 19
14 Gales Sub 21 Gales 9 15 7 16
15 Hungría Sub 21 Hungría 9 9 7 14
16 Bosnia Sub 21 Bosnia 9 4 8 9
17 Luxemburgo Sub 21 Luxemburgo 8 2 16 4
18 Países Bajos Sub 21 Países 8 19 5 21
19 España Sub 21 España 8 15 5 19
20 Finlandia Sub 21 Finlandia 8 11 7 10
21 Polonia Sub 21 Polonia 8 11 13 9
22 Liechtenstein Sub 21 Liechtenstei 8 1 27 0
23 República Checa Sub 21 República 8 25 4 22
24 Islandia Sub 21 Islandia 8 29 11 16
25 Alemania Sub 21 Alemania 8 26 10 12
26 Irlanda del Norte Sub 21 Irlanda 8 12 16 7
27 San Marino Sub 21 Marino 8 0 51 0
28 Suecia Sub 21 Suecia 8 15 5 19
29 Israel Sub 21 Israel 8 18 8 16
30 Montenegro Sub 21 Montenegro 8 9 11 13
31 Kazajistán Sub 21 Kazajistán 8 7 17 5
32 Bulgaria Sub 21 Bulgaria 8 8 16 4
33 Croacia Sub 21 Croacia 8 17 10 17
34 Eslovaquia Sub 21 Eslovaquia 9 12 15 14
35 Serbia Sub 21 Serbia 8 14 12 13
36 Noruega Sub 21 Noruega 9 18 19 10
37 Chipre Sub 21 Chipre 8 8 13 6
38 Ucrania Sub 21 Ucrania 8 13 5 16
39 Francia Sub 21 Francia 8 12 6 15
40 Bélgica Sub 21 Bélgica 8 8 5 15
41 Eslovenia Sub 21 Eslovenia 8 6 10 8
42 Malta Sub 21 Malta 8 0 13 0
43 Grecia Sub 21 Grecia 8 13 7 19
44 Inglaterra Sub 21 Inglaterra 8 15 7 17
45 Portugal Sub 21 Portugal 8 12 8 13
46 Lituania Sub 21 Lituania 8 3 11 5
47 Macedonia del Norte Sub 21 Macedonia 8 9 19 2
48 Bielorrusia Sub 21 Bielorrusia 8 16 11 17
49 Escocia Sub 21 Escocia 7 14 6 14
50 Austria Sub 21 Austria 7 16 9 14
51 Albania Sub 21 Albania 8 11 20 4
52 Azerbaiyán Sub 21 Azerbaiyán 8 8 19 4
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Italia Sub 21 Italia 10 21 5 24
2 Croacia Sub 21 Croacia 10 20 12 22
3 Grecia Sub 21 Grecia 10 20 13 18
4 Albania Sub 21 Albania 10 10 13 12
5 Islas Feroe Sub 21 Islas Feroe 10 5 18 4
6 Azerbaiyán Sub 21 Azerbaiyán 10 6 21 3
7 Turquía Sub 21 Turquía 8 18 6 19
8 Ucrania Sub 21 Ucrania 8 16 7 15
9 República Checa Sub 21 República 8 19 5 14
10 Armenia Sub 21 Armenia 8 8 16 10
11 Liechtenstein Sub 21 Liechtenstei 8 4 31 0
12 Inglaterra Sub 21 Inglaterra 8 17 1 22
13 Portugal Sub 21 Portugal 8 13 7 14
14 Montenegro Sub 21 Montenegro 8 5 12 8
15 Bulgaria Sub 21 Bulgaria 8 4 9 7
16 Irlanda Sub 21 Irlanda 8 4 14 5
17 España Sub 21 España 8 21 2 24
18 Rusia Sub 21 Rusia 8 12 6 15
19 Polonia Sub 21 Polonia 8 9 11 9
20 Kazajistán Sub 21 Kazajistán 8 9 16 6
21 Georgia Sub 21 Georgia 8 6 22 6
22 Suiza Sub 21 Suiza 8 16 5 16
23 Países Bajos Sub 21 Países 8 10 3 16
24 Noruega Sub 21 Noruega 9 7 6 13
25 Macedonia del Norte Sub 21 Macedonia 9 5 6 10
26 Estonia Sub 21 Estonia 8 1 19 3
27 Finlandia Sub 21 Finlandia 8 11 6 19
28 Escocia Sub 21 Escocia 8 17 6 16
29 Dinamarca Sub 21 Dinamarca 8 13 4 16
30 Eslovenia Sub 21 Eslovenia 8 4 13 5
31 Lituania Sub 21 Lituania 8 2 18 1
32 Austria Sub 21 Austria 8 12 6 20
33 Bélgica Sub 21 Bélgica 8 13 11 11
34 Eslovaquia Sub 21 Eslovaquia 8 13 12 10
35 Islandia Sub 21 Islandia 8 6 9 7
36 Chipre Sub 21 Chipre 8 9 15 6
37 Serbia Sub 21 Serbia 8 24 5 17
38 Bielorrusia Sub 21 Bielorrusia 8 15 5 17
39 Hungría Sub 21 Hungría 8 14 13 12
40 Letonia Sub 21 Letonia 8 6 6 11
41 San Marino Sub 21 Marino 8 1 31 0
42 Alemania Sub 21 Alemania 9 24 3 18
43 Israel Sub 21 Israel 9 16 5 18
44 Irlanda del Norte Sub 21 Irlanda 8 13 12 12
45 Moldavia Sub 21 Moldavia 8 6 8 12
46 Luxemburgo Sub 21 Luxemburgo 8 1 32 0
47 Gales Sub 21 Gales 8 20 6 18
48 Francia Sub 21 Francia 8 16 5 17
49 Rumanía Sub 21 Rumanía 8 11 5 15
50 Bosnia Sub 21 Bosnia 8 7 17 4
51 Malta Sub 21 Malta 8 3 24 3
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Países Bajos Sub 21 Países 10 21 7 23
2 República Checa Sub 21 República 10 26 8 21
3 Rumanía Sub 21 Rumanía 10 17 8 19
4 Macedonia del Norte Sub 21 Macedonia 10 9 18 9
5 Finlandia Sub 21 Finlandia 10 7 16 7
6 Armenia Sub 21 Armenia 10 2 25 5
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Francia Sub 21 Francia 8 14 0 22
2 Chipre Sub 21 Chipre 8 12 5 15
3 Israel Sub 21 Israel 8 6 11 10
4 Eslovenia Sub 21 Eslovenia 8 4 7 9
5 Malta Sub 21 Malta 8 0 13 1
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Suiza Sub 21 Suiza 8 22 10 16
2 Rusia Sub 21 Rusia 8 23 9 15
3 Serbia y Montenegro Sub 21 Serbia 8 22 11 15
4 Eslovenia Sub 21 Eslovenia 8 10 10 8
5 Luxemburgo Sub 21 Luxemburgo 8 1 38 0
Ver
TEMPORADA 1997/1998
Equipo PJ GF GC Puntos
1 Italia Sub 21 Italia 8 20 7 22
2 Suiza Sub 21 Suiza 8 8 4 14
3 Dinamarca Sub 21 Dinamarca 8 11 13 10
4 Bielorrusia Sub 21 Bielorrusia 8 5 12 7
5 Gales Sub 21 Gales 8 6 14 3
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 Dinamarca Sub 21 Dinamarca 8 16 9 16
2 Grecia Sub 21 Grecia 8 12 7 16
3 Croacia Sub 21 Croacia 8 13 9 12
4 Eslovenia Sub 21 Eslovenia 8 9 13 9
5 Bosnia Sub 21 Bosnia 8 6 18 5
Ver
TEMPORADA 1993/1994
Equipo PJ GF GC Puntos
1 Francia Sub 21 Francia 10 25 3 21
2 Polonia Sub 21 Polonia 10 18 18 17
3 Rumanía Sub 21 Rumanía 10 17 10 16
4 Eslovaquia Sub 21 Eslovaquia 10 11 10 14
5 Israel Sub 21 Israel 10 12 11 12
6 Azerbaiyán Sub 21 Azerbaiyán 10 5 36 3
Ver
TEMPORADA 1991/1992
Equipo PJ GF GC Puntos
1 Italia Sub 21 Italia 6 12 5 15
2 Portugal Sub 21 Portugal 6 10 2 14
3 Suiza Sub 21 Suiza 7 11 6 11
4 Escocia Sub 21 Escocia 8 8 11 8
5 Malta Sub 21 Malta 7 1 18 0
Ver
TEMPORADA 1989/1990
Equipo PJ GF GC Puntos
1 Checoslovaquia Sub 21 Checoslovaqu 8 23 4 22
2 Francia Sub 21 Francia 8 7 5 11
3 España Sub 21 España 7 6 5 11
4 Albania Sub 21 Albania 7 3 13 5
5 Islandia Sub 21 Islandia 8 3 15 4
Ver
TEMPORADA 1987/1988
Equipo PJ GF GC Puntos
1 Bulgaria Sub 21 Bulgaria 6 16 4 15
2 Rumanía Sub 21 Rumanía 6 8 7 9
3 Dinamarca Sub 21 Dinamarca 6 9 14 7
4 Grecia Sub 21 Grecia 6 3 11 4
Ver
TEMPORADA 1985/1986
Equipo PJ GF GC Puntos
1 España Sub 21 España 6 9 1 14
2 Rumanía Sub 21 Rumanía 6 7 7 9
3 Austria Sub 21 Austria 6 5 7 8
4 Albania Sub 21 Albania 6 4 10 2
Ver
TEMPORADA 1979/1980
Equipo PJ GF GC Puntos
1 Alemania Sub 21 Alemania 6 15 5 15
2 Bulgaria Sub 21 Bulgaria 6 7 5 15
3 Austria Sub 21 Austria 6 3 9 4
4 Finlandia Sub 21 Finlandia 6 4 10 1
Ver
TEMPORADA 1977/1978
Equipo PJ GF GC Puntos
1 Inglaterra Sub 21 Inglaterra 4 11 2 8
2 Dinamarca Sub 21 Dinamarca 4 3 4 2
3 Bulgaria Sub 21 Bulgaria 4 2 10 2
Ver
TEMPORADA 1975/1976
Equipo PJ GF GC Puntos
1 Dinamarca Sub 21 Dinamarca 4 10 5 5
2 Polonia Sub 21 Polonia 4 7 10 4
3 Suecia Sub 21 Suecia 4 6 8 3

  USO DE MEMORIA  
7,888,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1567
Total Execution Time  0.1586
  CADENA URL  
/clasificacion_europeo_sub_212013/grupo1/historico
  GET DATOS  
$_GET['/clasificacion_europeo_sub_212013/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT type FROM routes WHERE alias = 'clasificacion_europeo_sub_212013'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_europeo_sub_21' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  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 = 41905 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 848 AND group_code = 1 and tables = 1 AND year <= 2013 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0033  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 `tables2013` 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 = 41905 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2011` 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 = 41908 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 41917 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 56968 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2002` 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 = 56955 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 56941 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1998` 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 = 56928 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1996` 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 = 56918 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1994` 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 = 56909 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1992` 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 = 56901 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1990` 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 = 56882 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1988` 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 = 56870 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1986` 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 = 56860 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1980` 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 = 56841 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1978` 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 = 72144 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1976` 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 = 72152 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 03:23:29' 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=2 AND last_update > '2024-04-28 03:23:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0028  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 03:23:29' 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-28 03:23:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_europeo_sub_21' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 848 AND l.year = 2013
0.0030  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (41905,41906) 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.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 (41905,41906) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (37776,70866,1787,13212,56272,66208,44027,81821,131071,146484) ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 848 AND l.year = 2013
0.0034  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (41905,41906) AND (e.action = 4 or e.action = 5) 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 (41905,41906) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (191559,132592,14329,32726,100805,107197,141679,153174,168267,178400) ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 848 AND l.year = 2013
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (41905,41906) 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 (41905,41906) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (32726,57607,178400,30005,30088,34045,35260,39537,44146,49846) ORDER BY rp.in_squad = 1 DESC
0.0070  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 41905 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC