4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Camas Sub 8
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla Sub 8 Sevilla 28 244 16 84
2 Real Betis Balompie Sub 8 Real Betis. 28 184 47 72
3 UD Tomares Sub 8 Tomares 28 153 57 71
4 San Roque Balompie Sub 8 Roque 28 120 67 56
5 AAVV Centro Histórico Sub 8 AAVV Centro 27 107 79 55
6 Castilleja Sub 8 Castilleja 28 80 81 45
7 Coria CF Sub 8 Coria 28 92 109 45
8 Umbrete Sub 8 Umbrete 28 82 96 41
9 Camas Sub 8 Camas Sub 8 27 71 86 33
10 AD Dani Triana Sub 8 Dani Triana 28 79 116 30
11 Lora CF Sub 8 Lora 28 75 129 23
12 Calavera CF Sub 8 Calavera 28 53 107 22
13 Loreto Sub 8 Loreto 28 54 143 20
14 Atlético Algabeño Sub 8 Atlético 28 44 121 16
15 Colegio Claret Sub 8 Colegio 28 71 173 16
16 Juventud Dva. Gines Sub 8 Juventud 28 40 122 12
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 255 11 90
2 UD Tomares Sub 8 Tomares 29 156 80 70
3 Sevilla Sub 8 B Sevilla 30 136 74 63
4 San Roque Balompie Sub 8 Roque 30 143 69 57
5 Umbrete Sub 8 Umbrete 30 107 82 57
6 Camas Sub 8 Camas Sub 8 30 114 77 55
7 Loreto Sub 8 Loreto 30 92 70 51
8 Coria CF Sub 8 Coria 30 137 102 49
9 David Castedo 3 (DC 3) David 30 110 128 43
10 Lora CF Sub 8 Lora 30 89 128 37
11 Montequinto Sub 8 Montequinto 30 98 104 36
12 Castilleja Sub 8 Castilleja 30 82 128 28
13 SAM-CAM Dos Hermanas Sub 8 SAM-CAM 30 84 145 26
14 Cud Santiponce Sub 10 Santiponce 29 69 182 13
15 Municipal de Gerena Sub 10 Municipal 30 49 230 9
16 CD Esfubasa Sub 10 Esfubasa 30 52 203 7
TEMPORADA 2021/2022
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Cud Santiponce Sub 10 Santiponce 30 138 47 75
2 CD Atlético San Martin Atlético 30 130 52 72
3 Umbrete Sub 8 Umbrete 30 135 67 68
4 Albaida benjamin a Albaida 30 110 87 57
5 Juventud Gines Juventud 29 107 68 53
6 Atletico Sanlucar CF Atletico 30 109 85 50
7 Tomares B Tomares B 30 92 78 49
8 CD FB Juventud Deportiva Juventud 30 105 95 48
9 Tor del Rey de Pilas Pilas 30 97 101 42
10 Camino Viejo A Camino Viejo 30 101 110 40
11 Villafranco Villafranco 30 94 101 36
12 Camas Sub 8 Camas Sub 8 30 64 86 34
13 Mairena del Aljarafe Sub 10 Mairena 30 88 114 34
14 Castilleja Sub 8 Castilleja 29 63 144 19
15 AAVV Centro Histórico Sub 8 AAVV Centro 30 46 132 10
16 Benacazon Benacazon 30 34 146 7
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 6
Equipo PJ GF GC Puntos
1 Mairena del Aljarafe Sub 10 Mairena 8 36 15 22
2 Salteras A Salteras A 8 35 20 22
3 Camas Sub 8 Camas Sub 8 8 50 20 21
4 AD Dani Triana Sub 8 Dani Triana 7 46 17 21
5 Club Polideportivo Bormujos Club 8 23 21 15
6 CD Antonio Puerta A Antonio 10 21 33 6
7 CD Esfubasa Sub 10 Esfubasa 10 25 37 4
8 Municipal de Gerena Sub 10 Municipal 9 23 44 3
9 Alcala del Rio Sub 10 Alcala 10 24 76 1
TEMPORADA 2019/2020
2ª SEVILLA BENJAMIN (2ª FASE) GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 9 108 3 27
2 AD Dani Triana Sub 8 Dani Triana 9 20 25 16
3 Aficionado Écija Sub 8 Aficionado 9 32 51 15
4 CD Asoc. Dva. Nervion B Asoc. Dva.. 9 21 32 13
5 UD Tomares Sub 8 Tomares 9 17 34 13
6 Pablo VI Sub 8 Pablo 9 13 23 10
7 Camas Sub 8 Camas Sub 8 9 24 45 6
8 Utrera Sub 8 Utrera 9 11 33 6
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 14 166 7 42
2 Coria CF Sub 8 Coria 14 55 42 31
3 Tomares Tomares 14 68 38 25
4 Castilleja Sub 8 Castilleja 14 63 48 24
5 Camas Sub 8 Camas Sub 8 14 49 46 22
6 San Martin San Martin 14 28 57 11
7 Olivarense Atletico Olivarense 14 30 104 7
8 Loreto Sub 8 Loreto 14 20 137 3
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 8
Equipo PJ GF GC Puntos
1 Camas Sub 8 Camas Sub 8 14 46 10 37
2 Atletico Oromana Atletico 14 61 39 31
3 Utrera CD Utrera CD 14 59 30 26
4 CD Esfubasa Sub 10 Esfubasa 14 62 17 25
5 Municipal de Gerena Sub 10 Municipal 14 43 42 20
6 Circulo Don Bosco Circulo 14 38 38 14
7 Alcosa Pol. Alcosa Pol. 14 31 68 8
8 Diablos Rojos Diablos 14 6 102 0
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 2
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 30 255 24 86
2 Real Betis Balompié B Real Betis. 30 170 36 79
3 AD Dani Triana Sub 8 Dani Triana 30 164 55 68
4 Asociación Nervion Sub 8 Asociación 30 108 55 66
5 AAVV Centro Histórico Sub 8 AAVV Centro 30 106 54 66
6 Circulo Don Bosco Circulo 30 104 76 50
7 Coria CF Sub 8 Coria 30 88 78 50
8 Camas Sub 8 Camas Sub 8 30 97 84 41
9 Tomares Tomares 30 100 109 40
10 Diez Sanlucar Diez 30 86 94 33
11 CD Esfubasa Sub 10 Esfubasa 30 64 101 33
12 Municipal de Gerena Sub 10 Municipal 30 84 146 31
13 San Martin San Martin 30 63 181 25
14 Calavera CF Sub 8 Calavera 30 49 151 16
15 Gelves Gelves 30 36 213 9
16 El Pilar El Pilar 30 22 178 2

  USO DE MEMORIA  
5,276,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5815
Total Execution Time  0.5828
  CADENA URL  
/historico/Camas-Cf-Benjamin
  GET DATOS  
$_GET['/historico/Camas-Cf-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0155  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 = 'Camas-Cf-Benjamin' 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=33300 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=33300 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0295  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 = 74452
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=33300 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=855 AND type_rel = 3
0.0148  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 = '33300' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '33300' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '33300' 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 = 74452 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=33300 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (74452) 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_base WHERE league_id = 74452 AND teamId = 33300
0.0146  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 = 74452 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '33300' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '33300' 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 = '33300' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0149  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 = 33300 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_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 = 74452 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_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 = 69680 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.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 `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 = 64499 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 64504 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_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 = 60680 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.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 `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 = 60704 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.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_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 = 62292 AND t.round = 10 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 `tables2020_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 = 53312 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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_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 = 55279 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 44980 AND t.round = 14 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_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 = 42869 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 = 34837 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 = 74452 ORDER BY nameShow LIMIT 100