4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Camarles
TEMPORADA 2023/2024
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Aldeana Aldeana 0 0 0 0
2 Ampolla Ampolla 0 0 0 0
3 At. Móra la Nova Móra Nova 0 0 0 0
4 Camarles Camarles 0 0 0 0
5 Cambrils Unió Cambrils 0 0 0 0
6 Cubelles Cubelles 0 0 0 0
7 España Canonja España 0 0 0 0
8 Gandesa Gandesa 0 0 0 0
9 Hospitalet de l'Infant Hospitalet 0 0 0 0
10 Jesus Catalonia Jesus 0 0 0 0
11 Jesus y Maria Jesus Maria 0 0 0 0
12 L'Arboç L'Arboç 0 0 0 0
13 La Sénia La Sénia 0 0 0 0
14 Pobla Mafumet B Pobla 0 0 0 0
15 Remolins Bítem Remolins 0 0 0 0
16 UE Segur UE Segur 0 0 0 0
17 Ulldecona Ulldecona 0 0 0 0
18 Vila-Seca Vila-Seca 0 0 0 0
TEMPORADA 2022/2023
2ª CATALANA GRUPO 12
Equipo PJ GF GC Puntos
1 Tortosa Tortosa 18 57 20 41
2 Ebre Escola A Ebre Escola 18 34 16 37
3 Aldeana Aldeana 18 29 21 32
4 Ulldecona Ulldecona 18 41 27 31
5 Ampolla Ampolla 18 24 34 23
6 Jesus Catalonia Jesus 18 26 43 21
7 Camarles Camarles 18 23 33 20
8 At. Móra la Nova Móra Nova 18 26 32 18
9 La Sénia La Sénia 18 26 40 16
10 Remolins Bítem Remolins 18 12 32 13
TEMPORADA 2021/2022
2ª CATALANA GRUPO 11
Equipo PJ GF GC Puntos
1 Tortosa Tortosa 20 30 21 37
2 Aldeana Aldeana 18 38 26 34
3 Ampolla Ampolla 17 30 19 34
4 Amposta Amposta 19 35 27 30
5 Ebre Escola A Ebre Escola 19 25 26 24
6 La Sénia La Sénia 18 27 33 24
7 Ulldecona Ulldecona 19 23 29 24
8 At. Móra la Nova Móra Nova 19 27 23 23
9 Perelló Perelló 20 32 38 23
10 Camarles Camarles 16 24 25 22
11 Remolins Bítem Remolins 17 10 34 9
TEMPORADA 2020/2021
2ª CATALANA GRUPO 12
Equipo PJ GF GC Puntos
1 La Sénia La Sénia 1 2 0 3
2 Ulldecona Ulldecona 1 3 2 3
3 Ampolla Ampolla 1 1 0 3
4 Perelló Perelló 1 1 1 1
5 Tortosa Tortosa 1 1 1 1
6 Amposta Amposta 0 0 0 0
7 Camarles Camarles 0 0 0 0
8 Remolins Bítem Remolins 1 2 3 0
9 At. Móra la Nova Móra Nova 1 0 1 0
10 Aldeana Aldeana 1 0 2 0
TEMPORADA 2019/2020
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Gandesa Gandesa 22 50 15 50
2 Rapitenca Rapitenca 22 55 25 46
3 Tortosa Tortosa 22 44 24 46
4 La Sénia La Sénia 21 44 37 38
5 Perelló Perelló 22 38 29 35
6 Canonja Canonja 22 39 36 34
7 Ulldecona Ulldecona 21 33 30 34
8 Amposta Amposta 22 35 31 33
9 At. Móra la Nova Móra Nova 22 33 27 32
10 Camarles Camarles 22 39 32 30
11 Ampolla Ampolla 21 33 38 26
12 Cambrils Cambrils 23 29 41 26
13 Pobla Mafumet B Pobla 21 25 30 22
14 At. Roda Barà Roda Barà 22 33 45 22
15 Riudoms Riudoms 22 21 49 15
16 Montblanc Montblanc 21 22 51 14
17 Bonavista Bonavista 21 21 53 12
18 Les Borges del Camp A Borges Camp 1 2 3 0
TEMPORADA 2018/2019
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 UE Valls UE Valls 34 88 27 84
2 El Catllar El Catllar 34 80 42 77
3 Tortosa Tortosa 34 75 36 70
4 Gandesa Gandesa 34 55 29 61
5 Ampolla Ampolla 34 66 72 53
6 Camarles Camarles 34 66 57 52
7 Ulldecona Ulldecona 34 61 56 50
8 Amposta Amposta 34 61 51 50
9 La Sénia La Sénia 34 53 53 50
10 At. Móra la Nova Móra Nova 34 56 55 48
11 Pobla Mafumet B Pobla 34 48 47 46
12 Riudoms Riudoms 34 54 53 46
13 Canonja Canonja 34 55 57 40
14 Vendrell Vendrell 34 50 63 38
15 Vilaseca Vilaseca 34 46 58 33
16 Torreforta Torreforta 34 31 69 27
17 Reus FC Reddis Reus Reddis 34 32 80 24
18 Escola La Pastoreta Escola 34 32 104 12
TEMPORADA 2017/2018
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Cambrils Cambrils 34 80 28 79
2 Amposta Amposta 34 68 24 77
3 Gandesa Gandesa 34 90 41 69
4 Camarles Camarles 34 75 51 60
5 La Sénia La Sénia 34 80 59 54
6 Vendrell Vendrell 34 68 57 54
7 Ulldecona Ulldecona 34 55 46 51
8 Pobla Mafumet B Pobla 34 70 58 49
9 Torreforta Torreforta 34 51 58 48
10 Reus FC Reddis Reus Reddis 34 58 57 47
11 Canonja Canonja 34 44 53 47
12 Morell Morell 34 57 63 44
13 La Cava La Cava 34 58 65 44
14 Batea CF Batea CF 34 55 67 39
15 At. Roda Barà Roda Barà 34 53 64 36
16 Jesus Catalonia Jesus 34 56 69 34
17 Hospitalet de l'Infant Hospitalet 34 30 99 22
18 Torredembarra Torredembarr 34 34 123 16
TEMPORADA 2016/2017
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Tortosa Tortosa 34 77 32 78
2 UE Valls UE Valls 34 77 34 76
3 Cambrils Cambrils 34 65 32 67
4 Amposta Amposta 34 54 21 66
5 Camarles Camarles 34 72 37 65
6 Gandesa Gandesa 34 63 35 57
7 Reus FC Reddis Reus Reddis 34 71 67 52
8 Ulldecona Ulldecona 34 46 53 44
9 Vendrell Vendrell 34 51 54 43
10 Hospitalet de l'Infant Hospitalet 34 56 57 42
11 Torredembarra Torredembarr 34 42 59 41
12 La Cava La Cava 34 42 59 41
13 Batea CF Batea CF 34 62 77 38
14 At. Roda Barà Roda Barà 34 50 43 37
15 UE Segur UE Segur 34 54 77 36
16 El Catllar El Catllar 34 39 80 22
17 La Riera La Riera 34 34 87 21
18 Salou Salou 34 28 79 17
TEMPORADA 2015/2016
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Cambrils Cambrils 34 94 26 79
2 Tortosa Tortosa 34 79 43 72
3 UE Valls UE Valls 34 71 44 72
4 Gandesa Gandesa 34 66 43 56
5 La Cava La Cava 34 69 59 56
6 Ulldecona Ulldecona 34 62 48 55
7 Camarles Camarles 34 56 55 49
8 At. Roda Barà Roda Barà 34 60 56 48
9 Hospitalet de l'Infant Hospitalet 34 49 52 47
10 La Riera La Riera 34 45 47 46
11 Remolins Bítem Remolins 34 49 60 45
12 Racing Bonavista Racing 34 55 54 44
13 Jesus Catalonia Jesus 34 44 46 42
14 Ampolla Ampolla 34 42 64 37
15 Torreforta Torreforta 34 44 55 33
16 Canonja Canonja 34 40 60 32
17 Alcanar Alcanar 34 60 91 28
18 Godall FC Godall FC 34 26 108 10
TEMPORADA 2014/2015
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Vilaseca Vilaseca 34 102 24 85
2 Jesus y Maria Jesus Maria 34 76 30 78
3 Remolins Bítem Remolins 34 89 40 63
4 Gandesa Gandesa 34 60 40 63
5 Canonja Canonja 34 62 44 59
6 La Cava La Cava 34 68 51 58
7 At. Roda Barà Roda Barà 34 57 51 51
8 Tortosa Tortosa 34 72 44 50
9 UE Valls UE Valls 34 51 47 48
10 Jesus Catalonia Jesus 34 50 49 48
11 Alcanar Alcanar 34 67 55 47
12 Camarles Camarles 34 53 64 42
13 Ampolla Ampolla 34 47 63 41
14 Cambrils Cambrils 34 42 66 39
15 Tancat Tancat 34 41 100 29
16 Deltebre Deltebre 34 30 82 25
17 E.F. San Pedro San Pablo E.F. Pedro. 34 32 93 23
18 At. Camp Clar Camp Clar 34 35 91 15

  USO DE MEMORIA  
5,917,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6481
Total Execution Time  0.6495
  CADENA URL  
/historico/Camarles
  GET DATOS  
$_GET['/historico/Camarles']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0187  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 = 'Camarles' 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.0150  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=11849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153  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=11849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0316  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 = 72891
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11849 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=683 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 683 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (1235030,1214782,1117609,935979,869940) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '11849' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '11849' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '11849' 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 = 72891 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=11849 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (72891) 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 = 72891 AND teamId = 11849
0.0154  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 = 72891 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0149  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 = '11849' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11849' and rp.type = 4
0.0147  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 = '11849' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 = 72891 WHERE rp.league_id = 72891 AND rp.teamId = 11849 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.0148  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 = 72891 WHERE rp.league_id = 72891 AND rp.teamId = 11849 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 72891 WHERE rp.league_id = 72891 AND rp.teamId = 11849 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 11849 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0157  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 = 72891 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.0155  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 = 68566 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 63745 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.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 = 58784 AND t.round = 18 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 = 50604 AND t.round = 23 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 `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 = 44414 AND t.round = 34 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 = 38998 AND t.round = 34 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 `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 = 33990 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 16677 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 3953 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 72891 ORDER BY nameShow LIMIT 100