4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2006
Temporada Siguiente »
Publicidad 600x120.gif
Botola 2 2006
2005/2006

Botola 2 2006

Información Histórica 
						
Second Level 2005/06


Final Table:

 1. Maghrib AS Fès			       30 16 12  2 33-14 60  Promoted
 2. Kawkab Athletic Club de Marrakech	       30 16 10  4 32-18 58  Promoted
-------------------------------------------------------------------
 3. CA Youssoufia Berrechid		       30 13  8  9 32-28 47
 4. Racing Athlétique Club (Casablanca)	       30 11 12  7 26-23 45
 5. Renaissance Sportive de Berkane	       30 13  5 12 32-36 44
 6. Union Sportive Mohammédia		       30  9 13  8 25-23 40
 7. Union Sportive Sidi Kacem		       30 10 10 10 21-22 40
 8. Kénitra Atlantic Club		       30  8 15  7 27-20 39
 9. Rachad Bernoussi (Casablanca)	       30  9 10 11 28-31 37
10. Hilal Association Nador		       30  8 11 11 20-26 35
11. Stade Marocain (Rabat)		       30  8 11 11 20-23 35
12. Wafaa Widad Sidi Othmane (Casablanca)      30  7 11 12 27-35 32
13. Fath Union Sportive (Rabat)		       30  5 17  8 14-18 32
14. Renaissance Sportive de Settat	       30  8  9 13 26-31 31  [-2]
-------------------------------------------------------------------
15. Najm Riadi Marrakech		       30  7  9 14 24-27 30  Relegated
16. Fath Riadi Nador			       30  5 11 14 17-29 26  Relegated

Round 1 [Sep 3]
R. Bernoussi	1-1 KAC Marrakech
Stade Marocain	1-1 WAFA
FR Nador	1-1 MAS Fès
RS Berkane	2-1 US Sidi Kacem
Kénitra AC	2-0 HA Nador
US Mohamedia	0-0 FUS Rabat
NR Marrakech	2-0 CAYB Berrechid
RS Settat	0-1 RAC Casablanca

Round 2 [Sep 11]
KAC Marrakech	1-1 RS Settat
US Sidi Kacem	0-1 FR Nador
HA Nador	2-0 RS Berkane
MAS Fès		1-0 Stade Marocain
RAC Casablanca	1-1 NR Marrakech
FUS Rabat	0-0 Kénitra AC
CAYB Berrechid	2-1 US Mohamedia
WAFA		2-3 R. Bernoussi

Round 3 [Sep 18]
KAC Marrakech	4-1 WAFA
FR Nador	1-2 HA Nador
RS Berkane	1-0 FUS Rabat
Stade Marocain	0-1 US Sidi Kacem
RS Settat	3-2 NR Marrakech
Kénitra AC	2-0 CAYB Berrechid
US Mohamedia	0-1 RAC Casablanca
R. Bernoussi	1-1 MAS Fès

Round 4
[Sep 24]
CAYB Berrechid	2-3 RS Berkane
WAFA		2-2 RS Settat
[Sep 25]
MAS Fès		1-1 KAC Marrakech
FUS Rabat	1-0 FR Nador
HA Nador	1-0 Stade Marocain
RAC Casablanca	2-2 Kénitra AC
NR Marrakech	2-0 US Mohamedia
US Sidi Kacem	1-1 R. Bernoussi

Round 5
[Oct 1]
WAFA		0-1 MAS Fès
[Oct 2]
KAC Marrakech	0-0 US Sidi Kacem
R. Bernoussi	0-0 HA Nador
Stade Marocain	0-0 FUS Rabat
FR Nador	0-1 CAYB Berrechid
RS Berkane	2-0 RAC Casablanca
Kénitra AC	1-0 NR Marrakech
RS Settat	1-0 US Mohamedia

Round 6
[Oct 15]
CAYB Berrechid	3-1 Stade Marocain
[Oct 16]
MAS Fès		1-0 RS Settat
US Sidi Kacem	3-1 WAFA
HA Nador	0-0 KAC Marrakech
FUS Rabat	1-1 R. Bernoussi
RAC Casablanca	1-1 FR Nador
NR Marrakech	0-1 RS Berkane
US Mohammedia	1-1 Kénitra AC

Round 7
[Oct 22]
MAS Fès		0-1 US Sidi Kacem
WAFA		0-0 HA Nador
KAC Marrakech	1-0 FUS Rabat
Stade Marocain	1-2 RAC Casablanca
[Oct 23]
R. Bernoussi	1-2 CAYB Berrechid
FR Nador	0-0 NR Marrakech
RS Berkane	1-1 US Mohammedia
RS Settat	2-0 Kénitra AC

Round 8 [Oct 29]
US Sidi Kacem	1-1 RS Settat
HA Nador	1-1 MAS Fès
FUS Rabat	0-0 WAFA
CAYB Berrechid	2-1 KAC Marrakech
RAC Casablanca	3-2 R. Bernoussi
NR Marrakech	1-0 Stade Marocain
US Mohammedia	1-1 FR Nador
Kénitra AC	4-0 RS Berkane

Round 9
[Nov 12]
WAFA		0-1 CAYB Berrechid
KAC Marrakech	1-0 RAC Casablanca
[Nov 13]
US Sidi Kacem	1-0 HA Nador
MAS Fès		1-1 FUS Rabat
R. Bernoussi	1-0 NR Marrakech
Stade Marocain	0-1 US Mohammedia
FR Nador	1-1 Kénitra AC
RS Settat	1-0 RS Berkane

Round 10
[Nov 20]
HA Nador	2-1 RS Settat
FUS Rabat	0-0 US Sidi Kacem
CAYB Berrechid	0-0 MAS Fès
RAC Casablanca	0-0 WAFA
NR Marrakech	0-0 KAC Marrakech
Kénitra AC	1-2 Stade Marocain
RS Berkane	3-2 FR Nador
[Jan 1]
US Mohammedia	1-0 R. Bernoussi

Round 11 [Nov 27]
HA Nador	0-0 FUS Rabat
US Sidi Kacem	2-1 CAYB Berrechid
MAS Fès		2-0 RAC Casablanca
WAFA		2-1 NR Marrakech
KAC Marrakech	1-1 US Mohammedia
R. Bernoussi	1-0 Kénitra AC
Stade Marocain	0-3 RS Berkane
RS Settat	1-0 FR Nador

Round 12
[Dec 3]
FUS Rabat	0-0 RS Settat
CAYB Berrechid	3-1 HA Nador
US Mohammedia	2-2 WAFA
[Dec 4]
RAC Casablanca	1-0 US Sidi Kacem
NR Marrakech	0-1 MAS Fès
Kénitra AC	0-1 KAC Marrakech
RS Berkane	1-0 R. Bernoussi
FR Nador	0-0 Stade Marocain

Round 13
[Dec 10]
FUS Rabat	0-0 CAYB Berrechid
WAFA		0-0 Kénitra AC
R. Bernoussi	1-0 FR Nador
[Dec 11]
HA Nador	0-0 RAC Casablanca
US Sidi Kacem	0-0 NR Marrakech
MAS Fès		1-0 US Mohammedia
KAC Marrakech	2-0 RS Berkane
RS Settat	1-0 Stade Marocain

Round 14
[Dec 17]
US Mohammedia	2-0 US Sidi Kacem
[Dec 18]
RS Settat	0-1 CAYB Berrechid
RAC Casablanca	2-1 FUS Rabat
NR Marrakech	0-2 HA Nador
Kénitra AC	1-0 MAS Fès
RS Berkane	3-1 WAFA
FR Nador	0-1 KAC Marrakech
Stade Marocain	1-0 R. Bernoussi

Round 15
[Dec 24]
CAYB Berrechid	0-3 RAC Casablanca
WAFA		2-1 FR Nador
R. Bernoussi	2-1 RS Settat
[Dec 25]
FUS Rabat	2-2 NR Marrakech
HA Nador	0-0 US Mohammedia
US Sidi Kacem	1-0 Kénitra AC
MAS Fès		1-1 RS Berkane
KAC Marrakech	0-0 Stade Marocain

Round 16
[Jan 7]
WAFA		2-1 Stade Marocain
CAYB Berrechid	2-1 NR Marrakech
RAC Casablanca	0-0 RS Settat
[Jan 8]
KAC Marrakech	1-0 R. Bernoussi
MAS Fès		2-0 FR Nador
US Sidi Kacem	2-0 RS Berkane
HA Nador	3-2 Kénitra AC
FUS Rabat	0-0 US Mohammedia

Round 17 [Jan 29]
RS Settat	0-1 KAC Marrakech
FR Nador	1-0 US Sidi Kacem
RS Berkane	2-0 HA Nador
Stade Marocain	1-2 MAS Fès
NR Marrakech	1-2 RAC Casablanca
Kénitra AC	1-1 FUS Rabat
US Mohammedia	0-0 CAYB Berrechid
R. Bernoussi	1-0 WAFA

Round 18
[Feb 4]
WAFA		0-1 KAC Marrakech
RAC Casablanca	0-1 US Mohamedia
MAS Fès		2-0 R. Bernoussi
[Feb 5]
FUS Rabat	2-1 RS Berkane
US Sidi Kacem	1-1 Stade Marocain
NR Marrakech	0-0 RS Settat
CAYB Berrechid	1-0 Kénitra AC
[Mar 22]
HA Nador	1-1 FR Nador

Round 19 [Feb 12]
RS Berkane	1-0 CAYB Berrechid
RS Settat	1-0 WAFA
KAC Marrakech	0-2 MAS Fès
FR Nador	0-1 FUS Rabat
Stade Marocain	1-0 HA Nador
Kénitra AC	0-0 RAC Casablanca
US Mohamedia	2-1 NR Marrakech
R. Bernoussi	1-1 US Sidi Kacem

Round 20
[Feb 25]
US Mohamedia	3-2 RS Settat
[Feb 26]
MAS Fès		2-2 WAFA
US Sidi Kacem	1-2 KAC Marrakech
HA Nador	2-0 R. Bernoussi
FUS Rabat	0-0 Stade Marocain
CAYB Berrechid	3-1 FR Nador
RAC Casablanca	1-0 RS Berkane
NR Marrakech	0-0 Kénitra AC

Round 21
[Mar 4]
WAFA		1-0 US Sidi Kacem
R. Bernoussi	0-0 FUS Rabat
[Mar 5]
Stade Marocain	0-0 CAYB Berrechid
RS Settat	0-1 MAS Fès
KAC Marrakech	1-0 HA Nador
FR Nador	0-0 RAC Casablanca
RS Berkane	1-0 NR Marrakech
Kénitra AC	1-1 US Mohammedia

Round 22 [Mar 12]
US Sidi Kacem	0-0 MAS Fès
HA Nador	1-0 WAFA
FUS Rabat	1-2 KAC Marrakech
RAC Casablanca	0-1 Stade Marocain
CAYB Berrechid	0-1 R. Bernoussi
NR Marrakech	0-0 FR Nador
US Mohammedia	1-0 RS Berkane
Kénitra AC	awd RS Settat		[2-0 awarded; RS Settat dns;RS Settat 2 points deducted]

Round 23
[Mar 25]
WAFA		0-0 FUS Rabat
R. Bernoussi	0-1 RAC Casablanca
[Mar 26]
RS Settat	1-0 US Sidi Kacem
MAS Fès		1-0 HA Nador
KAC Marrakech	2-1 CAYB Berrechid
Stade Marocain	1-0 NR Marrakech
FR Nador	1-0 US Mohammedia
RS Berkane	0-0 Kénitra AC

Round 24 [Apr 2]
CAYB Berrechid	0-0 WAFA
RAC Casablanca	1-1 KAC Marrakech
HA Nador	0-1 US Sidi Kacem
FUS Rabat	0-1 MAS Fès
NR Marrakech	1-1 R. Bernoussi
US Mohammedia	0-0 Stade Marocain
Kénitra AC	0-0 FR Nador
RS Berkane	2-1 RS Settat

Round 25 [Apr 8]
RS Settat	1-1 HA Nador
US Sidi Kacem	1-0 FUS Rabat
MAS Fès		2-1 CAYB Berrechid
WAFA		0-1 RAC Casablanca
KAC Marrakech	2-0 NR Marrakech
Stade Marocain	1-1 Kénitra AC
FR Nador	1-1 RS Berkane
R. Bernoussi	2-1 US Mohammedia

Round 26 [Apr 16]
FUS Rabat	1-0 HA Nador
CAYB Berrechid	0-0 US Sidi Kacem
RAC Casablanca	0-0 MAS Fès
NR Marrakech	2-1 WAFA
US Mohammedia	1-0 KAC Marrakech
Kénitra AC	1-0 R. Bernoussi
RS Berkane	0-0 Stade Marocain
FR Nador	1-0 RS Settat

Round 27 [Apr 29]
RS Settat	0-0 FUS Rabat
HA Nador	0-0 CAYB Berrechid
WAFA		1-0 US Mohammedia
US Sidi Kacem	1-0 RAC Casablanca
MAS Fès		1-0 NR Marrakech
KAC Marrakech	1-1 Kénitra AC
R. Bernoussi	4-2 RS Berkane
Stade Marocain	1-0 FR Nador

Round 28 [May 13]
CAYB Berrechid	2-0 FUS Rabat
Kénitra AC	1-1 WAFA
FR Nador	1-0 R. Bernoussi
RAC Casablanca	1-1 HA Nador
NR Marrakech	2-0 US Sidi Kacem
US Mohammedia	1-1 MAS Fès
RS Berkane	0-1 KAC Marrakech
Stade Marocain	2-1 RS Settat

Round 29 [May 20]
US Sidi Kacem	1-1 US Mohammedia
CAYB Berrechid	2-1 RS Settat
FUS Rabat	2-0 RAC Casablanca
HA Nador	0-3 NR Marrakech
MAS Fès		0-0 Kénitra AC
WAFA		3-1 RS Berkane
KAC Marrakech	2-0 FR Nador
R. Bernoussi	0-0 Stade Marocain

Round 30  [May 27]
RAC Casablanca	2-2 CAYB Berrechid
FR Nador	1-2 WAFA
NR Marrakech	2-0 FUS Rabat
US Mohammedia	2-0 HA Nador
Kénitra AC	2-0 US Sidi Kacem
RS Berkane	0-3 MAS Fès
Stade Marocain	4-0 KAC Marrakech
RS Settat	3-3 R. Bernoussi

Final Table:

 1. Maghrib AS Fès			       30 16 12  2 33-14 60  Promoted
 2. Kawkab Athletic Club de Marrakech	       30 16 10  4 32-18 58  Promoted
-------------------------------------------------------------------
 3. CA Youssoufia Berrechid		       30 13  8  9 32-28 47
 4. Racing Athlétique Club (Casablanca)	       30 11 12  7 26-23 45
 5. Renaissance Sportive de Berkane	       30 13  5 12 32-36 44
 6. Union Sportive Mohammédia		       30  9 13  8 25-23 40
 7. Union Sportive Sidi Kacem		       30 10 10 10 21-22 40
 8. Kénitra Atlantic Club		       30  8 15  7 27-20 39
 9. Rachad Bernoussi (Casablanca)	       30  9 10 11 28-31 37
10. Hilal Association Nador		       30  8 11 11 20-26 35
11. Stade Marocain (Rabat)		       30  8 11 11 20-23 35
12. Wafaa Widad Sidi Othmane (Casablanca)      30  7 11 12 27-35 32
13. Fath Union Sportive (Rabat)		       30  5 17  8 14-18 32
14. Renaissance Sportive de Settat	       30  8  9 13 26-31 31  [-2]
-------------------------------------------------------------------
15. Najm Riadi Marrakech		       30  7  9 14 24-27 30  Relegated
16. Fath Riadi Nador			       30  5 11 14 17-29 26  Relegated



Third Level 2005/06


Tables:

Groupe Sud
 1. Chabab Houara                              23 14  7  2 47-13 49   
 2. Najah Souss (Agadir)                       23 12  7  4 35-25 43   
 3. CACAS Marrakech                            23 11  5  7 32-21 38   
 4. US Aït Melloul                             23  8  9  6 21-17 33   
 5. Union Taroudant                            23  8  7  8 36-35 31   
 6. Olympique Dcheira                          23  8  6  9 28-32 30   
 7. Mouloudia Laâyoune                         23  6 11  6 23-31 29   
 8. RCMA Rajaa Agadir                          23  7  7  9 23-24 28   
 9. Tihad Sidi Ifni                            23  8  4 11 26-33 28   
10. Olympique Youssoufia                       23  7  7  9 24-31 28   
11. USKM Inzegane                              23  6  8  9 25-32 26   
12. RS Tantan                                  23  6  8  9 15-24 26   
13. El Kelaâ Wydad Serghini                    23  6  6 11 18-29 24   
14. MCM Marrakech                              23  6  4 13 25-31 22  
NB: Chabab Houra qualified for promotion playoff
Relegated: RS Tantan and MCM Marrakech

Groupe Nord
 1. Tihad Temara                               22 13  7  2 31- 9 46   
 2. Renaissance Tiflet                         21 11  5  5 23-13 38   
 3. RS Martil                                  22 10  3  9 28-18 33   
 4. Olympique Ouezzene                         22  8  9  5 24-19 33   
 5. Widad Temara                               20  6 10  4 15-12 28   
 6. Youssoufia Club Rabat                      20  7  7  6 16-14 28   
 7. Hasania Benslimane                         22  7  6  9 20-23 27   
 8. Nadi Ksar Kbir                             20  6  7  7 17-20 25   
 9. Union Sportive Yacoub El Mansour (Rabat)   21  5  9  7 16-15 24   
10. Hasania Sidi Slimane                       21  6  7  8 15-19 23  [-2]
11. ACK Amal Belksiri                          20  3 12  5 11-14 21   
12. Chabab Ismailia Meknès                     19  6  3 10 11-22 21   
13. Chabab Larache                             19  5  5  9 15-20 20   
14. TR Chaouen                                 21  6  2 13 16-40 20   
NB: Tihad Temara qualified for promotion playoff
Relegated: Nadi Ksar Kbir and TR Chaouen

Groupe Centre
 1. TAS Casablanca                             21 12  5  4 29-11 41   
 2. Raja de Beni Mellal                        22 11  8  3 20- 9 41   
 3. Chabab Ben Guérir                          21 10  6  5 23-15 36   
 4. Amal Souk Sebt                             23 10  7  6 20-16 36  [-1]
 5. ASOFP                                      20  9  7  4 17-11 34 
 6. IRFBS Fkih Ben Salah                       20  9  6  5 29-15 31  [-2]
 7. RCOZ Oued Zem                              21  7  6  8 13-19 27   
 8. Renaissance El Gara                        21  7  6  8 16-23 27   
 9. Najm Soualem                               20  7  5  8 14-15 26   
10. Nejm Shabab Bidawi                         20  6  3 11 18-25 21   
11. CSMB Bus Casa                              19  4  6  9 13-22 18   
12. Olympique Casablanca (Lavage)              19  3  8  8 13-20 17   
13. Fath Sidi Bennour                          21  4  5 12 18-29 17   
14. Wafaa Sidi Moumen                          20  3  6 11 11-24 15   
NB: TAS Casablanca qualified for promotion playoff
Relegated: Fath Sidi Bennour and Wafaa Sidi Moumen

Groupe Ouest
 1. Chabab Rif Hoceima                         22 13  5  4 35-18 44   
 2. Chabab Atlas Khénifra                      22 10 10  2 28- 9 40   
 3. Wydad A. Fès                               22 11  6  5 25-10 39   
 4. Chabab Darouich                            22 10  6  6 26-24 36   
 5. Najah Meknes                               23  9  8  6 30-18 35   
 6. AS Taza                                    22  7  9  6 29-28 30   
 7. USM Oujda                                  20  7  8  5 28-24 29   
 8. Wifak Zeghnan                              22  8  4 10 23-23 28   
 9. Qods Taza                                  21  7  4 10 20-30 25   
10. Etoile Oujda                               22  5  9  8 21-28 24   
11. Chabab Mrirt                               21  5  4 12 19-32 19   
12. CAA Amal Azrou                             21  4  6 11 18-33 18   
13. Renaissance Zaio                           22  3  5 14 16-41 14   
14. ASM Amal Sidi Hrazem                       withdrew or excluded
NB: Chabab Rif Hoceima qualified for promotion playoff
Relegated: Renaissance Zaio and ASM Amal Sidi Hrazem

Promotion Playoffs
[Jun 17]
Chabab Houra    1-0 TAS Casablanca
[Jun 25]
Ch. Rif Hoceima 0-0 Tihad Temara        [0-3 pen]

NB: Chabab Houra and Tihad Temara promoted


Author: José Batalha
(jose.batalha@netvisao.pt)

Last updated: 10 Aug 2007

(C) Copyright José Batalha and RSSSF 2005/07


  USO DE MEMORIA  
4,242,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0836
Total Execution Time  0.0855
  CADENA URL  
/elite_2_marruecos2006
  GET DATOS  
$_GET['/elite_2_marruecos2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0018  SELECT type FROM routes WHERE alias = 'elite_2_marruecos2006'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'elite_2_marruecos' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 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=409 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 409 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (975843,911464,803650,73999) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=1151
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 = 29457 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2006' WHERE c.parentId=409 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT type,rule FROM rules WHERE categoryId = 409 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 10:16:09' 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-04-27 10:16:09' 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=4 AND last_update > '2024-04-27 10:16:09' 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-04-27 10:16:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'elite_2_marruecos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0026  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=29457 AND rel.round=30
0.0020  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29457 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29457 AND esl.points > 0
0.0018  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29457 ORDER BY creation_date DESC LIMIT 0, 10
0.0029  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29457
0.0022  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2006` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 29457 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0021  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2006` e INNER JOIN calendars2006 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 30 AND e.real_date IS NOT NULL AND e.league_id = 29457 ORDER BY total DESC LIMIT 40
0.0021  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2006` e INNER JOIN calendars2006 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 29457 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
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 `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 = 29457 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(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 = 29457 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0017  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 29457 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=409
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=409 AND year=2006