4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Apollon Pontou
TEMPORADA 2023/2024
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Levadiakos Levadiakos 22 36 9 55
2 AE Larisa AE Larisa 22 32 12 49
3 Niki Volos Niki Volos 22 33 24 32
4 AEK Athens B Athens 22 23 17 32
5 Makedonikos Neapolis Makedonikos 22 24 23 31
6 PAOK B PAOK B 22 31 27 30
7 Anagennisi Karditsas Anagennisi 22 22 24 29
8 Iraklis Thessaloniki Iraklis 22 25 20 29
9 Kozani FC Kozani FC 22 10 17 24
10 Kampaniakos Chalastra Kampaniakos 22 18 32 23
11 Aiolikos Aiolikos 22 20 36 19
12 Apollon Pontou Apollon 22 12 45 11
13 Almopos Aridea Almopos 0 0 0 0
TEMPORADA 2022/2023
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Panserraikos FC Panserraikos 28 43 13 64
2 AE Larisa AE Larisa 28 50 19 58
3 Niki Volos Niki Volos 28 41 20 52
4 Iraklis Thessaloniki Iraklis 28 53 22 50
5 PAOK B PAOK B 28 51 33 49
6 Almopos Aridea Almopos 28 23 17 36
7 Anagennisi Karditsas Anagennisi 28 34 21 35
8 Makedonikos Neapolis Makedonikos 28 28 30 33
9 Panathinaikos B Panathinaiko 28 39 41 33
10 Diagoras Diagoras 28 38 42 33
11 Apollon Pontou Apollon 28 21 37 32
12 Veria NPS Veria NPS 28 28 32 31
13 Iraklis Larissa Iraklis 28 17 42 26
14 Thesprotos Thesprotos 28 26 49 17
15 Apollon Larisas Apollon 28 8 82 4
TEMPORADA 2021/2022
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Veria NPS Veria NPS 32 61 23 75
2 AE Larisa AE Larisa 32 42 15 67
3 Xanthi Xanthi 32 43 25 53
4 Niki Volos Niki Volos 32 38 20 52
5 Anagennisi Karditsas Anagennisi 32 47 34 51
6 Olympiacos Piraeus B Olympiacos 32 40 31 51
7 Iraklis Thessaloniki Iraklis 32 51 29 48
8 PAOK B PAOK B 32 41 32 44
9 Almopos Aridea Almopos 32 40 39 39
10 Apollon Pontou Apollon 32 34 38 37
11 Apollon Larisas Apollon 32 27 42 35
12 Thesprotos Thesprotos 32 34 43 34
13 Panserraikos FC Panserraikos 32 31 39 33
14 Pierikos Pierikos 32 36 49 32
15 Kavala Kavala 32 25 71 31
16 Olympiakos Volos Olympiakos 32 34 49 29
17 Trikala Trikala 32 17 62 21
TEMPORADA 2020/2021
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Veria NPS Veria NPS 18 24 6 38
2 Kavala Kavala 18 32 18 35
3 Panserraikos FC Panserraikos 18 21 12 31
4 Olympiakos Volos Olympiakos 18 23 21 29
5 Pierikos Pierikos 18 23 21 26
6 Thesprotos Thesprotos 18 19 24 22
7 Triglia Rafinas Triglia 18 14 16 21
8 Almopos Aridea Almopos 18 18 21 20
9 Apollon Pontou Apollon 18 16 25 19
10 AEP Kozani AEP Kozani 18 7 33 7
11 Kalamata FC Kalamata FC 18 20 7 35
12 Rodos Rodos 18 20 15 30
13 Athens Kallithea Athens 18 20 14 29
14 Episkopi Episkopi 18 15 10 27
15 Santorini Santorini 18 15 16 24
16 Ialysos Ialysos 18 16 22 24
17 Egaleo Egaleo 18 14 14 23
18 Niki Volos Niki Volos 18 18 14 22
19 Asteras Vlachioti Asteras 18 14 16 19
20 Enosis Aspropyrgos Enosis 18 10 34 8
TEMPORADA 2019/2020
SEGUNDA GRECIA
Equipo PJ GF GC Puntos
1 PAS Giannina Giannina 20 44 11 49
2 Apollon Smyrnis Apollon 20 36 13 42
3 Levadiakos Levadiakos 20 27 15 38
4 Chania Chania 20 29 13 35
5 Karaiskakis Karaiskakis 20 32 29 31
6 Apollon Larisas Apollon 20 27 25 30
7 Ergotelis Ergotelis 20 31 33 29
8 Panachaiki Panachaiki 20 34 19 28
9 Platanias Platanias 20 26 32 26
10 Doxa Dramas Doxa Dramas 20 25 25 24
11 Apollon Pontou Apollon 20 8 58 0
12 Kerkyra Kerkyra 20 6 52 0
TEMPORADA 2018/2019
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Volos New Football Volos 30 59 29 57
2 Apollon Larisas Apollon 30 44 27 57
3 Platanias Platanias 30 53 22 55
4 Ergotelis Ergotelis 30 46 29 49
5 Apollon Pontou Apollon 30 33 27 49
6 Doxa Dramas Doxa Dramas 30 43 26 48
7 Panachaiki Panachaiki 30 32 25 48
8 Kerkyra Kerkyra 30 30 25 47
9 Chania Chania 30 40 24 46
10 Iraklis Thessaloniki Iraklis 30 29 24 42
11 Karaiskakis Karaiskakis 30 24 28 40
12 Trikala Trikala 30 27 30 35
13 Irodotos Irodotos 30 24 50 31
14 Aittitos Spata Aittitos 30 18 50 22
15 Aiginiakos Aiginiakos 30 24 66 19
16 Sparti Sparti 30 18 62 18
TEMPORADA 2017/2018
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 OFI OFI 34 86 14 86
2 Aris Thessaloniki Aris 34 65 13 85
3 Panachaiki Panachaiki 34 50 21 73
4 Chania Chania 34 64 32 64
5 Doxa Dramas Doxa Dramas 34 57 25 63
6 Trikala Trikala 34 31 22 58
7 Apollon Pontou Apollon 34 43 27 53
8 Karaiskakis Karaiskakis 34 35 32 48
9 Ergotelis Ergotelis 34 56 47 46
10 Apollon Larisas Apollon 34 45 54 43
11 Aiginiakos Aiginiakos 34 36 54 37
12 Sparti Sparti 34 29 46 34
13 Anagennisi Karditsas Anagennisi 34 32 41 34
14 Panserraikos FC Panserraikos 34 43 52 27
15 Panegialios Panegialios 34 29 57 25
16 Athens Kallithea Athens 34 26 40 21
17 Veria NPS Veria NPS 33 13 70 5
18 Acharnaikos Acharnaikos 33 2 95 0
TEMPORADA 2016/2017
TERCERA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Apollon Pontou Apollon 27 72 16 70
2 Doxa Dramas Doxa Dramas 28 67 16 69
3 Langadas Langadas 28 38 30 50
4 Nestos Chrisoupolis Nestos 28 37 35 45
5 Orfeas Xanthi Orfeas 28 31 22 44
6 Kavala Kavala 28 43 26 43
7 Apollon Paralimniou Apollon 28 44 23 42
8 Naoussa Naoussa 28 28 32 40
9 Kampaniakos Chalastra Kampaniakos 28 34 44 38
10 Kardias Kardias 27 33 35 37
11 Makedonikos Foufas Makedonikos 28 29 34 32
12 Almopos Aridea Almopos 28 24 31 30
13 Doxa Proskyniton Doxa 28 26 46 25
14 Eordaikos Eordaikos 28 23 68 17
15 Pontion Vatolakkou Pontion 28 4 75 5
TEMPORADA 2015/2016
TERCERA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Aris Thessaloniki Aris 32 76 17 87
2 Nestos Chrisoupolis Nestos 32 66 35 66
3 Doxa Dramas Doxa Dramas 32 47 24 63
4 Kavala Kavala 32 53 24 58
5 Apollon Pontou Apollon 32 46 29 53
6 Langadas Langadas 32 50 35 53
7 Ethnikos Neo Agioneri FC Ethnikos 32 35 25 50
8 Kampaniakos Chalastra Kampaniakos 32 45 31 47
9 Eordaikos Eordaikos 32 35 35 46
10 AEP Kozani AEP Kozani 32 41 49 44
11 Byzantio Kokkinokhóma Byzantio 32 47 51 37
12 Thyella Filotas Thyella 32 32 38 35
13 Apollon Krya Vrysi Apollon Krya 32 27 43 34
14 Iraklis Ampelokipoi Iraklis 32 33 57 28
15 Ethnikos Alexandroupoli Ethnikos 32 20 45 27
16 Evros Soufli Evros Soufli 32 32 86 22
17 Ethnikos Gazoros Ethnikos 32 10 71 11
TEMPORADA 2014/2015
FOOTBALL LEAGUE GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Iraklis Thessaloniki Iraklis 24 34 8 57
2 AE Larisa AE Larisa 24 27 11 45
3 Olympiakos Volos Olympiakos 24 33 21 45
4 Lamia Lamia 24 24 17 43
5 Zakynthos Zakynthos 24 26 27 39
6 Anagennisi Karditsas Anagennisi 24 26 27 32
7 Aiginiakos Aiginiakos 24 23 19 30
8 Pierikos Pierikos 24 19 29 30
9 Agrotikos Asteras Agrotikos 24 23 27 29
10 Tyrnavos Tyrnavos 24 16 24 29
11 Apollon Pontou Apollon 24 19 23 26
12 Ethnikos Gazoros Ethnikos 24 11 30 15
13 Fokikos Fokikos 24 12 30 12
TEMPORADA 2013/2014
FOOTBALL LEAGUE GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kerkyra Kerkyra 26 45 18 59
2 Niki Volos Niki Volos 26 47 12 56
3 Aiginiakos Aiginiakos 26 45 15 51
4 Iraklis Thessaloniki Iraklis 26 36 19 48
5 Anagennisi Karditsas Anagennisi 26 28 20 44
6 Tyrnavos Tyrnavos 26 27 22 41
7 Apollon Pontou Apollon 26 33 32 37
8 Ethnikos Gazoros Ethnikos 26 23 22 35
9 Zakynthos Zakynthos 26 25 35 31
10 Doxa Dramas Doxa Dramas 26 22 30 30
11 Pierikos Pierikos 26 20 34 29
12 Vataniakos Vataniakos 26 20 45 20
13 Kavala Kavala 26 18 49 17
14 Anagennisi Giannitsa Anagennisi 26 15 51 12
TEMPORADA 2012/2013
TERCERA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Apollon Pontou Apollon 22 33 12 48
2 Anagennisi Karditsas Anagennisi 22 42 19 47
3 Kassiopi FC Kassiopi FC 22 35 13 45
4 Aiginiakos Aiginiakos 22 34 21 37
5 Tyrnavos Tyrnavos 22 28 26 35
6 Vataniakos Vataniakos 22 27 30 31
7 Odysseas Kordeliou FC Odysseas 22 35 28 29
8 Zakynthos Zakynthos 22 22 25 29
9 Ethnikos Sidirokastro Ethnikos 22 23 24 27
10 Doxa Kranoula Doxa 22 23 35 18
11 Tilikratis Tilikratis 22 17 37 15
12 Oikonomos Tsaritsani Oikonomos 22 6 55 6
TEMPORADA 2011/2012
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ethnikos Gazoros Ethnikos 22 37 17 43
2 Niki Volos Niki Volos 22 31 11 40
3 Oikonomos Tsaritsani Oikonomos 22 27 16 39
4 Apollon Pontou Apollon 22 25 15 38
5 Iraklis Thessaloniki Iraklis 22 31 14 36
6 Tilikratis Tilikratis 22 22 15 35
7 Tyrnavos Tyrnavos 22 22 17 35
8 Vataniakos Vataniakos 22 16 26 24
9 Doxa Kranoula Doxa 22 17 26 22
10 Odysseas Anagennisi Odysseas 22 15 30 20
11 M. Alexandros Irakleia Alexandros 22 21 43 20
12 Aetos Skydra Aetos Skydra 22 14 48 7
TEMPORADA 2008/2009
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Atromitos Atromitos 34 54 30 74
2 PAS Giannina Giannina 34 70 36 69
3 Kavala Kavala 34 56 28 65
4 Ionikos Nikea Ionikos 34 43 37 55
5 Kerkyra Kerkyra 34 45 40 51
6 Ilysiakos AO Ilysiakos 34 42 40 46
7 Agrotikos Asteras Agrotikos 34 39 39 45
8 Diagoras Diagoras 34 46 38 44
9 Kalamata FC Kalamata FC 34 33 43 43
10 Pierikos Pierikos 34 33 43 42
11 Ethnikos Asteras Ethnikos 34 42 40 41
12 Olympiakos Volos Olympiakos 34 32 36 41
13 Apollon Pontou Apollon 34 34 45 41
14 Ethnikos Piraeus Ethnikos 34 42 41 40
15 Anagennisi Karditsas Anagennisi 34 30 43 39
16 Veria NPS Veria NPS 34 27 36 38
17 Athens Kallithea Athens 34 25 43 34
18 Kastoria Kastoria 34 28 63 18
TEMPORADA 2007/2008
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 65 17 68
2 Olympiacos Piraeus Olympiacos 30 55 24 67
3 Panathinaikos Panathinaiko 30 44 18 66
4 Aris Thessaloniki Aris 30 33 20 50
5 Panionios Panionios 30 39 42 45
6 AE Larisa AE Larisa 30 35 30 45
7 Asteras Tripolis Asteras 30 28 24 44
8 Xanthi Xanthi 30 33 39 36
9 PAOK PAOK 30 29 35 35
10 Iraklis Thessaloniki Iraklis 30 28 34 35
11 Levadiakos Levadiakos 30 31 51 33
12 OFI OFI 30 39 49 32
13 Ergotelis Ergotelis 30 28 42 30
14 Atromitos Atromitos 30 23 36 29
15 Apollon Pontou Apollon 30 28 54 25
16 Veria NPS Veria NPS 30 21 44 23
TEMPORADA 2006/2007
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 62 23 71
2 AEK Athens AEK Athens 30 60 27 62
3 Panathinaikos Panathinaiko 30 47 28 54
4 Aris Thessaloniki Aris 30 32 26 46
5 Panionios Panionios 30 33 31 45
6 PAOK PAOK 30 32 29 45
7 OFI OFI 30 41 45 42
8 Atromitos Atromitos 30 40 44 40
9 Ergotelis Ergotelis 30 30 32 39
10 AE Larisa AE Larisa 30 30 38 36
11 Xanthi Xanthi 30 24 22 36
12 Apollon Pontou Apollon 30 27 36 35
13 Kerkyra Kerkyra 30 34 36 35
14 Iraklis Thessaloniki Iraklis 30 24 36 33
15 Aigaleo FC Athens Aigaleo 30 27 45 28
16 Ionikos Nikea Ionikos 30 16 61 5
TEMPORADA 2005/2006
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 63 23 70
2 Panathinaikos Panathinaiko 30 55 23 67
3 AEK Athens AEK Athens 30 42 20 67
4 Iraklis Thessaloniki Iraklis 30 39 31 51
5 Xanthi Xanthi 30 31 25 47
6 PAOK PAOK 30 44 31 46
7 Atromitos Atromitos 30 36 37 42
8 AE Larisa AE Larisa 30 31 37 39
9 Apollon Pontou Apollon 30 32 36 38
10 Aigaleo FC Athens Aigaleo 30 23 41 33
11 Panionios Panionios 30 33 45 32
12 Ionikos Nikea Ionikos 30 36 41 32
13 OFI OFI 30 23 37 31
14 Levadiakos Levadiakos 30 24 36 31
15 Athens Kallithea Athens 30 28 49 20
16 Akratitos Akratitos 30 19 47 18
TEMPORADA 2004/2005
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 54 18 65
2 Panathinaikos Panathinaiko 30 51 18 64
3 AEK Athens AEK Athens 30 46 22 62
4 Xanthi Xanthi 30 43 29 50
5 PAOK PAOK 30 43 39 46
6 Aigaleo FC Athens Aigaleo 30 31 26 45
7 Iraklis Thessaloniki Iraklis 30 36 30 41
8 Halkidona Halkidona 30 34 38 38
9 Athens Kallithea Athens 30 39 44 37
10 Ionikos Nikea Ionikos 30 22 32 36
11 Panionios Panionios 30 25 32 35
12 Apollon Pontou Apollon 30 31 49 33
13 OFI OFI 30 36 44 32
14 Aris Thessaloniki Aris 30 26 37 25
15 Ergotelis Ergotelis 30 19 50 20
16 Kerkyra Kerkyra 30 21 49 17
TEMPORADA 2003/2004
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Kerkyra Kerkyra 30 42 13 67
2 Apollon Pontou Apollon 30 53 27 58
3 Ergotelis Ergotelis 30 39 24 55
4 Kassandra FC Kassandra 30 37 23 53
5 Poseidon Neon Poron Poseidon 30 42 23 52
6 Niki Volos Niki Volos 30 31 18 49
7 Ethnikos Asteras Ethnikos 30 35 28 45
8 Levadiakos Levadiakos 30 30 31 43
9 Apollon Smyrnis Apollon 30 36 37 41
10 Kalamata FC Kalamata FC 30 26 27 41
11 Patraikos Patraikos 30 28 25 40
12 Panserraikos FC Panserraikos 30 31 31 40
13 Atromitos Atromitos 30 33 45 37
14 PAS Giannina Giannina 30 26 31 31
15 Fostiras Fostiras 30 2 55 5
16 Panachaiki Panachaiki 30 1 54 3
TEMPORADA 2002/2003
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Halkidona Halkidona 30 61 20 65
2 Paniliakos Paniliakos 30 43 25 60
3 Apollon Pontou Apollon 30 38 19 59
4 Fostiras Fostiras 30 34 27 45
5 Kerkyra Kerkyra 30 31 23 44
6 Ethnikos Asteras Ethnikos 30 36 32 44
7 Kalamata FC Kalamata FC 30 29 22 40
8 Apollon Smyrnis Apollon 30 40 43 39
9 Atromitos Atromitos 30 30 33 37
10 Patraikos Patraikos 30 28 32 36
11 Panserraikos FC Panserraikos 30 33 41 36
12 Panegialios Panegialios 30 31 42 34
13 Athinaikos Athinaikos 30 30 41 34
14 Kassandra FC Kassandra 30 27 36 33
15 Olympiakos Volos Olympiakos 30 25 43 31
16 Kavala Kavala 30 21 58 16

  USO DE MEMORIA  
7,450,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1581
Total Execution Time  0.1593
  CADENA URL  
/historico/Apollon-Kalamarias
  GET DATOS  
$_GET['/historico/Apollon-Kalamarias']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0030  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 = 'Apollon-Kalamarias' 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.0019  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=16656 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=16656 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=16656 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 73941
0.0024  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 = 73551
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16656 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2166 AND type_rel = 3
0.0026  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 = '16656' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '16656' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 73551 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 73941 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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=16656 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73941,73551) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 73941 AND teamId = 16656
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 16656
0.0021  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 = 73941 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '16656' 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 = '16656' 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 = '16656' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033  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 = 73941 WHERE rp.league_id = 73941 AND rp.teamId = 16656 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.0035  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 = 73941 WHERE rp.league_id = 73941 AND rp.teamId = 16656 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 73941 WHERE rp.league_id = 73941 AND rp.teamId = 16656 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 16656 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 73941 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 69284 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 `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 = 65350 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.0025  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 = 60731 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.0021  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 = 51252 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 46942 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 39254 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 36065 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 15926 AND t.round = 34 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 `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 = 4429 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 3487 AND t.round = 26 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 `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 = 2781 AND t.round = 22 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 `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 = 24779 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 13403 AND t.round = 34 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 `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 = 396 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 397 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 398 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 `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 = 399 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2004` 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 = 13398 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 `tables2003` 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 = 13397 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 = 73941 ORDER BY nameShow LIMIT 100