Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Peyia Peyia 26 42 12 57
2 MEAP Nisou MEAP Nisou 26 41 23 49
3 Digenis Ypsonas Digenis 26 41 26 48
4 AE Zakakiou AE Zakakiou 26 44 26 47
5 Digenis Morphou Digenis 26 45 25 43
6 Elia Lythrodonta Elia 26 35 36 35
7 Iraklis Yerolakkou Iraklis 26 35 40 32
8 Kouris Erimi Kouris Erimi 26 29 36 29
9 EN THOI Lakatamia THOI 26 32 35 29
10 APEP APEP 26 32 40 29
11 Ethnikos Assias Ethnikos 26 26 43 28
12 Ormideia Ormideia 26 27 42 28
13 Halkanoras Halkanoras 26 28 44 25
14 Omonia Psevda Omonia 26 33 62 21
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Omonia 29is Omonia 29is 26 45 22 58
2 Olympiada Lympion Olympiada 25 49 16 53
3 Peyia Peyia 26 46 27 52
4 Ethnikos Assias Ethnikos 26 49 30 43
5 MEAP Nisou MEAP Nisou 25 39 31 38
6 Halkanoras Halkanoras 26 40 31 38
7 Ormideia Ormideia 25 42 36 37
8 Iraklis Yerolakkou Iraklis 25 37 33 35
9 APONA Anagias APONA 26 35 34 31
10 APEP APEP 26 30 34 31
11 Oroklini / Troulloi Oroklini 25 28 47 26
12 Elpida Astromeritis Elpida 25 27 45 25
13 ENAD ENAD 25 21 40 25
14 Amathous Amathous 26 23 37 24
15 Elia Lythrodonta Elia 26 34 45 23
16 O Kormakitis Kormakitis 25 20 57 12
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Ahironas Ahironas 22 49 26 49
2 PAEEK PAEEK 22 48 20 46
3 Kouris Erimi Kouris Erimi 22 43 23 45
4 EN THOI Lakatamia THOI 22 39 23 41
5 Halkanoras Halkanoras 22 45 31 39
6 MEAP Nisou MEAP Nisou 22 47 31 37
7 Elpida Astromeritis Elpida 22 39 36 36
8 Elia Lythrodonta Elia 22 31 25 32
9 Iraklis Yerolakkou Iraklis 22 29 25 30
10 APONA Anagias APONA 22 26 36 28
11 Ormideia Ormideia 22 33 26 25
12 Ethnikos Assias Ethnikos 22 32 41 23
13 Amathous Amathous 22 21 42 17
14 O Kormakitis Kormakitis 22 20 45 17
15 Digenis Voroklinis Digenis 22 20 59 9
16 ENAD ENAD 22 18 51 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Digenis Morphou Digenis 30 62 26 62
2 Omonia Psevda Omonia 30 50 35 58
3 Digenis Ypsonas Digenis 30 52 27 53
4 Xylotympou Xylotympou 30 39 25 52
5 ENAD ENAD 30 45 35 47
6 Halkanoras Halkanoras 30 52 50 43
7 Ethnikos Assias Ethnikos 30 44 44 43
8 Kouris Erimi Kouris Erimi 30 39 39 42
9 Ormideia Ormideia 30 44 39 41
10 Ahironas Ahironas 30 42 42 40
11 Elpida Astromeritis Elpida 30 38 49 39
12 Amathous Amathous 30 37 42 38
13 APEA APEA 30 43 50 38
14 Olympiada Lympion Olympiada 30 43 53 33
15 Ethnikos Latsion Ethnikos 30 30 52 25
16 Peyia Peyia 30 25 77 9
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Onisilos Onisilos 30 60 22 68
2 MEAP Nisou MEAP Nisou 30 67 31 63
3 Akritas Chlorakas Akritas 30 44 22 58
4 Digenis Ypsonas Digenis 30 61 45 48
5 ENAD ENAD 30 47 35 47
6 Elpida Astromeritis Elpida 30 44 36 46
7 Peyia Peyia 30 41 48 45
8 APEA APEA 30 35 39 41
9 Ahironas Ahironas 30 41 47 38
10 Ormideia Ormideia 30 33 35 38
11 Ethnikos Latsion Ethnikos 30 45 55 37
12 Digenis Morphou Digenis 30 45 47 36
13 Olympiada Lympion Olympiada 30 45 60 35
14 APEP APEP 30 36 46 32
15 Foinikas Agia Marina Foinikas 30 23 51 20
16 Leivadiakós Leivadiakós 30 35 83 15
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Xylotympou Xylotympou 30 54 22 70
2 Digenis Voroklinis Digenis 30 57 35 57
3 Halkanoras Halkanoras 30 52 39 56
4 Ethnikos Latsion Ethnikos 30 59 25 54
5 Olympiada Lympion Olympiada 30 41 45 46
6 Digenis Ypsonas Digenis 30 42 45 43
7 Digenis Morphou Digenis 30 48 48 42
8 Ahironas Ahironas 30 38 38 39
9 Peyia Peyia 30 41 38 38
10 MEAP Nisou MEAP Nisou 30 34 44 36
11 Ormideia Ormideia 30 31 36 35
12 APEP APEP 30 32 40 35
13 Leivadiakós Leivadiakós 30 44 48 34
14 Iraklis Yerolakkou Iraklis 30 41 48 32
15 Elpida Astromeritis Elpida 30 36 54 29
16 Agiou Georgiou Vrysoúllon Agiou 30 27 72 18
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Akritas Chlorakas Akritas 30 72 21 67
2 Alki Oroklini Alki 30 62 25 67
3 Ethnikos Assias Ethnikos 30 64 34 57
4 MEAP Nisou MEAP Nisou 30 51 33 50
5 Ahironas Ahironas 30 44 36 49
6 Halkanoras Halkanoras 30 44 34 47
7 Xylotympou Xylotympou 30 36 43 44
8 Digenis Ypsonas Digenis 30 31 38 39
9 Iraklis Yerolakkou Iraklis 30 39 41 38
10 Olympiada Lympion Olympiada 30 38 48 38
11 Ormideia Ormideia 30 37 50 34
12 Digenis Morphou Digenis 30 44 59 34
13 Ethnikos Latsion Ethnikos 30 24 39 33
14 APEP APEP 30 38 55 33
15 Kouris Erimi Kouris Erimi 30 27 53 20
16 Amathous Amathous 30 26 68 17
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 EN THOI Lakatamia THOI 26 46 17 57
2 ASIL Lysi ASIL Lysi 26 37 16 46
3 Digenis Ypsonas Digenis 26 36 29 41
4 PAEEK PAEEK 26 36 30 41
5 MEAP Nisou MEAP Nisou 26 33 32 39
6 Akritas Chlorakas Akritas 26 37 37 36
7 Ahironas Ahironas 26 33 29 35
8 Ethnikos Latsion Ethnikos 26 28 31 34
9 Amathous Amathous 26 40 46 33
10 Ethnikos Assias Ethnikos 26 30 36 33
11 Chalkanoras Idaliou Chalkanoras 26 37 41 30
12 Ormideia Ormideia 26 32 38 28
13 Digenis Morphou Digenis 26 21 37 23
14 Foinikas Agia Marina Foinikas 26 20 47 13
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Elpida Astromeritis Elpida 26 43 10 62
2 ENAD ENAD 26 59 20 60
3 EN THOI Lakatamia THOI 26 58 24 54
4 Ahironas Ahironas 26 42 25 45
5 MEAP Nisou MEAP Nisou 26 35 40 38
6 Ormideia Ormideia 26 32 31 36
7 Foinikas Agia Marina Foinikas 26 41 40 36
8 Ethnikos Assias Ethnikos 26 37 46 35
9 Akritas Chlorakas Akritas 26 25 35 32
10 Ethnikos Latsion Ethnikos 26 27 38 30
11 Digenis Morphou Digenis 26 24 40 25
12 Spartakos Kitiou Spartakos 26 31 52 25
13 Adonis Idaliou Adonis 26 33 51 17
14 Constantinos Constantinos 26 31 66 12
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Karmiotissa Karmiotissa 26 49 19 56
2 EN Parekklisias Parekklisias 26 54 20 53
3 Digenis Voroklinis Digenis 26 40 26 51
4 ASIL Lysi ASIL Lysi 26 41 22 50
5 ENAD ENAD 26 39 22 45
6 Spartakos Kitiou Spartakos 26 38 37 41
7 Adonis Idaliou Adonis 26 38 35 37
8 Ethnikos Latsion Ethnikos 26 27 34 29
9 Ormideia Ormideia 26 33 33 27
10 Ahironas Ahironas 26 26 55 23
11 Digenis Morphou Digenis 26 27 43 22
12 Elpida Astromeritis Elpida 26 22 43 22
13 Frenaros 2000 Frenaros 26 32 52 21
14 Atromitos Yeroskipou Atromitos 26 28 53 20
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 AEK Kouklia AEK Kouklia 26 62 16 61
2 N&S Erimis N&S Erimis 26 42 26 53
3 AE Zakakiou AE Zakakiou 26 43 28 52
4 ASIL Lysi ASIL Lysi 26 56 26 46
5 Adonis Idaliou Adonis 26 43 33 42
6 ENAD ENAD 26 39 33 38
7 Spartakos Kitiou Spartakos 26 36 28 37
8 Digenis Morphou Digenis 26 33 35 33
9 Frenaros 2000 Frenaros 26 29 33 32
10 Elpida Astromeritis Elpida 26 26 36 31
11 Ormideia Ormideia 26 27 33 30
12 Ahironas Ahironas 26 32 46 28
13 Anagennisi Germasogeias Anagennisi 26 21 38 23
14 Maroniou Maroniou 26 0 78 0
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Ethnikos Assias Ethnikos 26 43 23 52
2 EN Parekklisias Parekklisias 26 49 29 48
3 Ayia Napa Ayia Napa 26 39 14 47
4 ENAD ENAD 26 36 24 47
5 Spartakos Kitiou Spartakos 26 38 33 40
6 AEK Kouklia AEK Kouklia 26 32 36 39
7 Frenaros 2000 Frenaros 26 28 23 34
8 AE Zakakiou AE Zakakiou 26 35 46 33
9 Anagennisi Germasogeias Anagennisi 26 31 38 31
10 N&S Erimis N&S Erimis 26 33 41 29
11 Elpida Astromeritis Elpida 26 25 34 29
12 Digenis Voroklinis Digenis 26 31 41 24
13 MEAP Nisou MEAP Nisou 26 31 44 21
14 Iraklis Yerolakkou Iraklis 26 24 49 17
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Halkanoras Halkanoras 26 74 24 59
2 Adonis Idaliou Adonis 26 47 28 47
3 Anagennisi Anagennisi 26 42 29 46
4 AE Zakakiou AE Zakakiou 26 42 41 37
5 AE Kouklion AE Kouklion 26 37 39 35
6 ENAD ENAD 26 38 37 34
7 Elpida Astromeritis Elpida 26 25 32 34
8 Spartakos Kitiou Spartakos 26 41 36 33
9 Ethnikos Assias Ethnikos 26 32 40 32
10 Iraklis Yerolakkou Iraklis 26 40 50 32
11 Digenis Voroklinis Digenis 26 36 50 31
12 Kissos Kissonergas Kissos 26 31 36 29
13 EN THOI Lakatamia THOI 26 37 48 27
14 Ahironas Ahironas 26 20 52 21
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Akritas Chlorakas Akritas 26 46 23 54
2 Frenaros 2000 Frenaros 26 52 29 48
3 Othellos Athienou Othellos 26 35 23 46
4 AE Zakakiou AE Zakakiou 26 42 35 39
5 Digenis Voroklinis Digenis 26 36 32 39
6 AEK Kouklia AEK Kouklia 26 33 27 38
7 Kissos Kissonergas Kissos 26 36 38 38
8 Spartakos Kitiou Spartakos 26 48 37 37
9 Adonis Idaliou Adonis 26 39 31 36
10 Elpida Astromeritis Elpida 26 34 40 33
11 Anagennisi Anagennisi 26 32 35 32
12 Anagennisi Trahoniou Anagennisi 26 38 51 31
13 Orfeas FC Levkosia Orfeas 26 24 44 25
14 Olympos Xylofagou FC Olympos 26 26 76 7

  USO DE MEMORIA  
6,425,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1003
Total Execution Time  0.1023
  CADENA URL  
/3_division_chipre2022/grupo1/historico
  GET DATOS  
$_GET['/3_division_chipre2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0019  SELECT type FROM routes WHERE alias = '3_division_chipre2022'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_division_chipre' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=578 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=578 ORDER BY order_id ASC
0.0021  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 64646 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 578 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 64646 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.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 = 58330 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.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 `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 = 51095 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.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 `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 = 44928 AND t.round = 30 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 `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 = 39162 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 `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 = 33689 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 `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 = 15847 AND t.round = 30 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 `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 = 4165 AND t.round = 26 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 `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 = 3551 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 23918 AND t.round = 26 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 `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 = 23919 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 `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 = 23920 AND t.round = 26 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 `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 = 23921 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 `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 = 23922 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 12:34:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 12:34:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 12:34:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 12:34:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_division_chipre' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0024  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64646 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64646 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64646 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64646 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64646 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64646 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  SELECT *,(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 = 64646 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