4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CFB Totana
TEMPORADA 2023/2024
1ª REGIONAL MURCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Lorca Deportiva B Lorca 27 69 19 65
2 CD Lumbreras Lumbreras 27 75 21 62
3 CD Zeneta CD Zeneta 27 52 23 57
4 Juvenia Juvenia 27 57 34 56
5 EF Alhama EF Alhama 26 47 23 51
6 Deportivo Murcia Deportivo 27 59 28 51
7 UD Alberca UD Alberca 27 49 46 44
8 CD Alberca CD Alberca 27 61 50 39
9 San Gines de La Jara Gines Jara 26 48 49 37
10 AD Palmeral AD Palmeral 27 44 44 31
11 Roldan AD Roldan AD 27 43 62 25
12 Alcantarilla FC B Alcantarilla 27 43 62 23
13 CFB Totana CFB Totana 27 32 66 20
14 EF Dolores de Pacheco Dolores 27 28 63 18
15 Deportivo Huracán Deportivo 26 22 55 16
16 Club Futbol Base H-O Club Futbol 26 20 104 8
TEMPORADA 2022/2023
1ª REGIONAL MURCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Atletico Pinatarense Atletico 22 50 17 50
2 CFB Totana CFB Totana 22 49 29 44
3 Fuente Alamo Fuente Alamo 22 46 28 41
4 UD Alberca UD Alberca 22 36 24 41
5 EF Alhama EF Alhama 22 40 29 38
6 CD Alberca CD Alberca 22 38 35 29
7 San Gines de La Jara Gines Jara 22 38 53 29
8 Roldan AD Roldan AD 22 44 51 28
9 EF Los Alcazares Alcazares 22 44 47 24
10 Club Futbol Base H-O Club Futbol 22 43 48 24
11 Juvenia Juvenia 22 25 46 13
12 Roldan Roldan 22 25 71 9
TEMPORADA 2019/2020
1ª REGIONAL MURCIA
Equipo PJ GF GC Puntos
1 Algezares UD Algezares 25 45 18 54
2 Cehegin Cehegin 25 46 25 52
3 Yeclano Deportivo B Yeclano 25 44 20 47
4 El Raal El Raal 24 35 24 44
5 Santomera Santomera 24 41 32 40
6 Alcantarilla FC Alcantarilla 24 35 27 37
7 Juvenia Juvenia 24 33 26 36
8 Independiente Ceutí Independient 25 32 25 36
9 Aguilas FC B Aguilas 25 38 38 35
10 Fuente Alamo Fuente Alamo 25 34 43 33
11 Atletico Pinatarense Atletico 25 37 34 30
12 Montecasillas Montecasilla 25 32 40 29
13 EF La Aljorra Sabic Aljorra 25 35 42 28
14 CD Lumbreras Lumbreras 25 33 52 27
15 CFB Totana CFB Totana 24 27 35 24
16 Atletico Cabezo de Torres B Atletico 24 19 42 18
17 Escuela de Futbol de Molina Escuela 25 35 75 14
18 Club Deportivo Tercia Sport Club 3 4 7 1
TEMPORADA 2018/2019
1ª REGIONAL MURCIA
Equipo PJ GF GC Puntos
1 Unión Molinense Unión 34 88 30 74
2 Ciudad de Calasparra Ciudad 34 78 31 74
3 Yeclano Deportivo B Yeclano 34 68 43 67
4 CFB Totana CFB Totana 34 75 40 66
5 Caravaca Caravaca 34 66 44 65
6 Cehegin Cehegin 34 63 44 61
7 Alcantarilla FC Alcantarilla 34 54 36 61
8 Aguilas FC B Aguilas 34 64 45 59
9 Fuente Alamo Fuente Alamo 34 56 47 53
10 El Raal El Raal 34 67 44 50
11 Escuela de Futbol de Molina Escuela 34 50 70 40
12 Independiente Ceutí Independient 34 41 58 38
13 Atletico Pinatarense Atletico 34 38 59 33
14 Atletico Cabezo de Torres B Atletico 34 48 77 33
15 CD Lumbreras Lumbreras 34 37 63 27
16 At. Barqueros Barqueros 34 38 93 19
17 Ed Javali ñora Javali ñora 34 37 101 18
18 E Esperanza V de La Caridad Esperanza 34 27 70 0
TEMPORADA 2017/2018
2ª REGIONAL MURCIA
Equipo PJ GF GC Puntos
1 Yeclano Deportivo B Yeclano 36 82 34 76
2 Cehegin Cehegin 36 96 51 75
3 Ciudad de Calasparra Ciudad 36 76 50 74
4 E Esperanza A Esperanza 36 94 65 72
5 Atletico Pinatarense Atletico 36 73 46 70
6 CFB Totana CFB Totana 36 101 52 65
7 E.F. Molina E.F. Molina 36 100 66 65
8 Atlético Sangonera Atlético 36 78 59 55
9 Puente Tocinos Normatex Puente 36 73 72 53
10 Santiago de La Ribera Santiago 36 60 62 53
11 Ceutí Ceutí 36 57 47 52
12 At. Barqueros Barqueros 36 54 77 41
13 Corvera Corvera 36 54 88 39
14 Cf Santomera Santomera 36 66 86 37
15 Roldan Roldan 36 54 85 36
16 Carmelitano Alguazas Carmelitano 36 56 104 31
17 CD Minerva CD Minerva 36 42 80 26
18 CD Hoya del Campo Hoya Campo 36 53 83 25
19 Cabezo de Torres Cabezo 36 48 110 24

  USO DE MEMORIA  
5,358,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4164
Total Execution Time  0.4176
  CADENA URL  
/historico/Club-Ef-Totana-A
  GET DATOS  
$_GET['/historico/Club-Ef-Totana-A']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0277  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 = 73793
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103060 AND type_rel = 2
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1454 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1454 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (999350,275156) ORDER BY n.cover_points DESC, update_date 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 = '103060' 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 = 73793 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=103060 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73793) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73793 AND teamId = 103060
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 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 = 73793 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135  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 = '103060' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '103060' and rp.type = 4
0.0138  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 = '103060' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 = 73793 WHERE rp.league_id = 73793 AND rp.teamId = 103060 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 73793 WHERE rp.league_id = 73793 AND rp.teamId = 103060 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 events2024 e ON e.player_id = p.id AND e.league_id = 73793 WHERE rp.league_id = 73793 AND rp.teamId = 103060 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 = 103060 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73793 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.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 `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 = 69362 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.0143  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 = 51339 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 45114 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 39763 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC