4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CF Motril

CF Motril

Entrenador: Edu Oriol

TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 J. Torremolinos Torremolinos 30 62 21 69
2 Real Jaén Real Jaén 31 61 25 66
3 Almería B Almería B 31 58 25 60
4 UD Torre Del Mar Torre 31 43 27 59
5 At. Malagueño Malagueño 30 48 19 57
6 CF Motril CF Motril 30 34 18 49
7 Arenas de Armilla Arenas 31 29 35 44
8 Huétor Vega Huétor Vega 31 37 37 42
9 Poli Almería Poli 31 30 32 40
10 UDC Torredonjimeno Torredonjime 30 31 41 36
11 CD Torreperogil Torreperogil 30 29 37 35
12 Mancha Real Mancha Real 30 36 36 35
13 Pvo. El Ejido Pvo. Ejido 31 26 37 33
14 CD Huétor Tájar Huétor 31 20 35 31
15 FC Málaga City Málaga City 31 23 40 30
16 Maracena Maracena 31 27 47 29
17 CD Rincón CD Rincón 31 26 50 22
18 Atletico Melilla Atletico 31 15 73 4
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Marbella FC Marbella FC 30 67 17 72
2 Real Jaén Real Jaén 30 59 12 68
3 El Palo FC El Palo FC 30 43 20 63
4 UD Torre Del Mar Torre 30 53 31 55
5 At. Malagueño Malagueño 30 45 27 45
6 Huétor Vega Huétor Vega 30 42 35 45
7 CF Motril CF Motril 30 37 41 41
8 UDC Torredonjimeno Torredonjime 30 45 42 41
9 Almería B Almería B 30 40 34 41
10 Arenas de Armilla Arenas 30 36 36 39
11 CD Torreperogil Torreperogil 30 40 45 38
12 CD Huétor Tájar Huétor 30 52 44 37
13 Maracena Maracena 30 34 48 33
14 FC Málaga City Málaga City 30 22 48 25
15 Atletico Porcuna Atletico 30 30 54 21
16 CD Huracán Melilla Huracán 30 8 119 5
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 J. Torremolinos Torremolinos 32 45 21 63
2 CD Huétor Tájar Huétor 32 56 30 58
3 Marbella FC Marbella FC 32 53 26 58
4 Almería B Almería B 32 59 31 57
5 At. Malagueño Malagueño 32 51 38 57
6 CF Motril CF Motril 32 59 37 56
7 UDC Torredonjimeno Torredonjime 32 55 35 55
8 UD Torre Del Mar Torre 32 52 40 49
9 Atletico Porcuna Atletico 32 42 47 42
10 El Palo FC El Palo FC 32 40 40 41
11 Huétor Vega Huétor Vega 32 33 38 39
12 CD Torreperogil Torreperogil 32 28 36 38
13 Real Jaén Real Jaén 32 31 43 36
14 Alhaurín de la Torre Alhaurín 32 28 49 34
15 UD San Pedro Pedro 32 26 48 28
16 CD Alhaurino Alhaurino 32 40 53 27
17 Intergym Melilla Intergym 32 13 99 4
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Mancha Real Mancha Real 20 35 12 36
2 Almería B Almería B 20 32 25 33
3 UDC Torredonjimeno Torredonjime 20 35 25 33
4 CD Torreperogil Torreperogil 20 16 17 28
5 CD Huétor Tájar Huétor 20 28 25 28
6 Huétor Vega Huétor Vega 20 25 27 25
7 Real Jaén Real Jaén 20 24 27 25
8 Poli Almería Poli 20 15 25 23
9 Loja Loja 20 15 32 21
10 Atletico Porcuna Atletico 20 22 23 21
11 Maracena Maracena 20 19 28 20
12 Vélez CF Vélez CF 18 22 15 37
13 Antequera CF Antequera 18 29 11 30
14 El Palo FC El Palo FC 18 18 17 28
15 J. Torremolinos Torremolinos 18 23 18 28
16 At. Malagueño Malagueño 18 28 19 28
17 Alhaurín de la Torre Alhaurín 18 17 27 20
18 CD Estepona CD Estepona 18 18 25 20
19 CF Motril CF Motril 18 21 26 20
20 Melilla CD Melilla CD 18 17 29 17
21 CD Alhaurino Alhaurino 18 22 28 17
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Linares Deportivo Linares 29 60 16 75
2 Pvo. El Ejido Pvo. Ejido 29 48 28 57
3 CF Motril CF Motril 29 50 24 56
4 Real Jaén Real Jaén 29 54 25 56
5 Almería B Almería B 29 60 28 53
6 UDC Torredonjimeno Torredonjime 29 53 33 50
7 Antequera CF Antequera 29 42 32 49
8 El Palo FC El Palo FC 29 44 37 48
9 At. Malagueño Malagueño 29 41 37 39
10 Loja Loja 29 49 55 37
11 Mancha Real Mancha Real 29 25 29 35
12 CD Huétor Tájar Huétor 29 42 48 35
13 CD Torreperogil Torreperogil 29 30 35 34
14 Maracena Maracena 29 33 41 30
15 Poli Almería Poli 29 35 49 29
16 Vélez CF Vélez CF 29 37 56 28
17 Huétor Vega Huétor Vega 29 33 48 27
18 Melilla CD Melilla CD 29 21 64 23
19 Atletico Porcuna Atletico 29 21 48 20
20 Alhaurín de la Torre Alhaurín 29 29 74 13
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 42 99 32 101
2 Linares Deportivo Linares 42 80 31 90
3 Antequera CF Antequera 42 90 35 82
4 El Palo FC El Palo FC 42 65 34 81
5 Vélez CF Vélez CF 42 56 40 68
6 CF Motril CF Motril 42 79 59 68
7 Loja Loja 42 68 64 62
8 Mancha Real Mancha Real 42 59 52 60
9 UDC Torredonjimeno Torredonjime 42 74 59 58
10 CD Torreperogil Torreperogil 42 43 52 58
11 CD Huétor Tájar Huétor 42 65 55 57
12 Huétor Vega Huétor Vega 42 56 65 57
13 Poli Almería Poli 42 53 57 57
14 Alhaurín de la Torre Alhaurín 42 72 70 56
15 CD Alhaurino Alhaurino 42 72 66 56
16 J. Torremolinos Torremolinos 42 57 65 53
17 CD Rincón CD Rincón 42 45 63 52
18 Martos CD Martos CD 42 41 70 44
19 Atarfe Industrial Atarfe 42 49 79 42
20 UD San Pedro Pedro 42 48 75 41
21 Guadix CF Guadix CF 42 44 95 35
22 River Melilla River 42 28 125 4
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 At. Malagueño Malagueño 42 95 31 96
2 Almería B Almería B 42 97 35 86
3 Real Jaén Real Jaén 42 58 29 82
4 Antequera CF Antequera 42 78 37 82
5 CD Huétor Tájar Huétor 42 77 49 82
6 CF Motril CF Motril 42 85 56 81
7 Linares Deportivo Linares 42 68 47 74
8 Mancha Real Mancha Real 42 66 46 72
9 Loja Loja 42 87 63 69
10 El Palo FC El Palo FC 42 66 50 67
11 UDC Torredonjimeno Torredonjime 42 79 65 67
12 Vélez CF Vélez CF 42 60 65 56
13 CD Rincón CD Rincón 42 53 61 52
14 J. Torremolinos Torremolinos 42 64 76 50
15 Martos CD Martos CD 42 58 85 47
16 Atarfe Industrial Atarfe 42 46 69 43
17 UD San Pedro Pedro 42 43 80 43
18 Huétor Vega Huétor Vega 42 47 74 38
19 Guadix CF Guadix CF 42 40 77 37
20 Maracena Maracena 42 44 73 35
21 CD Villacarrillo Villacarrill 42 44 79 28
22 Melistar Melistar 42 24 132 12
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 At. Malagueño Malagueño 38 107 34 90
2 Antequera CF Antequera 38 70 38 75
3 Almería B Almería B 38 61 36 71
4 CD Huétor Tájar Huétor 38 73 48 71
5 CF Motril CF Motril 38 71 43 70
6 Loja Loja 38 63 41 66
7 CD Rincón CD Rincón 38 49 52 57
8 El Palo FC El Palo FC 38 64 57 56
9 Martos CD Martos CD 38 57 54 53
10 Guadix CF Guadix CF 38 47 51 51
11 UD San Pedro Pedro 38 44 49 48
12 UDC Torredonjimeno Torredonjime 38 41 51 48
13 Maracena Maracena 38 50 54 46
14 Atarfe Industrial Atarfe 38 42 61 45
15 Vélez CF Vélez CF 38 44 64 44
16 Huétor Vega Huétor Vega 38 45 55 44
17 River Melilla River 38 47 67 40
18 CD Alhaurino Alhaurino 38 37 67 31
19 D.H. San Andrés D.H. Andrés 38 48 88 28
20 Alhaurín de la Torre Alhaurín 38 39 89 19
TEMPORADA 2015/2016
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 CF Motril CF Motril 34 83 28 75
2 Cd Huetor Vega Huetor Vega 34 78 24 73
3 Cd Oriente Cd Oriente 34 67 43 61
4 Arenas de Armilla Arenas 33 69 38 60
5 UD Pavía UD Pavía 34 54 37 57
6 Cullar Vega Cullar Vega 34 60 55 57
7 Cd Adra Milenaria Adra 33 54 47 55
8 CD Universidad de Almería Universidad 33 71 43 52
9 La Cañada Atlético Cañada 33 68 66 50
10 Purullena CF Purullena 34 54 56 46
11 Alfacar UD Alfacar UD 34 50 55 44
12 Vandalia Vandalia 34 41 58 40
13 Berja Berja 34 50 68 39
14 Churriana de la Vega Churriana 34 39 51 39
15 Ciudad de Roquetas Ciudad 33 47 65 34
16 Baza Baza 34 38 68 29
17 Los Molinos Los Molinos 34 44 83 27
18 Celtic Pulianas Celtic 33 32 114 8
TEMPORADA 2014/2015
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Purullena CF Purullena 34 82 27 85
2 CF Motril CF Motril 34 100 24 83
3 Alhendin Balompié Alhendin 34 100 39 75
4 Motril Atlético C.D. Motril 34 76 39 72
5 Atletismo Padul Atletismo 34 62 61 54
6 Gabia Gabia 34 63 68 52
7 Atlético Monachil Atlético 34 67 58 50
8 CD Santa Fe CD Santa Fe 34 58 61 48
9 Otura CF Otura CF 34 61 65 47
10 CD UD Íllora Íllora 34 65 73 46
11 Águilas De Zujaira Águilas 34 68 69 44
12 Huetor Tajar B Huetor Tajar 34 62 67 43
13 Albolote CF Albolote CF 34 46 54 43
14 Cd Abes Cd Abes 34 76 80 39
15 CD Iznalloz CD Iznalloz 34 47 79 34
16 Pinos Puente Pinos Puente 34 42 66 28
17 La Peza Fc La Peza Fc 34 53 116 28
18 CD Dúrcal CD Dúrcal 34 39 121 5

  USO DE MEMORIA  
6,373,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.7603
Total Execution Time  0.7618
  CADENA URL  
/historico/Motril
  GET DATOS  
$_GET['/historico/Motril']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0294  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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1745 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1745 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (135107,242228,251699,322188,386274) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '1745' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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.0147  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 = 72268 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=1745 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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,72268,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72268 AND teamId = 1745
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 72571 AND teamId = 1745
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1745
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 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.0147  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 = '1745' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1745' and rp.type = 4
0.0146  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 = '1745' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 = 1745 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.0155  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 = 1745 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 1745 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 1745 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 62393 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.0149  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 = 58588 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.0150  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 = 50277 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.0151  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 = 44397 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 39033 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 33359 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 16715 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 4109 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC