4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD San Lorenzo
TEMPORADA 2022/2023
PREFERENTE LA RIOJA GRUPO 4
Equipo PJ GF GC Puntos
1 Autol Autol 32 73 28 67
2 Villegas Villegas 32 64 42 60
3 CD Arnedo B CD Arnedo B 32 65 69 40
4 Náxara B Náxara B 32 43 47 40
5 Calasancio Calasancio 32 38 45 38
6 CD San Lorenzo Lorenzo 32 69 90 37
7 Alfaro B Alfaro B 32 60 66 37
8 Bañuelos Bañuelos 32 52 62 36
9 Real Bethlehem Real 32 39 71 29
10 Inter de Logroño Inter 32 46 79 26
11 Racing Rioja C Racing Rioja 32 26 105 10
12 Sporting Cascajos Sporting 32 26 113 7
TEMPORADA 2021/2022
PREFERENTE LA RIOJA GRUPO 5
Equipo PJ GF GC Puntos
1 Náxara B Náxara B 26 36 37 39
2 Bañuelos Bañuelos 26 52 44 39
3 San Marcial San Marcial 28 39 50 34
4 Alfaro B Alfaro B 28 50 68 25
5 CD Arnedo B CD Arnedo B 26 25 60 23
6 CD San Lorenzo Lorenzo 28 44 71 22
7 Inter de Logroño Inter 28 33 61 21
8 Salesianos Domingo Savio Salesianos 26 26 81 6
TEMPORADA 2020/2021
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 River Ebro B River Ebro 14 41 14 34
2 Cenicero Cenicero 15 31 22 33
3 Rapid de Murillo Rapid 14 28 13 30
4 Aldeano Aldeano 15 32 18 30
5 Haro Promesas Haro 14 27 16 27
6 Peña Balsamaiso CF Peña 15 19 12 27
7 Autol Autol 15 27 19 25
8 Bañuelos Bañuelos 14 23 18 21
9 San Marcial San Marcial 15 21 22 21
10 Real Bethlehem Real 15 19 23 18
11 Alfaro B Alfaro B 15 29 29 17
12 Pradejon B Pradejon B 15 23 33 16
13 Salesianos Domingo Savio Salesianos 15 16 28 14
14 Racing Rioja B Racing Rioja 15 17 30 9
15 CD Arnedo B CD Arnedo B 15 15 38 6
16 CD San Lorenzo Lorenzo 15 12 45 3
TEMPORADA 2019/2020
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Racing Rioja Racing Rioja 23 83 12 58
2 Agoncillo Agoncillo 22 53 14 55
3 CD Tedeón CD Tedeón 22 67 19 51
4 Autol Autol 22 66 25 49
5 San Marcial San Marcial 23 54 41 43
6 River Ebro B River Ebro 23 38 22 42
7 Rapid de Murillo Rapid 22 41 33 42
8 Haro Promesas Haro 21 46 29 36
9 Varea B Varea B 23 41 40 32
10 Alfaro B Alfaro B 23 40 49 26
11 Bañuelos Bañuelos 22 32 48 26
12 Cenicero Cenicero 23 36 43 21
13 Peña Balsamaiso CF Peña 22 29 49 17
14 Pradejon B Pradejon B 23 28 78 16
15 CD San Lorenzo Lorenzo 22 26 62 11
16 Aldeano Aldeano 23 20 70 11
17 Calasancio B Calasancio 23 26 92 8
TEMPORADA 2018/2019
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 CD Calahorra B Calahorra 24 56 17 54
2 Comillas CF Comillas CF 24 47 26 51
3 Casalarreina Casalarreina 24 49 19 50
4 Villegas Villegas 24 40 23 48
5 CD Tedeón CD Tedeón 24 47 25 44
6 Cenicero Cenicero 24 37 23 40
7 Racing Rioja Racing Rioja 24 47 37 35
8 San Marcial San Marcial 24 29 46 27
9 Bañuelos Bañuelos 24 36 46 24
10 Haro Sport Club Haro Sport. 24 44 62 22
11 Aldeano Aldeano 24 30 57 21
12 Alfaro B Alfaro B 24 27 55 21
13 CD San Lorenzo Lorenzo 24 20 73 8
TEMPORADA 2017/2018
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Autol Autol 22 54 17 49
2 Alberite Alberite 22 71 24 47
3 La Calzada La Calzada 22 45 21 45
4 Rapid de Murillo Rapid 22 38 23 40
5 Haro Sport Club Haro Sport. 22 38 43 32
6 San Marcial San Marcial 22 37 37 28
7 Alfaro B Alfaro B 22 27 44 27
8 Cenicero Cenicero 22 27 21 26
9 Aldeano Aldeano 22 47 49 26
10 CD San Lorenzo Lorenzo 22 26 42 20
11 Bañuelos Bañuelos 22 21 47 15
12 Calasancio B Calasancio 22 17 80 9
TEMPORADA 2016/2017
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Pradejón Pradejón 26 57 20 61
2 CD Berceo CD Berceo 26 64 21 60
3 Yagüe Yagüe 26 64 25 58
4 Alberite Alberite 26 69 20 55
5 Autol Autol 26 44 35 44
6 Alfaro B Alfaro B 26 53 53 37
7 Peña Balsamaiso CF Peña 26 46 53 32
8 Haro Sport Club Haro Sport. 26 40 56 29
9 Oyonesa B Oyonesa B 26 32 61 28
10 Aldeano Aldeano 26 42 69 27
11 Bañuelos Bañuelos 26 38 53 24
12 Cenicero Cenicero 26 29 53 22
13 Náxara B Náxara B 26 33 58 19
14 CD San Lorenzo Lorenzo 26 22 56 12
TEMPORADA 2015/2016
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Rapid de Murillo Rapid 28 76 21 72
2 UD Logroñés B Logroñés 28 103 13 71
3 Casalarreina Casalarreina 28 69 16 64
4 Yagüe Yagüe 28 79 40 54
5 CD Berceo CD Berceo 28 49 31 48
6 Autol Autol 28 48 39 43
7 Haro Sport Club Haro Sport. 28 58 61 39
8 Alfaro B Alfaro B 28 30 46 39
9 Club Atlético Vianés B Club 28 32 55 33
10 Oyonesa B Oyonesa B 28 33 51 31
11 Bañuelos Bañuelos 28 43 64 29
12 Cenicero Cenicero 28 34 59 25
13 Aldeano Aldeano 28 31 75 24
14 Náxara B Náxara B 28 24 84 15
15 CD San Lorenzo Lorenzo 28 23 77 12
TEMPORADA 2014/2015
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Pradejón Pradejón 26 63 16 59
2 San Marcial San Marcial 26 68 27 56
3 Alberite Alberite 26 72 28 52
4 Oyonesa B Oyonesa B 26 44 31 51
5 CD Berceo CD Berceo 26 61 31 49
6 Rapid de Murillo Rapid 26 51 33 49
7 Autol Autol 26 41 34 42
8 Club Atlético Vianés B Club 26 39 34 32
9 Haro Sport Club Haro Sport. 26 29 54 28
10 Náxara B Náxara B 26 32 49 22
11 Aldeano Aldeano 26 35 75 20
12 Cenicero Cenicero 26 31 50 19
13 Bañuelos Bañuelos 26 19 65 14
14 CD San Lorenzo Lorenzo 26 22 80 11
TEMPORADA 2013/2014
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Casalarreina Casalarreina 28 72 32 58
2 Club Atlético Vianés B Club 28 58 24 58
3 Náxara B Náxara B 28 62 26 55
4 Yagüe Yagüe 28 59 32 54
5 CD Tedeón CD Tedeón 28 60 31 51
6 Oyonesa B Oyonesa B 28 42 23 50
7 Rapid de Murillo Rapid 28 68 41 50
8 Autol Autol 28 38 40 42
9 Cenicero Cenicero 28 54 65 37
10 CD Arnedo B CD Arnedo B 28 44 57 36
11 Aldeano Aldeano 28 46 68 24
12 Bañuelos Bañuelos 28 37 67 23
13 Peña Balsamaiso B Peña 28 35 77 22
14 CD San Lorenzo Lorenzo 28 20 71 16
15 Haro Sport Club Haro Sport. 28 30 71 12
TEMPORADA 2012/2013
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Alfaro B Alfaro B 26 66 24 59
2 Alberite Alberite 26 64 34 53
3 Peña Balsamaiso CF Peña 26 55 37 48
4 Náxara B Náxara B 25 45 29 47
5 Casalarreina Casalarreina 26 42 29 46
6 Edf Logroño Logroño 26 47 35 45
7 Cenicero Cenicero 26 38 37 41
8 Oyonesa B Oyonesa B 26 35 25 40
9 CD San Lorenzo Lorenzo 25 42 41 35
10 CD Tedeón CD Tedeón 25 28 34 32
11 Autol Autol 25 31 51 23
12 Club Atlético Vianés B Club 26 32 52 21
13 Bañuelos Bañuelos 26 30 65 11
14 Calasancio B Calasancio 26 13 75 8
TEMPORADA 2009/2010
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 SD Logroñés Logroñés 36 159 21 106
2 CD Varea CD Varea 37 98 33 91
3 UD Logroñés B Logroñés 38 96 29 88
4 Casalarreina Casalarreina 38 75 65 62
5 CD Tedeón CD Tedeón 38 71 54 60
6 Náxara B Náxara B 37 56 53 58
7 CD San Lorenzo Lorenzo 32 73 50 56
8 La Calzada La Calzada 38 65 62 55
9 Anguiano B Anguiano B 40 50 67 53
10 UF Rioja UF Rioja 36 60 59 50
11 Oyonesa B Oyonesa B 37 53 56 48
12 Calasancio B Calasancio 38 44 60 48
13 Bañuelos Bañuelos 37 49 72 46
14 Club Atlético Vianés B Club 38 55 68 41
15 Rapid de Murillo Rapid 38 48 70 39
16 Haro Promesas Haro 38 49 68 37
17 Autol Autol 37 38 68 35
18 Celta Cenicero Celta 38 50 98 32
19 Albelda Atletic Albelda 38 37 104 15
20 Santa María Santa María 38 28 105 13
21 CF Ciudad Alfaro Ciudad 5 13 5 9
TEMPORADA 2008/2009
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Vianés Vianés 30 58 27 69
2 Pradejón Pradejón 30 68 25 68
3 Aldeano Aldeano 30 49 32 63
4 CF Ciudad Alfaro Ciudad 30 57 46 55
5 Calasancio B Calasancio 30 48 37 53
6 Casalarreina Casalarreina 30 72 45 52
7 Náxara B Náxara B 30 61 43 52
8 CD San Lorenzo Lorenzo 30 56 42 50
9 La Calzada La Calzada 30 37 41 36
10 Rapid de Murillo Rapid 30 43 58 32
11 UF Rioja UF Rioja 30 39 55 29
12 Anguiano B Anguiano B 30 45 58 28
13 Oyonesa B Oyonesa B 30 40 63 25
14 Bañuelos Bañuelos 30 38 61 23
15 Autol Autol 30 25 61 20
16 Haro Promesas Haro 30 26 68 18
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 Ejea Ejea 40 95 37 93
2 Barbastro Barbastro 40 102 24 88
3 CD Teruel CD Teruel 40 73 29 84
4 Atlético Monzón Atlético 40 76 34 81
5 Andorra Andorra 40 74 45 81
6 Deportivo Aragón Deportivo 40 84 38 80
7 Villanueva CF Villanueva 40 65 46 71
8 Sariñena Sariñena 40 59 52 58
9 At. Calatayud Calatayud 40 40 39 53
10 Sabiñánigo Sabiñánigo 40 51 57 52
11 Utebo Utebo 40 56 65 51
12 CD San Lorenzo Lorenzo 40 48 74 43
13 CD Binéfar CD Binéfar 40 42 71 43
14 CD Cuarte CD Cuarte 40 52 81 43
15 Brea Brea 40 52 91 43
16 Fraga Fraga 40 41 66 40
17 CD Ebro CD Ebro 40 40 65 40
18 Figueruelas Figueruelas 40 38 64 37
19 Illueca Illueca 40 43 78 33
20 Peñas Oscenses Peñas 40 36 74 29
21 Jacetano Jacetano 40 47 84 28
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 Haro Deportivo Haro 38 100 15 94
2 ADF Logroñes Logroñes 38 111 22 91
3 CD Calahorra Calahorra 38 90 29 85
4 Anguiano Anguiano 38 94 32 80
5 Oyonesa Oyonesa 38 84 36 78
6 CD Varea CD Varea 38 63 27 76
7 Náxara Náxara 38 46 37 63
8 Agoncillo Agoncillo 38 68 51 60
9 Arnedo Arnedo 38 46 31 58
10 River Ebro River Ebro 38 59 53 55
11 San Marcial San Marcial 38 53 53 49
12 CF Ciudad Alfaro Ciudad 38 54 65 46
13 Cenicero Cenicero 38 35 70 37
14 Yagüe Yagüe 38 37 69 37
15 Calasancio Calasancio 38 24 63 36
16 Rapid de Murillo Rapid 38 36 68 35
17 Autol Autol 38 31 89 33
18 Pradejón Pradejón 38 49 107 29
19 CD San Lorenzo Lorenzo 38 29 99 19
20 Bañuelos Bañuelos 38 29 122 10
TEMPORADA 1960/1961
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Puertollano Puertollano 32 84 29 48
2 CP Villarrobledo Villarrobled 32 81 34 44
3 CD Badajoz CD Badajoz 32 72 37 43
4 Getafe Deportivo Getafe 32 56 48 37
5 CD Toledo CD Toledo 32 64 53 37
6 Atlético B Atlético B 32 61 45 36
7 CD Don Benito Benito 32 51 60 34
8 Gimnástico de Alcázar Gimnástico 32 60 55 33
9 CD Manchego CD Manchego 32 57 51 33
10 Real Aranjuez CF Real 32 47 45 32
11 CD Guadalajara Guadalajara 32 42 47 29
12 RSD Alcalá RSD Alcalá 32 57 68 29
13 Manzanares CF Manzanares 32 52 61 28
14 SAD Villaverde Villaverde 32 42 57 28
15 Mérida CP Mérida CP 32 48 52 27
16 CD San Lorenzo Lorenzo 32 24 112 14
17 Manufacturas Metálicas Manufacturas 32 35 79 12
TEMPORADA 1959/1960
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Manchego CD Manchego 30 71 32 45
2 CP Villarrobledo Villarrobled 30 78 33 43
3 Puertollano Puertollano 30 85 35 41
4 Mérida CP Mérida CP 30 63 49 37
5 Gimnástico de Alcázar Gimnástico 30 59 46 36
6 Atlético B Atlético B 30 59 42 35
7 Real Aranjuez CF Real 30 63 55 34
8 Manzanares CF Manzanares 30 69 65 32
9 Getafe Deportivo Getafe 30 47 62 28
10 CD Toledo CD Toledo 30 46 59 26
11 CD Don Benito Benito 30 53 63 24
12 CD Guadalajara Guadalajara 30 43 67 23
13 CD San Lorenzo Lorenzo 30 45 69 21
14 Manufacturas Metálicas Manufacturas 30 32 49 20
15 RCD Carabanchel Carabanchel 30 34 71 18
16 Leganés Leganés 30 36 86 17
TEMPORADA 1954/1955
TERCERA DIVISIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 AD Plus Ultra Plus Ultra 18 47 25 26
2 Rayo Vallecano Rayo 18 37 16 23
3 Real Aranjuez CF Real 18 45 31 20
4 Cuatro Caminos Cuatro 18 34 39 18
5 Leganés Leganés 18 43 46 17
6 Girod Girod 18 33 39 17
7 CD San Lorenzo Lorenzo 18 35 38 17
8 CD Toledo CD Toledo 18 35 41 16
9 UB Conquense Conquense 18 21 34 13
10 CD Guadalajara Guadalajara 18 25 46 13

  USO DE MEMORIA  
6,955,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9590
Total Execution Time  0.9603
  CADENA URL  
/historico/Cd-San-Lorenzo-Senior
  GET DATOS  
$_GET['/historico/Cd-San-Lorenzo-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (64)  
0.0164  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Cd-San-Lorenzo-Senior' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0369  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Cd-San-Lorenzo-Senior' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 68761
0.0132  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 71278
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10612 AND type_rel = 2
0.0129  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '10612' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '10612' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '10612' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '10612' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 71278 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=10612 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0125  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (71278) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71278 AND teamId = 10612
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2023` 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 = 68761 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10612' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10612' and rp.type = 4
0.0129  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10612' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0133  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68761 WHERE rp.league_id = 68761 AND rp.teamId = 10612 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68761 WHERE rp.league_id = 68761 AND rp.teamId = 10612 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68761 WHERE rp.league_id = 68761 AND rp.teamId = 10612 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 10612 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 `tables2023` 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 = 68761 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2023` 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 = 71278 AND t.round = 12 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 `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 = 64034 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 66990 AND t.round = 8 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 `tables2021` 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 = 59802 AND t.round = 15 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 `tables2020` 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 = 51283 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2019` 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 = 45240 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 41319 AND t.round = 22 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 `tables2017` 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 = 36067 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 `tables2016` 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 = 16726 AND t.round = 30 ORDER BY team.conference 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 `tables2015` 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 = 4848 AND t.round = 26 ORDER BY team.conference 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 `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 = 2694 AND t.round = 30 ORDER BY team.conference 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 `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 = 2080 AND t.round = 26 ORDER BY team.conference 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 `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 = 767 AND t.round = 30 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 `tables2007` 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 = 101 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1961` 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 = 21532 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1960` 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 = 21519 AND t.round = 30 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 `tables1955` 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 = 21432 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 68761 ORDER BY nameShow LIMIT 100