4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Cambil
TEMPORADA 2022/2023
2ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Hispania CD Hispania 20 50 24 49
2 UD La Guardia Guardia 20 54 25 46
3 Los Villares CF Villares 20 36 34 31
4 CD Jimena CD Jimena 20 36 32 31
5 Real Jaén B Real Jaén 20 30 22 28
6 Martos Unión Martos 20 32 28 26
7 Huelma CP Huelma CP 20 28 32 23
8 Veteranos Alcaudete Veteranos 20 32 33 21
9 UD Cambil UD Cambil 20 32 56 16
10 Villargordo CF Villargordo 20 37 54 15
11 Castillo de Locubin Castillo 20 27 54 15
TEMPORADA 2021/2022
2ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 UDC Torredonjimeno B Torredonjime 24 87 19 60
2 UD La Guardia Guardia 24 58 25 55
3 CD Hispania CD Hispania 24 48 19 51
4 Atlético Jaén Atlético 24 42 21 44
5 Atlético Mengibar Atlético 24 53 33 43
6 Club At Arjonilla Club 23 37 34 39
7 AD Lopera AD Lopera 23 48 37 35
8 Villargordo CF Villargordo 24 38 39 35
9 UD Cambil UD Cambil 24 51 78 22
10 Castillo de Locubin Castillo 24 35 55 20
11 CD Utica CD Utica 23 33 60 16
12 Martos Unión Martos 23 17 75 8
13 Veteranos Alcaudete Veteranos 24 22 74 6
TEMPORADA 2020/2021
2ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Alcalá Enjoy Alcalá 10 26 8 27
2 UD Cambil UD Cambil 10 20 16 14
3 AD Lopera AD Lopera 10 16 19 13
4 Villargordo CF Villargordo 10 14 13 12
5 Veteranos Alcaudete Veteranos 10 17 27 11
6 Atlético Mengibar Atlético 10 10 20 7
TEMPORADA 2019/2020
2ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 Fuensanta CF Fuensanta 18 47 15 43
2 Valdepeñas de Jaén CF Valdepeñas 18 43 22 39
3 CD Alcalá Enjoy Alcalá 18 41 17 35
4 CD Utica CD Utica 18 42 23 33
5 AD Lopera AD Lopera 18 28 28 30
6 Club At Arjonilla Club 18 30 30 28
7 Villargordo CF Villargordo 18 22 26 25
8 CD Tuccitana Tuccitana 18 24 29 23
9 Adebal Adebal 18 30 25 21
10 UD Cambil UD Cambil 18 32 43 19
11 Rus Club Dvo. Club Dvo. 18 26 57 7
12 Atlético Mengibar Atlético 18 15 65 2
TEMPORADA 2016/2017
2ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 Iliturgi 2016 Iliturgi 20 42 21 44
2 Recreativo Bailén Recreativo 20 32 22 37
3 Martos CD Martos CD 20 39 22 36
4 CD Utica CD Utica 20 33 31 30
5 UD Cambil UD Cambil 20 28 23 29
6 Valdepeñas de Jaén CF Valdepeñas 19 34 36 29
7 Club At Arjonilla Club 20 29 28 23
8 CD Alcalá Enjoy Alcalá 20 25 43 20
9 Mancha Real AD Mancha Real 20 23 30 19
10 Escañolense Escañolense 20 29 42 19
11 AD Lopera AD Lopera 19 24 40 17
TEMPORADA 2015/2016
3ª ANDALUZA JAÉN GRUPO 2
Equipo PJ GF GC Puntos
1 Villargordo CF Villargordo 22 62 10 53
2 C.D. Torredelcampo C.D. 21 67 21 49
3 Fuensanta CF Fuensanta 22 64 18 43
4 Mancha Real AD Mancha Real 22 43 25 42
5 Recreativo Bailén Recreativo 21 35 20 32
6 UD Cambil UD Cambil 22 46 37 29
7 Valdepeñas de Jaén CF Valdepeñas 22 38 46 28
8 CD Utica CD Utica 22 38 45 28
9 Escañolense Escañolense 22 41 48 22
10 Castillo Locubín Castillo 22 32 58 16
11 Jódar CF Jódar CF 21 30 42 13
12 Mureño CF Mureño CF 21 16 142 6
TEMPORADA 2014/2015
3ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Hispania CD Hispania 24 69 20 58
2 AD Lopera AD Lopera 24 67 31 52
3 Escañolense Escañolense 24 52 22 50
4 Huelma CP Huelma CP 23 63 31 48
5 CD Alcalá Enjoy Alcalá 24 62 34 44
6 Martos CD Martos CD 24 48 37 38
7 Villargordo CF Villargordo 24 56 45 36
8 Atlético Jaén Atlético 24 54 43 35
9 Valdepeñas de Jaén CF Valdepeñas 24 34 49 32
10 Iliturgi CF Iliturgi CF 23 31 58 17
11 UD Cambil UD Cambil 24 25 71 13
12 Mancha Real AD Mancha Real 24 27 54 12
13 Mureño CF Mureño CF 24 21 114 7
14 Veteranos Alcaudete Veteranos 0 0 0 0
TEMPORADA 2011/2012
3ª ANDALUZA JAÉN GRUPO 1
Equipo PJ GF GC Puntos
1 Escañolense Sd Escañolen 22 55 19 50
2 CD Alcalá Enjoy Alcalá 22 59 28 45
3 Club At Arjonilla Club 22 56 21 44
4 At Jaen Fc At Jaen Fc 22 52 45 41
5 Atlético Mengibar Atlético 21 52 25 39
6 Ibros CF Ibros CF 22 61 28 38
7 CD Tuccitana Tuccitana 22 53 33 38
8 CD Hispania CD Hispania 22 41 39 34
9 CD Linares CF 2011 Linares 2011 21 37 24 32
10 Veteranos Alcaudete Veteranos 22 40 51 31
11 Fuensanta CF Fuensanta 22 44 38 29
12 Cd At Higuerense Cf Higuerense 22 33 47 20
13 AD Lopera AD Lopera 22 33 53 14
14 UD Cambil UD Cambil 22 25 71 11
15 Castillo de Locubin Castillo 22 26 96 11
16 Arjona Ad Arjona Ad 22 14 63 10

  USO DE MEMORIA  
5,284,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0793
Total Execution Time  0.0804
  CADENA URL  
/historico/Ud-Cambil-Senior
  GET DATOS  
$_GET['/historico/Ud-Cambil-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0042  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 = 69263
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8623 AND type_rel = 2
0.0026  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 = '8623' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = '8623' 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 = 69263 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=8623 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (69263) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 69263 AND teamId = 8623
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 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 = 69263 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '8623' 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 = '8623' 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 = '8623' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 = 69263 WHERE rp.league_id = 69263 AND rp.teamId = 8623 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.0019  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 = 69263 WHERE rp.league_id = 69263 AND rp.teamId = 8623 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 69263 WHERE rp.league_id = 69263 AND rp.teamId = 8623 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 8623 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 69263 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.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 `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 = 64175 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 59449 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.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 `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 = 51357 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 34425 AND t.round = 22 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 = 16849 AND t.round = 22 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 = 4114 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 1834 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC