4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Monjos
TEMPORADA 2023/2024
4ª CATALANA GRUPO 26
Equipo PJ GF GC Puntos
1 Hortonenc A Hortonenc A 26 96 30 75
2 Sant Cugat Sesgarrigues Sant Cugat. 26 61 28 60
3 Sant Sadurni A Sant Sadurni 26 72 30 59
4 Monjos Monjos 26 60 41 49
5 Ribes CD B Ribes CD B 26 64 46 47
6 Gelida CF A Gelida CF A 26 61 50 47
7 Riudebitlles B Riudebitlles 26 65 45 46
8 Base Vilanova 2015 CNF A Base 26 57 60 37
9 At. Vilanova I La Geltru Vilanova 26 67 58 36
10 Sant Pau D'Ordal A Sant D'Ordal 26 66 52 34
11 Olivella B Olivella B 27 64 77 31
12 Puigdalber A Puigdalber 26 32 57 26
13 Canyelles Canyelles 28 33 62 23
14 Martinenca A Martinenca 26 49 82 19
15 Avinyonet A Avinyonet A 26 55 87 17
16 Quintinenc A Quintinenc 27 23 120 5
TEMPORADA 2022/2023
4ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 Sant Pere Molanta Sant Pere M. 30 121 31 79
2 Canyelles Assoc Esp A Canyelles 30 88 39 72
3 Hortonenc A Hortonenc A 30 97 55 54
4 Sant Pau D'Ordal A Sant D'Ordal 30 81 54 52
5 Gelida CF A Gelida CF A 29 91 46 51
6 Sant Cugat Sesgarrigues Sant Cugat. 30 74 49 49
7 Canyelles Canyelles 30 73 63 48
8 Monjos Monjos 29 49 42 48
9 Riudebitlles B Riudebitlles 29 59 56 44
10 Martinenca A Martinenca 29 59 64 44
11 Sant Sadurni A Sant Sadurni 30 58 73 34
12 Puigdalber A Puigdalber 28 52 73 25
13 Olivella B Olivella B 28 46 85 21
14 Base Vilanova 2015 CNF A Base 30 48 116 17
15 Avinyonet A Avinyonet A 30 37 106 13
16 La Torre Claramunt B Torre 28 42 123 9
TEMPORADA 2021/2022
4ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 Can Cartro A Cartro 29 118 26 78
2 Base Vilanova 2015 CNF A Base 30 84 49 60
3 Martinenca A Martinenca 29 84 44 59
4 Gelida CF A Gelida CF A 29 97 59 56
5 Hortonenc A Hortonenc A 29 102 63 53
6 Sant Pere Molanta Sant Pere M. 28 102 59 49
7 Quintinenc A Quintinenc 29 72 53 48
8 Sant Sadurni A Sant Sadurni 29 79 64 46
9 Sant Pau D'Ordal A Sant D'Ordal 26 80 60 45
10 Canyelles Assoc Esp A Canyelles 29 59 73 37
11 Sant Cugat Sesgarrigues Sant Cugat. 28 56 86 33
12 Avinyonet A Avinyonet A 29 71 90 31
13 Puigdalber A Puigdalber 28 43 91 26
14 Olivella B Olivella B 29 50 135 19
15 Capellades B Capellades 30 47 114 9
16 Monjos Monjos 29 44 122 9
TEMPORADA 2020/2021
3ª CATALANA GRUPO 12
Equipo PJ GF GC Puntos
1 Montserrat Igualada Montserrat 16 45 9 42
2 Penya Jove Roquetes Penya Jove. 16 45 21 34
3 Ribes Ribes 16 40 24 34
4 Riudebitlles Riudebitlles 16 38 22 34
5 At. Vilanova I La Geltru Vilanova 16 45 38 25
6 Torrellenc Torrellenc 16 33 26 25
7 La Múnia La Múnia 16 19 29 22
8 Sitges B Sitges B 16 29 32 21
9 La Granada La Granada 16 28 38 19
10 Piera Piera 16 29 49 18
11 Anoia Anoia 16 29 40 17
12 Vilanova Camí Vilanova 16 22 34 17
13 La Pobla Claramunt Pobla 16 34 39 16
14 Masquefa Masquefa 16 28 38 16
15 Monjos Monjos 16 29 30 15
16 Ateneu Igualadí Ateneu 16 25 38 15
17 Les Cabanyes Cabanyes 16 20 31 12
TEMPORADA 2019/2020
4ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 Torrellenc Torrellenc 24 66 24 61
2 Monjos Monjos 23 73 42 51
3 Hortonenc A Hortonenc A 24 54 32 47
4 Can Cartro A Cartro 22 70 31 46
5 Sant Pau D'Ordal A Sant D'Ordal 24 57 42 46
6 Base Espirall Les Clotes A Base 24 74 34 45
7 Mediona A Mediona A 22 52 39 42
8 Sant Cugat Sesgarrigues Sant Cugat. 24 57 48 37
9 Sant Pere Molanta Sant Pere M. 23 43 37 33
10 Quintinenc A Quintinenc 22 29 42 24
11 Ribes CD B Ribes CD B 23 38 52 24
12 Martinenca A Martinenca 23 30 53 24
13 Cubelles CF B Cubelles 24 54 63 23
14 Sant Sadurni A Sant Sadurni 23 41 63 21
15 Gelida CF A Gelida CF A 21 46 65 19
16 Pla del Penedes Penedes 22 32 74 9
17 Avinyonet A Avinyonet A 24 22 97 5
TEMPORADA 2018/2019
4ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 At. Vilanova I La Geltru Vilanova 32 128 39 77
2 Les Cabanyes Cabanyes 33 90 36 77
3 Torrellenc Torrellenc 32 92 45 68
4 Can Cartro A Cartro 30 102 49 66
5 Sant Cugat Sesgarrigues Sant Cugat. 31 64 36 65
6 Base Espirall Les Clotes A Base 32 86 37 64
7 Sant Pau D'Ordal A Sant D'Ordal 33 75 72 52
8 Martinenca A Martinenca 33 54 70 44
9 Sant Sadurni A Sant Sadurni 33 63 69 43
10 Sant Pere Molanta Sant Pere M. 30 65 58 40
11 Gelida CF A Gelida CF A 32 78 74 40
12 Ribes CD B Ribes CD B 31 54 68 40
13 Hortonenc A Hortonenc A 31 67 75 36
14 Pla del Penedes Penedes 32 55 91 36
15 Monjos Monjos 32 51 97 23
16 Quintinenc A Quintinenc 33 36 102 18
17 Castellvi de la Marca A Castellvi 33 29 125 6
18 Sant Miquel - Montagut Sant Miquel 15 15 61 1
TEMPORADA 2017/2018
4ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 La Granada La Granada 29 99 18 75
2 Pª Jove de Les Roquetes A Pª Jove Ro. 27 84 37 62
3 Les Cabanyes Cabanyes 30 95 56 61
4 Torrellenc Torrellenc 30 86 41 60
5 Can Cartro A Cartro 27 72 38 54
6 At. Vilanova I La Geltru Vilanova 30 72 46 53
7 Base Espirall Les Clotes A Base 29 58 47 47
8 Sant Sadurni A Sant Sadurni 30 66 69 39
9 Sant Pau D'Ordal A Sant D'Ordal 30 53 55 34
10 Monjos Monjos 29 57 77 34
11 Ribes CD B Ribes CD B 29 60 81 33
12 Sant Cugat Sesgarrigues Sant Cugat. 26 48 62 28
13 Gelida CF A Gelida CF A 27 50 65 28
14 Avinyonet A Avinyonet A 26 37 81 22
15 Castellvi de la Marca A Castellvi 28 41 82 19
16 Puigdalber A Puigdalber 27 14 137 0
TEMPORADA 2016/2017
4ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 Mediona A Mediona A 28 82 42 69
2 Can Cartro A Cartro 28 93 32 64
3 Ribes Ribes 27 65 17 63
4 Les Cabanyes Cabanyes 28 78 35 58
5 Base Espirall Les Clotes A Base 27 76 32 49
6 Pª Jove de Les Roquetes A Pª Jove Ro. 28 75 59 44
7 La Granada B Granada 25 56 36 39
8 Sant Sadurni A Sant Sadurni 25 50 44 39
9 Avinyonet A Avinyonet A 28 52 60 38
10 Castellvi de la Marca A Castellvi 26 52 52 37
11 Puigdalber A Puigdalber 25 55 62 23
12 Monjos Monjos 27 41 83 23
13 Sant Pau D'Ordal A Sant D'Ordal 27 48 68 15
14 Newell's Vilanova i la Gelt Newell's 24 24 125 7
15 Torrellenc Torrellenc 27 19 119 3
TEMPORADA 2015/2016
4ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 Suburense B Suburense B 30 106 31 82
2 Hortonenc A Hortonenc A 30 97 26 76
3 Can Cartro A Cartro 30 93 36 69
4 Les Cabanyes Cabanyes 30 94 43 59
5 La Plana Rodona A Plana Rodona 30 78 47 57
6 Base Espirall-Les Clotes Base 30 75 40 55
7 Ribes Ribes 29 96 71 53
8 Penya Jove Roquetes Penya Jove. 30 79 80 45
9 Sant Sadurni A Sant Sadurni 29 61 65 37
10 Torrellenc Torrellenc 29 72 92 34
11 Sant Pau D'Ordal A Sant D'Ordal 30 46 80 25
12 Monjos Monjos 30 45 86 22
13 Canyelles Assoc. Esp. CF A Canyelles 30 34 94 21
14 Puigdalber A Puigdalber 28 26 84 17
15 La Granada B Granada 30 36 104 16
16 Avinyonet A Avinyonet A 29 43 102 12
TEMPORADA 2014/2015
4ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 Martinenca A Martinenca 29 116 24 74
2 Castellvi de la Marca A Castellvi 30 93 36 73
3 Can Cartro A Cartro 30 71 30 66
4 Les Cabanyes Cabanyes 30 89 48 64
5 Hortonenc A Hortonenc A 29 96 40 62
6 Mediona A Mediona A 30 67 58 52
7 Sant Sadurni A Sant Sadurni 30 70 54 45
8 Monjos Monjos 29 73 75 45
9 La Plana Rodona A Plana Rodona 29 50 58 42
10 Sant Pau D'Ordal A Sant D'Ordal 30 69 82 37
11 Torrellenc Torrellenc 29 54 75 31
12 La Granada B Granada 29 50 65 29
13 Rapit Catala A Rapit Catala 30 42 91 23
14 Puigdalber A Puigdalber 30 33 106 19
15 Avinyonet A Avinyonet A 30 42 94 10
16 Quintinenc A Quintinenc 24 20 99 3

  USO DE MEMORIA  
5,923,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5930
Total Execution Time  0.5944
  CADENA URL  
/historico/Monjos-A
  GET DATOS  
$_GET['/historico/Monjos-A']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0154  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 = 'Monjos-A' 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.0145  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=24049 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=24049 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 74060
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24049 AND type_rel = 2
0.0150  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 = '24049' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '24049' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155  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 = 74060 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0166  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=24049 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (74060) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 74060 AND teamId = 24049
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 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 = 74060 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0154  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 = '24049' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '24049' and rp.type = 4
0.0148  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 = '24049' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0324  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 = 74060 WHERE rp.league_id = 74060 AND rp.teamId = 24049 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.0146  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 = 74060 WHERE rp.league_id = 74060 AND rp.teamId = 24049 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 74060 WHERE rp.league_id = 74060 AND rp.teamId = 24049 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 24049 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74060 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.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 `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 = 69469 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.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 = 64522 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.0148  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 = 58796 AND t.round = 17 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 `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 = 51608 AND t.round = 25 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 `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 = 44761 AND t.round = 34 ORDER BY team.conference 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 `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 = 39937 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 36074 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 17043 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 4740 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74060 ORDER BY nameShow LIMIT 100