4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del El Perelló
TEMPORADA 2023/2024
TERCERA FFCV GRUPO 10
Equipo PJ GF GC Puntos
1 Daimus A Daimus A 24 66 27 54
2 Miramar Miramar 22 54 27 47
3 C Albalat de La Ribera Albalat 24 57 37 46
4 Rotova A Rotova A 23 51 26 45
5 Villalonga Villalonga 24 53 26 45
6 Ath. La Vall Ath. Vall 23 44 30 37
7 Xeraco Xeraco 23 57 36 34
8 El Perelló El Perelló 24 45 50 33
9 Safor CF Gandia B Safor Gandia 24 81 44 29
10 Benirredra Benirredra 23 41 42 26
11 UD Oliva B UD Oliva B 22 28 64 23
12 Simat B Simat B 23 28 59 17
13 SD Sueca B SD Sueca B 24 30 67 15
14 Piles A Piles A 23 25 61 13
15 Sueca United Sueca United 2 0 64 0
TEMPORADA 2022/2023
TERCERA FFCV GRUPO 10
Equipo PJ GF GC Puntos
1 Carlet Carlet 29 133 18 67
2 CD Olímpic B Olímpic 29 153 27 66
3 UD Carcaixent B Carcaixent 30 123 27 64
4 C Albalat de La Ribera Albalat 30 107 41 63
5 Sollana A Sollana A 29 105 39 53
6 Atletico Carcer Atletico 30 110 36 51
7 Cullera B Cullera B 30 107 47 51
8 Senyera Senyera 29 124 47 45
9 Benifaio B Benifaio B 30 93 53 42
10 L'Alcúdia B L'Alcúdia 29 99 44 39
11 El Perelló El Perelló 29 69 56 36
12 Pobla Llarga Pobla Llarga 30 92 60 33
13 Barxeta Barxeta 29 81 55 33
14 FBCD Catarroja B FBCD 28 63 85 19
15 CF At Polinya Polinya 29 18 161 7
16 Sueca United Sueca United 30 11 255 1
TEMPORADA 2021/2022
TERCERA FFCV GRUPO 9
Equipo PJ GF GC Puntos
1 Balompié Alfafar Balompié 28 93 25 70
2 FBCD Catarroja FBCD 28 72 36 61
3 Castellar Oliveral CF Castellar 27 76 43 61
4 El Perelló El Perelló 27 76 55 55
5 At. Ciudad Paiporta Ciudad 28 69 43 54
6 Catarroja CF Catarroja 27 56 34 48
7 Atletico Sedavi A Atletico 28 57 44 38
8 Juventud Picanya B Juventud 27 49 47 38
9 Union Benetuser-Fabara B Union 28 52 54 36
10 E-1 Valencia Valencia 27 51 59 34
11 Picassent B Picassent B 28 48 61 33
12 Albal CF Albal CF 27 47 50 32
13 Sedavi CF Sedavi CF 27 36 72 18
14 Valls Dels Alcalans B Valls Dels. 18 13 58 4
15 Beniparrell Beniparrell 27 20 116 3
16 Sport Catarroja B Sport 4 2 20 0
TEMPORADA 2020/2021
TERCERA FFCV GRUPO 45
Equipo PJ GF GC Puntos
1 El Perelló El Perelló 5 25 0 15
2 Cullera B Cullera B 5 16 11 9
3 Piles A Piles A 5 17 10 7
4 Beniopa Beniopa 5 11 6 7
5 CF Llutxent CF Llutxent 5 11 14 6
6 Sueca United Sueca United 5 7 46 0
TEMPORADA 2015/2016
TERCERA FFCV GRUPO 9
Equipo PJ GF GC Puntos
1 Silla B Silla B 30 116 31 71
2 Vall Dels Alcalans Vall Dels A. 30 124 18 69
3 C. Alzira C. Alzira 30 129 40 59
4 Racing D´ Algemesí Racing 30 109 39 53
5 Catarroja Catarroja 30 114 59 52
6 Sollana A Sollana A 30 89 43 52
7 Beniparrell Beniparrell 30 110 58 49
8 Albal CF Albal CF 30 96 58 47
9 Alginet B Alginet B 30 96 58 45
10 Picassent B Picassent B 30 81 61 39
11 O. Alcàsser Alcàsser 30 84 72 34
12 Prom. Sueca B Prom. Sueca 30 73 68 31
13 Carlet EMF A Carlet 30 58 86 30
14 El Perelló El Perelló 30 59 83 27
15 Esperanza Esperanza 30 72 97 20
16 Sueca United Sueca United 30 6 255 0

  USO DE MEMORIA  
5,125,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0685
Total Execution Time  0.0697
  CADENA URL  
/historico/Ad-El-Perello
  GET DATOS  
$_GET['/historico/Ad-El-Perello']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66361 AND type_rel = 2
0.0023  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 = '66361' 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 = 73846 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=66361 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73846) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73846 AND teamId = 66361
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 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 = 73846 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '66361' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66361' and rp.type = 4
0.0021  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 = '66361' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 73846 WHERE rp.league_id = 73846 AND rp.teamId = 66361 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.0024  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 = 73846 WHERE rp.league_id = 73846 AND rp.teamId = 66361 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 73846 WHERE rp.league_id = 73846 AND rp.teamId = 66361 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 66361 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 = 69413 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 = 64352 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.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 `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 = 59570 AND t.round = 13 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 `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 = 62500 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 16886 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC