4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Deportivo Marratxi
TEMPORADA 2023/2024
2ª REGIONAL BALEARES GRUPO 3
Equipo PJ GF GC Puntos
1 Alaró B Alaró B 26 85 35 63
2 Collerense B Collerense 26 103 30 61
3 Pla de Na Tesa B Tesa 26 107 47 56
4 Son Sardina B Sardina 26 82 44 49
5 Son Maciá Son Maciá 26 80 39 46
6 San Roque B San Roque B 26 87 58 46
7 A-Llubi A-Llubi 26 52 45 40
8 Deportivo Marratxi Deportivo 26 56 49 39
9 Lloret del S Lloret 26 40 48 35
10 Ferriolense B Ferriolense 26 64 50 32
11 La Union B La Union B 26 26 86 17
12 Palmanyola B Palmanyola 26 50 106 16
13 At. de Paguera B Paguera 26 27 110 16
14 Unión Latina Unión 26 29 141 0
TEMPORADA 2022/2023
1ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Platges de Calvià B Platges 30 78 26 73
2 Sta Ponsa Talarrubias Ponsa 30 86 35 68
3 Constancia B Constancia 30 91 41 63
4 UE Alcudia B Alcudia 30 64 31 58
5 Santa Ponsa Santa Ponsa 30 67 42 56
6 Soller B Soller B 30 56 46 45
7 CF Pollença Pollença 30 67 57 44
8 Atlético Marratxí Atlético 30 62 60 40
9 Viva Sports Viva Sports 30 54 79 35
10 Ce Campanet Ce Campanet 30 41 59 31
11 Porto Cristo Porto Cristo 30 43 69 31
12 Sporting Sant Marçal Sporting 30 45 73 31
13 Montaura Montaura 30 47 63 30
14 Deportivo Marratxi Deportivo 30 48 82 28
15 Rotlet Molinar B Rotlet 30 53 93 25
16 Sant Jordi B Sant Jordi 30 49 95 24
TEMPORADA 2021/2022
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Sta Ponsa Talarrubias Ponsa 38 78 36 83
2 Andratx B Andratx B 37 95 30 82
3 Consell Consell 38 89 43 81
4 Santa Ponsa Santa Ponsa 37 78 44 71
5 Baleares Sin Fronteras Baleares 38 66 39 71
6 Pilares La Soledad Pilares 38 67 56 62
7 Sporting Sant Marçal Sporting 37 61 55 54
8 Santa Mónica Santa 37 74 71 54
9 CD Binissalem B Binissalem 38 56 58 54
10 Soller B Soller B 36 67 59 53
11 UE Alcudia B Alcudia 38 66 58 52
12 Port de Soller Port Soller 38 51 62 51
13 Atlético Marratxí Atlético 37 73 77 45
14 Sant Jordi B Sant Jordi 37 63 70 45
15 Athetic Club Montuiri Athetic Club 37 52 75 43
16 Margaritense AtlÈtic Margaritense 36 62 69 39
17 Deportivo Marratxi Deportivo 37 52 98 29
18 Taujá Taujá 38 42 91 23
19 Establiments Establiments 36 27 96 23
20 Santanyi del Atb B Santanyi 30 35 67 21
TEMPORADA 2020/2021
3ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Deportivo Marratxi Deportivo 20 53 21 48
2 At. de Paguera B Paguera 20 38 26 35
3 Alaró B Alaró B 20 48 36 32
4 Esporles B Esporles B 20 39 33 31
5 Genova B Genova B 20 41 29 30
6 Col. San Pedro Col. Pedro 20 61 58 29
7 La Union B La Union B 20 31 40 27
8 At. Aldosivi de Mallorca Aldosivi 20 34 30 25
9 Son Ferrer del PC Ferrer 20 26 33 24
10 Santa Ponsa B Santa Ponsa 20 38 33 22
11 Son Ferrer B Ferrer 20 24 94 4
TEMPORADA 2019/2020
3ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Athlàtic Huialfàs Athlàtic 22 80 16 60
2 Murense B Murense B 22 71 34 51
3 Cala D'or Cala D'or 21 59 25 48
4 Deportivo Marratxi Deportivo 23 57 38 45
5 Santanyi del Atb B Santanyi 24 58 40 44
6 San Roque B San Roque B 24 73 53 43
7 Santa Ponsa B Santa Ponsa 23 53 35 40
8 Independiente C/r B Independient 25 65 59 38
9 Son Sardina B Sardina 24 58 68 34
10 Esporles B Esporles B 22 62 42 31
11 Alaró B Alaró B 21 33 28 27
12 Palmanyola Palmanyola 24 52 65 25
13 La Union B La Union B 23 44 66 23
14 Atlético de Paguera Atlético 24 34 61 23
15 Son Ferrer del PC Ferrer 22 36 65 23
16 Llucmajor B Llucmajor B 24 40 63 15
17 Rtvº Puigpunyent i Galilea Rtvº 22 40 64 14
18 Son Ferrer B Ferrer 24 29 122 4
TEMPORADA 2018/2019
3ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Collerense B Collerense 30 109 44 72
2 Bunyola Bunyola 30 95 35 70
3 San Cayetano Cayetano 30 88 61 65
4 Taujá Taujá 30 66 38 63
5 Sp. Son Ferrer A Ferrer 30 70 32 62
6 Athlàtic Huialfàs Athlàtic 30 60 44 47
7 Deportivo Marratxi Deportivo 30 67 68 45
8 Esporles B Esporles B 30 74 65 44
9 Son Maciá Son Maciá 29 56 55 38
10 La Real de Lu Real 31 65 91 37
11 Montaura B Montaura B 31 57 84 30
12 Santanyi del Atb B Santanyi 29 44 51 28
13 Rotlet Molinar B Rotlet 30 50 75 24
14 Santa Maria del Uesm Santa Maria 29 41 81 22
15 San Roque San Roque 30 49 99 19
16 Sant Marcal B Sant Marcal 29 31 99 11
TEMPORADA 2017/2018
3ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Son Ximelis Son Ximelis 23 85 20 61
2 Juv Can Picafort Picafort 23 65 21 51
3 Esporles B Esporles B 23 54 26 47
4 Collerense B Collerense 22 63 39 47
5 Mallorca Toppfotball Mallorca 21 53 36 34
6 Rotlet Molinar B Rotlet 23 56 52 32
7 Montaura B Montaura B 24 43 37 30
8 Sp. Son Ferrer A Ferrer 24 47 46 30
9 Deportivo Marratxi Deportivo 22 42 51 29
10 Campanet B Campanet B 23 35 53 17
11 Concos Concos 22 34 60 15
12 Son Maciá Son Maciá 23 28 123 10
13 Arta Arta 15 22 63 7
TEMPORADA 2016/2017
3ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Margaritense AtlÈtic Margaritense 24 81 22 62
2 Sporting Valldemossa Sporting 24 76 36 52
3 Santa Mónica Santa 24 70 31 52
4 Poblense B Poblense B 24 67 35 47
5 Esporles B Esporles B 23 59 30 46
6 Taujá Taujá 24 66 53 37
7 Cala D'or Cala D'or 23 45 39 36
8 A Llubí B A Llubí B 24 43 54 29
9 Deportivo Marratxi Deportivo 24 49 55 28
10 Cardassar B Cardassar B 24 49 58 24
11 Sta Ponsa Talarrubias Ponsa 24 63 74 22
12 Son Maciá Son Maciá 24 23 88 8
13 Son Ferrer B Ferrer 24 18 134 2

  USO DE MEMORIA  
5,533,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0899
Total Execution Time  0.0921
  CADENA URL  
/historico/Deportivo-Marratxi-Senior
  GET DATOS  
$_GET['/historico/Deportivo-Marratxi-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0026  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 = 'Deportivo-Marratxi-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.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=91124 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=91124 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 73789
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=91124 AND type_rel = 2
0.0021  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 = '91124' 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 = 73789 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=91124 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (73789,69163) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 69163 AND teamId = 91124
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73789 AND teamId = 91124
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 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 = 73789 AND t.round = 26 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 = '91124' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '91124' 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 events2024 e ON e.player_id = p.id AND e.league_id = 73789 WHERE rp.league_id = 73789 AND rp.teamId = 91124 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.0020  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 = 73789 WHERE rp.league_id = 73789 AND rp.teamId = 91124 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 73789 WHERE rp.league_id = 73789 AND rp.teamId = 91124 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 = 91124 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73789 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.0026  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 = 69163 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.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 `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 = 63706 AND t.round = 38 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 `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 = 60685 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.0028  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 = 51504 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.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 `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 = 44637 AND t.round = 34 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 `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 = 39186 AND t.round = 26 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 `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 = 34310 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC