4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2000
Temporada Siguiente »
Publicidad 600x120.gif
Iraq Stars League 2000
1999/2000

Iraq Stars League 2000

Información Histórica 
						
Round 1 [Oct 1]
Al-Zawraa               7-1     Maysan
Samara                  0-0     Al-Shurta 
Samawa                  0-2     Minaa 
Talaba                  2-1     Al-Nassriya 

Round 3 [Oct 7]
Al-Zawraa               5-1     Al-Nafat 
Al-Shurta               4-0     Duhok 
Maysan                  2-1     Al-Talaba 
Salahaddin              2-0     Kadhimiya 
Al-Jaish                4-2     Al-Nassriya 
Al-Najaf                4-1     Kirkuk 
Al-Defaa Al-Jawiya      2-0     Kut 
Samaraa                 2-0     Mosul 
Al-Minaa                1-1     Diyala 
Samawa                  3-3     Al-Ramadi 
Haifa                   1-1     Karbala
Al-Quwa Al-Jawiya       4-0     Arbil 
Al-Karkh                1-0     Al-Diwaniya 

Round 4 [Oct 11]
Al-Talaba               6-0     Al-Kadhimiya 
Karbala                 0-0     Al-Zawra 
Al-Karkh                2-2     Al-Najaf
Al-Quwa Al-Jawiya       1-1     Maysan
Al-Kut                  0-1     Al-Shurta 
Mosul                   3-1     Al-Jaish 
Al-Diwaniya             1-2     Al-Nafat 
Duhok                   4-0     Haifa 
Diyala                  1-0     Al-Defaa Al-Jawiya 
Al-Ramadi               2-1     Arbil 
Kirkuk                  0-2     Samara
Al-Minaa                0–0     Salahaddin 
Al-Nassriya             3-0     Samawa

Round 5 [Oct 15]
Al-Zawraa               0-0     Al-Quwa Al-Jawiya 
Talaba                  4-2     Al-Ramadi 
Kut                     3-1     Kirkuk 
Arbil                   1-0     Maysan 
Al-Kadhimiya            2-1     Samawa 
Haifa                   1-0     Al-Diwaniya
Al-Shurta               2-1     Al-Najaf
Diyala                  3-1     Mosul 
Al-Jaish                0-0     Al-Minaa 
Al-Nafat                5-0     Karbala
Samara                  2-4     Al-Defaa Al-Jawiya 

Round 6 [Oct 18]
Al-Zawraa               2-0     Diyala 
Al-Talaba               2-2     Duhok 
Karbala                 0-1     Al-Quwa Al-Jawiya
Al-Shurta               2-1     Al-Nasria 
Al-Kadhimiya            0-0     Al-Karkh 
Samara                  1-2     Al-Jaish
Haifa                   1-2     Al-Ramadi
Al-Defaa Al-Jawiya      2-1     Mosul 
Arbil                   3-1     Al-Diwaniya 
Kirkuk                  0-1     Al-Mina'a 
Salah Al-Deen           1-1     Al-Kut 
Al-Najaf                8-2     Al-Samawa

Top of Table:
 1.Al-Zawra  14 
 2.Al-Shorta 14 
 3.Diyala    13 
 4.Al-Talaba 11 
 5.Al-Karkh  11 


Round 10 [Nov 1]
Al-Quwa Al-Jawiya       2-1     Al-Jaish 
Samawa                  4-2     Talaba 
Haifa                   0-4     Al-Shurta 
Kut                     2-1     Al-Kadhimiya 
Kirkuk                  2-2     Al-Nafat 
Al-Defaa Al-Jawiya      1-1     Karbala
Al-Minaa                0-0     Duhok 
Al-Diwaniya             2-1     Mosul 
Maysan                  1-1     Diyala
Al-Nassriya             0-1     Al-Najaf
Samara                  0-3     Al-Ramadi 

Round 11 [Nov 5]
Talaba                  2-2     Haifa 
Arbil                   3-2     Al-Karkh 
Al-Mosul                1-0     Al-Kadhimiya
Al-Jaish                1-1     Al-Diwaniya
Al-Nafat                1-2     Samawa
Al-Defaa Al-Jawiya      5-2     Ramadi 
Diyala                  1-2     Duhok
Kirkuk                  3-1     Maysan
Salahaddin              1-1     Karbala 
Al-Nassriya             0-0     Al-Minaa 
Al-Najaf                2-0     Samara 

Round 24
Al-Qowa Al-Jawia        3-0     Al-Kadhmia
Al-Nafot                0-0     Al-Najaf
Al-Zawra                4-0     Al-Diwania
Al-Mina'a               0-0     Al-Talaba
Diala                   0-0     Al-Shorta
Samara'a                0-1     Al-Karkh
Karkouk                 2-3     Al-Jaish
Haifa                   0-2     Al-Koot
Salah Al-Din            2-0     Al-Difa'a Al-Jawi
Karbala'a               1-1     Dohouk
Al-Simawa               4-1     Al-Mosiel
Miesan                  0-1     Al-Ramadi
   
Round 25
Al-Difa'a Al-Jawi       4-3     Karkouk
Al-Jaish                0-1     Al-Zawra
Al-Koot                 0-2     Al-Talaba
Al-Mosiel               0-1     Al-Shorta
Al-Karkh                1-0     Al-Mina'a
Al-Nafot                5-0     Al-Kadhmia
Al-Najaf                1-0     Arbeel  
Salah Al-Din            1-2     Diala
Al-Ramadi               2-1     Karbala
Al-Diwania              0-0     Misan
Haifa                   0-0     Al-Nasiria

Round 26
Al-Qowa Al-Jawia        2-0     Al-Ramadi
Al-Nasiria              4-3     Al-Talaba
Al-Shorta               0-0     Samara'a
Al-Koot                 0-4     Al-Karkh
Al-Kadhimia             1-0     Arbeel
Al-Jaish                1-1     Al-Difa'a Al-Jawi
Al-Nafot                0-2     Dihouk
Haifa                   1-3     Al-Najaf
Karbala                 1-1     Al-Diwania
Al-Mina'a               3-1     Al-Simawa
   
Round 28:
Al-Qowa Al-Jawia        6-2     Arbil 
Dihouk                  2-0     Al-Shorta 
Al-Talaba               7-1     Miesan 
Al-Karkh                8-0     Al-Diwania
Salah Al-Din            2-0     Al-Kadhmia 
Al-Zawra                1-0     Al-Nafot 
Al-Minaa                1-1     Diala 
Karkouk                 0-1     Al-Najaf 
Al-Ramadi               1-1     Al-Simawa 
Al-Difa'a Al-Jawi       1-0     Al-Koot 
Al-Nasiria              2-0     Al-Jaish 
Al-Mosil                2-0     Samara'a 
Haifa                   1-0     Karbalaa

Round 31
Al-Zawra                3-2     Diala 
Dihouk                  1-0     Al-Talaba 
Al-Qowa Al-Jawia        1-1     Karbala 
Al-Karkh                2-0     Al-Kadhmia 
Al-Jaish                0-0     Samara 
Al-Mosil                1-0     Al-Difa'a Al-Jawi 
Al-Mina'a               1-0     Karkouk  
Al-Koot                 1-3     Salah Al-Din 
Al-Simawa               1-0     Al-Najaf 

Round 32
Al-Mosil                1-0     Al-Zawra
Al-Talaba               2-1     Al-Diwania
Al-Nafot                0-2     Al-Qowa Al-Jawia
Al-Shorta               6-3     Al-Kadhmia
Al-Ramadi               0-0     Al-Karkh
Al-Koot                 1-0     Al-Jaish
Haifa                   1-2     Miesan
Al-Difa'a Al-Jawi       0-0     Al-Mina'a
Al-Simawa               0-0     Dihouk
Arbil                   1-0     Karbala
Karkouk                 1-3     Al-Nasiria
Salah Al-Din            0-0     Al-Najaf
Samra'a                 1-0     Diala

Round 33
Al-Zawra                2-0     Samra'a
Karbala                 2-2     Al-Talaba
Al-Qowa Al-Jawia        6-0     Hafia
Al-Shorta               1-0     Al-Ramadi
Al-Kadhima              1-0     Karkouk
Maisan                  1-1     Al-Karkh
Al-Najaf                1-0     Al-Jaish
Al-Nafot                0-0     Arbeel
Al-Nasiria              0-0     Al-Difa'a Al-Jawi
Dihouk                  2-2     Salah Al-Din
Al-Mina'a               2-0     Al-Mosil
Diala                   0-0     Al-Koot
Al-Diwania              2-2     Al-Simawa       

Round 34
Arbeel                  0-2     Zawra 
Al-Talaba               1-1     Al-Jawia 
Al-Diwania              1-1     Al-Shorta 
Al-Karkh                6-0     Karbala 
Al-Jaish                2-2     Al-Kadhmia
Haifa                   1-2     Al-Nafot 
Al-Difa'a Al-Jawi       1-1     Al-Najaf 
Karkouk                 0-1     Dihouk 
Al-Koot                 0-1     Al-Mosil
Salah Al-Din            1-2     Al-Ramadi 
Al-Nasiria              2-3     Diala 
Al-Simawa               3-2     Maisan 
Samara'a                4-0     Al-Mina'a 

Round 35
Al-Shorta               3-0     Haifa
Al-Jwia                 2-0     Al-Jaish
Al-Talaba               5-2     Al-Simawa
Al-Zawra                4-1     Al-Karkh
Al-Difa'a Al-Jawi       1-3     Karbala
Al-Ramadi               0-1     Samara'a
Salah Al-Din            2-0     Arbeel
Al-Najaf                3-1     Al-Nasiria
Diala                   2-1     Miesan
Al-Koot                 1-0     Al-Kadhmia
Al-Mosil                2-1     Al-Diwania
Karkouk                 1-1     Al-Nafot

Round 39
Al-Shorta               1-2     Al-Zawra 
Al-Talaba               0-1     Al-Jaish 
Al-Qowa Al-Jawia        2-1     Al-Samara'a
Karkouk                 1-0     Al-Karkh 
Al-Ramadi               1-0     Al-Najaf 
Diala                   0-0     Arbeel 
Al-Mina'a               2-0     Karbala'a
Salah Al-Din            3-1     Al-Simawa 
Al-Mosil                1-2     Al-Nafot 
Al-Koot                 2-0     Miesan 
Al-Difa'a Al-Jawi       3-0     Haifa 
Al-Nasiria              1-2     Al-Diawania 
Dihouk                  2-1     Al-Kadhmia 

Round 49 
Al-Jaish                1-0     Karkouk
Al-Koot                 2-1     Haifa 
Al-Difa'a Al-Jawi       0-0     Sala Al-Diln 
Al-Mosil x              1-0     Al-Simawa
Al-Qowa Al-Jawia        4-1     Al-KAdhomia 
Al-Talaba               1-1     Al-Mina'a 
Al-Zawra                4-0     Al-Diwania 
Al-Shorta               6-2     Al-Ramadi 
Al-Karkh                7-0     Samara'a

Final Table:

 1.Zawra          50  34  12   4  112- 35  114  Champions
 2.Air Force      50  32  14   4   99- 29  110  [Al-Qowa Al-Jawia]
 3.Police         50  33  11   6   97- 34  110  [Al-Shorta]
 4.Al-Talaba      50  30  10  10  116- 56  100
 5.Duhook         50  28  14   8   80- 44   98 
 6.Karkh          50  25  14  11  103- 42   91 
 7.Salaheddin     50  22  19   9   61- 39   85 
 8.Port           50  20  24   6   56- 28   84  [Al-Mina'a]
 9.Najaf          50  23  14  13   64- 44   83 
10.Arbil          50  20  10  20   69- 66   70 
11.Ground Defence 50  19  13  18   58- 57   70 
12.Ramadi         50  17  16  17   55- 59   67 
13.Army           50  18  11  21   56- 50   65  [Al-Jaish]
14.Diyala         50  17  15  18   56- 64   65 
15.Samarra        50  17  12  21   49- 67   63 
16.Mosil          50  16  13  21   45- 72   63 
17.Petrol         50  15  14  21   56- 60   59 
18.Nasiriya       50  14  10  26   55- 88   52 
19.Diwaniya       50  11  18  21   41- 60   51 
20.Samawa         50  13  11  26   56- 70   50 
21.Kazimiya       50  13  11  26   46- 50   50 
22.Kut            50  11  15  24   46- 78   48 
23.Karbala        50  10  15  25   42- 91   45 
24.Maysan         50   8  14  28   34- 83   38 
25.Karkook        50   6  12  32   39- 93   30 
26.Haifa          50   3   9  38   27-114   18 

Topscorers:

1.Haider Aid (Nasiria)   28
2.Kahtan Chitheer (Karkh) 27
3.Mufeed Asim (Shurta)    25




Authors: Refel Hashim ,
Hassanin Mubarak
(Iraqifootball@yahoo.com).
Hans Schöggl
and Mohammed Qayed
(mhqayed@hotmail.com)

Last updated: 8 May 2008

(C) Copyright Refel Hashim, Hassanin Mubarak,
Hans Schöggl, Mohammed Qayed and RSSSF 2000/08


  USO DE MEMORIA  
4,252,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6305
Total Execution Time  0.6325
  CADENA URL  
/super_league_iraq2000
  GET DATOS  
$_GET['/super_league_iraq2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0146  SELECT type FROM routes WHERE alias = 'super_league_iraq2000'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_league_iraq' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0148  SELECT text_es as historical_text FROM leagues_text WHERE id=909
0.0149  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 = 29231 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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='2000' WHERE c.parentId=476 GROUP BY c.id ORDER BY c.order_id ASC
0.0149  SELECT type,rule FROM rules WHERE categoryId = 476 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:25:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:25:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:25:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 06:25:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0153  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_league_iraq' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29231) 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.0145  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 (29231) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29231) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29231) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29231) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29231) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2000 e WHERE e.league_id IN (29231) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (29231) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0144  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 = 29231 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0144  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 = 29231 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0147  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=29231 AND rel.round=50
0.0146  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 = 29231 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146  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 = 29231 AND esl.points > 0
0.0147  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` = 29231 ORDER BY creation_date DESC LIMIT 0, 10
0.0153  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` = 29231
0.0146  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 `calendars2000` 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` = 29231 AND c.`round` = 50 ORDER BY shedule ASC LIMIT 200
0.0144  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 `events2000` e INNER JOIN calendars2000 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 = 50 AND e.real_date IS NOT NULL AND e.league_id = 29231 ORDER BY total DESC LIMIT 40
0.0147  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 `events2000` e INNER JOIN calendars2000 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 = 29231 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0147  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 `tables2000` 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 = 29231 AND t.round = 48 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 29231 AND t.round = 50 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 29231 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=476
0.0147  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 476 AND l.year = 2000 ORDER BY l.group_code ASC
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=476 AND year=2000