4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2008
Temporada Siguiente »
Publicidad 600x120.gif
Liga Mauricio 2008
2007/2008

Liga Mauricio 2008

Información Histórica 
						
Premier League (Barclays League since early 2008) 2007/08

Final Table: 

 1.Curepipe Starlight SC       20 13  5  2  41-17  44  [3-0]  Champions
 2.Pamplemousses SC            20 11  4  5  39-15  37  [4-0,15-0]
 3.AS Port-Louis 2000          20 11  3  6  27-13  36  [6-0]
 4.Savanne SC                  20  8  4  8  29-25  28  [3-0]
 5.Petite Rivière Noire SC     20  6  9  5  29-27  27  [2-0]
 6.Pointe-aux-Sables Mates     20  6  7  7  22-24  25  [3-0]
 7.US Beau-Bassin/Rose Hill    20  5  9  6  21-24  24  [4-0]
 8.Étoile de l'Ouest (Bambous) 20  7  2 11  21-40  23  [2-0]
 9.AS de Vacoas-Phoenix        20  4  8  8  23-23  20  [4-1]
10.AS Rivière du Rempart       20  4  8  8  23-29  20  [2-1]
-----------------------------------------------------
11.Bolton City (Roche-Bois)    20  2  7 11  16-54  13  [4-0]  Relegated
 -.Olympique de Moka           withdrew Jan 31, 2008; results annulled;
   record at withdrawal:       12  0  0 12   2-52   0

NB: annulled results vs Olympique de Moka between square brackets

Round 1
[Oct 5]
USBBRH                  0-0 PAS Mates
Etoile de l'Ouest       1-1 AS Rivière du Rempart
  [Jaïrzinho L’Effronté; Swaley Boodhun]
Bolton City             0-6 Pamplemousses SC 
  [Andy Sophie (3), Gilbert Bayaram, Jiovanni Jubeau,
   Praxis Rabemananjara]
ASVP                    4-1 OM                       [annulled]
  [Jean-Pierre Cerveaux (2), Shanawaz Allybocus, Gravel Azie;
   Jordan Salomon]
[Oct 6]
Petite Rivière Noire SC 0-0 ASPL 2000
[Oct 7]
Savanne SC              0-2 CSSC 
  [Westley Marquette, Fabrice Pauline]

Round 2
[Oct 12]
CSSC                    2-0 Bolton City 
  [Westley Marquette, Kersley Appou]
PAS Mates               3-0 OM                       [annulled]
  [Brian Nanon, Jean-Yves Noumé, Joye Estazie]
Pamplemousses SC        1-0 AS Rivière du Rempart
  [Jérôme Thomas]
USBBRH                  1-2 Savanne SC 
  [Joey Mourgine; Westley Laboucherie (2)] 
[Oct 13]
Petite Rivière Noire SC 2-2 ASVP
  [Kersley Levrai (og), Alan Lamour; Gravel Azie, Bingo Rabarilala]
[Oct 14]
Etoile de l'Ouest       0-2 ASPL 2000
  [Mervyn Bhujun, Kris Etowar]

Round 3 
[Oct 19]
Etoile de l'Ouest       1-0 ASVP
  [Mikaël Philippe]
Bolton City             2-2 AS Rivière du Rempart
  [Colin Modliar, Jerry Jackson; Feizal Chitbahal, Viviadeo Boodhun]
[Oct 20]
PAS Mates               2-2 Petite Rivière Noire SC
  [Samuel Rebet (og), Guillano Edouard; Curtis Laseringue,
   Genario Figaro]
[Oct 21]
ASPL 2000               1-0 Pamplemousses SC
  [Akmez Lauthan]
OM                      0-3 Savanne SC               [annulled]
  [Yannick Dig-Dig (2), Westley Laboucherie]
USBBRH                  1-3 CSSC
  [Herilalao; Westley Marquette (2), Jeannot Lamarque]

Round 4
[Oct 26]
Etoile de l'Ouest       2-0 PAS Mates
  [Guillano Edouard (og) (also credited to Gupta Sookroo),
   Michaël Mitraille]
ASVP                    0-0 Pamplemousses SC 
AS Rivière du Rempart   0-1 ASPL 2000 
  [Stéphan L'Enflé]
[Oct 27]
Bolton City             0-0 USBBRH 
[Oct 28]
CSSC                    3-0 OM                       [annulled]
  [Westley Marquette 45+, 55, 63]
Savanne SC              2-0 Petite Rivière Noire SC 
  [Westley Laboucherie, Fabrice Pithia]

Round 5 [Nov 3]
CSSC                    0-1 Petite Rivière Noire SC
  [Stéphane Pierre 61]
Bolton City             0-4 ASPL 2000 
  [Jonathan Ernest 62, Bruno Ravina 71, Mervyn Bhujun 84,
   Blaise Kadima 88]
Savanne SC              6-0 Etoile de l'Ouest
  [Westley Laboucherie (3), Kurty Dessalles (2), Heman Sookroo (og)]
PAS Mates               1-0 Pamplemousses SC
  [Ashley Lemince 63]
OM                      0-4 USBBRH                   [annulled]
  [Devin Balaghee (2), Herilalao (2)]
ASVP                    3-1 AS Rivière du Rempart  
  [Bingo Rabarilala, Thierry Bérard, Jean-Yonez Agathe; 
   Victor Raffin]

Round 6
[Nov 10]
ASVP                    1-0 ASPL 2000
  [Thierry Bérard 76]
Savanne SC              1-4 Pamplemousses SC
  [Fabrice Pithia 21; Henri Spéville 29, Andy Sophie 36, 58,
   Praxis Rabemananjara 73]
AS Rivière du Rempart   1-0 PAS Mates
  [Nitish Khugputh 37] 
Bolton City             4-0 OM                       [annulled]
  [Ricardo Chavry, Yousouf Dookhee, Guillano Li Chen Ki (2)]
[Nov 11]
CSSC                    3-0 Etoile de l'Ouest
  [France Pierre 85, Westley Marquette 86, Rodson Tojosoa 90]
Petite Rivière Noire SC 1-1 USBBRH
  [Frédérik Antoine; Darlien Ralahinirina]

Round 7
[Nov 16]
AS Rivière du Rempart   2-2 Savanne SC
  [Mikaël Duval 63, Dario Sutton 84; Stevenson Hollingsworth 15,
   Bassanio Diolle 78pen]
ASVP                    0-0 Bolton City 
USBBRH                  4-1 Etoile de l'Ouest
  [Darlien Ralahinirina 20, 84, Zoubaïr Rummun 50, 74;
   Michaël Mitraille 90]
[Nov 17]
ASPL 2000               1-0 PAS Mates
  [Blaise Kadima]
OM                      awd Petite Rivière Noire SC  [annulled; awarded 0-2, OM
[Nov 18]                                              showed with 6 players]
CSSC                    2-1 Pamplemousses SC
  [Henri Speville 25og, Westley Marquette 68; Gilbert Bayaram 35]

Round 8
[Nov 23]
OM                      0-2 Etoile de l'Ouest        [annulled]
  [Eric Jamalac, Michaël Mitraille]
USBBRH                  1-1 Pamplemousses SC 
  [Roddy Edwards; Praxis Rabemananjara]
AS Rivière du Rempart   2-2 CSSC
  [Ally Ramcharan 52, Tony François 57; Westley Marquette 5,
   Nana Kwasi Kyeremateng 35]
[Nov 24]
ASVP                    1-2 PAS Mates
  [Jean-Pierre Cerveaux 1-2; Joye Estazie 48, Jimmy Far 0-2]
Petite Rivière Noire SC 1-1 Bolton City
  [Frédérik Antoine; Guillano Li Chen Ki]
[Nov 25]
Savanne SC              1-1 ASPL 2000 
  [Sakir Saïb 59; Blaise Kadima 86pen]

Round 9
[Nov 30]
Petite Rivière Noire SC 2-0 Etoile de l'Ouest       
  [Frédérik Antoine 27, Genario Figaro 60]
AS Rivière du Rempart   1-3 USBBRH      
  [Tony François; Darlien Ralahinirina (2), Jean-Reck Ah-Fock]            
[Dec 1]
Bolton City             1-4 PAS Mates    
  [Guillano Li Chen Ki; Stéphane Badul (2), Jimmy Far, Mike Dario]           
Pamplemousses SC        4-0 OM                       [annulled]
  [Andy Sophie 22pen, 42pen, Praxis Rabemananjara 34, Gilbert Bayaram 65]         
[Dec 19]
ASVP                    0-0 Savanne SC 
ASPL 2000               1-1 CSSC       
  [Blaise Kadima 63; Johann Candasamy 58]             

Round 10
[Dec 7]
Pamplemousses SC        1-0 Petite Rivière Noire SC 
  [Praxis Rabemananjara 63]
OM                      1-2 AS Rivière du Rempart    [annulled]
  [Julien Salomon; Dario Sutton, Deepak Cauroo]   
[Dec 8]
CSSC                    2-1 ASVP          
  [Ricardo Hovas 11, Tomy Sanhoboa 52; Jean-Pierre Cerveaux 25]   
Etoile de l'Ouest       0-0 Bolton City             
[Dec 12]
ASPL 2000               0-1 USBBRH     
  [Viraj Persootamah 14]
Savanne SC              0-1 PAS Mates               
  [Stéphane Badul]

Round 11
[Dec 14]
Petite Rivière Noire SC 1-1 AS Rivière du Rempart 
  [Kersley Botlar; Hailey Appadoo]  
[Dec 15]
Pamplemousses SC        5-0 Etoile de l'Ouest 
  [Andy Sophie 11, 60pen, 62, 86, 89]      
OM                      0-6 ASPL 2000                [annulled]
  [Jonathan Ernest (2), Bruno Ravina, Josua Soul, David Lim Sik Fang,
   Stéphane Arthée]              
[Dec 16]
ASVP                    1-1 USBBRH 
  [Jean-Pierre Cerveaux; Frédéric Zéphyr]                 
CSSC                    1-1 PAS Mates   
  [Kersley Appou 45; Guillano Edouard 61]
Savanne SC              4-0 Bolton City             
  [Fabrice Pithia (3), Westley Laboucherie]

Round 12 
[Jan 26]
Petite Rivière Noire SC 1-1 CSSC
  [Jean-Reck Ah-Fock 36; Nana Kwasi Kyeremateng 17]            
AS Rivière du Rempart   1-1 ASVP
  [Rico Shocktorap; Gabriel Otoo]
Etoile de l'Ouest       0-1 Savanne SC    
  [Mikaël Mitraille]  
OM                     0-15 Pamplemousses SC         [annulled]
  [Andy Sophie (5), Gilbert Bayaram (3), Guillaume Sockalingum (3),
   Mike Kayava (2), Colin Bell, Clarel Beeharry]
[Jan 27]
ASPL 2000               2-0 PAS Mates   
  [Dario Mike 56og, Blaise Kadima 88]    
USBBRH                  0-0 Bolton City      

Round 13 
[Feb 2]
ASPL 2000               0-1 Savanne SC
  [Fabrice Pithia 62]
CSSC                    3-2 AS Rivière du Rempart 
  [Christopher Perle 16, Joseph Tojosoa 31pen, Kersley Appou 76;
   Rico Shocktorap 15, Swaley Boodhun 78]
Bolton City             1-3 Petite Rivière Noire SC
  [Jérôme Thomas; Dany Février, Jean-Reck Ah-Fock, Curtis Laseringue]
[Feb 3]
PAS Mates               0-0 ASVP           
Pamplemousses SC        1-1 USBBRH
  [Mike Kayava 31; Roddy Edwards 62]
Etoile de l'Ouest       n/p OM

Round 14
[Feb 6]
PAS Mates               0-1 Etoile de l'Ouest   
  [Hailey Appadu] 
[Feb 7]
Pamplemousses SC        1-0 ASPL 2000
  [Praxis Rabemananjara 70]
USBBRH                  1-1 ASVP
  [Viraj Persootamah; Jean-Karl Augustin]
AS Rivière du Rempart   0-1 Petite Rivière Noire SC  
  [Curtis Laseringue]   
Bolton City             2-1 Savanne SC 
  [Stephen Léopold 26, Jérôme Thomas 75; Mikaël Mitraille 5]
OM                      n/p CSSC

Round 15 [Feb 10]
Pamplemousses SC        2-1 PAS Mates
  [Mike Kayava 86, Praxis Rabemananjara 90; Jimmy Far 13]
Bolton City             2-1 Etoile de l'Ouest        
  [Jérôme Thomas 2, Yovano Topize 81; Benjamin Rakotoarison 32]
CSSC                    1-0 ASPL 2000   
  [Christopher Perle 67] 
Savanne SC              1-3 ASVP
  [Stevenson Hollingsworth; Gabriel Otoo (2), Raffick Madron]
USBBRH                  2-2 Petite Rivière Noire SC
  [Jean-Noël Laboiteuse (2); Frédérik Antoine (2)]
AS Rivière du Rempart   n/p OM                

Round 16
[Feb 15]
AS Rivière du Rempart   2-3 Etoile de l'Ouest
  [Tony François 21, 90+; Benjamin Rakotoarison 2, 
   Jean-Aimée Randriasalana 17, 30]
[Feb 16]
Pamplemousses SC        1-0 ASVP                   
  [Mike Kayava 33]
Savanne SC              0-1 USBBRH      
  [Selven Viraragaven]          
[Feb 20]
Bolton City             2-4 CSSC 
  [Giano Li Thien Kee 73, 75pen; Fabrice Pauline 13, 26,
   Westley Marquette 50, Christopher Perle 82]         
[Feb 21]
ASPL 2000               2-1 Petite Rivière Noire SC  
  [Bruno Ravina 26, Jonathan Ernest 62; Jean Daniel Dig-Dig 89]
OM                      n/p PAS Mates                

Round 17 
[Feb 23]
PAS Mates               1-1 AS Rivière du Rempart  
  [Jean-Yves Noumé 86; Kuldeepak Cauroo ~50]  
Pamplemousses SC        2-0 Savanne SC
  [Andy Sophie 60, Guillaume Sockalingum 73]
ASPL 2000               2-1 Etoile de l'Ouest 
  [Bruno Ravina, Jonathan Ernest; Benjamin Rakotoarison]
[Mar 30]
CSSC                    3-0 USBBRH
  [Westley Marquette 4, 58, Kersley Appou 36]
[Apr 2]
ASVP                    1-3 Petite Rivière Noire SC
  [Lionel Agathe; Curtis Laseringue, Dany Février,
   Frédérik Antoine]
OM                      n/p Bolton City     

Round 18
[Mar 1]
USBBRH                  1-0 AS Rivière du Rempart 
  [Sewraj Dawoochand]   
ASPL 2000               5-2 Bolton City  
  [Thierry Collet, Jonathan Ernest (2), David Lim Sik Fang,
   Mervyn Bhujun; Jérôme Thomas, Stéphan Leopold] 
Etoile de l'Ouest       4-1 Pamplemousses SC  
  [Jairzinho L'Effronté 25pen, Nicolas Vial 61, 88,
   Benjamina Rakotoarison 90; Guillaume Sockalingum 31]
[Apr 9]
CSSC                    1-2 Savanne SC
  [Westley Marquette 62; Sakir Saïb 14, 35]
Petite Rivière Noire SC 2-2 PAS Mates    
  [Jean-Reck Ah-Fock, Dany Février; Jean-Yves Noumé,             
   Joey Mourgine]      
OM                      n/p ASVP   

Round 19
[Apr 5]
PAS Mates               3-0 Bolton City 
  [Jimmy Far, Gérard Naboth, Joye Estazie]
ASVP                    1-2 Etoile de l'Ouest 
  [Thierry Bérard; Hailey Appadoo, Eric Jamala]
ASPL 2000               1-2 AS Rivière du Rempart
  [Thierry Collet 9; Rico Shoctorap 71pen, Westley Cotte 91] 
[Apr 23]
Petite Rivière Noire SC 2-3 Savanne SC
  [Curtis Laseringue, Frédérik Antoine; Fabrice Pithia,
   Yannick Dig-Dig, Izzidine Boodhoo]
[Apr 27]
Pamplemousses SC        1-1 CSSC      
  [Guillaume Sockalingum 60; Rodson Tojosoa 45]
USBBRH                  n/p OM             

Round 20     
[Apr 12]
ASVP                    7-1 Bolton City    
  [Ben Abdallah (5), Kersley Louis, Aslam Abdullah; Yousouf Dookhee]
AS Rivière du Rempart   1-0 Pamplemousses SC 
  [Jean-Noël Marie]           
[Apr 16]                 
Etoile de l'Ouest       0-4 Petite Rivière Noire SC
  [Jean-Reck Ah-Fock (2), Stéphane Pierre, Samuel Rebet]     
[Apr 23]
PAS Mates               1-5 CSSC       
  [Gabriel Gaspard; Westley Marquette (3), Nana Kwasi Kyeremateng,
   Kersley Appou]
[Apr 26]
USBBRH                  0-1 ASPL 2000 
  [Stéphane Arthée]
Savanne SC              n/p OM    

Round 21 
[Apr 16]                
Pamplemousses SC        6-1 Bolton City       
  [Pamphilato Rajaonainabalo (4), Williamo Randriajato (2);
   Giano Li Thien Kee 63pen]   
AS Rivière du Rempart   2-1 Savanne SC  
  [Feizal Chitbahal 1-1, Tony François 2-1; Stevenson Hollingsworth 0-1]       
[Apr 19]
PAS Mates               2-1 USBBRH
  [Joey Mourgine, Joye Estazie; Viraj Persoomatah]
[Apr 20]              
Etoile de l'Ouest       0-3 CSSC   
  [Christopher Perle 30, Jeannot Lamarque 45,
   Nana Kwasi Kyeremateng 83]
ASPL 2000               3-0 ASVP    
  [Akmez Lauthan, Thierry Collet, Stéphane Arthée]
Petite Rivière Noire SC n/p OM     

Round 20
[Apr 12]
PAS Mates               1-1 Savanne SC
  [Joey Mourgine; Stevenson Hollingsworth]                     
Etoile de l'Ouest       4-1 USBBRH  
  [Benjamino Rakotoarison, Jaïrzinho L’Effronté, Didier Lindor (2);
   Devin Balaghee]  
[Apr 16]
ASVP                    0-1 CSSC
  [Jerry Louis 70]
[Apr 20]
AS Rivière du Rempart   1-1 Bolton City
  [Rico Shoctorap; Jérôme Thomas]
Petite Rivière Noire SC 0-5 Pamplemousses SC
  [Pamphilato Rajaonainabalo (2), Williamo Randriajato,
   Praxis Rabemanjara, Guillaume Sockalingum]
ASPL 2000               n/p OM  

Final Table: 

 1.Curepipe Starlight SC       20 13  5  2  41-17  44  [3-0]  Champions
 2.Pamplemousses SC            20 11  4  5  39-15  37  [4-0,15-0]
 3.AS Port-Louis 2000          20 11  3  6  27-13  36  [6-0]
 4.Savanne SC                  20  8  4  8  29-25  28  [3-0]
 5.Petite Rivière Noire SC     20  6  9  5  29-27  27  [2-0]
 6.Pointe-aux-Sables Mates     20  6  7  7  22-24  25  [3-0]
 7.US Beau-Bassin/Rose Hill    20  5  9  6  21-24  24  [4-0]
 8.Étoile de l'Ouest (Bambous) 20  7  2 11  21-40  23  [2-0]
 9.AS de Vacoas-Phoenix        20  4  8  8  23-23  20  [4-1]
10.AS Rivière du Rempart       20  4  8  8  23-29  20  [2-1]
-----------------------------------------------------
11.Bolton City (Roche-Bois)    20  2  7 11  16-54  13  [4-0]  Relegated
 -.Olympique de Moka           withdrew Jan 31, 2008; results annulled;
   record at withdrawal:       12  0  0 12   2-52   0

NB: annulled results vs Olympique de Moka between square brackets

Topscorers:
14 Westley Marquette (CSSC)
11 Andy Sophie (Pamplemousses SC)
 8 Westley Laboucherie (Savanne SC)
 7 Frédérik Antoine (Petite Rivière Noire FC)
   Westley Laboucherie (Savanne SC)
   Fabrice Pithia (Savanne SC)
   Praxis Rabemananjara (Pamplemousses SC)
   Jérôme Thomas (Bolton City)
 6 Jean-Reck Ah-Fock (Petite Rivière Noire FC)
   Tony François (AS Rivière du Rempart)
   Pamphilato Rajaonainabako (Pamplemousses SC)
 5 Ben Abdallah (ASVP)
   Kersley Appou (CSSC)
   Jonathan Ernest (ASPL 2000)
   Stevenson Hollingsworth (Savanne SC)
   Blaise Kadima (ASPL 2000)
   Curtis Laseringue (Petite Rivière Noire FC)
   Benjamin Rakotoarison (Etoile de l’Ouest)
   Darlien Ralahinirina (USBBRH)
   Guillano Lee Tien Kee (Bolton City)



 

Author: Major

Last updated: 23 Oct 2008

(C) Copyright Major and RSSSF 2007/08


  USO DE MEMORIA  
4,274,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1041
Total Execution Time  0.1060
  CADENA URL  
/barclays_league_mauricio2008
  GET DATOS  
$_GET['/barclays_league_mauricio2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT type FROM routes WHERE alias = 'barclays_league_mauricio2008'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'barclays_league_mauricio' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=493 AND type_rel = 3
0.0024  SELECT text_es as historical_text FROM leagues_text WHERE id=2164
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 = 30435 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='2008' WHERE c.parentId=493 GROUP BY c.id ORDER BY c.order_id ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 04:31:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 04:31:52' 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-01 04:31:52' 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-01 04:31:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'barclays_league_mauricio' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (30435) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30435) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (30435) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30435) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (30435) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0023  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30435) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (30435) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30435) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT rp.lineup 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 30435 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  SELECT rp.events 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 30435 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
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=30435 AND rel.round=20
0.0024  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 = 30435 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0023  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 = 30435 AND esl.points > 0
0.0023  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-04-01" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30435 ORDER BY creation_date DESC LIMIT 0, 10
0.0032  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-04-01" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30435
0.0025  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 `calendars2008` 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` = 30435 AND c.`round` = 20 ORDER BY shedule ASC LIMIT 200
0.0019  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 `events2008` e INNER JOIN calendars2008 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 = 20 AND e.real_date IS NOT NULL AND e.league_id = 30435 ORDER BY total DESC LIMIT 40
0.0034  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 `events2008` e INNER JOIN calendars2008 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 = 30435 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0032  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 = 30435 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT *,(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 = 30435 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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-05-01 00:00:00' AND c.`shedule` < '2024-05-05 23:59:59' AND l.id = 30435 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0032  SELECT data1, data2 FROM services_tags WHERE categoryId=493
0.0032  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 493 AND l.year = 2008 ORDER BY l.group_code ASC
0.0032  SELECT group_code, extraName from `leagues` WHERE categoryId=493 AND year=2008