4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Montequinto Sub 12
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 28 183 36 73
2 Sevilla Sub 12 B Sevilla 28 167 39 73
3 Doctor Fleming Sub 12 Doctor 28 117 40 65
4 Castilleja Sub 12 Castilleja 28 101 47 65
5 Camas CF Sub 12 Camas 28 115 61 54
6 San Roque Balompie Sub 12 Roque 28 111 72 50
7 Coria Sub 12 Coria 28 126 81 49
8 Juventud Gines Sub 12 Juventud 28 112 83 47
9 Umbrete Sub 12 Umbrete 28 105 89 40
10 Tomares Sub 12 B Tomares 28 90 125 30
11 Atletico Sanlucar Sub 12 Atletico 28 85 89 27
12 Montequinto Sub 12 Montequinto 28 63 136 27
13 Guillena Sub 12 Guillena 28 40 142 16
14 La Liara Sub 12 Liara 28 40 128 15
15 El Pilar Sub 12 Pilar 28 34 167 7
16 Mairena Del Aljarafe Sub 12 Mairena 28 51 205 6
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 207 34 85
2 Sevilla Sub 12 B Sevilla 30 137 54 69
3 Tomares Sub 12 B Tomares 30 96 48 68
4 Castilleja Sub 12 Castilleja 30 100 55 64
5 San Roque Balompié Sub 12 B Roque 30 99 74 58
6 Camas CF Sub 12 Camas 30 88 92 49
7 Montequinto Sub 12 Montequinto 30 87 101 40
8 La Liara Sub 12 Liara 30 108 125 38
9 Coria Sub 12 Coria 30 87 99 36
10 Doctor Fleming Sub 12 Doctor 30 77 117 33
11 Umbrete Sub 12 Umbrete 30 68 97 31
12 Juventud Gines Sub 12 Juventud 30 56 98 30
13 Mairena Del Aljarafe Sub 12 Mairena 30 78 113 29
14 Lora Lora 30 68 122 25
15 Sededos Sededos 30 45 83 24
16 Atlético Algabeño Atlético 30 33 122 11
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 169 24 85
2 San Roque Balompie Sub 12 Roque 29 183 43 76
3 Sevilla Sub 12 Sevilla 30 149 66 66
4 Montequinto Sub 12 Montequinto 30 101 73 54
5 Coria Sub 12 Coria 30 93 67 53
6 Tomares Sub 12 Tomares 30 108 57 52
7 Juventud Gines Sub 12 Juventud 30 104 97 48
8 Castilleja Sub 12 Castilleja 30 94 113 39
9 Camas A Camas A 29 80 112 35
10 C. Claret A C. Claret A 30 88 123 29
11 AD Dani Triana Ar Rabad A Dani Triana 30 67 123 29
12 Umbrete Sub 12 Umbrete 30 60 139 27
13 Bellavista A Bellavista 30 64 149 25
14 Asociación Nervion Sub 12 B Asociación 30 68 123 24
15 Sededos Sededos 28 62 89 23
16 Atlético Antoniano Atlético 30 54 146 18
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 10 89 10 30
2 Real Betis Sub 12 B Real Betis 10 60 17 24
3 SAM-CAM Sub 12 SAM-CAM 10 52 28 22
4 Sededos Sededos 10 23 34 12
5 Utrera Sub 12 Utrera 10 25 39 12
6 Aficionado de Ecija Sub 12 Aficionado 10 34 43 11
7 Mosquito Sub 12 Mosquito 10 30 48 11
8 Pablo VI A Pablo VI A 10 22 46 7
9 San Roque Balompié Sub 12 B Roque 10 24 70 7
10 Montequinto Sub 12 Montequinto 10 27 51 6
TEMPORADA 2019/2020
2ª SEVILLA ALEVÍN (2ª FASE) GRUPO 3
Equipo PJ GF GC Puntos
1 Camas CF Sub 12 Camas 9 27 13 23
2 Montequinto Sub 12 Montequinto 9 28 17 18
3 Umbrete Sub 12 Umbrete 9 27 28 16
4 Andalucia Este Andalucia 9 18 15 15
5 Consolacion Consolacion 9 25 29 12
6 Colegio Claret Sub 12 Colegio 9 28 31 10
7 Union Balompedica Lebrijana Union 9 21 26 9
8 Pablo VI Pablo VI 9 14 29 0
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 14 177 6 42
2 Tomares Tomares 14 70 28 33
3 CD Antonio Puerta Sub 12 Antonio 14 88 54 26
4 Montequinto Sub 12 Montequinto 14 41 51 23
5 SAM-CAM Sub 12 SAM-CAM 14 51 67 21
6 Circulo Don Bosco Circulo 14 44 51 13
7 El Pilar El Pilar 14 16 125 6
8 AD San José Sub 12 José 14 16 121 0
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 14 117 14 42
2 Centro Historico Sub 12 Centro 14 32 29 25
3 Sededos Sededos 14 36 39 25
4 Coria Sub 12 Coria 14 39 42 21
5 Circulo Don Bosco Circulo 14 39 55 19
6 Asociación Nervion Sub 12 B Asociación 14 45 45 17
7 Montequinto Sub 12 Montequinto 14 22 43 12
8 Jose Antonio Luque Jose Antonio 14 17 80 3
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 30 255 25 86
2 N. Sevilla A Sevilla 30 187 67 74
3 Coria Sub 12 Coria 30 142 70 66
4 Asociación Nervion A Asociación 30 145 74 66
5 La Liara Sub 12 Liara 30 92 67 59
6 Sededos Sededos 30 107 61 55
7 Tomares Tomares 30 105 116 47
8 Montequinto Sub 12 Montequinto 30 96 93 42
9 AD San José Sub 12 José 30 101 111 42
10 Olivarense Atletico Olivarense 30 94 108 34
11 SAM-CAM Sub 12 SAM-CAM 30 90 113 32
12 Diez Sanlucar Diez 30 57 125 25
13 Camas Camas 30 82 151 23
14 Tor del Rey de Pilas Pilas 30 60 141 23
15 Atlético Algabeño Atlético 30 37 188 11
16 Benacazon Benacazon 30 45 189 9
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA ALEVÍN
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 30 255 20 88
2 Sevilla Sub 12 Sevilla 30 255 35 85
3 Asociación Nervion Sub 12 B Asociación 30 147 69 70
4 CD Antonio Puerta Sub 12 Antonio 30 130 81 66
5 Coria Sub 12 Coria 30 113 91 55
6 Tomares Tomares 30 79 80 51
7 Montequinto Sub 12 Montequinto 30 96 90 46
8 Sededos Sededos 30 83 74 45
9 AD San José Sub 12 José 30 83 116 42
10 Utrera Sub 12 Utrera 30 71 130 30
11 Lora C.F Lora C.F 30 64 95 30
12 CD Alcala CD Alcala 30 94 153 28
13 El Pilar El Pilar 30 68 141 27
14 La Liara Sub 12 Liara 30 60 157 20
15 C.D. BORMUJOS S.M. C.D. 30 28 158 5
16 Betisevilla Betisevilla 30 41 255 3

  USO DE MEMORIA  
5,400,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  2.5626
Total Execution Time  2.5646
  CADENA URL  
/historico/Cd-Montequinto-Alevin
  GET DATOS  
$_GET['/historico/Cd-Montequinto-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.2384  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 = 'Cd-Montequinto-Alevin' 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.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=73811 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=73811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 74449
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=73811 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=470 AND type_rel = 3
0.0812  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 470 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0439  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 (658127,72746) ORDER BY n.cover_points DESC, update_date DESC
0.1272  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 = '73811' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.2261  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 = '73811' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0103  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 = 74449 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0779  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=73811 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0120  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 (74449) 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.0073  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74449 AND teamId = 73811
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 `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 = 74449 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0428  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 = '73811' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0236  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '73811' 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 = '73811' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.1556  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 = 73811 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0789  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 = 74449 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.1439  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 = 69673 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.0489  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 = 64486 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.4359  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 = 64479 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.0261  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 = 60530 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.0807  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 = 60542 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.0828  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 = 60607 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.0338  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 = 62287 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.0670  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 = 53982 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.0849  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 = 53960 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.0218  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 = 55289 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.0460  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 = 44976 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0549  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 = 42081 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0204  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 = 42861 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0472  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 = 34537 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1908  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 = 17854 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC