4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SC Torrevieja CF
TEMPORADA 2023/2024
PRIMERA FFCV GRUPO 4
Equipo PJ GF GC Puntos
1 SC Torrevieja CF Torrevieja 27 52 31 53
2 Novelda UCF Novelda UCF 26 45 28 52
3 Murada Murada 25 50 24 51
4 Almoradí Almoradí 25 46 28 46
5 El Campello El Campello 27 38 38 38
6 Novelda CF Novelda CF 25 44 41 37
7 Benferri Benferri 26 38 36 37
8 Atlético Catral Atlético 26 43 45 35
9 Villena Villena 26 48 55 32
10 Villajoyosa Villajoyosa 27 41 49 32
11 Mutxamel Mutxamel 26 27 30 30
12 Carrús UD Ilicitana Carrús 25 43 49 28
13 S. Fulgencio Fulgencio 27 26 34 28
14 UE Crevillent Crevillent 26 21 39 25
15 Polop Polop 26 39 55 25
16 Pinoso Pinoso 26 34 53 22
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 SC Torrevieja CF Torrevieja 30 109 21 75
2 Pinoso Pinoso 30 63 23 71
3 S. Fulgencio Fulgencio 30 51 17 68
4 UE Crevillent Crevillent 30 73 37 67
5 UD Aspe UD Aspe 30 52 37 58
6 CD Montesinos A Montesinos 30 60 40 53
7 Elche Dream Elche Dream 29 61 77 42
8 Cox Cox 30 49 46 41
9 Il-Licitana Raval A Il-Licitana 30 51 52 39
10 Algorfa Algorfa 30 52 60 38
11 Sax Sax 30 53 63 29
12 Rafal Rafal 30 39 71 24
13 Algueña Cf Algueña Cf 29 32 68 21
14 San Miguel CF Miguel 30 37 77 19
15 Sporting Dolores Sporting 30 33 71 18
16 UD La Coca Aspense A Coca Aspense 30 33 88 14
TEMPORADA 2021/2022
SEGUNDA FFCV GRUPO 9
Equipo PJ GF GC Puntos
1 Atlético Catral Atlético 28 76 26 68
2 SC Torrevieja CF Torrevieja 28 72 35 58
3 Pinoso Pinoso 28 47 51 46
4 CD Montesinos A Montesinos 28 47 36 45
5 S. Fulgencio Fulgencio 28 46 26 44
6 Cox Cox 28 47 33 43
7 Algueña Cf Algueña Cf 28 48 39 40
8 Rafal Rafal 28 41 40 40
9 Algorfa Algorfa 28 44 41 36
10 Sporting Dolores Sporting 28 48 47 36
11 San Miguel CF Miguel 28 36 61 31
12 Benijofar Benijofar 28 35 52 26
13 Sp. Albatera Albatera 28 38 57 25
14 CFP Orihuela Deportiva Orihuela 28 42 80 20
15 Orihuela B Orihuela B 28 31 74 19
TEMPORADA 2020/2021
TERCERA FFCV GRUPO 34
Equipo PJ GF GC Puntos
1 Atlético Algorfa Atlético 6 14 6 14
2 SC Torrevieja CF Torrevieja 6 12 8 12
3 Sp. Costablanca Costablanca 5 11 3 11
4 Guardamar Soccer Guardamar 6 13 11 8
5 Benejuzar Benejuzar 6 8 13 5
6 Redovan B Redovan B 5 6 12 4
7 Bigastro Bigastro 6 6 17 1
TEMPORADA 2019/2020
TERCERA FFCV GRUPO 14
Equipo PJ GF GC Puntos
1 CD Montesinos A Montesinos 23 91 16 63
2 Benijofar Benijofar 22 76 24 55
3 Sp. Albatera Albatera 23 70 23 52
4 SC Torrevieja CF Torrevieja 23 84 27 48
5 S. Guardamar CF Guardamar 23 65 36 40
6 Bigastro Bigastro 22 59 37 38
7 Atlético Algorfa Atlético 22 52 43 32
8 Horadada B Horadada B 22 48 36 31
9 Dolores Dolores 21 50 34 30
10 Benejuzar Benejuzar 23 40 52 30
11 Playa Santa Pola City A Playa Santa 15 34 26 24
12 Formentera Formentera 23 28 46 21
13 Sp. Saladar Sp. Saladar 22 31 81 20
14 Daya Nueva Atletic Daya Nueva. 22 35 59 17
15 Crevillente Crevillente 22 25 86 4
16 Montesinos Todo Deporte Montesinos 22 18 180 0
TEMPORADA 2018/2019
TERCERA FFCV GRUPO 15
Equipo PJ GF GC Puntos
1 Cox Cox 30 90 30 69
2 CFP Orihuela Deportiva Orihuela 30 67 25 69
3 Sp. Saladar Sp. Saladar 30 77 25 66
4 Bigastro Bigastro 30 79 44 61
5 SC Torrevieja CF Torrevieja 30 67 35 52
6 Sp. Albatera Albatera 30 76 49 52
7 G. Caliche G. Caliche 30 69 50 50
8 Daya Nueva Atletic Daya Nueva. 30 78 62 48
9 Atl. Orihuela Atl. 30 67 49 41
10 Formentera Formentera 30 40 60 37
11 Atlético Algorfa Atlético 30 57 72 33
12 Thader B Thader B 30 43 65 33
13 Sporting Orihuela Sporting 30 51 68 29
14 Benijofar Benijofar 30 47 70 28
15 SC Torrevieja B Torrevieja 30 43 97 13
16 Montesinos Todo Deporte Montesinos 30 13 163 4
TEMPORADA 2017/2018
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 CF Intercity Intercity 30 85 18 76
2 UD Horadada UD Horadada 30 60 17 66
3 Santa Pola Cf Santa Pola 30 58 30 52
4 CD Montesinos A Montesinos 30 75 54 50
5 San Miguel CF Miguel 30 48 34 50
6 Dolores Dolores 29 42 46 42
7 Atlético Catral Atlético 30 36 41 40
8 Santa Pola Santa Pola 30 57 57 39
9 Rafal Rafal 30 47 44 37
10 Callosa D. B Callosa 30 49 53 37
11 CF San Gabriel Gabriel 29 53 66 37
12 Altet Altet 30 32 51 37
13 H. Nieves H. Nieves 30 48 58 34
14 S. Guardamar CF Guardamar 30 32 49 31
15 Cox Cox 30 31 69 25
16 SC Torrevieja CF Torrevieja 30 26 92 8
TEMPORADA 2016/2017
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 Monforte Monforte 30 51 25 61
2 Rafal Rafal 30 64 36 58
3 Pinoso Pinoso 30 57 35 58
4 Santa Pola Santa Pola 30 56 41 50
5 Santa Pola Santa Pola 30 60 43 47
6 Atlético Catral Atlético 30 40 31 45
7 Dolores Dolores 29 48 39 44
8 San Miguel CF Miguel 29 54 39 42
9 UD Horadada UD Horadada 30 35 38 42
10 Algorfa Algorfa 30 40 44 41
11 Altet Altet 30 41 38 40
12 H. Nieves H. Nieves 29 45 50 39
13 SC Torrevieja CF Torrevieja 30 43 64 31
14 Bigastro Bigastro 30 35 44 29
15 AC Torrellano Torrellano 29 39 70 20
16 Sp. Saladar Sp. Saladar 30 32 103 7
TEMPORADA 2015/2016
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 Redovan Redovan 30 73 27 71
2 Carrús UD Ilicitana Carrús 30 68 22 70
3 Santa Pola Santa Pola 30 73 43 60
4 Altet Altet 30 52 36 58
5 Aspe UD Aspe UD 30 49 39 51
6 Pinoso Pinoso 30 51 31 45
7 Algorfa Algorfa 30 59 39 45
8 Atlético Catral Atlético 30 55 51 41
9 Bigastro Bigastro 30 47 52 38
10 Santa Pola Santa Pola 30 51 66 37
11 SC Torrevieja CF Torrevieja 30 46 55 33
12 Sp. Saladar Sp. Saladar 30 45 67 30
13 AC Torrellano Torrellano 30 50 58 28
14 Algueña Cf Algueña Cf 30 37 72 21
15 Coca de Aspe Coca Aspe 30 44 87 20
16 Albaterense Albaterense 30 30 85 13
TEMPORADA 2014/2015
SEGUNDA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 Rafal Rafal 30 57 34 57
2 Jove Espanyol B Jove 30 60 35 54
3 Atlético Catral Atlético 30 50 34 54
4 H. Nieves H. Nieves 30 49 38 54
5 Carrús UD Ilicitana Carrús 30 63 24 53
6 Aspe UD Aspe UD 30 51 46 45
7 SC Torrevieja CF Torrevieja 30 47 51 43
8 Albaterense Albaterense 30 53 40 42
9 Redovan Redovan 30 40 36 40
10 Coca de Aspe Coca Aspe 30 45 43 39
11 Santa Pola Santa Pola 30 38 35 38
12 Algorfa Algorfa 30 45 52 32
13 Orihuela B Orihuela B 29 40 55 31
14 Sp. Saladar Sp. Saladar 29 47 73 29
15 S. Fulgencio Fulgencio 30 37 68 24
16 Alicante Rvo. A Alicante 30 25 83 17

  USO DE MEMORIA  
5,973,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5302
Total Execution Time  0.5314
  CADENA URL  
/historico/Torrevieja-Cf-Senior
  GET DATOS  
$_GET['/historico/Torrevieja-Cf-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0133  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 = 'Torrevieja-Cf-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.0125  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=46445 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=46445 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 73772
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46445 AND type_rel = 2
0.0129  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 = '46445' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '46445' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '46445' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 73772 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=46445 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (73772,69376) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73772 AND teamId = 46445
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 69376 AND teamId = 46445
0.0129  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 = 73772 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '46445' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '46445' and rp.type = 4
0.0127  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 = '46445' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 = 73772 WHERE rp.league_id = 73772 AND rp.teamId = 46445 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.0137  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 = 73772 WHERE rp.league_id = 73772 AND rp.teamId = 46445 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 73772 WHERE rp.league_id = 73772 AND rp.teamId = 46445 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 46445 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 73772 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 69376 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.0128  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 = 64340 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.0130  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 = 59576 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.0128  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 = 62489 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 51391 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 45324 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 39368 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 34298 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16847 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 7091 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC