4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Alqueria
TEMPORADA 2023/2024
1ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Consell Consell 30 85 22 70
2 Son Sardina Son Sardina 29 79 44 62
3 Juv Can Picafort Picafort 28 66 25 60
4 Port de Soller Port Soller 29 59 38 55
5 Cardassar B Cardassar B 29 63 41 51
6 Unió Esportiva Sta Maria Unió 28 49 33 50
7 Soller B Soller B 28 58 52 45
8 Constancia B Constancia 29 50 53 38
9 Maria de la Salut Maria Salut 29 44 50 37
10 Montaura Montaura 29 65 61 37
11 Atlético Rafal B Atlético 29 56 63 35
12 San Roque San Roque 29 41 61 31
13 Atlético Marratxí Atlético 29 54 74 29
14 Viva Sports Viva Sports 29 53 91 22
15 Alqueria Alqueria 29 34 95 11
16 Margaritense AtlÈtic Margaritense 13 7 60 0
TEMPORADA 2022/2023
PREFERENTE BALEARES GRUPO 6
Equipo PJ GF GC Puntos
1 Calvia Calvia 40 62 61 53
2 Esporles Esporles 40 64 58 53
3 UE Petra UE Petra 40 62 62 52
4 Indep. Camp Redó Indep. Camp 40 77 80 51
5 Murense Murense 40 60 49 50
6 S´Horta S´Horta 40 66 70 50
7 Son Sardina Son Sardina 40 60 88 37
8 CD Génova CD Génova 40 73 128 24
9 Alqueria Alqueria 40 27 104 20
10 Arta Arta 40 44 130 18
TEMPORADA 2021/2022
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Inter Manacor Inter 38 66 36 75
2 CD Sant Jordi Sant Jordi 38 71 39 71
3 Porreres Porreres 38 70 40 70
4 Cardassar Cardassar 38 55 32 69
5 Sineu Sineu 38 66 39 68
6 Recreativo La Victoria Recreativo 38 56 45 63
7 Ferriolense Ferriolense 38 45 42 63
8 UE Alcudia UE Alcudia 38 64 40 62
9 CD Génova CD Génova 38 60 43 61
10 CE Xilvar CE Xilvar 38 51 47 60
11 Santa Catalina Atlético Santa 38 52 41 53
12 UD Alaró UD Alaró 38 64 47 51
13 CD Son Cladera Cladera 38 42 43 48
14 UE Petra UE Petra 38 51 60 45
15 Calvia Calvia 38 49 63 42
16 Arta Arta 37 52 80 38
17 Alqueria Alqueria 37 38 70 35
18 Pla de Na Tesa Tesa 38 52 90 30
19 Son Sardina Son Sardina 38 47 95 26
20 Esporles Esporles 38 37 96 19
TEMPORADA 2020/2021
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Rotlet Molinar Rotlet 18 25 9 38
2 Murense Murense 18 25 11 37
3 Sineu Sineu 18 36 21 29
4 Serverense Serverense 18 30 23 29
5 UD Alaró UD Alaró 18 23 29 22
6 Alqueria Alqueria 18 20 28 22
7 CE Xilvar CE Xilvar 18 26 26 21
8 Cala Millor Cala Millor 18 18 33 20
9 Atletico Rafal Atletico 18 19 25 18
10 La Unión CF Unión 18 18 35 13
TEMPORADA 2019/2020
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Alqueria Alqueria 26 48 27 54
2 Son Sardina Son Sardina 27 67 45 53
3 Indep. Camp Redó Indep. Camp 27 67 53 45
4 CF Pollença Pollença 27 44 40 44
5 Algaida Algaida 25 48 26 43
6 Calvia Calvia 23 54 31 42
7 Recreativo La Victoria Recreativo 27 45 37 42
8 Santa Mónica Santa 27 58 51 40
9 Serralta Serralta 26 54 40 38
10 Ce Campanet Ce Campanet 26 51 54 38
11 Consell Consell 26 54 72 37
12 Vilafranca Vilafranca 25 48 38 36
13 S´Horta S´Horta 26 35 51 35
14 Pla de Na Tesa Tesa 26 58 48 34
15 Espanya Espanya 27 26 43 30
16 UD Arenal UD Arenal 25 41 36 29
17 Platges de Calvià B Platges 27 35 51 24
18 Port de Soller Port Soller 26 33 56 22
19 Sporting Sant Marçal Sporting 26 30 53 21
20 Montaura Montaura 27 34 78 21
TEMPORADA 2018/2019
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Santa Mónica Santa 38 100 43 90
2 Calvia Calvia 38 88 34 82
3 Vilafranca Vilafranca 38 108 58 80
4 Serralta Serralta 38 99 57 71
5 Alqueria Alqueria 37 78 58 63
6 Athetic Club Montuiri Athetic Club 38 80 50 62
7 UE Lloret UE Lloret 37 66 50 59
8 CD Binissalem B Binissalem 37 65 53 58
9 Establiments Establiments 38 65 57 57
10 CE Escolar CE Escolar 38 64 69 49
11 Constancia B Constancia 38 62 58 47
12 Portol Portol 38 62 71 45
13 Soller B Soller B 38 68 83 43
14 Pilares La Soledad Pilares 38 67 85 42
15 Juv Can Picafort Picafort 38 51 76 42
16 Poblense B Poblense B 38 38 72 39
17 Valldemossa Atl Valldemossa 38 57 86 36
18 Margaritense AtlÈtic Margaritense 38 44 70 35
19 Palmanyola Palmanyola 38 41 102 27
20 Porto Cristo Porto Cristo 37 37 108 18
TEMPORADA 2017/2018
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Porreres Porreres 38 108 28 92
2 Algaida Algaida 38 105 46 91
3 Santa Mónica Santa 38 97 40 78
4 Vilafranca Vilafranca 37 90 57 74
5 CE Escolar CE Escolar 38 88 56 73
6 Athetic Club Montuiri Athetic Club 37 80 57 69
7 Alqueria Alqueria 38 65 57 62
8 Constancia B Constancia 38 77 64 58
9 Serralta Serralta 37 72 87 49
10 Soller B Soller B 38 59 62 49
11 Margaritense AtlÈtic Margaritense 38 54 65 48
12 Porto Cristo Porto Cristo 37 62 76 47
13 UE Lloret UE Lloret 38 68 85 43
14 Calvia Calvia 37 57 69 42
15 Atlético de Paguera Atlético 38 66 96 40
16 Santanyi DS Santanyi DS 38 46 78 37
17 Portol Portol 38 49 77 36
18 Pilares La Soledad Pilares 38 56 113 35
19 San Cayetano Cayetano 37 47 79 33
20 Atlético Marratxí Atlético 38 50 104 20
TEMPORADA 2016/2017
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
TEMPORADA 2015/2016
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Bunyola Bunyola 38 102 29 90
2 Son Veri Son Veri 38 112 64 78
3 CF Pollença Pollença 37 98 49 70
4 Establiments Establiments 38 72 52 69
5 Montaura Montaura 38 72 42 66
6 Baleares Sin Fronteras Baleares 35 73 49 65
7 UEF Santa María Santa María 37 79 58 62
8 Llucmajor Llucmajor 38 70 54 59
9 Athetic Club Montuiri Athetic Club 38 75 58 58
10 Portol Portol 38 76 67 58
11 Algaida Algaida 38 68 65 57
12 Soller B Soller B 38 65 67 54
13 Alqueria Alqueria 37 76 73 49
14 Serralta Serralta 38 67 80 48
15 Porto Cristo Porto Cristo 38 67 89 46
16 Vilafranca Vilafranca 38 73 93 38
17 San Cayetano Cayetano 38 57 90 36
18 Santanyi DS Santanyi DS 37 40 92 29
19 Sporting Valldemossa Sporting 38 55 101 25
20 Son Ferrer Son Ferrer 35 32 157 6
TEMPORADA 2014/2015
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Valldemossa Atl Valldemossa 37 101 40 80
2 Son Sardina Son Sardina 37 85 38 80
3 Cala Millor Cala Millor 36 78 51 67
4 Llucmajor Llucmajor 37 58 41 64
5 Llosetense C Llosetense 36 76 55 62
6 Baleares Sin Fronteras Baleares 36 71 47 59
7 Maria de la Salut Maria Salut 36 79 66 57
8 Serralta Serralta 36 71 57 56
9 Soller B Soller B 36 63 55 55
10 Montaura Montaura 36 65 61 55
11 Porto Cristo Porto Cristo 36 50 49 54
12 San Cayetano Cayetano 37 72 79 49
13 UEF Santa María Santa María 37 64 78 42
14 Bunyola Bunyola 36 44 62 37
15 Vilafranca Vilafranca 37 68 89 37
16 Alqueria Alqueria 37 75 88 34
17 Sporting Valldemossa Sporting 36 63 98 33
18 Son Ximelis Son Ximelis 37 43 80 29
19 Poblense B Poblense B 37 50 111 28
20 Pollença B Pollença B 9 7 38 4

  USO DE MEMORIA  
6,007,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.8747
Total Execution Time  0.8759
  CADENA URL  
/historico/Alqueria
  GET DATOS  
$_GET['/historico/Alqueria']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
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 = 'Alqueria' 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=18553 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=18553 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0299  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 = 73783
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18553 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=686 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 686 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0152  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 (1104898,627067,564570) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '18553' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0154  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 = '18553' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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 = 73783 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0165  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=18553 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (73783,71378) 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.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 71378 AND teamId = 18553
0.0163  SELECT count(id) as num_players from rel_players WHERE league_id = 73783 AND teamId = 18553
0.0154  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 = 73783 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0151  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 = '18553' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18553' and rp.type = 4
0.0156  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 = '18553' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0200  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 18553 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 18553 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 18553 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 18553 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` 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 = 73783 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.0153  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` 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 = 68764 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.0153  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` 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 = 71378 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.0155  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` 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 = 63634 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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` 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 = 58942 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.0153  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` 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 = 51289 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.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 `tables2019` 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 = 44635 AND t.round = 38 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` 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 = 39185 AND t.round = 38 ORDER BY team.conference 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 `tables2017` 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 = 34312 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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` 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 = 16795 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 3983 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 73783 ORDER BY nameShow LIMIT 100