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 Jeunesse Sportive Omrane Jeunesse 19 36 9 42
2 Jendouba Sports Jendouba 19 26 9 41
3 Hammam-Lif Hammam-Lif 19 24 13 32
4 ES Hammam Sousse Hammam 19 24 19 31
5 Sportif de Korba Sportif 19 20 16 29
6 AS Ariana AS Ariana 19 20 21 29
7 JS Kairouanaise Kairouanaise 19 15 12 24
8 ES Rades ES Rades 20 19 28 23
9 M'Saken M'Saken 20 10 16 21
10 CS Tabarka CS Tabarka 20 18 29 20
11 Oued Ellil Oued Ellil 19 8 20 19
12 Kalaâ Sport Kalaâ Sport 20 11 24 15
13 Sporting Ben Arous Sporting 20 9 24 13
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Marsa Marsa 23 42 13 50
2 JS Kairouanaise Kairouanaise 23 28 17 42
3 Jerba Jerba 23 20 21 33
4 Oued Ellil Oued Ellil 23 21 17 31
5 Gabès Gabès 23 22 22 31
6 Jendouba Sports Jendouba 23 24 25 29
7 ES Rades ES Rades 23 18 21 27
8 Rogba Tataouine Rogba 23 21 25 27
9 CO Médenine Médenine 23 19 23 27
10 Sportif de Korba Sportif 23 18 22 27
11 AS Mohammedia Mohammedia 23 22 29 26
12 CS Bembla CS Bembla 23 22 42 21
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Stade Tunisien Stade 10 14 7 20
2 Kalaâ Sport Kalaâ Sport 10 11 8 15
3 CS Bembla CS Bembla 10 6 7 15
4 Stade Sportif Sfaxien Stade 10 9 10 14
5 ES Rades ES Rades 10 9 13 11
6 CO Médenine Médenine 10 4 8 7
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 CO Médenine Médenine 10 15 5 23
2 Hammam-Lif Hammam-Lif 10 16 14 18
3 Sportif de Korba Sportif 10 16 14 12
4 Jendouba Sports Jendouba 10 7 9 11
5 Sportive de Djerba Sportive 10 7 13 10
6 Sbikha Sbikha 10 12 18 8
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Olympique Béja Olympique 15 18 7 32
2 CO Sidi Bouzid Sidi Bouzid 15 16 9 28
3 Sfax Railways Sfax 15 18 15 26
4 Sbikha Sbikha 15 15 15 22
5 CO Médenine Médenine 15 12 12 22
6 Sporting Ben Arous Sporting 15 14 10 21
7 Zarzis Zarzis 15 9 6 21
8 Gabès Gabès 15 13 12 19
9 ES Rades ES Rades 15 12 11 19
10 M'Saken M'Saken 15 19 17 18
11 Menzel Bourguiba Menzel 15 5 15 14
12 AS Ariana AS Ariana 15 5 27 4
13 Rejiche Rejiche 15 27 10 32
14 EGS Gafsa EGS Gafsa 15 18 11 31
15 Stade Gabésien Stade 15 9 7 22
16 Jendouba Sports Jendouba 15 17 15 21
17 Oued Ellil Oued Ellil 15 15 13 21
18 Jerba Jerba 15 11 11 21
19 Sportive de Djerba Sportive 15 13 14 19
20 Menzel Bouzelfa Menzel 15 9 11 18
21 ES Hammam Sousse Hammam 15 12 20 15
22 AS Kasserine Kasserine 15 15 21 14
23 Marsa Marsa 15 10 16 14
24 Stade Sportif Sfaxien Stade 15 16 23 13
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 AS Soliman AS Soliman 22 40 23 46
2 Marsa Marsa 22 27 17 43
3 Olympique Béja Olympique 22 30 18 42
4 Zarzis Zarzis 22 26 20 38
5 CO Médenine Médenine 22 22 30 28
6 Jerba Jerba 22 23 28 27
7 Sfax Railways Sfax 22 27 30 25
8 Sportive de Djerba Sportive 22 24 24 23
9 Oued Ellil Oued Ellil 22 34 43 23
10 AS Ariana AS Ariana 22 19 30 23
11 US Seliana US Seliana 22 29 31 21
12 Sportif de Korba Sportif 22 21 28 20
13 Chebba Chebba 22 40 8 58
14 Menzel Bourguiba Menzel 22 25 17 39
15 EGS Gafsa EGS Gafsa 22 39 25 37
16 Stade Sportif Sfaxien Stade 22 27 22 32
17 AS Kasserine Kasserine 22 24 22 32
18 Jendouba Sports Jendouba 22 24 23 27
19 ES Hammam Sousse Hammam 22 19 24 27
20 ES Rades ES Rades 21 29 31 26
21 Sporting Ben Arous Sporting 22 16 22 26
22 Jebeniana Jebeniana 21 20 34 21
23 CO Sidi Bouzid Sidi Bouzid 21 18 37 21
24 Kerkennah Kerkennah 21 12 28 16
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 US Tataouine Tataouine 18 29 16 38
2 EGS Gafsa EGS Gafsa 18 27 15 34
3 Sfax Railways Sfax 18 17 12 30
4 Marsa Marsa 18 22 18 29
5 AS Kasserine Kasserine 18 26 26 24
6 Sportif de Korba Sportif 18 21 20 23
7 ES Hammam Sousse Hammam 18 18 18 21
8 Kerkennah Kerkennah 18 14 18 20
9 AS Ariana AS Ariana 18 16 26 19
10 STIR S Zarzouna STIR 18 10 31 9
11 Chebba Chebba 18 23 15 28
12 CO Sidi Bouzid Sidi Bouzid 18 22 16 27
13 Olympique Béja Olympique 18 17 19 26
14 Hammam-Lif Hammam-Lif 18 15 11 25
15 Menzel Bourguiba Menzel 18 18 19 25
16 AS Soliman AS Soliman 18 19 15 24
17 Jendouba Sports Jendouba 18 14 16 23
18 Stade Sportif Sfaxien Stade 18 16 24 23
19 Sporting Ben Arous Sporting 18 16 21 21
20 Sportive de Djerba Sportive 18 19 23 20
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Monastir Monastir 18 27 11 36
2 Menzel Bourguiba Menzel 18 21 11 30
3 Sporting Ben Arous Sporting 18 18 20 28
4 EGS Gafsa EGS Gafsa 18 22 11 24
5 AS Kasserine Kasserine 18 15 19 24
6 Sportif de Korba Sportif 18 19 20 23
7 ES Hammam Sousse Hammam 18 16 17 23
8 FC Hammamet FC Hammamet 18 16 18 22
9 Olympique du Kef Olympique 17 11 21 17
10 US Seliana US Seliana 17 8 25 13
11 Sportive de Djerba Sportive 18 18 10 32
12 Stade Tunisien Stade 18 18 10 31
13 Stade Sportif Sfaxien Stade 18 21 21 28
14 CO Médenine Médenine 18 17 12 26
15 Jendouba Sports Jendouba 18 22 22 23
16 Sfax Railways Sfax 18 18 21 23
17 M'Saken M'Saken 18 21 24 22
18 AS Ariana AS Ariana 18 27 29 21
19 Grombalia Sports Grombalia 18 13 19 20
20 Stade Nabeulien Stade 18 16 23 19
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Monastir Monastir 18 31 20 34
2 FC Hammamet FC Hammamet 18 22 13 33
3 Jendouba Sports Jendouba 18 25 16 31
4 Grombalia Sports Grombalia 18 23 16 30
5 Sportif de Korba Sportif 18 16 17 23
6 Stade Sportif Sfaxien Stade 18 20 22 22
7 Olympique du Kef Olympique 18 20 28 20
8 STIR S Zarzouna STIR 18 14 20 18
9 Sportive de Djerba Sportive 18 16 23 18
10 Sbeitla Sbeitla 18 19 31 14
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Sfax Railways Sfax 18 23 14 32
2 Olympique du Kef Olympique 18 20 14 29
3 CO Sidi Bouzid Sidi Bouzid 18 22 19 29
4 Sportif de Korba Sportif 18 21 23 25
5 Olympique Béja Olympique 18 18 17 24
6 Sbeitla Sbeitla 18 18 16 23
7 FC Hammamet FC Hammamet 18 18 18 21
8 Jendouba Sports Jendouba 18 20 25 21
9 Stade Sportif Sfaxien Stade 18 16 22 19
10 LPTA Tozeur LPTA Tozeur 18 12 20 17
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Gabès Gabès 18 29 14 40
2 Sportive de Djerba Sportive 18 22 16 31
3 Zarzis Zarzis 18 20 14 30
4 CO Sidi Bouzid Sidi Bouzid 18 20 17 23
5 M'Saken M'Saken 18 22 22 23
6 Sporting Ben Arous Sporting 18 18 20 23
7 AS Ariana AS Ariana 18 18 23 23
8 AS Kasserine Kasserine 18 19 26 21
9 Sportif Hilalien Sportif 18 17 23 20
10 ES Beni-Khalled Beni-Khalled 18 11 21 14
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Etoile Metlaoui Etoile 18 26 10 35
2 Grombalia Sports Grombalia 18 27 16 35
3 ES Beni-Khalled Beni-Khalled 18 20 16 24
4 M'Saken M'Saken 18 22 18 23
5 Sportif de Korba Sportif 18 22 25 23
6 Jendouba Sports Jendouba 18 18 20 22
7 AS Kasserine Kasserine 18 15 20 21
8 Enfida Sports Enfida 18 15 20 21
9 Menzel Bourguiba Menzel 18 16 23 20
10 EA Mateur EA Mateur 18 12 25 18
11 LPTA Tozeur LPTA Tozeur 18 21 13 30
12 Sfax Railways Sfax 18 20 16 29
13 Ben Guerdane Guerdane 18 19 14 27
14 Sporting Ben Arous Sporting 18 20 20 27
15 Gabès Gabès 18 20 21 24
16 Sportif Hilalien Sportif 18 12 12 22
17 Club Transports Club 18 13 14 22
18 CO Sidi Bouzid Sidi Bouzid 18 19 25 22
19 Sportive de Djerba Sportive 18 25 23 21
20 SC Moknine SC Moknine 18 15 26 18
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Olympique du Kef Olympique 30 37 29 53
2 Stade Gabésien Stade 30 38 24 50
3 Ben Guerdane Guerdane 30 34 25 49
4 Sportif de Korba Sportif 30 37 24 48
5 M'Saken M'Saken 30 31 24 46
6 SC Moknine SC Moknine 30 44 47 42
7 Grombalia Sports Grombalia 30 34 33 41
8 AS Kasserine Kasserine 30 28 32 39
9 Sportif Hilalien Sportif 30 28 32 38
10 Jendouba Sports Jendouba 30 29 28 37
11 Sportive de Djerba Sportive 30 30 33 37
12 LPTA Tozeur LPTA Tozeur 30 26 26 36
13 EA Mateur EA Mateur 30 26 30 35
14 Club Transports Club 30 26 42 35
15 Stade Nabeulien Stade 30 30 39 33
16 Kalaâ Sport Kalaâ Sport 30 27 37 28
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Monastir Monastir 26 36 20 51
2 ES Beni-Khalled Beni-Khalled 26 37 29 46
3 Stade Gabésien Stade 26 35 26 40
4 LPTA Tozeur LPTA Tozeur 26 31 26 39
5 Sportive de Djerba Sportive 26 30 29 36
6 EA Mateur EA Mateur 26 20 25 35
7 Club Transports Club 26 26 27 34
8 Sportif de Korba Sportif 26 30 32 34
9 SC Moknine SC Moknine 26 33 35 31
10 Jendouba Sports Jendouba 26 26 29 31
11 AS Kasserine Kasserine 26 24 28 31
12 Olympique du Kef Olympique 26 23 26 30
13 M'Saken M'Saken 26 27 31 30
14 Ben Guerdane Guerdane 26 20 35 21
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Marsa Marsa 26 44 17 59
2 Gabès Gabès 26 42 23 52
3 Stade Gabésien Stade 26 29 19 45
4 ES Beni-Khalled Beni-Khalled 26 30 23 43
5 M'Saken M'Saken 26 32 32 39
6 LPTA Tozeur LPTA Tozeur 26 29 30 37
7 Jendouba Sports Jendouba 26 27 30 37
8 Sportive de Djerba Sportive 26 34 30 35
9 Ben Guerdane Guerdane 26 25 27 34
10 Olympique du Kef Olympique 26 29 34 30
11 Sportif de Korba Sportif 26 19 26 29
12 EA Mateur EA Mateur 26 19 31 29
13 EM Mahdia EM Mahdia 26 21 29 28
14 Menzel Bourguiba Menzel 26 20 49 11
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Zarzis Zarzis 26 43 18 56
2 JS Kairouanaise Kairouanaise 26 37 17 46
3 Stade Gabésien Stade 26 31 19 45
4 M'Saken M'Saken 26 32 24 43
5 Sportive de Djerba Sportive 26 30 27 37
6 Sportif de Korba Sportif 26 31 35 34
7 ES Beni-Khalled Beni-Khalled 26 28 31 33
8 Gabès Gabès 26 28 33 32
9 Olympique du Kef Olympique 26 23 29 30
10 EM Mahdia EM Mahdia 26 23 31 29
11 Ben Guerdane Guerdane 26 23 32 29
12 AS Ariana AS Ariana 26 22 29 27
13 Menzel Bourguiba Menzel 26 27 36 27
14 STIR S Zarzouna STIR 26 20 37 20

  USO DE MEMORIA  
6,658,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.1604
Total Execution Time  0.1638
  CADENA URL  
/ligue_ii_tunez2024/grupo1/historico
  GET DATOS  
$_GET['/ligue_ii_tunez2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0041  SELECT type FROM routes WHERE alias = 'ligue_ii_tunez2024'
0.0054  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_ii_tunez' 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=414 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=414 ORDER BY order_id ASC
0.0019  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 = 74234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 414 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 = 74234 AND t.round = 21 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 = 69695 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.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 `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 = 65686 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0068  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 = 61665 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0082  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 = 51178 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.0037  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 = 45065 AND t.round = 22 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 `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 = 39712 AND t.round = 18 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 = 36063 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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 = 15821 AND t.round = 18 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 `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 = 9212 AND t.round = 18 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 `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 = 2971 AND t.round = 18 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 = 15384 AND t.round = 18 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 = 15387 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 `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 = 15388 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 `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 = 15389 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 `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 = 15390 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 16:55:23' 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-05-05 16:55:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 16:55:23' 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=3 AND last_update > '2024-05-05 16:55:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_ii_tunez' 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.0118  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 = 74234 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74234 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.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 = 74234 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74234 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  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 = 74234 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74234 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 = 74234 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC