4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Fosa Juniors Fosa Juniors 7 22 9 18
2 ASA Diana ASA Diana 8 14 6 17
3 Fanalamanga Fanalamanga 7 17 4 13
4 Tsaramandroso Tsaramandros 7 15 18 13
5 USCA Foot USCA Foot 7 8 7 10
6 COSFA COSFA 7 7 16 4
7 KFCA KFCA 6 6 15 4
8 Ajesaia Ajesaia 7 10 24 1
9 CS-Disciples CS-Disciples 7 12 5 15
10 Elgeco Plus Elgeco Plus 7 7 3 13
11 3FB Toliara 3FB Toliara 7 4 6 10
12 Zanak'Ala Zanak'Ala 7 4 6 10
13 CFFA CFFA 7 5 5 9
14 Mama FCA Mama FCA 7 5 6 9
15 Dato FC Dato FC 7 8 11 6
16 Inate FC Inate FC 7 3 6 5
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Fosa Juniors Fosa Juniors 14 24 7 34
2 COSFA COSFA 14 19 11 25
3 Ajesaia Ajesaia 14 18 13 22
4 ASA Diana ASA Diana 14 28 23 21
5 Fanalamanga Fanalamanga 14 16 12 21
6 USCA Foot USCA Foot 14 14 16 16
7 Tsaramandroso Tsaramandros 14 10 27 9
8 Tia Kitra Tia Kitra 14 10 30 7
9 Elgeco Plus Elgeco Plus 14 18 9 29
10 CFFA CFFA 14 19 10 28
11 Mama FCA Mama FCA 14 18 15 21
12 CNaPS Sport CNaPS Sport 14 24 17 18
13 Zanak'Ala Zanak'Ala 14 20 22 17
14 3FB Toliara 3FB Toliara 14 16 24 17
15 Dato FC Dato FC 14 15 21 12
16 JET Mada JET Mada 14 11 23 11
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Fosa Juniors Fosa Juniors 14 36 10 38
2 Ajesaia Ajesaia 14 23 18 20
3 Fanalamanga Fanalamanga 14 15 13 20
4 COSFA COSFA 14 15 16 20
5 USCA Foot USCA Foot 14 23 20 19
6 JET Mada JET Mada 14 14 20 15
7 Tia Kitra Tia Kitra 14 13 29 13
8 Five FC Five FC 14 8 21 7
9 Elgeco Plus Elgeco Plus 14 28 14 28
10 CFFA CFFA 14 23 10 28
11 CNaPS Sport CNaPS Sport 14 27 17 22
12 Dato FC Dato FC 14 14 14 21
13 Zanak'Ala Zanak'Ala 14 18 17 19
14 Mama FCA Mama FCA 14 9 15 16
15 3FB Toliara 3FB Toliara 14 16 34 8
16 ASJF Capricorne ASJF 14 14 28 7
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Five FC Five FC 9 17 7 18
2 COSFA COSFA 9 14 8 16
3 JET Mada JET Mada 9 9 9 10
4 Elgeco Plus Elgeco Plus 8 7 9 9
5 Fosa Juniors Fosa Juniors 7 5 7 8
6 Tia Kitra Tia Kitra 8 6 18 5
7 AS Adema AS Adema 10 19 6 25
8 Ajesaia Ajesaia 11 23 8 24
9 USCA Foot USCA Foot 11 21 16 16
10 Zanak'Ala Zanak'Ala 12 23 20 16
11 Ilakaka Ilakaka 10 19 20 15
12 CNaPS Sport CNaPS Sport 11 22 23 14
13 3FB Toliara 3FB Toliara 11 7 41 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 CNaPS Sport CNaPS Sport 16 43 12 36
2 COSFA COSFA 15 25 12 31
3 Fosa Juniors Fosa Juniors 14 28 8 30
4 Ajesaia Ajesaia 15 28 11 30
5 Elgeco Plus Elgeco Plus 15 33 17 26
6 JET Mada JET Mada 15 30 21 24
7 AS Adema AS Adema 14 15 11 22
8 3FB Toliara 3FB Toliara 15 15 24 18
9 Tia Kitra Tia Kitra 15 21 27 14
10 Zanak'Ala Zanak'Ala 14 19 28 9
11 Ilakaka Ilakaka 15 10 32 9
12 Club M Club M 15 8 72 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Fosa Juniors Fosa Juniors 4 20 1 12
2 Ajesaia Ajesaia 4 18 5 7
3 JSMS JSMS 4 8 10 5
4 Tam Port Berger Port Berger 4 9 6 4
5 3FB Betsiboka Betsiboka 0 0 0 0
6 JSA JSA 4 3 36 0
7 AS Adema AS Adema 4 4 1 10
8 JET Mada JET Mada 4 3 1 8
9 Tia Kitra Tia Kitra 4 5 4 6
10 Club M Club M 4 3 3 3
11 VoromaherinAlaotra VoromaherinA 4 2 8 1
12 AJS Maintirano Maintirano 0 0 0 0
13 Zanak'Ala Zanak'Ala 5 21 2 15
14 CNaPS Sport CNaPS Sport 5 18 4 12
15 FC Vakinankaratra Vakinankarat 5 10 8 9
16 Jofama Jofama 5 6 16 6
17 Fitafa Fitafa 5 5 15 3
18 Grand Sud Est Grand 5 2 17 0
19 Ilakaka Ilakaka 5 7 2 11
20 3FB Toliara 3FB Toliara 5 9 3 10
21 COSFA COSFA 5 12 3 8
22 Tolanaro Tolanaro 5 5 6 8
23 VFM VFM 5 5 9 4
24 Rohondroho Rohondroho 5 2 17 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Fosa Juniors Fosa Juniors 5 19 1 15
2 CNaPS Sport CNaPS Sport 5 19 2 12
3 Tam Port Berger Port Berger 5 11 11 9
4 Metal Metal 5 10 13 4
5 Iharana Iharana 5 7 18 4
6 FC Maeva FC Maeva 5 3 24 0
7 Ajesaia Ajesaia 5 17 2 15
8 FCA FCA 5 12 9 12
9 MTM MTM 5 9 10 5
10 Racing Soma Beach Racing Soma 5 5 8 5
11 Ascoimi Mahanoro Ascoimi 5 6 10 5
12 Leopard Leopard 5 3 13 0
13 JET Mada JET Mada 5 11 1 13
14 Elgeco Plus Elgeco Plus 5 7 2 11
15 FC Vakinankaratra Vakinankarat 5 6 3 7
16 AZ AZ 5 4 5 7
17 Rabaza Rabaza 5 3 6 4
18 Olympique Belo/na Olympique 5 0 14 0
19 3FB Toliara 3FB Toliara 4 8 1 12
20 Fils Eléphant Fils 4 6 4 9
21 Akon Ambatomena Akon 4 10 4 6
22 VFM VFM 4 2 5 3
23 Espoir Manerinerina Espoir 0 0 0 0
24 Manjaka Manjaka 4 1 13 0
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 COSFA COSFA 5 17 3 13
2 USSK Ambanja USSK Ambanja 5 13 8 8
3 Varatraza Varatraza 5 9 14 7
4 Fosa Juniors Fosa Juniors 5 7 5 5
5 Iharana Iharana 5 7 13 5
6 MTM MTM 5 5 15 2
7 HZAM Amparafaravola HZAM 5 5 3 10
8 Ajesaia Ajesaia 5 11 2 9
9 JET Mada JET Mada 5 9 4 9
10 Fifafifi TFC Atsinana Fifafifi 5 8 8 8
11 FC Vakinankaratra Vakinankarat 5 9 7 7
12 STF STF 5 2 20 0
13 Elgeco Plus Elgeco Plus 5 27 3 13
14 Top Dom Top Dom 5 12 3 13
15 FC Maeva FC Maeva 5 14 15 7
16 VFM VFM 5 11 12 7
17 Malaimbandy Malaimbandy 5 7 20 3
18 Menagnara Menagnara 5 3 21 0
19 CNaPS Sport CNaPS Sport 5 22 2 15
20 Angèle Angèle 5 20 9 9
21 Zanak'Ala Zanak'Ala 5 20 10 9
22 3FB Toliara 3FB Toliara 5 8 7 7
23 JSA JSA 5 6 22 4
24 Espoir Manerinerina Espoir 5 5 31 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Fosa Juniors Fosa Juniors 5 26 4 12
2 Joël Sava Joël Sava 5 14 5 12
3 JET Mada JET Mada 5 14 8 10
4 USSK Ambanja USSK Ambanja 5 10 12 7
5 Tam Port Berger Port Berger 5 9 21 3
6 Espoir Manerinerina Espoir 5 1 24 0
7 Ajesaia Ajesaia 5 5 1 11
8 Elgeco Plus Elgeco Plus 5 7 3 10
9 Fitama Fitama 5 3 2 8
10 Otiv Otiv 5 4 6 5
11 FCE Atsinanana Atsinanana 5 4 7 4
12 FC 3M Menabe Menabe 5 2 6 3
13 CNaPS Sport CNaPS Sport 5 28 1 13
14 Tana Formation Tana 5 22 5 11
15 FC Vakinankaratra Vakinankarat 5 15 4 10
16 MTM MTM 5 5 24 4
17 Black Star Black Star 5 5 14 3
18 SFF SFF 5 3 30 1
19 Zanak'Ala Zanak'Ala 5 15 4 12
20 Fort Dauphin Fort Dauphin 5 9 2 10
21 Comato Comato 5 9 4 7
22 ASJF Capricorne ASJF 5 8 6 7
23 Jocker Jocker 5 5 9 7
24 Real Tsihombey Real 5 3 24 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CNaPS Sport CNaPS Sport 5 20 2 15
2 Joël Sava Joël Sava 5 9 7 9
3 ASCUM Boeny ASCUM Boeny 5 6 10 9
4 Tam Port Berger Port Berger 5 13 13 7
5 Nosy-Bé Nosy-Bé 5 9 16 4
6 FC Maeva FC Maeva 5 5 14 0
7 Ajesaia Ajesaia 4 17 3 10
8 Tana Formation Tana 4 16 2 10
9 Cousin Cousin 4 5 10 4
10 Itasy Itasy 4 4 10 4
11 THEM FC THEM FC 4 1 18 0
12 AS Fortior AS Fortior 4 7 1 8
13 Iarivo Iarivo 4 5 0 8
14 HZAM Amparafaravola HZAM 4 5 2 8
15 FC Vakinankaratra Vakinankarat 4 1 4 3
16 Demerde Analanjirofo Demerde 4 1 12 0
17 Comato Comato 5 12 2 11
18 PRESCOI Marovoay FC PRESCOI 5 13 2 10
19 3FB Toliara 3FB Toliara 5 7 1 10
20 Clik Clik 5 10 3 9
21 ECAR Mangarivotra ECAR 5 5 10 3
22 Atafa Atafa 5 2 31 0
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 AS Adema AS Adema 5 8 0 13
2 ASCUM Boeny ASCUM Boeny 5 10 6 10
3 FC Maeva FC Maeva 5 5 2 8
4 Antalaha Sava Antalaha 5 6 9 6
5 Amazone Ambilobe Amazone 5 6 10 3
6 Bemiray Sofia Bemiray 5 5 13 3
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 AS Saint-Michel Saint-Michel 5 10 0 13
2 Terrible de la Cote Ouest Terrible 5 6 1 11
3 FC Vohemar FC Vohemar 5 3 8 6
4 FC Maeva FC Maeva 5 5 7 4
5 Andona Mahay Miray FC Andona Mahay 5 3 9 4
6 Kohinoor SC Kohinoor SC 5 2 4 3
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Tana Formation Tana 5 17 3 13
2 COSFA COSFA 5 10 4 12
3 Terrible de la Cote Ouest Terrible 5 3 3 6
4 FC Jirama FC Jirama 5 8 14 5
5 FC2A Amboasary FC2A 5 4 11 4
6 Comato Comato 5 3 10 1
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Port Port 5 3 6 4
2 ASJF Capricorne ASJF 5 9 3 13
3 FC Ihosy FC Ihosy 5 10 7 9
4 FC2A Amboasary FC2A 5 1 1 6
5 Fomela Fomela 5 3 6 4
6 Vohipeno Vohipeno 5 5 7 3
7 Rohondroho Rohondroho 5 4 8 2
8 Académie Ny Antsika Académie 5 16 0 15
9 Japan Actuel's Japan 5 12 4 10
10 Briamdat Briamdat 5 4 6 6
11 RDN Arivonimamo Arivonimamo 5 2 10 4
12 FCCM Vangaindrano FCCM 5 4 15 3
13 CNaPS Sport CNaPS Sport 5 20 3 15
14 FCE Atsinanana Atsinanana 5 13 4 12
15 HZAM Amparafaravola HZAM 5 7 7 7
16 BAS Tsiroanomamandidy Tsiroanomama 5 3 8 4
17 AJS Sainte Marie Sainte Marie 5 3 12 2
18 ACFM Fandriana ACFM 5 5 17 2
19 Ajesaia Ajesaia 5 7 4 11
20 Nosy-Bé Nosy-Bé 5 6 5 8
21 ASCUM Boeny ASCUM Boeny 5 3 2 8
22 Fitamy Mampikony Fitamy 5 7 7 7
23 FC Maeva FC Maeva 5 2 4 4
24 Joël Sava Joël Sava 5 2 5 2
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Nosy-Bé Nosy-Bé 3 4 3 6
2 ASCUM Boeny ASCUM Boeny 3 3 2 4
3 Joël Sava Joël Sava 3 3 4 4
4 Herita Antsohihy Herita 3 4 5 2
5 CNaPS Sport CNaPS Sport 3 8 3 6
6 Tana Formation Tana 3 5 5 4
7 MTM MTM 3 4 5 4
8 BAS Tsiroanomamandidy Tsiroanomama 3 3 7 2
9 Académie Ny Antsika Académie 3 13 0 9
10 Japan Actuel's Japan 3 6 1 6
11 FC Maeva FC Maeva 3 2 10 3
12 FC Grand Olympique Menabe Grand 3 1 11 0
13 FC Jirama FC Jirama 2 5 0 6
14 Real Vatovavy Real 2 1 3 3
15 FCCM Vangaindrano FCCM 0 0 0 0
16 Mania Ambositra Mania 2 0 3 0
17 3FB Toliara 3FB Toliara 2 2 0 4
18 Ilakaka Ilakaka 2 1 0 4
19 Espoir Ambovombe FC Espoir 0 0 0 0
20 Fils Eléphant Fils 2 0 3 0
21 AS Adema AS Adema 3 11 1 5
22 VoromaherinAlaotra VoromaherinA 3 5 2 5
23 AS Fortior AS Fortior 3 5 3 5
24 Espérance Vavatenina Espérance 3 0 15 0

  USO DE MEMORIA  
6,706,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1121
Total Execution Time  0.1139
  CADENA URL  
/liga_madagascar2024/grupo1/historico
  GET DATOS  
$_GET['/liga_madagascar2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_madagascar2024'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_madagascar' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 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=522 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 522 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (352207) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=522 ORDER BY order_id ASC
0.0020  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 522 GROUP BY l.categoryId
0.0020  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=522 GROUP BY l.year ORDER BY l.year DESC
0.0020  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 = 75399 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 522 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 75399 AND t.round = 7 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 = 70567 AND t.round = 14 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 `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 = 66089 AND t.round = 14 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 `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 = 61127 AND t.round = 14 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 = 55375 AND t.round = 15 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 `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 = 49816 AND t.round = 5 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 `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 = 44681 AND t.round = 5 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 `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 = 43905 AND t.round = 5 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 = 34817 AND t.round = 5 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 `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 = 24806 AND t.round = 5 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 = 12870 AND t.round = 5 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 `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 = 3317 AND t.round = 5 ORDER BY team.conference 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 `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 = 24817 AND t.round = 5 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 = 24821 AND t.round = 5 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 `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 = 24828 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 20:34:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 20: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-05-03 20: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-05-03 20:34:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_madagascar' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2024 e ON e.player_id = p.id AND e.league_id = 75399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75399 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 events2024 e ON e.player_id = p.id AND e.league_id = 75399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75399 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events2024 e ON e.player_id = p.id AND e.league_id = 75399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75399 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  SELECT *,(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 = 75399 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC