4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 España España 8 25 5 21
2 Escocia Escocia 8 17 8 17
3 Noruega Noruega 8 14 12 11
4 Georgia Georgia 8 12 18 8
5 Chipre Chipre 8 3 28 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Inglaterra Inglaterra 8 37 6 21
2 República Checa República 8 13 11 15
3 Kosovo Kosovo 8 13 16 11
4 Bulgaria Bulgaria 8 6 17 6
5 Montenegro Montenegro 8 3 22 3
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 República Checa República 10 19 14 22
2 Islandia Islandia 10 17 6 20
3 Turquía Turquía 10 14 9 18
4 Países Bajos Países 10 17 14 13
5 Kazajistán Kazajistán 10 7 18 5
6 Letonia Letonia 10 6 19 5
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Alemania Alemania 10 34 7 30
2 Turquía Turquía 10 13 11 17
3 Bélgica Bélgica 10 21 15 15
4 Austria Austria 10 16 17 12
5 Azerbaiyán Azerbaiyán 10 10 26 7
6 Kazajistán Kazajistán 10 6 24 4
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

Equipos de esta liga

5

  USO DE MEMORIA  
7,840,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6675
Total Execution Time  0.6695
  CADENA URL  
/clasificacion_eurocopa2022/grupo1/historico
  GET DATOS  
$_GET['/clasificacion_eurocopa2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0128  SELECT type FROM routes WHERE alias = 'clasificacion_eurocopa2022'
0.0253  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=142 AND type_rel = 3
0.0270  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.0130  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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=201 ORDER BY order_id ASC
0.0127  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 = 69977 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 142 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2022` 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 = 69977 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `tables2018` 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 = 48333 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2014` 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 = 3593 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2010` 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 = 988 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 `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.0205  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.0166  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.0156  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.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 `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.0153  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.0150  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.0149  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.0151  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.0139  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.0133  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.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 19:38:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 19:38:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 19:38:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 19:38:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0139  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0136  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2022
0.0168  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (69977,69978,69979,69980,69981,69982,69983,69984,69985,69986,74654) 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.0139  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 (69977,69978,69979,69980,69981,69982,69983,69984,69985,69986,74654) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (37669,28185,234474,120815,289788,834769,193339,326208,752190,185513) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2022
0.0140  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (69977,69978,69979,69980,69981,69982,69983,69984,69985,69986,74654) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0131  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 (69977,69978,69979,69980,69981,69982,69983,69984,69985,69986,74654) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (240734,357750,123845,191735,280127,342661,75798,171094,191693,192305) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2022
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (69977,69978,69979,69980,69981,69982,69983,69984,69985,69986,74654) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0131  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 (69977,69978,69979,69980,69981,69982,69983,69984,69985,69986,74654) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3156638,46855,93092,103289,106210,143590,147067,153650,167208,171094) ORDER BY rp.in_squad = 1 DESC
0.0132  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 69977 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC