4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rotlet Molinar B
TEMPORADA 2019/2020
2ª BALEARES ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Rafal B Atlético 21 96 43 59
2 Patronato A Patronato A 21 107 31 51
3 Campusesport Atº D CE Campusesport 21 138 48 50
4 Madre Alberta Atº DMA A Madre 21 81 40 48
5 Santa Maria del Uesm Santa Maria 21 109 57 45
6 Son Sardina AT DSS Sardina 21 93 61 35
7 Rotlet Molinar B Rotlet 21 57 67 31
8 Son Ferrer Del PC Ferrer 21 63 80 31
9 Sant Jordi B Sant Jordi 21 84 55 30
10 La Real de Lu A Real 21 71 68 27
11 Rec. Arenal A Rec. Arenal 21 64 78 26
12 Rtvº Penya Arrabal C Rtvº Penya 19 58 84 20
13 La Salle Atlético B Salle 21 48 80 14
14 SP AT Ciutat de Palma A Ciutat Palma 19 32 72 13
15 Collerense B Collerense 21 20 125 3
16 San Pedro Atletico Pedro 21 37 169 3
TEMPORADA 2018/2019
2ª BALEARES ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 Mercat de Santa Catalina Cl Mercat Santa 30 117 50 69
2 Penya Arrabal C Penya 30 129 43 66
3 Atlético Rafal B Atlético 30 122 62 64
4 Atletic Es Liceu Atletic 30 119 58 62
5 Recreativo S'indioteria Recreativo 30 129 63 60
6 Patronato B Patronato B 30 131 60 56
7 Cide B Cide B 30 114 69 55
8 La Real de Lu B Real 30 123 113 53
9 Son Sardina B Sardina 30 127 82 52
10 San Francisco B Francisco 30 97 84 45
11 Arenal B Arenal B 30 70 96 38
12 Rotlet Molinar B Rotlet 30 60 116 23
13 Col. San Pedro Alevin Col. Pedro. 30 60 133 16
14 Sant Jordi B Sant Jordi 30 53 141 16
15 Son Ferrer Son Ferrer 30 50 193 11
16 Juventud S O Atlético Juventud 30 33 171 7
TEMPORADA 2017/2018
2ª BALEARES ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 CE Andratx A Andratx 26 108 49 61
2 Santa Monica Santa Monica 26 150 54 60
3 Mercat de Santa Catalina Cl Mercat Santa 26 141 64 57
4 La Real de Lu B Real 26 114 50 54
5 Atlético San Cayetano Atlético 26 132 72 54
6 Son Sardina B Sardina 26 104 39 53
7 Recreativo Penya Arrabal B Recreativo 26 100 94 45
8 Recreativo S'indioteria Recreativo 26 90 78 41
9 Recreativo Arenal del A B Recreativo 26 90 93 33
10 La Real de Lu A Real 26 70 76 28
11 Juventud S O Atlético B Juventud 26 56 99 20
12 Rotlet Molinar B Rotlet 26 51 176 16
13 Atlético Camp Redo Industri Atlético 26 59 192 7
14 Collerense B Collerense 26 32 161 1
TEMPORADA 2016/2017
1ª BALEARES ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 Atlético Ciutat de Palma B Atlético 30 145 45 77
2 Pollença I Port FC Pollença 30 140 59 69
3 Cide B Cide B 30 138 65 63
4 Felanitx Felanitx 30 96 42 61
5 Balears B Balears B 30 111 70 60
6 CD Atlético Manacor Atlético 30 96 87 49
7 Atlético La Union Atlético 30 88 82 47
8 C. Atlético Cide B Atlético 30 105 82 43
9 Escolar Escolar 30 82 92 39
10 Consell Consell 30 76 97 39
11 Urbanitzacions Urbanitzacio 30 83 124 35
12 Sant Marcal B Sant Marcal 30 96 121 34
13 UD Alaró UD Alaró 30 81 139 30
14 Valldemossa Atlético Valldemossa 30 61 125 22
15 Rotlet Molinar B Rotlet 30 68 117 18
16 Àgora Portals B Àgora 30 66 185 4
TEMPORADA 2015/2016
2ª BALEARES ALEVÍN GRUPO 7
Equipo PJ GF GC Puntos
1 Sant Jordi A Sant Jordi 30 190 20 86
2 CD San Cayetano B Cayetano 30 173 29 78
3 AD Santa Catalina A Santa 30 207 43 77
4 Independiente C/R Independient 30 209 62 68
5 Atlético Son Ferriol A Atlético 30 109 63 58
6 Estudiantes Del PS A Estudiantes 30 132 63 57
7 La Real de Lu A Real 30 132 48 55
8 Atlético Rafal B Atlético 30 132 108 51
9 Rotlet Molinar B Rotlet 30 128 113 36
10 SP San Francisco Francisco 30 97 136 34
11 Madre Alberta Atlético Dma Madre 30 88 127 31
12 Recreativo S'indioteria Drl Recreativo 30 78 169 29
13 Patronato B Patronato B 30 73 195 17
14 Genova Genova 30 38 212 11
15 Collerense B Collerense 30 34 255 7
16 Son Sardina B Sardina 30 31 203 4
TEMPORADA 2014/2015
2ª BALEARES ALEVÍN GRUPO 6
Equipo PJ GF GC Puntos
1 Recreativo Penya Arrabal A Recreativo 30 240 33 81
2 Santa Catalina Atlético B Santa 30 144 57 72
3 La Victoria B Victoria 30 142 33 70
4 Rotlet Molinar B Rotlet 30 171 77 59
5 Atlético Camp Redo Industri Atlético 30 130 61 58
6 Son Cladera Atlético del Sc Cladera 30 125 85 56
7 Sant Jordi A Sant Jordi 30 111 75 55
8 Atlético San Cayetano A Atlético 30 111 79 52
9 Recreativo Marratxí del Atm Recreativo 30 106 67 48
10 Recreativo Rafal del Atr Recreativo 30 66 150 33
11 Genova B Genova B 30 66 131 24
12 Recreativo Patronato Atléti Recreativo 30 51 148 21
13 Son Oliva Atlético A Oliva 30 61 178 19
14 Collerense Collerense 30 63 181 18
15 Atlético Son Ferriol B Atlético 30 39 134 15
16 La Unión CF B Unión 30 44 181 14

  USO DE MEMORIA  
5,207,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1000
Total Execution Time  0.1012
  CADENA URL  
/historico/Rotlet-Molinar-B-Alevin
  GET DATOS  
$_GET['/historico/Rotlet-Molinar-B-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0025  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 = 'Rotlet-Molinar-B-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.0027  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 = 'Rotlet-Molinar-B-Alevin' 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.0017  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=35654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=35654 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=35654 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=35654 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=35654 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=35654 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=35654 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=35654 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 54160
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=35654 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=982 AND type_rel = 3
0.0020  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 = '35654' ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '35654' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '35654' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '35654' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 54160 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=35654 AND l.year in (2019,2020,2021) 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 (54160) 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_base WHERE league_id = 54160 AND teamId = 35654
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 54160 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '35654' 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 = '35654' and rp.type = 4
0.0020  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 = '35654' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 35654 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 54160 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.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 `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 = 44879 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 44878 AND t.round = 30 ORDER BY team.conference 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 `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 = 39290 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 35434 AND t.round = 30 ORDER BY team.conference 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 `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 = 17991 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 `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 = 6483 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 54160 ORDER BY nameShow LIMIT 100