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

  USO DE MEMORIA  
9,366,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7096
Total Execution Time  0.7115
  CADENA URL  
/clasificacion_eurocopa2006/grupo1/historico
  GET DATOS  
$_GET['/clasificacion_eurocopa2006/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0144  SELECT type FROM routes WHERE alias = 'clasificacion_eurocopa2006'
0.0295  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_eurocopa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=142 AND type_rel = 3
0.0198  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 142 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0151  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 (903768,1308187,1308144,1308131,1308060) ORDER BY n.cover_points DESC, update_date DESC
0.0157  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 = 37806 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 142 AND group_code = 1 and tables = 1 AND year <= 2006 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0176  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 `tables2006` 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 = 37806 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0178  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 = 37818 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0179  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 = 37820 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0179  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 = 37822 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172  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 = 37825 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0173  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 = 37826 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0174  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 `tables1982` 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 = 37828 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 = 37836 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0179  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 `tables1974` 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 = 37837 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 `tables1970` 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 = 37838 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1966` 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 = 37841 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 15:07:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 15:07:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 15:07:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 15:07:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_eurocopa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2006
0.0193  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (37806) 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.0151  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 (37806) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (161063,27165,2292,2278,5750,28185,2136,7585,10136,433) ORDER BY rp.in_squad = 1 DESC
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2006
0.0203  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (37806) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0149  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 (37806) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1160,4707,34823,80107,95387,101066,258065,258977,350506,120) ORDER BY rp.in_squad = 1 DESC
0.0162  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2006
0.0255  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (37806) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0147  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 (37806) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (120,365,483,1677,2234,3400,3551,4707,5182,5319) ORDER BY rp.in_squad = 1 DESC
0.0305  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 37806 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC