4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Egnatia KF Egnatia 32 50 33 60
2 Vllaznia Shkodër Vllaznia 32 38 29 52
3 Partizani Tirana Partizani 32 43 28 51
4 KF Tirana KF Tirana 32 52 46 46
5 Dinamo City Dinamo City 32 42 40 46
6 Skënderbeu Korçë Skënderbeu 32 30 36 44
7 Laçi Laçi 32 33 30 38
8 Teuta Durrës Teuta 32 29 35 38
9 Erzeni Shijak Erzeni 32 26 46 31
10 Kukësi Kukësi 32 28 48 26
TEMPORADA 2022/2023
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Partizani Tirana Partizani 36 56 37 67
2 KF Tirana KF Tirana 36 56 33 67
3 KF Egnatia KF Egnatia 36 46 32 52
4 Vllaznia Shkodër Vllaznia 36 39 37 50
5 Laçi Laçi 36 45 46 48
6 Teuta Durrës Teuta 36 33 40 48
7 Kukësi Kukësi 36 31 35 45
8 Erzeni Shijak Erzeni 36 36 48 40
9 Bylis Ballsh Bylis Ballsh 36 31 42 38
10 Kastrioti Krujë Kastrioti 36 26 49 35
TEMPORADA 2021/2022
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 36 64 27 73
2 Laçi Laçi 36 52 33 63
3 Partizani Tirana Partizani 36 52 30 58
4 Kukësi Kukësi 36 50 44 55
5 Vllaznia Shkodër Vllaznia 36 47 38 55
6 Teuta Durrës Teuta 36 39 44 50
7 Kastrioti Krujë Kastrioti 36 30 54 43
8 KF Egnatia KF Egnatia 36 30 49 35
9 Dinamo City Dinamo City 36 21 46 29
10 Skënderbeu Korçë Skënderbeu 36 23 43 26
TEMPORADA 2020/2021
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Teuta Durrës Teuta 36 42 16 66
2 Vllaznia Shkodër Vllaznia 36 44 22 66
3 Partizani Tirana Partizani 36 53 23 65
4 Laçi Laçi 36 41 26 61
5 KF Tirana KF Tirana 36 41 26 58
6 Kukësi Kukësi 36 47 48 45
7 Skënderbeu Korçë Skënderbeu 36 34 55 37
8 Kastrioti Krujë Kastrioti 36 26 44 35
9 Bylis Ballsh Bylis Ballsh 36 28 51 31
10 Apolonia Fier Apolonia 36 22 67 21
TEMPORADA 2019/2020
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 36 67 35 70
2 Kukësi Kukësi 36 59 31 66
3 Laçi Laçi 36 61 34 64
4 Skënderbeu Korçë Skënderbeu 36 42 43 58
5 Teuta Durrës Teuta 36 41 34 57
6 Partizani Tirana Partizani 36 51 40 53
7 Bylis Ballsh Bylis Ballsh 36 46 38 51
8 Vllaznia Shkodër Vllaznia 36 36 41 46
9 Flamurtari Vlorë Flamurtari 36 32 72 15
10 KF Luftëtari Luftëtari 36 19 86 14
TEMPORADA 2018/2019
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Partizani Tirana Partizani 36 45 22 70
2 Kukësi Kukësi 36 42 29 59
3 Teuta Durrës Teuta 36 43 36 57
4 Skënderbeu Korçë Skënderbeu 36 45 30 55
5 Flamurtari Vlorë Flamurtari 36 35 32 54
6 Laçi Laçi 36 33 30 49
7 KF Tirana KF Tirana 36 44 35 47
8 KF Luftëtari Luftëtari 36 37 39 47
9 Kastrioti Krujë Kastrioti 36 35 53 42
10 Kamza Kamza 36 13 66 17
TEMPORADA 2017/2018
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Skënderbeu Korçë Skënderbeu 36 68 41 72
2 Kukësi Kukësi 36 61 41 63
3 KF Luftëtari Luftëtari 36 47 37 59
4 Laçi Laçi 36 45 39 56
5 Partizani Tirana Partizani 36 41 36 53
6 Flamurtari Vlorë Flamurtari 36 37 37 46
7 Kamza Kamza 36 37 41 46
8 Teuta Durrës Teuta 36 55 58 46
9 Vllaznia Shkodër Vllaznia 36 38 42 44
10 Lushnja Lushnja 36 29 86 11
TEMPORADA 2016/2017
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Kukësi Kukësi 36 51 18 75
2 Partizani Tirana Partizani 36 46 17 72
3 Skënderbeu Korçë Skënderbeu 36 45 22 72
4 KF Luftëtari Luftëtari 36 37 45 44
5 Teuta Durrës Teuta 36 27 34 40
6 Laçi Laçi 36 23 35 40
7 Vllaznia Shkodër Vllaznia 36 29 35 40
8 Flamurtari Vlorë Flamurtari 36 42 34 40
9 KF Tirana KF Tirana 36 29 32 39
10 Korabi Peshkopi Korabi 36 11 68 13
TEMPORADA 2015/2016
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Skënderbeu Korçë Skënderbeu 36 73 27 79
2 Partizani Tirana Partizani 36 51 21 74
3 Kukësi Kukësi 36 41 25 63
4 Teuta Durrës Teuta 36 43 28 63
5 KF Tirana KF Tirana 36 37 25 53
6 Vllaznia Shkodër Vllaznia 36 36 42 39
7 Laçi Laçi 36 30 48 36
8 Flamurtari Vlorë Flamurtari 36 34 44 35
9 Bylis Ballsh Bylis Ballsh 36 27 53 32
10 Tërbuni Pukë Tërbuni 36 22 81 18
TEMPORADA 2014/2015
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Skënderbeu Korçë Skënderbeu 36 58 18 79
2 Kukësi Kukësi 36 59 27 75
3 Partizani Tirana Partizani 36 42 24 73
4 KF Tirana KF Tirana 36 47 27 71
5 Laçi Laçi 36 46 19 69
6 Flamurtari Vlorë Flamurtari 36 29 37 38
7 Vllaznia Shkodër Vllaznia 36 27 41 35
8 Teuta Durrës Teuta 36 31 54 29
9 Apolonia Fier Apolonia 36 19 56 25
10 KF Elbasani KF Elbasani 36 19 74 14
TEMPORADA 2013/2014
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Skënderbeu Korçë Skënderbeu 33 52 32 61
2 Kukësi Kukësi 33 46 34 57
3 Laçi Laçi 33 41 28 54
4 Teuta Durrës Teuta 33 46 35 54
5 Partizani Tirana Partizani 33 33 26 53
6 KF Tirana KF Tirana 33 36 31 50
7 Flamurtari Vlorë Flamurtari 33 45 40 48
8 Vllaznia Shkodër Vllaznia 33 42 36 45
9 Besa Kavajë Besa Kavajë 33 34 32 39
10 Kastrioti Krujë Kastrioti 33 26 46 29
11 Lushnja Lushnja 33 32 59 26
12 Bylis Ballsh Bylis Ballsh 33 20 54 24
TEMPORADA 2012/2013
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 Lushnja Lushnja 30 48 22 66
2 Partizani Tirana Partizani 30 39 33 56
3 Tërbuni Pukë Tërbuni 30 40 30 43
4 Mamurrasi Mamurrasi 30 48 45 43
5 Pogradeci Pogradeci 30 49 44 42
6 Himara Himara 30 32 29 42
7 Burreli Burreli 30 32 31 42
8 Ada Velipojë Velipojë 30 34 31 41
9 Kamza Kamza 30 38 47 41
10 Butrinti Sarandë Butrinti 30 38 33 40
11 Dinamo City Dinamo City 30 40 37 40
12 KF Elbasani KF Elbasani 30 42 46 40
13 Besëlidhja Lezhë Besëlidhja 30 28 30 38
14 KF Iliria KF Iliria 30 35 37 37
15 Gramshi Gramshi 30 18 41 31
16 Naftëtari Kuçovë Naftëtari 30 22 47 20
TEMPORADA 2011/2012
SEGUNDA ALBANIA GRUPO 2
Equipo PJ GF GC Puntos
1 Partizani Tirana Partizani 22 34 10 52
2 Naftëtari Kuçovë Naftëtari 22 47 8 51
3 Tepelena Tepelena 22 36 28 38
4 Turbina Cërrik Turbina 22 36 29 35
5 Albpetrol Patos Albpetrol 22 26 18 34
6 Bilisht Sporti Bilisht 22 29 31 29
7 Sopoti Librazhd Sopoti 22 23 31 27
8 Delvina Delvina 22 27 36 23
9 Përmeti Përmeti 22 24 34 22
10 Memaliaj Memaliaj 22 25 34 21
11 Domosdova Prrenjas Domosdova 22 18 40 18
12 Këlcyra Këlcyra 22 20 46 18
TEMPORADA 2010/2011
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 Pogradeci Pogradeci 30 56 27 68
2 Tomori Berat Tomori Berat 30 50 24 63
3 Kamza Kamza 30 42 20 60
4 Apolonia Fier Apolonia 30 50 31 60
5 Besëlidhja Lezhë Besëlidhja 30 40 17 57
6 Mamurrasi Mamurrasi 30 30 29 43
7 Lushnja Lushnja 30 35 25 39
8 Gramozi Ersekë Gramozi 30 34 45 39
9 Ada Velipojë Velipojë 30 40 41 37
10 KF Luftëtari Luftëtari 30 23 34 37
11 Burreli Burreli 30 29 37 36
12 Vlora Vlora 30 36 47 34
13 Gramshi Gramshi 30 24 34 31
14 Tërbuni Pukë Tërbuni 30 27 42 31
15 Bilisht Sporti Bilisht 30 30 64 27
16 Partizani Tirana Partizani 30 16 45 17
TEMPORADA 2009/2010
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 Bylis Ballsh Bylis Ballsh 30 57 26 69
2 KF Elbasani KF Elbasani 30 56 25 62
3 Kamza Kamza 30 50 21 62
4 Lushnja Lushnja 30 59 10 60
5 Partizani Tirana Partizani 30 49 35 57
6 Pogradeci Pogradeci 30 40 39 48
7 Ada Velipojë Velipojë 30 46 34 42
8 KF Luftëtari Luftëtari 30 38 45 36
9 Besëlidhja Lezhë Besëlidhja 30 32 40 35
10 Gramshi Gramshi 30 23 34 32
11 Bilisht Sporti Bilisht 30 30 50 32
12 Burreli Burreli 30 26 41 31
13 Skrapari Skrapari 30 29 56 31
14 Memaliaj Memaliaj 30 23 37 29
15 Turbina Cërrik Turbina 30 35 53 28
16 Sopoti Librazhd Sopoti 30 14 61 15
TEMPORADA 2008/2009
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 33 58 27 68
2 Vllaznia Shkodër Vllaznia 33 49 29 64
3 Dinamo City Dinamo City 33 48 34 52
4 Teuta Durrës Teuta 33 32 34 44
5 Shkumbini Peqin Shkumbini 33 32 38 44
6 Flamurtari Vlorë Flamurtari 33 33 33 42
7 Besa Kavajë Besa Kavajë 33 31 41 40
8 Apolonia Fier Apolonia 33 36 43 38
9 Bylis Ballsh Bylis Ballsh 33 28 38 37
10 Partizani Tirana Partizani 33 27 36 36
11 Lushnja Lushnja 33 25 35 36
12 KF Elbasani KF Elbasani 33 28 39 35
TEMPORADA 2007/2008
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Dinamo City Dinamo City 33 56 14 70
2 Partizani Tirana Partizani 33 47 22 65
3 Besa Kavajë Besa Kavajë 33 45 36 56
4 KF Elbasani KF Elbasani 33 40 24 52
5 Shkumbini Peqin Shkumbini 33 35 28 50
6 KF Tirana KF Tirana 33 46 36 49
7 Vllaznia Shkodër Vllaznia 33 46 46 45
8 Flamurtari Vlorë Flamurtari 33 35 37 44
9 Teuta Durrës Teuta 33 32 45 35
10 Kastrioti Krujë Kastrioti 33 24 43 35
11 Besëlidhja Lezhë Besëlidhja 33 31 52 34
12 Skënderbeu Korçë Skënderbeu 33 26 80 11
TEMPORADA 2006/2007
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 33 64 33 72
2 Teuta Durrës Teuta 33 44 26 67
3 Vllaznia Shkodër Vllaznia 33 46 28 63
4 Partizani Tirana Partizani 33 44 25 57
5 Dinamo City Dinamo City 33 41 39 47
6 Besa Kavajë Besa Kavajë 33 35 38 41
7 KF Elbasani KF Elbasani 33 34 39 40
8 Kastrioti Krujë Kastrioti 33 32 46 37
9 Flamurtari Vlorë Flamurtari 33 35 41 34
10 Shkumbini Peqin Shkumbini 33 36 53 34
11 KF Luftëtari Luftëtari 33 28 44 33
12 Apolonia Fier Apolonia 33 32 59 26
TEMPORADA 2005/2006
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Elbasani KF Elbasani 36 50 22 73
2 KF Tirana KF Tirana 36 54 33 62
3 Dinamo City Dinamo City 36 53 35 61
4 Partizani Tirana Partizani 36 51 35 60
5 Besa Kavajë Besa Kavajë 36 49 42 46
6 Vllaznia Shkodër Vllaznia 36 39 45 45
7 Shkumbini Peqin Shkumbini 36 31 49 43
8 Teuta Durrës Teuta 36 32 45 42
9 Skënderbeu Korçë Skënderbeu 36 33 50 42
10 Lushnja Lushnja 36 22 58 25
TEMPORADA 2004/2005
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 36 82 32 84
2 KF Elbasani KF Elbasani 36 59 27 79
3 Dinamo City Dinamo City 36 51 30 62
4 Vllaznia Shkodër Vllaznia 36 80 47 61
5 Teuta Durrës Teuta 36 47 49 52
6 Shkumbini Peqin Shkumbini 36 49 47 48
7 Lushnja Lushnja 36 43 47 48
8 Partizani Tirana Partizani 36 59 58 46
9 KF Egnatia KF Egnatia 36 26 48 28
10 Laçi Laçi 36 13 124 2

  USO DE MEMORIA  
7,671,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.6923
Total Execution Time  0.6946
  CADENA URL  
/historico/Partizani-Tirana
  GET DATOS  
$_GET['/historico/Partizani-Tirana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0123  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 = 'Partizani-Tirana' 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.0106  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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 = 72102
0.0112  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 = 72103
0.0110  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 = 73523
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9105 AND type_rel = 2
0.0106  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9105 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  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 (87949,92805,257742,262260,632684) ORDER BY n.cover_points DESC, update_date DESC
0.0121  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 = '9105' ORDER BY l.year DESC,cat.coefficient DESC
0.0112  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 = '9105' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0113  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 = '9105' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = 73523 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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 = 72060 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115  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=9105 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (73617,73523,72103,72093,72060,71432) 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.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 72060 AND teamId = 9105
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 72093 AND teamId = 9105
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 72103 AND teamId = 9105
0.0112  SELECT count(id) as num_players from rel_players WHERE league_id = 73617 AND teamId = 9105
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 73523 AND teamId = 9105
0.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9105
0.0108  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 = '9105' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9105' and rp.type = 4
0.0107  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 = '9105' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0120  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 = 72060 WHERE rp.league_id = 72060 AND rp.teamId = 9105 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.0117  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 = 72060 WHERE rp.league_id = 72060 AND rp.teamId = 9105 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 = 72060 WHERE rp.league_id = 72060 AND rp.teamId = 9105 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117  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 = 9105 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 68114 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 63209 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 58663 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 49904 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 43668 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 38728 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 33466 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 4445 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 3565 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2043 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 1868 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 8879 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 8877 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 8869 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2008` 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 = 8867 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2007` 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 = 8865 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2006` 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 = 8864 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2005` 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 = 8862 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC