4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Palomares
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis C Real Betis 28 111 16 74
2 La Barrera La Barrera 28 42 32 52
3 Palomares Palomares 28 34 24 52
4 Atlético Algabeño Atlético 28 60 41 50
5 El Palmar Vereda Real Palmar 28 35 38 47
6 Juventud Dva. Gines Juventud 28 51 43 44
7 La Liara Balompie Liara 28 37 36 41
8 Camas Camas 28 47 46 39
9 UD Villaverde Villaverde 28 42 41 38
10 Alcolea del Río F.C. Alcolea Río 28 48 62 37
11 Lora CF Lora CF 28 40 38 37
12 San Juan San Juan 27 35 47 34
13 La Motilla La Motilla 28 36 44 34
14 Camino Viejo Camino Viejo 28 37 55 21
15 Marchena Balompié Marchena 28 28 73 19
16 Pilas Pilas 27 23 70 5
TEMPORADA 2022/2023
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Palomares Palomares 30 68 20 66
2 Espartinas CF Espartinas 30 63 31 64
3 CD Valencina Valencina 30 59 30 60
4 Gelves C.D Gelves C.D 30 78 42 56
5 Aznalcazar, C.D. Aznalcazar, 30 76 44 53
6 CD Cantarrana Cantarrana 30 53 46 46
7 Salteras Salteras 30 46 45 42
8 Villanueva Atlético Villanueva 30 50 47 40
9 Atlético Sanlucar Atlético 30 52 52 39
10 Mairena del Aljarafe Mairena 30 44 50 38
11 CD Albaida CD Albaida 30 38 46 34
12 Almensilla CD Almensilla 30 43 50 33
13 Huévar C.F. Huévar C.F. 30 33 52 32
14 Castilleja B Castilleja 30 38 71 28
15 Umbrete Umbrete 30 35 82 21
16 At. Olivarense B Olivarense 30 29 97 14
TEMPORADA 2021/2022
3ª ANDALUZA SEVILLA GRUPO 5
Equipo PJ GF GC Puntos
1 Benacazón CF Benacazón 30 67 26 77
2 Juventud Dva. Gines Juventud 30 77 32 63
3 CD Valencina Valencina 30 69 31 62
4 Palomares Palomares 30 65 27 62
5 Villanueva Atlético Villanueva 30 57 36 58
6 Atlético Libertad Atlético 30 50 43 52
7 Salteras Salteras 30 50 35 46
8 CD Albaida CD Albaida 30 47 48 42
9 Huévar C.F. Huévar C.F. 30 48 52 38
10 Gelves C.D Gelves C.D 30 50 56 36
11 CD Cantarrana Cantarrana 30 44 48 33
12 Santiponce Santiponce 30 52 62 33
13 At. Olivarense B Olivarense 30 42 74 28
14 Mairena del Aljarafe Mairena 30 33 67 21
15 Almensilla CD Almensilla 30 23 77 14
16 Mures CF Mures CF 30 25 85 12
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA GRUPO 3
Equipo PJ GF GC Puntos
1 El Tinte de Utrera Tinte Utrera 29 88 46 62
2 Montellano CD Montellano 29 64 22 59
3 Huévar C.F. Huévar C.F. 29 79 44 54
4 Mairena del Aljarafe Mairena 29 74 58 50
5 Montequinto CD Montequinto 28 61 39 49
6 Atlético Maribáñez Atlético 28 46 31 48
7 Santiponce Santiponce 28 48 45 45
8 La Motilla La Motilla 27 51 47 40
9 Pilas Atlético Pilas 27 45 47 36
10 Colegio Claret Colegio 28 39 39 35
11 Gelves C.D Gelves C.D 29 52 64 35
12 UB Lebrijana B Lebrijana 29 49 63 35
13 Palomares Palomares 27 44 72 26
14 C.D. Rabesa C.D. Rabesa 28 42 82 19
15 UD Dos Hermanas Hermanas 29 35 93 16
16 El Palmar Vereda Real Palmar 10 7 32 1
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA GRUPO 1
Equipo PJ GF GC Puntos
1 Camas Camas 30 99 12 81
2 Utrera B Utrera B 31 73 28 72
3 UD Loreto UD Loreto 30 78 34 67
4 El Palmar Vereda Real Palmar 30 69 44 57
5 CD Cantarrana Cantarrana 30 63 50 52
6 Atlético Maribáñez Atlético 31 57 59 45
7 Mairena del Aljarafe Mairena 29 76 61 43
8 El Tinte de Utrera Tinte Utrera 29 67 68 40
9 Mosquito CD Mosquito CD 30 55 52 38
10 UD Dos Hermanas Hermanas 31 52 67 38
11 UB Lebrijana B Lebrijana 31 38 71 36
12 Almensilla CD Almensilla 30 47 59 35
13 Su Eminencia Eminencia 31 43 68 26
14 Palomares Palomares 29 38 68 22
15 Racing Los Molares Racing 25 31 77 19
16 Gelves C.D Gelves C.D 31 46 103 19
17 Cuervo Cuervo 8 8 19 7
TEMPORADA 2015/2016
4ª ANDALUZA SEVILLA GRUPO 3
Equipo PJ GF GC Puntos
1 Pilas Atlético Pilas 28 47 22 56
2 Montequinto CD Montequinto 28 52 27 55
3 Villanueva Atlético Villanueva 28 54 33 54
4 C.D. Atlético Porvenir C.D. 28 84 54 52
5 PD Rociera PD Rociera 27 54 33 49
6 CD Cantarrana Cantarrana 27 39 35 43
7 Almensilla CD Almensilla 27 53 39 42
8 UD Loreto UD Loreto 28 47 34 41
9 U.D. Bellavista U.D. 28 38 42 39
10 C.D. Rabesa C.D. Rabesa 28 44 49 37
11 J.D Bormujos Bormujos 28 40 49 29
12 Nueva Sevilla Nueva 28 40 68 26
13 Palomares Palomares 28 31 60 26
14 Atlético Maribáñez Atlético 27 22 56 18
15 Carrión Balompié Carrión 28 19 63 14

  USO DE MEMORIA  
5,383,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4908
Total Execution Time  0.4920
  CADENA URL  
/historico/Palomares-Cf-Senior
  GET DATOS  
$_GET['/historico/Palomares-Cf-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0133  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 = 'Palomares-Cf-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.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=66476 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=66476 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 73639
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66476 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=277 AND type_rel = 3
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 277 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (986815,818727,685220,55701) ORDER BY n.cover_points DESC, update_date DESC
0.0127  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 = '66476' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '66476' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '66476' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73639 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=66476 AND l.year in (2023,2024,2025) 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 (73639,69278) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73639 AND teamId = 66476
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 69278 AND teamId = 66476
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 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 = 73639 AND t.round = 28 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 = '66476' 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 = '66476' and rp.type = 4
0.0127  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 = '66476' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73639 WHERE rp.league_id = 73639 AND rp.teamId = 66476 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.0126  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 = 73639 WHERE rp.league_id = 73639 AND rp.teamId = 66476 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73639 WHERE rp.league_id = 73639 AND rp.teamId = 66476 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 66476 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 73639 AND t.round = 28 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 `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 = 69278 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.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 `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 = 64477 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.0128  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 = 39835 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 `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 = 35347 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 16946 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC