4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Celtic Pulianas
TEMPORADA 2023/2024
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Alfacar UD Alfacar UD 0 0 0 0
2 Atlético Monachil Atlético 0 0 0 0
3 CD Dúrcal CD Dúrcal 0 0 0 0
4 CD Santa Fe CD Santa Fe 0 0 0 0
5 Celtic Pulianas Celtic 0 0 0 0
6 Cf Villanueva Mesia Villanueva 0 0 0 0
7 Ciudad de Baza Ciudad Baza 0 0 0 0
8 Cubillas FC Cubillas FC 0 0 0 0
9 Cullar Vega Cullar Vega 0 0 0 0
10 Gabia Gabia 0 0 0 0
11 Guadix CF Guadix CF 0 0 0 0
12 Puerto de Motril Puerto 0 0 0 0
13 Purullena CF Purullena 0 0 0 0
14 Salar CF Salar CF 0 0 0 0
15 UD Maracena B Maracena 0 0 0 0
16 Vandalia Vandalia 0 0 0 0
TEMPORADA 2022/2023
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Churriana de la Vega Churriana 30 79 22 68
2 Loja Loja 30 66 21 63
3 Vandalia Vandalia 30 54 36 54
4 Puerto de Motril Puerto 30 56 35 51
5 CD Santa Fe CD Santa Fe 30 73 43 51
6 Salar CF Salar CF 30 46 39 50
7 Cullar Vega Cullar Vega 30 60 36 48
8 Guadix CF Guadix CF 30 58 43 48
9 Atlético Monachil Atlético 30 47 51 39
10 Alhendin Balompié Alhendin 30 40 55 33
11 Purullena CF Purullena 30 35 62 31
12 Celtic Pulianas Celtic 30 43 66 30
13 Gabia Gabia 30 35 45 29
14 Ciudad de Baza Ciudad Baza 30 39 66 26
15 Atletismo Padul Atletismo 30 35 94 19
16 Montefrio CF Montefrio 30 36 88 17
TEMPORADA 2021/2022
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Estepona CD Estepona 36 82 26 83
2 FC Málaga City Málaga City 36 61 29 75
3 Arenas de Armilla Arenas 36 64 23 70
4 Maracena Maracena 36 73 36 66
5 CD Villacarrillo Villacarrill 36 53 39 62
6 CD Rincón CD Rincón 36 54 39 60
7 CD Cantoria CD Cantoria 36 58 52 58
8 Atarfe Industrial Atarfe 36 53 50 54
9 Berja Berja 36 51 47 53
10 Cubillas FC Cubillas FC 36 48 40 52
11 Poli Almería Poli 36 42 36 50
12 CD Casabermeja Casabermeja 36 43 45 48
13 Celtic Pulianas Celtic 36 48 46 48
14 Begíjar CF Begíjar CF 36 40 45 45
15 Iliturgi 2016 Iliturgi 36 48 58 38
16 La Cañada Atlético Cañada 36 39 69 26
17 Loja Loja 36 29 73 18
18 Atlético Monachil Atlético 36 30 79 18
19 CD Churriana Churriana 36 29 113 16
TEMPORADA 2020/2021
DIVISIÓN HONOR SENIOR GRUPO 8
Equipo PJ GF GC Puntos
1 Cubillas FC Cubillas FC 30 37 32 45
2 Celtic Pulianas Celtic 30 48 45 45
3 CD Cantoria CD Cantoria 30 47 41 44
4 CD Casabermeja Casabermeja 30 36 26 44
5 Martos CD Martos CD 30 36 33 43
6 Athletic Coín Athletic 30 36 34 42
7 Berja Berja 30 44 31 42
8 Baeza CF Baeza CF 30 42 44 37
9 CD Villanueva Villanueva 30 38 50 34
10 CD Vera CD Vera 30 27 51 27
11 Vandalia Vandalia 30 33 63 21
12 Guadix CF Guadix CF 30 27 68 11
TEMPORADA 2019/2020
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Alhaurino Alhaurino 26 52 18 59
2 J. Torremolinos Torremolinos 27 46 17 57
3 CD Estepona CD Estepona 27 42 19 55
4 CD Rincón CD Rincón 26 48 32 46
5 Celtic Pulianas Celtic 27 45 40 46
6 Athletic Coín Athletic 27 37 37 44
7 Begíjar CF Begíjar CF 26 34 25 42
8 UD San Pedro Pedro 27 26 31 38
9 Atarfe Industrial Atarfe 26 36 28 36
10 Arenas de Armilla Arenas 26 37 34 36
11 Berja Berja 27 37 28 35
12 CD Villacarrillo Villacarrill 27 41 37 33
13 Martos CD Martos CD 27 34 46 30
14 CD Cantoria CD Cantoria 27 29 49 30
15 Cubillas FC Cubillas FC 26 25 28 29
16 CD Churriana Churriana 26 24 44 27
17 CD Casabermeja Casabermeja 27 22 38 24
18 Guadix CF Guadix CF 26 19 44 22
19 CD Villanueva Villanueva 26 21 60 11
TEMPORADA 2018/2019
4ª ANDALUZA GRANADA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Estrellas Parque Nueva Gran Estrellas 22 89 42 50
2 Celtic Pulianas Celtic 22 68 32 45
3 Vandalia de Peligros Vandalia 22 68 37 44
4 Estrellas Chana Barrio Estrellas 22 66 41 39
5 Campotejar Campotejar 22 61 45 39
6 Reino de Granada Reino 22 50 43 33
7 Ciudad de Baza 2017 Ciudad Baza 22 55 56 31
8 Club Deportivo Benalúa Club 22 57 77 28
9 Cullar Vega Base Cullar Vega 21 56 66 26
10 Albolote Albolote 21 56 76 23
11 Guadix Atletico Guadix 22 39 77 13
12 UD Maracena D Maracena 22 40 113 7
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 8
Equipo PJ GF GC Puntos
1 Celtic Pulianas Celtic 34 96 34 80
2 Cubillas FC Cubillas FC 33 80 31 70
3 Salar CF Salar CF 34 71 39 70
4 Campotejar CF Campotejar 32 64 35 62
5 Vandalia Vandalia 34 75 51 55
6 Huetor Tajar B Huetor Tajar 33 71 46 54
7 CD Dúrcal CD Dúrcal 34 56 57 48
8 CD UD Íllora Íllora 34 58 59 46
9 Gabia Gabia 33 57 69 44
10 Puerto de Motril Puerto 32 64 57 42
11 Atletismo Padul Atletismo 33 58 59 41
12 Águilas De Zujaira Águilas 33 61 66 41
13 Purullena CF Purullena 33 68 70 39
14 Chauchina Chauchina 32 51 81 37
15 Cd Abes Cd Abes 26 55 73 27
16 Atl. La Zubia Atl. Zubia 33 42 79 23
17 Pd La Herradura Herradura 30 31 82 20
18 Valderrubio Fútbol 98 Valderrubio 33 32 102 18
TEMPORADA 2016/2017
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 We FC Sub 19 30 78 53 62
2 Celtic Pulianas Celtic 30 79 44 61
3 Otura Otura 30 84 41 60
4 Atletico Monachil Atletico 30 91 46 59
5 UD Maracena C Maracena 30 79 57 54
6 Arenas de Armilla Arenas 30 79 65 54
7 La Herradura 2005 Herradura 30 59 49 53
8 Vandalia de Peligros Vandalia 30 59 56 40
9 Cullar Vega Base Cullar Vega 30 59 74 39
10 U.D. Alfacar U.D. Alfacar 30 64 68 38
11 Medina Lauxa Medina Lauxa 30 58 80 37
12 Cijuela 2008 Cijuela 2008 30 68 88 34
13 Atlético La Zubia A Atlético 30 58 61 33
14 Santa Fe C Santa Fe C 30 51 57 33
15 Cp Granada 74 Granada 30 44 82 20
16 CD UD Monachil Monachil 30 41 130 10
TEMPORADA 2015/2016
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 CF Motril CF Motril 34 83 28 75
2 Cd Huetor Vega Huetor Vega 34 78 24 73
3 Cd Oriente Cd Oriente 34 67 43 61
4 Arenas de Armilla Arenas 33 69 38 60
5 UD Pavía UD Pavía 34 54 37 57
6 Cullar Vega Cullar Vega 34 60 55 57
7 Cd Adra Milenaria Adra 33 54 47 55
8 CD Universidad de Almería Universidad 33 71 43 52
9 La Cañada Atlético Cañada 33 68 66 50
10 Purullena CF Purullena 34 54 56 46
11 Alfacar UD Alfacar UD 34 50 55 44
12 Vandalia Vandalia 34 41 58 40
13 Berja Berja 34 50 68 39
14 Churriana de la Vega Churriana 34 39 51 39
15 Ciudad de Roquetas Ciudad 33 47 65 34
16 Baza Baza 34 38 68 29
17 Los Molinos Los Molinos 34 44 83 27
18 Celtic Pulianas Celtic 33 32 114 8
TEMPORADA 2014/2015
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Comarca Del Marmol Comarca 34 85 36 78
2 Arenas de Armilla Arenas 34 67 24 76
3 Cd Adra Milenaria Adra 34 69 43 67
4 Cd Huetor Vega Huetor Vega 34 56 38 59
5 UD Pavía UD Pavía 34 53 41 56
6 CD Universidad de Almería Universidad 34 57 45 50
7 Alfacar UD Alfacar UD 34 52 47 50
8 Almuñecar 77 Almuñecar 34 51 65 45
9 Churriana de la Vega Churriana 34 54 61 43
10 Vandalia Vandalia 34 56 55 42
11 Cullar Vega Cullar Vega 34 31 33 42
12 Cd Oriente Cd Oriente 34 47 44 41
13 Celtic Pulianas Celtic 34 59 71 41
14 Baza Baza 34 31 50 41
15 La Cañada Atlético Cañada 34 50 61 40
16 CD Mojácar CD Mojácar 34 40 64 34
17 CD Huercal CD Huercal 34 46 69 32
18 Atl. La Zubia Atl. Zubia 34 36 93 22
TEMPORADA 2013/2014
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Almuñecar 77-p. Casquet Almuñecar 34 96 38 71
2 Celtic Pulianas Celtic 34 110 52 68
3 Atlético Monachil Atlético 34 82 52 68
4 Alhendin Balompié Alhendin 34 85 47 67
5 Huetor Tajar B Huetor Tajar 34 62 46 63
6 Motril Atlético C.D. Motril 34 76 48 61
7 Cd Abes Cd Abes 34 65 56 59
8 Purullena CF Purullena 34 73 70 49
9 Gabia Gabia 34 66 68 46
10 CD Santa Fe CD Santa Fe 34 62 65 43
11 La Peza Fc La Peza Fc 34 67 94 40
12 Atletismo Padul Atletismo 34 53 78 38
13 CD Iznalloz CD Iznalloz 34 34 65 38
14 CD Dúrcal CD Dúrcal 34 43 68 38
15 Otura CF Otura CF 34 51 64 37
16 Rayo Eneas Albayzín Rayo Eneas. 34 61 68 35
17 Ogijares 89 Cf Ogijares 34 45 70 25
18 Cd Ciudad De Guadahortuna S Ciudad 34 26 108 11
TEMPORADA 2012/2013
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Alfacar UD Alfacar UD 34 73 35 74
2 Vandalia de Peligros B Vandalia 34 74 32 71
3 Cd Huetor Vega Huetor Vega 34 72 28 70
4 Celtic Pulianas Celtic 34 99 42 67
5 Atlético Monachil Atlético 34 63 37 62
6 Purullena CF Purullena 34 70 44 61
7 Gabia Gabia 34 69 46 60
8 Almuñecar 77 Almuñecar 34 72 63 54
9 Alhendin Balompié Alhendin 34 61 48 49
10 Rayo Eneas Rayo Eneas 34 72 74 45
11 Otura CF Otura CF 34 62 64 44
12 Cd Abes Cd Abes 34 59 99 40
13 CD Dúrcal CD Dúrcal 34 43 44 39
14 Ogijares 89 Cf Ogijares 34 59 69 38
15 CD UD Íllora Íllora 34 60 81 37
16 UD Los Marinos Marinos 34 32 92 27
17 Caniles Cd Caniles Cd 34 37 98 20
18 Pd La Herradura Herradura 34 18 99 13
TEMPORADA 2011/2012
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Recreativo Granada Recreativo 33 67 23 73
2 Guadix CF Guadix CF 33 62 43 63
3 Español de Alquián Español 34 58 32 62
4 CD Huercal CD Huercal 34 80 49 59
5 CD Vera CD Vera 35 53 42 55
6 Atarfe Industrial Atarfe 34 74 59 52
7 Los Molinos Los Molinos 33 45 41 50
8 Parador Roquetas Parador 34 45 45 50
9 Águilas De Zujaira Águilas 34 51 52 47
10 Atl. La Zubia Atl. Zubia 33 42 53 47
11 Cullar Vega Cullar Vega 33 49 51 44
12 UD Pavía UD Pavía 34 54 62 44
13 Berja Berja 33 49 50 43
14 Baza Baza 34 41 59 39
15 Cd Adra Milenaria Adra 33 42 59 37
16 Atlético Monachil Atlético 34 51 58 34
17 Celtic Pulianas Celtic 33 37 62 32
18 Vandalia Vandalia 34 36 61 28
19 Atlético Bellavista Atlético 33 42 77 26
TEMPORADA 2010/2011
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Celtic Pulianas Celtic 34 66 25 72
2 Águilas De Zujaira Águilas 34 66 39 67
3 CD El Padul CD El Padul 34 52 33 63
4 Imperio De Albolote Imperio 34 65 50 58
5 Alfacar UD Alfacar UD 34 61 37 57
6 Churriana de la Vega Churriana 34 59 38 55
7 Loja CD Loja CD 34 59 45 55
8 Cd Abes Cd Abes 34 66 62 55
9 Huetor Tajar B Huetor Tajar 34 62 46 51
10 U.D.E. Chana U.D.E. Chana 34 55 52 48
11 CD Dúrcal CD Dúrcal 34 53 56 48
12 Caniles Cd Caniles Cd 34 46 61 44
13 Alhameña Alhameña 34 42 40 38
14 Purullena CF Purullena 34 48 60 38
15 CD Iznalloz CD Iznalloz 34 39 56 36
16 Calahonda-Carchuna Calahonda-Ca 34 54 73 36
17 Otura CF Otura CF 34 27 74 18
18 Gabia Gabia 34 38 111 13
TEMPORADA 2009/2010
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 CD UD Íllora Íllora 34 86 48 72
2 Atlético Monachil Atlético 34 93 39 71
3 Celtic Pulianas Celtic 34 57 46 65
4 U.D.E. Chana U.D.E. Chana 34 69 53 61
5 CD El Padul CD El Padul 34 66 55 59
6 Águilas De Zujaira Águilas 34 70 51 58
7 Purullena CF Purullena 34 60 47 50
8 Kamelamos Abes Kamelamos 34 65 63 48
9 CD Iznalloz CD Iznalloz 34 50 57 48
10 Loja CD Loja CD 34 59 54 47
11 Alhameña Alhameña 34 53 59 45
12 Otura CF Otura CF 34 44 72 45
13 Caniles Cd Caniles Cd 34 50 61 41
14 CF Sierra Nevada Cenes Sierra 34 49 73 40
15 Salar CF Salar CF 34 67 75 39
16 Pinos Puente Pinos Puente 34 48 63 34
17 Imperio B Imperio B 34 36 60 28
18 Ogijares 89 Cf Ogijares 34 41 87 16
TEMPORADA 2008/2009
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Huétor Vega Huétor Vega 34 69 39 68
2 CD El Padul CD El Padul 34 57 31 68
3 UD Los Marinos Marinos 34 63 39 67
4 Churriana de la Vega Churriana 34 49 31 61
5 Caniles Cd Caniles Cd 34 68 45 58
6 Motril CF B Motril CF B 34 74 48 57
7 Fs Las Vegas Futsal Vegas Futsal 34 61 45 55
8 Águilas De Zujaira Águilas 34 54 43 52
9 Salar CF Salar CF 34 45 50 48
10 Ogijares 89 Cf Ogijares 34 57 53 47
11 Alhameña Alhameña 34 56 53 46
12 Kamelamos Abes Kamelamos 34 55 53 46
13 Celtic Pulianas Celtic 34 54 59 45
14 Salobreña Salobreña 34 53 59 45
15 U.D.E. Chana U.D.E. Chana 34 51 63 40
16 Pinos Puente Pinos Puente 34 52 70 33
17 Alfacar UD Alfacar UD 34 49 76 25
18 Pd La Herradura Herradura 34 11 121 4

  USO DE MEMORIA  
7,015,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7069
Total Execution Time  0.7081
  CADENA URL  
/historico/Celtic-Pulianas-C-F
  GET DATOS  
$_GET['/historico/Celtic-Pulianas-C-F']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0169  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 = 'Celtic-Pulianas-C-F' 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.0128  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=13825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=13825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0259  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 = 73625
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13825 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13825 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0135  SELECT /*35 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 (22925,23125,24716) ORDER BY n.cover_points DESC, update_date DESC
0.0145  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 = '13825' ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '13825' 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 = '13825' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  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 = 73625 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0144  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=13825 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (73625) 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.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 73625 AND teamId = 13825
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 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 = 73625 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134  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 = '13825' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13825' 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 = '13825' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0194  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 = 73625 WHERE rp.league_id = 73625 AND rp.teamId = 13825 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.0133  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 = 73625 WHERE rp.league_id = 73625 AND rp.teamId = 13825 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 73625 WHERE rp.league_id = 73625 AND rp.teamId = 13825 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 13825 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73625 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `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 = 68700 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.0132  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 = 63952 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.0133  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 = 58972 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.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 `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 = 61681 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 51037 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.0140  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 = 44942 AND t.round = 34 ORDER BY team.conference 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 `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 = 45813 AND t.round = 22 ORDER BY team.conference 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 `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 = 39695 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 34595 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 35067 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` 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 = 16715 AND t.round = 34 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 `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 = 4080 AND t.round = 34 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 `tables2014_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 = 3338 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 `tables2014` 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 = 2582 AND t.round = 34 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 `tables2013` 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 = 2581 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2012` 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 = 1467 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables2011` 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 = 2970 AND t.round = 34 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 `tables2010` 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 = 2969 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2009` 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 = 2968 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC