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

Liga Palestina 2009

Información Histórica 
						

West Bank Premier League 2008/09

Final Table:

 1.Wadi Al-Neiss             21 15  4  2 46-10 49  Champions
 2.Shabab Al-Am'ari          21 15  3  3 49-14 48
 3.Jabal Mukabar             21 12  6  3 56-20 42  [East Jerusalem]
 4.Markaz Tulkarm            21 12  6  3 48-23 42
 5.Al-Bireh                  21 12  2  7 44-22 38
 6.Al-Thahriyeh              21 10  6  5 33-20 36
 7.Al-Khader                 21 11  3  7 29-26 36
 8.Thagafi Tulkarm           21 10  5  6 38-29 35
 9.Hilal Al-Quds             21  9  7  5 36-21 34  [East Jerusalem]
10.Shabab Al-Khalil          21  9  5  7 26-21 32  Playoff
- - - - - - - - - - - - - - - - - - - - - - - - -
11.Markaz Askar              21  9  5  7 32-26 32  Playoff
12.Hilal Ariha               21  8  4  9 40-34 28
13.Markaz Balata             21  7  7  7 21-19 28
14.Ahli Al-Khalil            21  7  7  7 27-32 28
15.Yatta                     21  7  4 10 32-35 25
16.Silwan                    21  6  4 11 30-28 22  [East Jerusalem]
17.Islami Bethlehem          21  6  4 11 21-43 22
18.Abu Dis                   21  5  4 12 25-49 19  [East Jerusalem]
19.Sur Baher (Al-Maqdesi)    21  4  6 11 18-43 18  [East Jerusalem]
20.Jenin                     21  4  2 15 19-46 14
- - - - - - - - - - - - - - - - - - - - - - - - -
21.Al-Arabi (Beit Safafa)    21  2  2 17 22-57  8  [East Jerusalem]
22.Ittihad Nablus            21  2  2 17 17-91  8

NB: Askar and Balata are refugee camps in the Nablus governate;
    Al-Am'ari is a refugee camp in the Ramallah and Al-Bireh governate;
    Ariha is the Arabic name for Jericho;
    Al-Khalil is the Arabic name for Hebron;
    Al-Quds is the Arabic name for Jerusalem 

Playoff for Tenth Place [Jan 16] 
Shabab Al-Khalil    2-1 Markaz Askar    

NB: top-10 qualify for Division A, teams 11-20 for Division B, bottom-2
    clubs relegated to 3rd level (Class 1)

Round 1
[Aug 21]
Silwan              0-0 Hilal Al-Quds    
[Aug 22]
Thagafi Tulkarm     2-2 Islami Bethlehem
Hilal Ariha         1-1 Shabab Al-Khalil  
Markaz Tulkarm      4-0 Ittihad Nablus    
Markaz Balata       1-2 Al-Thahriyeh        
[Aug 23]
Jenin               0-1 Markaz Askar       
Al-Ahli Al-Khalil   0-0 Wadi Al-Neiss   
Al-Bireh            1-0 Yatta
Jabal Mukabar       2-2 Al-Khader            
Sur Baher           0-3 Al-Arabi              
[Aug 25]       
Shabab Al-Am'ari    4-0 Abu Dis           

Round 2 
[Aug 29]
Abu Dis             1-1 Al-Thahriyeh 
Markaz Tulkarm      2-1 Shabab Al-Khalil     
Al-Bireh            6-0 Al-Khader     
Yatta               0-3 Wadi Al-Neiss  
Markaz Askar        2-0 Islami Bethlehem
Markaz Balata       0-0 Jenin    
[Aug 30]
Al-Ahli Al-Khalil   1-3 Shabab Al-Am'ari    
Thagafi Tulkarm     2-1 Al-Arabi     
Hilal Ariha         1-1 Jabal Mukabar      
Sur Baher           2-1 Hilal Al-Quds     
[Aug 31]
Silwan              6-0 Ittihad Nablus    

Round 3
[Sep 4]
Al-Khader           0-1 Yatta               
[Sep 5]
Hilal Ariha         0-1 Al-Bireh            
Markaz Tulkarm      2-2 Jabal Mukabar      
Silwan              3-4 Shabab Al-Khalil    
Markaz Balata       1-2 Islami Bethlehem   
[Sep 6]
Ittihad Nablus      0-0 Sur Baher           
Thagafi Tulkarm     1-2 Hilal Al-Quds       
Al-Ahli Al-Khalil   1-2 Al-Thahriyeh    
Shabab Al-Am'ari    0-1 Wadi Al-Neiss       
[Sep 7]
Abu Dis             0-2 Jenin               
[Sep 23] 
Markaz Askar        1-1 Al-Arabi   

Round 4
[Sep 11]
Markaz Tulkarm      3-0 Al-Bireh    
Hilal Ariha         3-2 Yatta
Wadi Al-Neiss       2-0 Al-Khader 
[Sep 12]
Jabal Mukabar       3-2 Silwan
Ittihad Nablus      0-1 Thagafi Tulkarm  
Hilal Al-Quds       0-3 Markaz Askar   
Jenin               0-3 Al-Ahli Al-Khalil  
[Sep 13]
Shabab Al-Khalil    1-1 Sur Baher   
Markaz Balata       1-0 Al-Arabi     
Islami Bethlehem    2-1 Abu Dis   
[Sep 14]
Shabab Al-Am'ari    2-2 Al-Thahriyeh

Round 5
[Sep 18]
Jabal Mukabar       3-0 Sur Baher  
Shabab Al-Khalil    2-3 Thagafi Tulkarm  
Ittihad Nablus      1-2 Markaz Askar   
[Sep 19]
Markaz Tulkarm      5-0 Yatta
Al-Khader           1-0 Hilal Ariha       
Wadi Al-Neiss       2-2 Al-Thahriyeh
[Sep 20]
Jenin               0-1 Shabab Al-Am'ari   
Al-Arabi            2-3 Abu Dis 
Hilal Al-Quds       1-1 Markaz Balata    
[Sep 21]
Silwan              2-0 Al-Bireh    
Islami Bethlehem    1-1 Al-Ahli Al-Khalil  

Round 6
[Sep 24]
Hilal Ariha         0-1 Wadi Al-Neiss
[Sep 25]
Yatta               1-0 Silwan         
Markaz Balata       2-0 Ittihad Nablus      
Al-Khader           3-1 Markaz Tulkarm   
[Sep 26]
Jabal Mukabar       3-2 Thagafi Tulkarm  
[Sep 27]
Al-Bireh            1-0 Sur Baher  
Shabab Al-Khalil    1-0 Markaz Askar   
[Sep 28]
Al-Thahriyeh        1-2 Jenin
Abu Dis             1-2 Hilal Al-Quds  
Shabab Al-Am'ari    2-0 Islami Bethlehem 
[Sep 29]
Al-Ahli Al-Khalil   2-0 Al-Arabi 

Round 7
[Oct 2]
Al-Khader           2-0 Silwan         
[Oct 3]
Hilal Ariha         3-2 Markaz Tulkarm   
Shabab Al-Khalil    1-1 Markaz Balata       
Thagafi Tulkarm     1-0 Al-Bireh            
[Oct 4]
Abu Dis             4-2 Ittihad Nablus      
Islami Bethlehem    0-0 Al-Thahriyeh 
Shabab Al-Am'ari    6-0 Al-Arabi 
Markaz Askar        0-0 Jabal Mukabar       
[Oct 5]
Hilal Al-Quds       0-1 Al-Ahli Al-Khalil   
Sur Baher           2-1 Yatta  
[Nov 4]
Wadi Al-Neiss       1-0 Jenin             

Round 8
[Oct 9]
Jenin               4-0 Islami Bethlehem 
Shabab Al-Khalil    2-0 Abu Dis             
[Oct 10]
Markaz Askar        2-2 Al-Bireh            
Yatta               1-2 Thagafi Tulkarm  
Shabab Al-Am'ari    2-1 Hilal Al-Quds  
Jabal Mukabar       0-2 Markaz Balata       
[Oct 11]
Ittihad Nablus      1-2 Al-Ahli Al-Khalil   
Hilal Ariha         2-1 Silwan         
Al-Arabi            0-3 Al-Thahriyeh        
Sur Baher           1-1 Al-Khader           
[Nov 11]
Markaz Tulkarm      2-2 Wadi Al-Neiss       

Round 9
[Oct 16]
Abu Dis             0-2 Jabal Mukabar 
Jenin               3-2 Al-Arabi  
Al-Khader           3-2 Thagafi Tulkarm 
[Oct 17]
Hilal Ariha         3-1 Sur Baher           
Yatta               3-2 Markaz Askar         
Shabab Al-Am'ari    8-1 Ittihad Nablus  
Al-Ahli Al-Khalil   0-2 Shabab Al-Khalil
Al-Bireh            2-1 Markaz Balata       
Islami Bethlehem    1-0 Wadi Al-Neiss        
[Oct 18]
Al-Thahriyeh        1-2 Hilal Al-Quds  
Markaz Tulkarm      3-1 Silwan              
     
Round 10
[Oct 30]
Al-Bireh            3-0 Abu Dis
Islami Bethlehem    2-0 Al-Arabi  
[Oct 31]
Al-Khader           2-1 Markaz Askar
Yatta               0-1 Markaz Balata
Hilal Ariha         0-2 Thagafi Tulkarm  
[Nov 1]
Al-Thahriyeh        3-0 Ittihad Nablus  
Jenin               1-7 Hilal Al-Quds  
Shabab Al-Khalil    0-2 Shabab Al-Am'ari  
Al-Ahli Al-Khalil   0-7 Jabal Mukabar 
[Nov 2]
Markaz Tulkarm      7-2 Sur Baher
[Dec 23]
Silwan              0-1 Wadi Al-Neiss

Round 11
[Nov 6]
Yatta               1-1 Abu Dis
Hilal Al-Quds       2-0 Islami Bethlehem 
Al-Khader           0-1 Markaz Balata
[Nov 7]
Hilal Ariha         1-2 Markaz Askar
Ittihad Nablus      2-1 Jenin
Markaz Tulkarm      1-1 Thagafi Tulkarm
Al-Bireh            1-0 Al-Ahli Al-Khalil  
Al-Arabi            1-3 Wadi Al-Neiss
Jabal Mukabar       1-0 Shabab Al-Am'ari  
[Nov 8]
Sur Baher           0-0 Silwan
Shabab Al-Khalil    0-1 Al-Thahriyeh 

Round 12
[Nov 13]
Ittihad Nablus      4-3 Islami Bethlehem        
[Nov 14]
Markaz Askar        1-2 Markaz Tulkarm          
Al-Bireh            1-2 Shabab Al-Am'ari        
Al-Ahli Al-Khalil   3-3 Yatta                   
Al-Khader           3-0 Abu Dis                 
Thagafi Tulkarm     1-1 Silwan               
Shabab Al-Khalil    4-1 Jenin                       
[Nov 15]
Hilal Al-Quds       4-2 Al-Arabi                
Markaz Balata       2-2 Hilal Ariha            
Wadi Al-Neiss       0-1 Sur Baher               
Jabal Mukabar       1-1 Al-Thahriyeh            

Round 13
[Nov 20]
Shabab Al-Khalil    1-1 Islami Bethlehem        
Thagafi Tulkarm     5-1 Sur Baher  
[Nov 21]             
Hilal Ariha         0-2 Abu Dis    
Al-Khader           1-1 Al-Ahli Al-Khalil       
Al-Bireh            0-4 Al-Thahriyeh            
Markaz Balata       0-1 Markaz Tulkarm          
Jabal Mukabar       6-0 Jenin                   
[Nov 22]                 
Ittihad Nablus      0-0 Al-Arabi                
Silwan              3-1 Markaz Askar            
Yatta               1-1 Shabab Al-Am'ari 
[Dec 30] 
Wadi Al-Neiss       1-0 Hilal Al-Quds             

Round 14
[Nov 27]
Shabab Al-Khalil    1-2 Al-Arabi         
Abu Dis             3-1 Markaz Tulkarm       
[Nov 28]          
Hilal Al-Quds       6-2 Ittihad Nablus          
Al-Ahli Al-Khalil   2-2 Hilal Ariha           
Al-Thahriyeh        1-0 Yatta                  
Al-Bireh            3-1 Jenin                   
Sur Baher           1-4 Markaz Askar     
Wadi Al-Neiss       3-0 Thagafi Tulkarm         
[Nov 29]           
Markaz Balata       1-1 Silwan                 
Shabab Al-Am'ari    2-0 Al-Khader               
Islami Bethlehem    1-2 Jabal Mukabar           

Round 15
[Dec 4]
Al-Bireh            4-0 Islami Bethlehem        
[Dec 5]
Shabab Al-Khalil    0-0 Hilal Al-Quds           
Markaz Askar        3-2 Thagafi Tulkarm         
Shabab Al-Am'ari    3-1 Hilal Ariha             
Al-Khader           1-0 Al-Thahriyeh            
Al-Ahli Al-Khalil   1-1 Markaz Tulkarm          
[Dec 6]
Yatta               4-1 Jenin                   
Markaz Balata       2-0 Sur Baher               
Wadi Al-Neiss      12-1 Ittihad Nablus          
Silwan              1-0 Abu Dis                 
Jabal Mukabar       3-2 Al-Arabi                

Round 16
[Dec 9]          
Abu Dis             2-2 Sur Baher               
Yatta               5-0 Islami Bethlehem        
Al-Thahriyeh        1-0 Hilal Ariha             
Markaz Balata       0-2 Thagafi Tulkarm   
[Dec 10]
Wadi Al-Neiss       2-0 Markaz Askar        
Jenin               1-4 Al-Khader               
Al-Ahli Al-Khalil   2-1 Silwan                  
Shabab Al-Khalil    1-0 Ittihad Nablus          
Jabal Mukabar       0-0 Hilal Al-Quds           
Al-Bireh            5-1 Al-Arabi                
[Dec 17]
Shabab Al-Am'ari    1-1 Markaz Tulkarm          

Round 17
[Dec 13]
Al-Ahli Al-Khalil   1-3 Sur Baher               
Al-Bireh            0-0 Hilal Al-Quds           
Abu Dis             3-3 Thagafi Tulkarm         
Jabal Mukabar      13-1 Ittihad Nablus          
Markaz Balata       0-0 Markaz Askar             
Silwan              1-2 Shabab Al-Am'ari     [abandoned at 1-2 in second half
[Dec 14]                                      due to violence; result stood]
Shabab Al-Khalil    0-1 Wadi Al-Neiss           
Islami Bethlehem    1-2 Al-Khader               
Al-Thahriyeh        0-1 Markaz Tulkarm          
Yatta               4-2 Al-Arabi                
Jenin               1-2 Hilal Ariha

Round 18
[Dec 19]
Al-Ahli Al-Khalil   0-2 Thagafi Tulkarm         
Al-Bireh           10-0 Ittihad Nablus          
Islami Bethlehem    1-5 Hilal Ariha             
Shabab Al-Khalil    0-2 Jabal Mukabar           
Hilal Al-Quds       2-2 Yatta                   
Al-Arabi            0-1 Al-Khader               
[Dec 20]
Wadi Al-Neiss       0-0 Markaz Balata           
Abu Dis             2-1 Markaz Askar            
Jenin               0-1 Markaz Tulkarm   
[Dec 30]                        
Shabab Al-Am'ari    awd Sur Baher            [awarded 3-0, Sur Baher dns] 
Al-Thahriyeh        4-3 Silwan                

Round 19
[Dec 25]
Abu Dis             1-4 Markaz Balata           
Yatta               3-1 Ittihad Nablus          
Al-Ahli Al-Khalil   2-2 Markaz Askar            
[Dec 26]
Islami Bethlehem    1-4 Markaz Tulkarm          
Al-Bireh            0-1 Shabab Al-Khalil        
Shabab Al-Am'ari    1-0 Thagafi Tulkarm         
Hilal Al-Quds       1-0 Al-Khader               
[Dec 27]
Al-Arabi            3-7 Hilal Ariha             
Al-Thahriyeh        awd Sur Baher            [awarded 3-0, Sur Baher dns]
Jabal Mukabar       0-1 Wadi Al-Neiss           
Jenin               0-1 Silwan                  

Round 20
[Jan 1]     
Al-Ahli Al-Khalil   1-0 Markaz Balata       
Ittihad Nablus      1-3 Al-Khader              
[Jan 2]               
Shabab Al-Khalil    1-0 Yatta                      
Al-Thahriyeh        1-1 Thagafi Tulkarm         
Hilal Ariha         0-4 Hilal Al-Quds
Islami Bethlehem    1-0 Silwan             
[Jan 3]
Shabab Al-Am'ari    1-2 Markaz Askar  
Jenin               0-0 Sur Baher               
[Jan 6]          
Abu Dis             1-8 Wadi Al-Neiss           
Al-Bireh            3-2 Jabal Mukabar           
Markaz Tulkarm      awd Al-Arabi             [awarded 3-0, Al-Arabi dns]              

Round 21
[Jan 9]
Abu Dis             awd Al-Ahli Al-Khalil    [awarded 0-3, Abu Dis dns]
Al-Thahriyeh        0-2 Markaz Askar            
Al-Khader           0-2 Shabab Al-Khalil        
Al-Bireh            1-2 Wadi Al-Neiss           
Thagafi Tulkarm     3-1 Jenin                   
Markaz Balata       awd Shabab Al-Am'ari     [awarded 0-3, Balata dns]
[Jan 10]
Hilal Ariha         7-0 Ittihad Nablus          
Yatta               awd Jabal Mukabar        [awarded 0-3, Yatta dns]
Markaz Tulkarm      1-1 Hilal Al-Quds           
Sur Baher           1-2 Islami Bethlehem        
Silwan              awd Al-Arabi             [awarded 3-0, Al-Arabi dns]

Final Table:

 1.Wadi Al-Neiss             21 15  4  2 46-10 49  Champions
 2.Shabab Al-Am'ari          21 15  3  3 49-14 48
 3.Jabal Mukabar             21 12  6  3 56-20 42  [East Jerusalem]
 4.Markaz Tulkarm            21 12  6  3 48-23 42
 5.Al-Bireh                  21 12  2  7 44-22 38
 6.Al-Thahriyeh              21 10  6  5 33-20 36
 7.Al-Khader                 21 11  3  7 29-26 36
 8.Thagafi Tulkarm           21 10  5  6 38-29 35
 9.Hilal Al-Quds             21  9  7  5 36-21 34  [East Jerusalem]
10.Shabab Al-Khalil          21  9  5  7 26-21 32  Playoff
- - - - - - - - - - - - - - - - - - - - - - - - -
11.Markaz Askar              21  9  5  7 32-26 32  Playoff
12.Hilal Ariha               21  8  4  9 40-34 28
13.Markaz Balata             21  7  7  7 21-19 28
14.Ahli Al-Khalil            21  7  7  7 27-32 28
15.Yatta                     21  7  4 10 32-35 25
16.Silwan                    21  6  4 11 30-28 22  [East Jerusalem]
17.Islami Bethlehem          21  6  4 11 21-43 22
18.Abu Dis                   21  5  4 12 25-49 19  [East Jerusalem]
19.Sur Baher (Al-Maqdesi)    21  4  6 11 18-43 18  [East Jerusalem]
20.Jenin                     21  4  2 15 19-46 14
- - - - - - - - - - - - - - - - - - - - - - - - -
21.Al-Arabi (Beit Safafa)    21  2  2 17 22-57  8  [East Jerusalem]
22.Ittihad Nablus            21  2  2 17 17-91  8

NB: Askar and Balata are refugee camps in the Nablus governate;
    Al-Am'ari is a refugee camp in the Ramallah and Al-Bireh governate;
    Ariha is the Arabic name for Jericho;
    Al-Khalil is the Arabic name for Hebron;
    Al-Quds is the Arabic name for Jerusalem 

Playoff for Tenth Place [Jan 16] 
Shabab Al-Khalil    2-1 Markaz Askar    

NB: top-10 qualify for Division A, teams 11-20 for Division B, bottom-2
    clubs relegated to 3rd level (Class 1)



Authors: Susan Shalabi Molano and Karel Stokkermans

Last updated: 11 Dec 2009

(C) Copyright Susan Shalabi Molano, Karel Stokkermans and 
RSSSF 2008/09


  USO DE MEMORIA  
4,272,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5827
Total Execution Time  0.5845
  CADENA URL  
/league_palestina2009
  GET DATOS  
$_GET['/league_palestina2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'league_palestina2009'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_palestina' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=503 AND type_rel = 3
0.0138  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 503 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1285339,1242636,1054899,994165,894718) ORDER BY n.cover_points DESC, update_date DESC
0.0133  SELECT text_es as historical_text FROM leagues_text WHERE id=1283
0.0126  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 = 29561 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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='2009' WHERE c.parentId=503 GROUP BY c.id ORDER BY c.order_id ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 12:08:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 12:08:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 12:08:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 12:08:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0137  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_palestina' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (29561) 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.0128  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 (29561) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (29561) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (29561) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (29561) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  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 (29561) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (29561) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (29561) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 29561 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0126  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 = 29561 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0131  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=29561 AND rel.round=21
0.0129  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 = 29561 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0128  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 = 29561 AND esl.points > 0
0.0131  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-02" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29561 ORDER BY creation_date DESC LIMIT 0, 10
0.0144  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-02" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29561
0.0135  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 `calendars2009` 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` = 29561 AND c.`round` = 21 ORDER BY shedule ASC LIMIT 200
0.0128  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 `events2009` e INNER JOIN calendars2009 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 = 21 AND e.real_date IS NOT NULL AND e.league_id = 29561 ORDER BY total DESC LIMIT 40
0.0134  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 `events2009` e INNER JOIN calendars2009 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 = 29561 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0132  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 = 29561 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT *,(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 = 29561 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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-02 00:00:00' AND c.`shedule` < '2024-05-06 23:59:59' AND l.id = 29561 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0132  SELECT data1, data2 FROM services_tags WHERE categoryId=503
0.0132  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 503 AND l.year = 2009 ORDER BY l.group_code ASC
0.0132  SELECT group_code, extraName from `leagues` WHERE categoryId=503 AND year=2009