4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ciudad de Lucena

Ciudad de Lucena

Entrenador: Falete

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 33 53 21 66
2 Ciudad de Lucena Ciudad 33 36 21 63
3 CD Pozoblanco Pozoblanco 33 48 34 62
4 Xerez Deportivo Xerez 33 48 22 61
5 AD Ceuta FC B Ceuta 33 47 26 56
6 Salerm Puente Genil Salerm 33 48 41 53
7 Utrera Utrera 33 48 44 46
8 CD Gerena CD Gerena 33 37 40 46
9 AD Cartaya AD Cartaya 33 35 31 45
10 La Palma CF La Palma CF 33 45 50 38
11 Córdoba CF B Córdoba 33 37 42 37
12 Bollullos CF Bollullos 33 27 40 37
13 Coria CF Coria CF 33 42 53 36
14 Atlético Espeleño Atlético 33 41 53 36
15 Conil Conil 33 28 40 34
16 Sevilla C Sevilla C 33 27 35 32
17 Ayamonte Ayamonte 33 29 47 29
18 Cabecense Cabecense 33 25 61 28
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Atlético Antoniano Atlético 30 47 24 60
2 Córdoba CF B Córdoba 30 44 19 58
3 CD Gerena CD Gerena 30 48 25 54
4 Sevilla C Sevilla C 30 35 26 49
5 Salerm Puente Genil Salerm 30 42 35 47
6 Ciudad de Lucena Ciudad 30 32 23 47
7 Xerez CD Xerez CD 30 36 29 41
8 Atlético Espeleño Atlético 30 40 40 40
9 Conil Conil 30 32 31 40
10 CD Pozoblanco Pozoblanco 30 29 37 40
11 AD Ceuta FC B Ceuta 30 25 29 39
12 Bollullos CF Bollullos 30 31 43 36
13 Ayamonte Ayamonte 30 31 43 33
14 AD Cartaya AD Cartaya 30 30 46 29
15 Coria CF Coria CF 30 26 40 24
16 CD Rota CD Rota 30 15 53 19
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 32 57 20 77
2 Utrera Utrera 32 59 26 67
3 Xerez CD Xerez CD 32 50 24 62
4 Ciudad de Lucena Ciudad 32 45 25 60
5 CD Gerena CD Gerena 32 53 31 58
6 Córdoba CF B Córdoba 32 54 33 58
7 Salerm Puente Genil Salerm 32 36 41 45
8 Sevilla C Sevilla C 32 40 48 43
9 AD Ceuta FC B Ceuta 32 26 39 37
10 Conil Conil 32 30 49 36
11 CD Rota CD Rota 32 31 45 36
12 CD Pozoblanco Pozoblanco 32 37 49 34
13 Atlético Antoniano Atlético 32 29 35 34
14 AD Cartaya AD Cartaya 32 26 30 33
15 UD Tomares UD Tomares 32 27 46 31
16 Cabecense Cabecense 32 25 51 23
17 Los Barrios Los Barrios 32 26 59 23
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 18 26 11 37
2 Xerez CD Xerez CD 18 23 11 35
3 AD Ceuta FC AD Ceuta FC 18 26 17 29
4 Los Barrios Los Barrios 18 18 17 24
5 CD Rota CD Rota 18 15 21 22
6 Atlético Antoniano Atlético 18 15 20 21
7 Conil Conil 18 19 18 20
8 Cabecense Cabecense 18 15 23 19
9 Arcos CF Arcos CF 18 10 19 17
10 Lebrijana Lebrijana 18 15 25 16
11 San Roque de Lepe Roque Lepe 20 30 18 45
12 Ciudad de Lucena Ciudad 20 35 16 40
13 Salerm Puente Genil Salerm 20 28 24 33
14 Córdoba CF B Córdoba 20 31 25 30
15 Utrera Utrera 20 26 26 30
16 CD Pozoblanco Pozoblanco 20 22 23 27
17 Sevilla C Sevilla C 20 17 20 26
18 CD Gerena CD Gerena 20 17 25 22
19 Castilleja Castilleja 20 25 27 21
20 Coria CF Coria CF 20 14 28 15
21 La Palma CF La Palma CF 20 14 27 13
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 29 68 28 59
2 Ciudad de Lucena Ciudad 29 46 24 55
3 Xerez Deportivo Xerez 29 44 24 55
4 Utrera Utrera 29 41 22 52
5 AD Ceuta FC AD Ceuta FC 29 50 22 51
6 Sevilla C Sevilla C 29 34 19 51
7 Atlético Antoniano Atlético 29 42 28 51
8 Salerm Puente Genil Salerm 29 48 35 50
9 CD Rota CD Rota 29 47 49 43
10 Coria CF Coria CF 29 39 36 42
11 San Roque de Lepe Roque Lepe 29 39 31 40
12 Conil Conil 29 34 37 40
13 Lebrijana Lebrijana 29 33 42 34
14 CD Gerena CD Gerena 29 31 37 33
15 Arcos CF Arcos CF 29 30 40 31
16 Los Barrios Los Barrios 29 25 35 30
17 Xerez CD Xerez CD 29 31 43 29
18 CD Pozoblanco Pozoblanco 29 32 51 26
19 Córdoba CF B Córdoba 29 30 54 23
20 Écija Balompié Écija 29 0 87 0
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 42 48 18 83
2 AD Ceuta FC AD Ceuta FC 42 68 42 80
3 Utrera Utrera 42 59 29 79
4 Algeciras CF Algeciras 42 64 35 77
5 Xerez Deportivo Xerez 42 49 24 77
6 Betis Deportivo Betis 42 93 40 76
7 Los Barrios Los Barrios 42 64 43 76
8 Córdoba CF B Córdoba 42 67 39 71
9 Ciudad de Lucena Ciudad 42 56 53 58
10 Xerez CD Xerez CD 42 45 42 57
11 Salerm Puente Genil Salerm 42 52 49 55
12 Lebrijana Lebrijana 42 47 65 52
13 Coria CF Coria CF 42 53 52 51
14 CD Gerena CD Gerena 42 43 68 50
15 Sevilla C Sevilla C 42 39 49 50
16 San Roque de Lepe Roque Lepe 42 52 61 49
17 Conil Conil 42 47 55 49
18 Arcos CF Arcos CF 42 45 53 49
19 Écija Balompié Écija 42 37 48 48
20 Cabecense Cabecense 42 39 80 30
21 Atlético Espeleño Atlético 42 45 91 29
22 CD Guadalcacín Guadalcacín 42 21 97 14
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 38 49 19 75
2 AD Ceuta FC AD Ceuta FC 38 54 24 74
3 Algeciras CF Algeciras 38 55 31 66
4 At. Sanluqueño Sanluqueño 38 51 27 64
5 Lebrijana Lebrijana 38 50 37 59
6 Sevilla C Sevilla C 38 62 48 59
7 CD Gerena CD Gerena 38 50 39 57
8 Salerm Puente Genil Salerm 38 47 44 53
9 Cabecense Cabecense 38 41 45 48
10 Ciudad de Lucena Ciudad 38 60 65 47
11 San Roque de Lepe Roque Lepe 38 50 60 45
12 Atlético Espeleño Atlético 38 53 65 45
13 Utrera Utrera 38 38 43 45
14 CD Guadalcacín Guadalcacín 38 38 46 45
15 Arcos CF Arcos CF 38 43 57 44
16 Xerez CD Xerez CD 38 50 66 43
17 Los Barrios Los Barrios 38 38 44 43
18 Atlético Onubense Atlético 38 42 54 41
19 CD Alcalá CD Alcalá 38 33 61 41
20 Castilleja Castilleja 38 41 70 34
TEMPORADA 2016/2017
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 38 83 28 82
2 Salerm Puente Genil Salerm 38 72 36 73
3 Xerez CD Xerez CD 38 74 37 72
4 Ciudad de Lucena Ciudad 38 60 39 71
5 Estrella San Agustín Estrella 38 59 46 68
6 Xerez Deportivo Xerez 38 65 43 63
7 Conil Conil 38 65 47 60
8 CD Pozoblanco Pozoblanco 38 39 36 58
9 La Palma CF La Palma CF 38 73 58 57
10 Viso UP Viso UP 38 47 38 54
11 AD Cartaya AD Cartaya 38 49 48 54
12 AD San José José 38 57 45 53
13 Ol. Valverdeña Valverdeña 38 55 74 45
14 CD Rota CD Rota 38 58 85 44
15 Chiclana CF Chiclana CF 38 46 62 42
16 Roteña Roteña 38 48 66 41
17 Lora CF Lora CF 38 48 71 39
18 San Juan San Juan 38 58 78 38
19 Pinzón CD Pinzón CD 38 45 71 28
20 Almodóvar del Río Almodóvar 38 25 118 13
TEMPORADA 2015/2016
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Espeleño Atlético 34 65 21 78
2 Atlético Antoniano Atlético 34 82 34 76
3 Estrella San Agustín Estrella 34 57 31 65
4 Lora CF Lora CF 34 55 38 62
5 CD Pozoblanco Pozoblanco 34 54 37 60
6 Salerm Puente Genil Salerm 34 61 34 59
7 Ciudad de Lucena Ciudad 34 47 26 59
8 AD San José José 34 61 50 55
9 Nervión Nervión 34 56 64 55
10 Moron Moron 34 57 48 49
11 PD Rociera PD Rociera 33 44 41 47
12 CD Pedrera CD Pedrera 34 49 55 40
13 Atco. Villanueva Atco. 34 39 49 38
14 La Barrera La Barrera 34 42 61 37
15 Mairena Mairena 33 33 58 28
16 Pilas Pilas 34 29 65 22
17 CD Montalbeño Montalbeño 34 26 88 14
18 Peñarroya Pueblonuevo Peñarroya 34 19 76 7
TEMPORADA 2014/2015
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Utrera Utrera 34 61 24 70
2 Castilleja Castilleja 34 65 34 69
3 Atlético Espeleño Atlético 34 66 36 68
4 Atlético Antoniano Atlético 34 65 31 67
5 CD Pozoblanco Pozoblanco 34 59 33 66
6 AD San José José 34 64 42 60
7 Lora CF Lora CF 34 61 48 57
8 Moron Moron 34 61 47 49
9 CD Pedrera CD Pedrera 34 46 59 43
10 Atco. Villanueva Atco. 34 37 56 43
11 La Barrera La Barrera 34 48 52 41
12 Estrella San Agustín Estrella 34 45 47 39
13 Peñarroya Pueblonuevo Peñarroya 34 47 54 37
14 Ciudad de Lucena Ciudad 34 43 52 37
15 Ciudad Jardin CD Ciudad 34 41 61 35
16 CD Coronil CD Coronil 34 32 69 25
17 Almodóvar del Río Almodóvar 34 27 73 22
18 La Voz La Voz 34 38 88 22
TEMPORADA 2013/2014
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 PD Rociera PD Rociera 34 51 28 69
2 Atlético Espeleño Atlético 34 64 24 67
3 Castilleja Castilleja 34 57 37 51
4 AD San José José 34 59 56 50
5 Utrera Utrera 34 55 34 50
6 Estrella San Agustín Estrella 34 56 48 49
7 La Barrera La Barrera 34 51 53 49
8 Atco. Villanueva Atco. 34 46 48 48
9 Atlético Antoniano Atlético 34 46 43 47
10 Lora CF Lora CF 34 39 43 45
11 Ciudad Jardin CD Ciudad 34 37 49 43
12 CD Coronil CD Coronil 34 36 47 42
13 Ciudad de Lucena Ciudad 34 42 51 41
14 La Voz La Voz 34 42 64 41
15 Osuna BC Osuna BC 34 41 53 40
16 Rud La Carlota Carlota 34 22 37 36
17 Montilla Montilla 34 53 57 36
18 Palma del Rio Atletico CF Palma 34 33 58 34
TEMPORADA 2012/2013
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Ciudad de Lucena Ciudad 30 95 33 74
2 La Voz La Voz 30 101 28 71
3 Almodóvar del Río Almodóvar 30 63 29 65
4 Las Palmeras Ud Palmeras 30 70 51 56
5 Salerm Puente Genil Salerm 30 55 37 56
6 Sur Sur 30 57 55 43
7 Alcolea Los Ángeles Alcolea 30 48 43 40
8 CD Montalbeño Montalbeño 30 38 52 37
9 Belmezano Belmezano 30 44 55 35
10 Peñarroya Pueblonuevo Peñarroya 30 41 47 34
11 UD Villanueva Rosario Villanueva 30 37 61 34
12 Cañete Base Cañete Base 30 48 73 34
13 Prieguense A.F. Prieguense 30 50 74 32
14 Almedinilla Atl Almedinilla 30 35 68 24
15 CD Castro Del Rio-Cajasol Castro 30 39 68 22
16 Aguilarense Aguilarense 30 35 82 19
TEMPORADA 2011/2012
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
TEMPORADA 2010/2011
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Ciudad Jardín Ciudad 29 57 26 57
2 Rud La Carlota Carlota 29 49 36 52
3 Cd Villaralto Villaralto 29 56 42 50
4 Atco. Villanueva Atco. 30 54 25 49
5 Hinojosa Hinojosa 29 58 51 45
6 Palma del Rio Atletico CF Palma 29 48 39 42
7 Ciudad de Lucena Ciudad 29 56 52 41
8 Salerm Puente Genil Salerm 29 48 46 40
9 UD Villanueva Rosario Villanueva 29 52 51 40
10 Las Palmeras Ud Palmeras 29 60 66 39
11 Salerm Cosmetics San Fermín Salerm 29 50 55 37
12 Almodóvar del Río Almodóvar 29 57 61 36
13 Nueva Carteya Nueva 29 38 43 35
14 C.D. Alcázar B C.D. 29 30 54 28
15 La Ribera Guadalq. Ribera 29 55 69 27
16 Baena At. Baena At. 16 9 61 2
TEMPORADA 2009/2010
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Atlético Espeleño Atlético 32 68 30 70
2 C.D. El Higuerón - Especolc C.D. 32 73 37 67
3 Rud La Carlota Carlota 32 73 40 63
4 Salerm Pte.Genil Salerm 32 51 24 61
5 C.D. Alcázar B C.D. 32 53 35 60
6 Las Palmeras Ud Palmeras 32 69 48 55
7 Ciudad de Lucena Ciudad 32 67 47 46
8 Palma del Rio Atletico CF Palma 32 46 46 44
9 La Ribera Guadalq. Ribera 32 63 61 43
10 Hinojosa Hinojosa 32 50 54 43
11 Almodóvar del Río Almodóvar 32 54 60 43
12 CD Apedem B CD Apedem B 32 48 48 41
13 Don Bosco CF C Bosco 32 52 63 38
14 Belmezano Belmezano 32 40 53 37
15 Parque Cruz Conde Parque Cruz 32 45 70 27
16 Villa De Espejo CD Villa Espejo 32 32 90 20
17 La Rambla Fem Rambla 32 27 105 6

  USO DE MEMORIA  
6,908,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1439
Total Execution Time  0.1452
  CADENA URL  
/historico/Ciudad-Lucena
  GET DATOS  
$_GET['/historico/Ciudad-Lucena']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0028  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 = 'Ciudad-Lucena' 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.0018  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=18047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=18047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 72571
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18047 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18047 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 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 (1188459,261079,436335,539651,822157) ORDER BY n.cover_points DESC, update_date DESC
0.0037  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 = '18047' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '18047' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0037  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 = '18047' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72571 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 72269 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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=18047 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72571,72269,71489,71432) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72269 AND teamId = 18047
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 18047
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72571 AND teamId = 18047
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18047
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72571 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '18047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18047' and rp.type = 4
0.0020  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 = '18047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0027  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 events2024 e ON e.player_id = p.id AND e.league_id = 72571 WHERE rp.league_id = 72571 AND rp.teamId = 18047 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.0023  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 events2024 e ON e.player_id = p.id AND e.league_id = 72571 WHERE rp.league_id = 72571 AND rp.teamId = 18047 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 events2024 e ON e.player_id = p.id AND e.league_id = 72571 WHERE rp.league_id = 72571 AND rp.teamId = 18047 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 18047 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 72269 AND t.round = 33 ORDER BY team.conference ASC,t.position 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 `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 = 67984 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 62394 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 58589 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.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 `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 = 50278 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 44398 AND t.round = 42 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 `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 = 39034 AND t.round = 38 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 `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 = 34070 AND t.round = 38 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 `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 = 16713 AND t.round = 34 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 `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 = 4057 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 2570 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 2583 AND t.round = 30 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 `tables2012` 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 = 1837 AND t.round = 34 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 `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 = 2933 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 2932 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC