4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Penya Arrabal
TEMPORADA 2022/2023
PREFERENTE BALEAR INFANTIL
Equipo PJ GF GC Puntos
1 Rtvº Mallorca Rtvº 34 153 24 91
2 Atlético Baleares A Atlético 34 126 23 83
3 La Salle Atlético Salle 34 118 28 82
4 San Francisco Francisco 34 129 27 80
5 Manacor Manacor 34 139 30 79
6 Penya Arrabal Penya 34 131 40 75
7 Balears A Balears A 34 76 72 54
8 Constancia Constancia 34 74 73 50
9 Mallorca Mallorca 34 69 68 49
10 Poblense Poblense 34 63 119 43
11 Campos Campos 34 70 80 40
12 Santa Catalina Santa 34 49 87 40
13 Recreativo Son Caliu Recreativo 34 67 75 37
14 San Francisco At Francisco 34 45 117 26
15 CF La Unión A Unión 34 45 143 23
16 Salla Salla 34 40 121 13
17 Ciutat de Palma A Ciutat Palma 34 29 143 9
18 Madre Alberta A Madre 34 22 175 2
TEMPORADA 2021/2022
PREFERENTE BALEAR INFANTIL
Equipo PJ GF GC Puntos
1 Rtvº Mallorca Rtvº 30 135 17 84
2 Balears A Balears A 30 86 19 78
3 Penya Arrabal Penya 28 108 19 75
4 Mallorca Mallorca 30 102 54 60
5 La Salle Atlético Salle 30 61 45 50
6 Ciutat de Palma A Ciutat Palma 30 51 59 45
7 Constancia Constancia 28 49 59 40
8 Manacor Manacor 29 52 54 39
9 Santa Catalina Santa 29 49 63 39
10 Atlético Rafal A Atlético 29 47 62 35
11 San Francisco Francisco 29 44 57 32
12 Poblense Poblense 29 33 61 24
13 Salla Salla 29 37 67 23
14 Madre Alberta A Madre 29 42 72 20
15 Recreativo Son Caliu Recreativo 30 30 90 16
16 CD Espanya CD Espanya 29 19 147 6
TEMPORADA 2020/2021
1ª BALEAR INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Manacor Manacor 8 35 7 21
2 Balears A Balears A 7 38 6 18
3 Penya Arrabal Penya 7 26 6 16
4 Montaura Montaura 8 20 14 16
5 Salla B Salla B 7 16 16 9
6 Alcúdia Atlétic del A Alcúdia 7 12 19 8
7 Atlético Rafal A Atlético 8 11 31 7
8 Madre Alberta A Madre 8 13 19 6
9 Joventut Mallorca Joventut 8 9 33 5
10 UE Alaró UE Alaró 8 9 38 3
TEMPORADA 2019/2020
2ª BALEAR INFANTIL GRUPO 3
Equipo PJ GF GC Puntos
1 Penya Arrabal Penya 15 127 3 45
2 Santanyí CF Santanyí 14 43 26 32
3 Rotlet Molinar Atº Del RM Rotlet 15 29 21 31
4 Pla De NA Tesa Atº del PDNT Tesa Atº PD. 11 38 9 27
5 Murense Murense 14 23 35 16
6 Atº Santa Monica Del SM Atº Santa M. 15 41 57 16
7 Binissalem B Binissalem 16 32 49 16
8 Poblenç Atº Del P Poblenç 14 23 41 16
9 Rtvº Arenal Del A Rtvº Arenal 14 27 65 12
10 Penya Esp. S'Arenal B Penya Esp.. 13 23 61 9
11 Felanitx B Felanitx B 13 16 55 6
TEMPORADA 2018/2019
1ª BALEAR INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Rtvº Mallorca Rtvº 30 184 19 84
2 CD Cide A CD Cide A 30 107 39 70
3 Es Jonquet Penya Arrabal Jonquet 30 63 23 68
4 Penya Arrabal Penya 30 95 37 62
5 Constancia Constancia 30 88 36 60
6 Mallorca Mallorca 30 87 40 59
7 Santa Catalina Atletico Santa 30 68 30 58
8 Recreativo Son Caliu A Recreativo 30 64 45 48
9 Ciutat de Palma A Ciutat Palma 30 67 56 44
10 Joventut Mallorca Joventut 30 41 52 42
11 Son Sardina Son Sardina 30 36 90 22
12 CD Binissalem Binissalem 30 30 95 22
13 Arenal Arenal 30 20 87 18
14 UE Alcúdia UE Alcúdia 30 31 101 15
15 Pla de na Tesa Tesa 30 24 107 14
16 Col San Pedro Pedro 30 13 161 4
TEMPORADA 2017/2018
1ª BALEAR INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Penya Arrabal Penya 30 145 10 88
2 Poblense Poblense 30 111 25 79
3 Es Jonquet Penya Arrabal Jonquet 30 101 30 73
4 Mallorca Mallorca 30 80 36 72
5 Ciutat de Palma A Ciutat Palma 30 88 47 59
6 Olimpic A Olimpic A 30 70 70 50
7 CD Cide A CD Cide A 30 88 56 47
8 San Francisco B Francisco 30 41 63 38
9 UE Alcúdia UE Alcúdia 30 58 92 37
10 Madre Alberta A Madre 30 47 65 33
11 CF La Unión A Unión 30 36 65 30
12 Ferriolense Ferriolense 30 35 69 29
13 Son Caliu Del R.S.C. Caliu R.S.C. 30 48 76 26
14 Pla de na Tesa Tesa 30 44 78 26
15 Juventud Constancia A Juventud 30 30 130 10
16 Pollença i Port Pollença 30 24 134 4
TEMPORADA 2016/2017
1ª BALEAR INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Cide A CD Cide A 30 178 22 84
2 Mallorca Mallorca 30 105 31 63
3 Ferriolense Ferriolense 30 96 34 62
4 Penya Arrabal Penya 30 103 24 60
5 Es Jonquet Penya Arrabal Jonquet 30 105 41 60
6 Santa Catalina Santa 30 107 37 58
7 Poblense Poblense 30 72 59 48
8 San Francisco B Francisco 30 65 42 45
9 CF La Unión A Unión 30 71 51 43
10 Atletico Rafal Atletico 30 83 69 41
11 S'horta Atlético A S'horta 30 69 70 41
12 Salla Salla 30 52 61 34
13 Joventut Mallorca Joventut 30 37 108 21
14 Olimpic A Olimpic A 30 31 111 12
15 Es Raval de Santa C Raval Santa 30 26 194 12
16 Col San Pedro Pedro 30 10 255 0
TEMPORADA 2015/2016
1ª BALEAR INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Es Jonquet Penya Arrabal Jonquet 30 162 16 86
2 Poblense Poblense 30 111 35 71
3 Penya Arrabal Penya 30 113 36 67
4 San Francisco Francisco 30 79 27 64
5 Constancia Constancia 30 90 39 63
6 Ferriolense Ferriolense 30 100 39 61
7 Ciutat de Palma A Ciutat Palma 30 67 48 52
8 Atletico Rafal Atletico 30 60 48 40
9 Atlético Baleares A Atlético 30 45 71 38
10 Arenal Arenal 30 53 78 37
11 CD Espanya CD Espanya 30 62 87 34
12 Escolar Escolar 30 53 90 31
13 Atlético Son Ferriol Atlético 30 36 98 17
14 Es Pla Es Pla 30 38 133 14
15 Recreativo Son Caliu A Recreativo 30 22 149 8
16 Campos Campos 30 27 124 8
TEMPORADA 2014/2015
1ª BALEAR INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Penya Arrabal Penya 29 164 16 80
2 Manacor Manacor 30 82 16 76
3 CD Cide A CD Cide A 30 92 20 72
4 Atlético Baleares A Atlético 30 78 35 54
5 San Francisco Francisco 30 63 42 54
6 Ferriolense Ferriolense 29 64 42 52
7 Constancia Constancia 30 78 54 49
8 San Pedro Col. Pedro Col. 30 61 60 49
9 Atletico Rafal Atletico 29 37 60 38
10 Pla ES Pla ES 29 31 39 34
11 Arenal Arenal 30 39 60 31
12 Escolar Escolar 30 44 72 28
13 Sant Marçal Sp. Sant Marçal 30 46 104 21
14 Recreativo Penya Arrabal Recreativo 30 20 75 20
15 UE Alcúdia UE Alcúdia 30 22 79 14
16 Son Oliva Son Oliva 26 7 154 4

  USO DE MEMORIA  
5,606,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5438
Total Execution Time  0.5450
  CADENA URL  
/historico/Penya-Arrabal-Infantil
  GET DATOS  
$_GET['/historico/Penya-Arrabal-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0130  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 = 'Penya-Arrabal-Infantil' 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.0143  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 = 'Penya-Arrabal-Infantil' 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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29925 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29925 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2503 AND type_rel = 3
0.0139  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 = '29925' ORDER BY l.year DESC,cat.coefficient DESC
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 = '29925' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '29925' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=29925 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (69187) 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.0129  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69187 AND teamId = 29925
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 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 = 69187 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135  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 = '29925' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29925' and rp.type = 4
0.0137  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 = '29925' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0143  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 = 29925 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 69187 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.0141  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 = 64747 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.0137  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 = 61066 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.0139  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 = 54151 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.0136  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 = 44860 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 39308 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 34414 AND t.round = 30 ORDER BY team.conference 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 `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 = 17606 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 5190 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC