4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CODM Meknes
TEMPORADA 2023/2024
BOTOLA 2
Equipo PJ GF GC Puntos
1 CODM Meknes CODM Meknes 24 28 18 48
2 Kawkab Marrakech Kawkab 24 32 21 43
3 USM Oujda USM Oujda 24 26 15 40
4 Difaâ El Jadida Difaâ 24 21 16 40
5 Raja Beni Mellal Raja Beni M. 24 40 25 36
6 Stade Marocain Stade 24 29 29 34
7 Olympique Khouribga Olympique 24 26 25 32
8 Chabab Atlas Khenifra Chabab Atlas 24 18 15 31
9 JS d'El Massira d'El Massira 24 32 33 31
10 Olympique Dcheïra Olympique 24 23 26 29
11 Chabab Benguerir Chabab 24 20 21 28
12 Wydad Fès Wydad Fès 24 20 28 26
13 Rapide Oued Zem Rapide Oued 24 16 21 25
14 Racing de Casablanca Racing 24 22 30 23
15 Ittifaq Marrakech Ittifaq 24 11 24 22
16 AS Salé AS Salé 24 22 39 18
TEMPORADA 2015/2016
BOTOLA 2
Equipo PJ GF GC Puntos
1 Chabab Atlas Khenifra Chabab Atlas 30 30 21 49
2 Kasba Tadla Kasba Tadla 30 24 20 49
3 AS Salé AS Salé 30 32 29 42
4 Rachad Bernoussi Rachad 30 31 27 41
5 US Temara US Temara 30 31 29 41
6 Youssoufia Berrechid Youssoufia 30 27 25 41
7 Racing de Casablanca Racing 30 37 38 41
8 Olympique Dcheïra Olympique 30 20 21 39
9 Raja Beni Mellal Raja Beni M. 30 24 29 39
10 JSM Laayoune Laayoune 30 35 32 38
11 Ittihad Khemisset Ittihad 30 23 22 38
12 Widad Temara Widad Temara 30 26 22 37
13 USM Ait Melloul Melloul 30 29 28 37
14 Wydad Fès Wydad Fès 30 28 32 37
15 Olympique Marrakech Olympique 30 24 28 37
16 CODM Meknes CODM Meknes 30 24 42 31
TEMPORADA 2014/2015
BOTOLA 2
Equipo PJ GF GC Puntos
1 Ittihad Tanger Ittihad 30 22 11 54
2 Mouloudia Oujda Mouloudia 30 32 22 49
3 USM Ait Melloul Melloul 30 39 24 48
4 Kasba Tadla Kasba Tadla 30 29 22 48
5 Youssoufia Berrechid Youssoufia 30 34 25 46
6 Raja Beni Mellal Raja Beni M. 30 21 16 39
7 JSM Laayoune Laayoune 30 24 24 37
8 AS Salé AS Salé 30 23 26 37
9 US Temara US Temara 30 33 37 36
10 CODM Meknes CODM Meknes 30 28 29 35
11 Widad Temara Widad Temara 30 23 26 35
12 Racing de Casablanca Racing 30 27 35 35
13 Olympique Dcheïra Olympique 30 24 32 33
14 Wydad Fès Wydad Fès 30 19 28 33
15 Chabab Houara Chabab 30 23 31 31
16 Union Mohammedia Union 30 22 35 28
TEMPORADA 2013/2014
BOTOLA 2
Equipo PJ GF GC Puntos
1 Ittihad Khemisset Ittihad 30 34 13 57
2 Chabab Atlas Khenifra Chabab Atlas 30 36 13 53
3 Ittihad Tanger Ittihad 30 33 21 48
4 CODM Meknes CODM Meknes 30 34 31 46
5 Tihad Temara Tihad Temara 30 26 25 44
6 Raja Beni Mellal Raja Beni M. 30 38 33 41
7 Union Mohammedia Union 30 23 27 39
8 Kasba Tadla Kasba Tadla 30 31 29 36
9 Youssoufia Berrechid Youssoufia 30 24 28 36
10 Mouloudia Oujda Mouloudia 30 25 30 35
11 Chabab Houara Chabab 30 30 37 35
12 JSM Laayoune Laayoune 30 23 34 35
13 Racing de Casablanca Racing 30 25 28 34
14 USM Ait Melloul Melloul 30 23 33 30
15 Rachad Bernoussi Rachad 30 21 31 29
16 USM Oujda USM Oujda 30 23 36 28
TEMPORADA 2012/2013
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 30 56 24 66
2 FAR Rabat FAR Rabat 30 34 18 62
3 Maghreb Fes Maghreb Fes 30 36 27 48
4 Wydad Casablanca Wydad 30 31 22 48
5 Moghreb Tetouan Moghreb 30 40 28 46
6 FUS Rabat FUS Rabat 30 31 27 41
7 RSB Berkane RSB Berkane 30 30 31 40
8 Chabab Rif Hoceima Chabab 30 28 31 36
9 Difaâ El Jadida Difaâ 30 28 32 35
10 Hassania Agadir Hassania 30 24 26 34
11 Wydad Fès Wydad Fès 30 25 32 33
12 Olympic Safi Olympic Safi 30 36 48 32
13 Olympique Khouribga Olympique 30 27 33 30
14 KAC Kenitra KAC Kenitra 30 23 35 27
15 CODM Meknes CODM Meknes 30 25 40 25
16 Raja Beni Mellal Raja Beni M. 30 22 42 24
TEMPORADA 2011/2012
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Moghreb Tetouan Moghreb 30 41 13 61
2 FUS Rabat FUS Rabat 30 32 16 57
3 Wydad Casablanca Wydad 30 32 18 51
4 Raja Casablanca Raja 30 34 24 51
5 Difaâ El Jadida Difaâ 30 35 27 48
6 FAR Rabat FAR Rabat 30 32 29 41
7 Maghreb Fes Maghreb Fes 30 35 26 41
8 Olympic Safi Olympic Safi 30 34 43 36
9 Olympique Khouribga Olympique 30 27 32 35
10 CODM Meknes CODM Meknes 30 19 26 35
11 KAC Kenitra KAC Kenitra 30 29 40 35
12 Hassania Agadir Hassania 30 22 31 35
13 Chabab Rif Hoceima Chabab 30 31 27 33
14 Wydad Fès Wydad Fès 30 26 39 30
15 JSM Laayoune Laayoune 30 24 42 28
16 Ittihad Khemisset Ittihad 30 12 32 24
TEMPORADA 2010/2011
BOTOLA 2
Equipo PJ GF GC Puntos
1 CODM Meknes CODM Meknes 34 35 10 64
2 Ittihad Khemisset Ittihad 34 43 29 61
3 USM Ait Melloul Melloul 34 42 24 61
4 Youssoufia Berrechid Youssoufia 34 33 20 59
5 TAS Casablanca Casablanca 34 26 25 50
6 Mouloudia Oujda Mouloudia 34 29 29 47
7 Union Mohammedia Union 34 28 28 46
8 Chabab Houara Chabab 34 28 29 46
9 Rachad Bernoussi Rachad 34 27 29 43
10 Racing de Casablanca Racing 34 38 36 42
11 Ittihad Tanger Ittihad 34 28 33 40
12 AS Salé AS Salé 34 38 39 39
13 US Temara US Temara 34 25 26 39
14 Stade Marocain Stade 34 18 24 39
15 Raja Al Hoceima Raja Hoceima 34 18 29 35
16 Fkih Ben Salah Fkih Salah 34 27 39 35
17 SCCM Mohamedia SCCM 34 25 33 33
18 Hilal Nador Hilal Nador 34 18 44 25
TEMPORADA 2009/2010
BOTOLA 2
Equipo PJ GF GC Puntos
1 Kasba Tadla Kasba Tadla 36 34 23 65
2 Chabab Rif Hoceima Chabab 36 32 23 61
3 Union Mohammedia Union 36 38 25 58
4 CODM Meknes CODM Meknes 36 38 26 58
5 US Temara US Temara 36 39 35 56
6 Chabab Houara Chabab 36 38 28 53
7 Stade Marocain Stade 36 36 33 52
8 Racing de Casablanca Racing 36 36 36 52
9 Raja Al Hoceima Raja Hoceima 36 37 36 48
10 Youssoufia Berrechid Youssoufia 36 39 35 43
11 Mouloudia Oujda Mouloudia 36 30 34 43
12 TAS Casablanca Casablanca 36 28 28 42
13 Ittihad Tanger Ittihad 36 28 33 42
14 Rachad Bernoussi Rachad 36 26 37 42
15 Fkih Ben Salah Fkih Salah 36 29 36 41
16 SCCM Mohamedia SCCM 36 26 37 41
17 Chabab Atlas Khenifra Chabab Atlas 36 31 46 40
18 Settat Settat 36 29 40 38
19 Sidi Kacem Sidi Kacem 36 33 36 36
TEMPORADA 2008/2009
BOTOLA 2
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 34 43 13 66
2 Wydad Fès Wydad Fès 34 39 22 61
3 Stade Marocain Stade 34 34 28 60
4 Chabab Rif Hoceima Chabab 34 37 30 51
5 Chabab Houara Chabab 34 42 31 50
6 Racing de Casablanca Racing 34 37 36 50
7 Union Mohammedia Union 34 32 27 47
8 CODM Meknes CODM Meknes 34 31 30 44
9 Ittihad Tanger Ittihad 34 27 26 44
10 Fkih Ben Salah Fkih Salah 34 34 34 44
11 Youssoufia Berrechid Youssoufia 34 31 32 43
12 Sidi Kacem Sidi Kacem 34 25 39 38
13 US Temara US Temara 34 23 35 36
14 TAS Casablanca Casablanca 34 19 23 35
15 Settat Settat 34 27 40 35
16 Rachad Bernoussi Rachad 34 31 34 34
17 Olympique Marrakech Olympique 34 24 36 34
18 CWW Casablanca Casablanca 34 26 46 26
TEMPORADA 2007/2008
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 30 36 23 53
2 Ittihad Khemisset Ittihad 30 34 22 50
3 Raja Casablanca Raja 30 32 23 48
4 Hassania Agadir Hassania 30 23 14 46
5 Difaâ El Jadida Difaâ 30 29 27 46
6 Olympique Khouribga Olympique 30 32 26 43
7 Moghreb Tetouan Moghreb 30 29 19 42
8 Wydad Casablanca Wydad 30 28 23 40
9 JSM Laayoune Laayoune 30 27 28 38
10 Maghreb Fes Maghreb Fes 30 27 29 37
11 Olympic Safi Olympic Safi 30 31 31 36
12 Kawkab Marrakech Kawkab 30 23 31 33
13 KAC Kenitra KAC Kenitra 30 20 33 31
14 Mouloudia Oujda Mouloudia 30 29 48 31
15 FUS Rabat FUS Rabat 30 23 30 26
16 CODM Meknes CODM Meknes 30 24 40 24
TEMPORADA 2006/2007
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Olympique Khouribga Olympique 30 38 16 62
2 FAR Rabat FAR Rabat 30 31 17 55
3 Moghreb Tetouan Moghreb 30 37 31 54
4 Wydad Casablanca Wydad 30 30 20 47
5 Difaâ El Jadida Difaâ 30 29 19 42
6 Kawkab Marrakech Kawkab 30 23 17 42
7 Ittihad Khemisset Ittihad 30 24 23 42
8 JSM Laayoune Laayoune 30 21 21 37
9 Hassania Agadir Hassania 30 22 23 36
10 Mouloudia Oujda Mouloudia 30 25 35 36
11 Raja Casablanca Raja 30 23 20 35
12 Olympic Safi Olympic Safi 30 22 31 32
13 CODM Meknes CODM Meknes 30 17 24 31
14 Maghreb Fes Maghreb Fes 30 19 34 29
15 Ittihad Tanger Ittihad 30 21 30 26
16 AS Salé AS Salé 30 21 42 21
TEMPORADA 2005/2006
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 33 16 61
2 FAR Rabat FAR Rabat 30 41 14 58
3 Olympique Khouribga Olympique 30 44 23 53
4 Raja Casablanca Raja 30 34 24 51
5 Hassania Agadir Hassania 30 31 24 49
6 CODM Meknes CODM Meknes 30 23 25 41
7 Difaâ El Jadida Difaâ 30 29 26 40
8 Ittihad Khemisset Ittihad 30 20 26 36
9 AS Salé AS Salé 30 18 26 35
10 Olympic Safi Olympic Safi 30 26 27 34
11 Mouloudia Oujda Mouloudia 30 27 30 34
12 Moghreb Tetouan Moghreb 30 19 27 33
13 JSM Laayoune Laayoune 30 23 26 32
14 Ittihad Tanger Ittihad 30 22 29 29
15 SCCM Mohamedia SCCM 30 15 35 27
16 UTS Rabat UTS Rabat 30 12 39 19
TEMPORADA 2004/2005
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 30 35 9 62
2 Raja Casablanca Raja 30 42 17 60
3 Wydad Casablanca Wydad 30 32 14 50
4 Olympic Safi Olympic Safi 30 25 22 41
5 JSM Laayoune Laayoune 30 26 25 39
6 Ittihad Khemisset Ittihad 30 18 21 37
7 Hassania Agadir Hassania 30 19 21 36
8 Olympique Khouribga Olympique 30 24 29 36
9 UTS Rabat UTS Rabat 30 27 33 36
10 AS Salé AS Salé 30 25 33 35
11 SCCM Mohamedia SCCM 30 18 24 34
12 Mouloudia Oujda Mouloudia 30 21 27 33
13 CODM Meknes CODM Meknes 30 16 22 33
14 Ittihad Tanger Ittihad 30 19 28 33
15 Maghreb Fes Maghreb Fes 30 22 26 32
16 Kawkab Marrakech Kawkab 30 17 35 27
TEMPORADA 2003/2004
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 30 37 18 56
2 FAR Rabat FAR Rabat 30 36 17 56
3 AS Salé AS Salé 30 33 23 51
4 Wydad Casablanca Wydad 30 19 8 49
5 Olympique Khouribga Olympique 30 30 17 48
6 CODM Meknes CODM Meknes 30 30 22 48
7 Mouloudia Oujda Mouloudia 30 23 29 39
8 Maghreb Fes Maghreb Fes 30 28 32 38
9 Hassania Agadir Hassania 30 23 26 37
10 Kawkab Marrakech Kawkab 30 24 24 36
11 JS d'El Massira d'El Massira 30 20 25 35
12 Ittihad Tanger Ittihad 30 15 19 34
13 SCC Mohammédia Mohammédia 30 13 26 31
14 Ittihad Khemisset Ittihad 30 17 24 29
15 Settat Settat 30 15 29 27
16 KAC Kenitra KAC Kenitra 30 14 38 18
TEMPORADA 2002/2003
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Hassania Agadir Hassania 30 32 12 54
2 Raja Casablanca Raja 30 36 18 52
3 Wydad Casablanca Wydad 30 25 15 52
4 CODM Meknes CODM Meknes 30 25 16 52
5 Maghreb Fes Maghreb Fes 30 34 20 49
6 Olympique Khouribga Olympique 30 27 24 44
7 SCC Mohammédia Mohammédia 30 23 26 37
8 JS d'El Massira d'El Massira 30 25 32 34
9 FAR Rabat FAR Rabat 30 27 29 33
10 TAS Casablanca Casablanca 30 23 27 33
11 Ittihad Khemisset Ittihad 30 22 30 33
12 Settat Settat 30 19 26 32
13 Kawkab Marrakech Kawkab 30 25 34 32
14 KAC Kenitra KAC Kenitra 30 20 24 31
15 Ittihad Tanger Ittihad 30 22 38 30
16 FUS Rabat FUS Rabat 30 13 27 27
TEMPORADA 2001/2002
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Hassania Agadir Hassania 30 41 9 65
2 Wydad Casablanca Wydad 30 38 12 62
3 Raja Casablanca Raja 30 42 18 55
4 Maghreb Fes Maghreb Fes 30 31 16 52
5 Olympique Khouribga Olympique 30 32 22 47
6 FAR Rabat FAR Rabat 30 27 24 42
7 TAS Casablanca Casablanca 30 24 26 41
8 Ittihad Khemisset Ittihad 30 22 29 35
9 JS d'El Massira d'El Massira 30 32 45 35
10 CODM Meknes CODM Meknes 30 18 25 34
11 Settat Settat 30 20 34 32
12 Kawkab Marrakech Kawkab 30 25 30 31
13 FUS Rabat FUS Rabat 30 17 22 31
14 Ittihad Tanger Ittihad 30 27 35 31
15 Stade Marocain Stade 30 21 41 30
16 Raja Beni Mellal Raja Beni M. 30 18 47 20
TEMPORADA 2000/2001
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 30 33 12 64
2 FUS Rabat FUS Rabat 30 32 17 55
3 Maghreb Fes Maghreb Fes 30 33 22 48
4 Settat Settat 30 26 19 48
5 Olympique Khouribga Olympique 30 25 19 42
6 Wydad Casablanca Wydad 30 34 25 41
7 Kawkab Marrakech Kawkab 30 24 21 41
8 FAR Rabat FAR Rabat 30 25 35 37
9 Ittihad Khemisset Ittihad 30 24 31 35
10 TAS Casablanca Casablanca 30 26 38 33
11 CODM Meknes CODM Meknes 30 21 25 32
12 Hassania Agadir Hassania 30 21 29 31
13 JS d'El Massira d'El Massira 30 27 33 30
14 Raja Beni Mellal Raja Beni M. 30 26 32 30
15 SCC Mohammédia Mohammédia 30 21 30 30
16 Racing de Casablanca Racing 30 13 23 26

  USO DE MEMORIA  
6,942,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0986
Total Execution Time  0.0998
  CADENA URL  
/historico/Codm-Meknes
  GET DATOS  
$_GET['/historico/Codm-Meknes']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0043  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 = 73593
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=806 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 806 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (73999) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '806' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73593 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 = 806 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 73593 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 15522 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 `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 = 4197 AND t.round = 30 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 = 2934 AND t.round = 30 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 `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 = 2213 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 `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 = 1585 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 = 8700 AND t.round = 34 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 `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 = 8697 AND t.round = 38 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 `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 = 8693 AND t.round = 34 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 `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 = 273 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 `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 = 8684 AND t.round = 30 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 `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 = 8682 AND t.round = 31 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 `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 = 8679 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 `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 = 23624 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 `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 = 23628 AND t.round = 30 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 `tables2002` 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 = 23631 AND t.round = 30 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 `tables2001` 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 = 23635 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC