4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Recreativo de Huelva B
TEMPORADA 2022/2023
2ª ANDALUZA HUELVA CADETE
Equipo PJ GF GC Puntos
1 Nuevo Molino Sub 16 Nuevo Molino 30 143 25 78
2 Recreativo de Huelva B Recreativo 30 138 36 77
3 Punta del Caiman Punta Caiman 30 125 62 72
4 1889 Escuela Y Porteros 1889 Escuela 30 81 36 67
5 San Roque de Lepe CD Roque Lepe 30 85 59 58
6 Bonares Bonares 30 93 75 55
7 CD Siempre Alegres Siempre 30 98 61 52
8 Verdeluz Verdeluz 30 82 78 46
9 Los Rosales Los Rosales 30 83 89 33
10 Valverdeño La Amistad Valverdeño 30 78 91 33
11 CD Cartaya Deportes Cartaya 30 75 115 31
12 Asociación Santa Marta Asociación 30 59 112 27
13 Iliplense Iliplense 30 64 129 20
14 Almonte Balompie Almonte 30 59 132 18
15 Club Deportivo 1889 Atletic Club 30 51 113 17
16 Santa Olalla Santa Olalla 30 39 140 7
TEMPORADA 2021/2022
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Peloteros Sierra Sur Sub 16 Peloteros 30 96 31 75
2 Real Betis Sub 16 B Real Betis 30 107 34 68
3 CD Utrera Sub 16 Utrera 29 86 35 68
4 Fundacion Cadiz CF CD Fundacion 29 83 33 64
5 Sevilla FC Sub 16 B Sevilla 30 63 38 57
6 San Roque Balompie Sub 16 Roque 29 59 43 53
7 Algeciras CF Sub 16 Algeciras 30 61 49 47
8 CD Asoc. Dva. Nervión Asoc. Dva.. 29 59 62 42
9 Palma del Rio Atlético Palma 30 44 62 39
10 Córdoba CF B Córdoba 30 36 55 31
11 San Fernando CD Isleño Fernando 30 52 73 26
12 Balón De Cádiz CF B Balón 30 46 69 24
13 CD Siempre Alegres Siempre 29 30 84 23
14 Recreativo de Huelva B Recreativo 30 38 72 20
15 Calavera CF Calavera CF 30 35 81 20
16 Nuevo Molino Sub 16 Nuevo Molino 29 27 101 14
TEMPORADA 2020/2021
2ª ANDALUZA HUELVA CADETE
Equipo PJ GF GC Puntos
1 Recreativo de Huelva B Recreativo 24 87 25 55
2 San Roque de Lepe B Roque Lepe 24 83 34 54
3 1889 Escuela Y Porteros 1889 Escuela 24 77 40 50
4 Los Rosales Los Rosales 24 72 36 47
5 Asociación Santa Marta Asociación 24 62 34 47
6 Isla Cristina Isla 24 56 34 46
7 Bollullos Bollullos 24 48 26 46
8 Valverdeño La Amistad Valverdeño 24 46 63 28
9 PMD Gibraleón Gibraleón 24 36 66 24
10 Siempre Alegres CD B Siempre 24 37 66 17
11 Aljaraque Aljaraque 24 30 68 17
12 Almonte Balompie Almonte 24 30 71 11
13 Punta del Caiman Punta Caiman 24 15 116 1
TEMPORADA 2018/2019
2ª ANDALUZA HUELVA CADETE
Equipo PJ GF GC Puntos
1 San Roque de Lepe CD Roque Lepe 30 127 28 77
2 Recreativo de Huelva B Recreativo 30 96 21 73
3 1889 Escuela Y Porteros 1889 Escuela 29 87 48 56
4 At. Tartessos Tartessos 29 88 66 55
5 Aljaraque Aljaraque 30 81 56 51
6 Gibraleón Gibraleón 29 66 66 49
7 Punta Umbria Punta Umbria 30 79 71 45
8 Isla Cristina Isla 29 74 70 42
9 Los Rosales Los Rosales 29 50 52 41
10 Nuevo Molino Sub 16 Nuevo Molino 29 70 68 32
11 Cd Huelva Atlético Huelva 29 63 72 32
12 Siempre Alegres CD B Siempre 30 52 68 32
13 Asociación Santa Marta Asociación 30 39 80 27
14 Bollullos Bollullos 29 39 78 21
15 Soccer Fabrica Soccer 21 38 73 18
16 San Diego San Diego 29 33 165 4
TEMPORADA 2017/2018
2ª ANDALUZA HUELVA CADETE
Equipo PJ GF GC Puntos
1 CD Siempre Alegres Siempre 28 112 33 72
2 San Roque de Lepe CD Roque Lepe 29 116 39 70
3 Nuevo Molino Sub 16 Nuevo Molino 28 92 32 67
4 1889 Escuela Y Porteros 1889 Escuela 28 99 25 64
5 Recreativo de Huelva B Recreativo 28 72 30 53
6 Asociación Santa Marta Asociación 28 75 53 53
7 Bollullos Bollullos 28 67 61 40
8 Los Rosales Los Rosales 29 78 74 39
9 Aljaraque Aljaraque 29 74 70 36
10 Club Atletico Tharsis Club 28 49 77 26
11 Isla Cristina Isla 28 57 88 26
12 San Diego San Diego 28 74 133 22
13 Cd Huelva Atlético Huelva 28 39 78 15
14 O. Valverdeña Valverdeña 27 34 119 13
15 Almonte Balompie Almonte 27 28 121 12
16 At. Onubense Onubense 3 0 33 0
TEMPORADA 2016/2017
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 16 B Real Betis 30 99 19 75
2 Peloteros Sierra Sur Sub 16 Peloteros 30 78 35 64
3 Sevilla FC Sub 16 B Sevilla 30 85 33 62
4 CD Alcala Sub 16 Alcala 30 76 33 60
5 CD Utrera Sub 16 Utrera 30 58 33 59
6 Ad Taraguilla Taraguilla 30 87 74 53
7 Córdoba CF B Córdoba 30 47 39 48
8 Don Bosco CF Sub 16 Bosco 30 60 57 39
9 San Fernando Isleño A Fernando 30 50 68 37
10 Atlético Sanluqueño Sub 16 Atlético 30 45 70 35
11 Atlético Seneca Atlético 30 50 63 30
12 CD Deportivo Cordoba CF Deportivo 30 38 68 29
13 Recreativo de Huelva B Recreativo 30 44 85 27
14 CD Siempre Alegres Siempre 30 42 77 26
15 Cd Huelva Atlético Huelva 30 33 77 25
16 Nuevo Molino Sub 16 Nuevo Molino 30 33 94 16
TEMPORADA 2015/2016
2ª ANDALUZA HUELVA CADETE
Equipo PJ GF GC Puntos
1 San Roque de Lepe CD Roque Lepe 30 121 42 72
2 Recreativo de Huelva B Recreativo 30 93 35 68
3 CD Siempre Alegres Siempre 30 82 37 57
4 Aljaraque Aljaraque 30 68 47 55
5 A. Romero A. Romero 30 95 63 55
6 Cartaya A Cartaya A 30 66 42 55
7 Los Rosales Los Rosales 30 69 65 42
8 Bollullos Bollullos 30 75 68 41
9 O. Valverdeña Valverdeña 30 80 95 38
10 San Diego San Diego 30 60 83 38
11 O. Onubense O. Onubense 30 51 71 37
12 1889 Futbol Base y Porteros 1889 Futbol 30 62 69 36
13 Aracena Aracena 30 65 98 32
14 Titan Titan 30 47 79 28
15 Estrella Estrella 30 53 126 18
16 Punta Umbria Punta Umbria 30 33 100 11
TEMPORADA 2014/2015
2ª ANDALUZA HUELVA CADETE
Equipo PJ GF GC Puntos
1 Nuevo Molino Sub 16 Nuevo Molino 30 87 25 75
2 Recreativo de Huelva B Recreativo 30 78 27 67
3 CD Siempre Alegres Siempre 30 73 32 58
4 2001 Porteros 2001 30 77 50 58
5 Punta Umbria Punta Umbria 30 70 55 53
6 San Roque de Lepe CD Roque Lepe 30 73 51 50
7 Cartaya A Cartaya A 30 75 61 49
8 Los Rosales Los Rosales 30 72 66 48
9 Aracena Aracena 30 67 65 42
10 Estrella Estrella 30 59 68 32
11 Aljaraque Aljaraque 30 49 82 32
12 O. Valverdeña Valverdeña 30 68 79 31
13 Isla Cristina Isla 30 43 72 29
14 Almonte Balompie Almonte 30 51 101 24
15 Gibraleon Gibraleon 30 39 68 17
16 At. Onubense Onubense 30 32 111 15

  USO DE MEMORIA  
5,493,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1231
Total Execution Time  0.1244
  CADENA URL  
/historico/Recreativo-Huelva-B
  GET DATOS  
$_GET['/historico/Recreativo-Huelva-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0023  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 = 'Recreativo-Huelva-B' 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.0030  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 = 'Recreativo-Huelva-B' 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=4134 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=4134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4134 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=4134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4134 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=4134 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 70164
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4134 AND type_rel = 2
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1108 AND type_rel = 3
0.0023  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 = '4134' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '4134' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '4134' 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 = 70164 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=4134 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (70164,64285) 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.0020  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64285 AND teamId = 4134
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70164 AND teamId = 4134
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 70164 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '4134' 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 = '4134' 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 = '4134' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4134' and rp.type = 4
0.0027  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 = 4134 AND l.year <= 2023 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 `tables2023_base` 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 = 70164 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_base` 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 = 64285 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.0024  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_base` 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 = 59539 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.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 `tables2019_base` 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 = 45916 AND t.round = 30 ORDER BY team.conference 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 `tables2018_base` 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 = 40562 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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_base` 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 = 34335 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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_base` 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 = 17367 AND t.round = 30 ORDER BY team.conference 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 `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 = 6874 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 70164 ORDER BY nameShow LIMIT 100
0.0103  SELECT c.name,l.categoryId,l.group_code,c.CountryCode,c.alias FROM categories_besoccer c INNER JOIN leagues_besoccer l ON l.categoryId = c.id WHERE c.active_year = l.year AND c.location = 'es' AND (c.ctype = 7) AND c.id != 1108 GROUP BY c.id ORDER BY c.troncal=1 DESC,c.coefficient DESC LIMIT 10