4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
Final Table:

 1.Zamalek (Cairo)              26 21  4  1  57-10  67  Champions
 2.Al Ahly (Cairo)              26 21  3  2  53-13  66
 3.Ismaily (Ismailiya)          26 13  7  6  35-22  46
 4.ENPPI (Cairo)                26 11  9  6  33-19  42  [Petroleum]
 5.Haras Al-Hodoud (Alexandria) 26 11  8  7  30-21  41  [aka Border Guards]
 6.Al Masry (Port Said)         26  9  6 11  22-26  33
 7.Ghazl Al-Mehalla             26  7 10  9  22-25  31
 8.Baladiyyat Al-Mehalla        26  8  7 11  21-29  31
 9.Ittihad (Alexandria)         26  9  4 13  24-36  31
10.Al Tersana (Cairo)           26  8  6 12  32-43  30  [aka Arsenal]
11.Mansoura (Mansoura)          26  7  8 11  20-26  29
------------------------------------------------------
12.Mokawloon al-Arab (Cairo)    26  5 13  8  23-25  28  Relegated  [aka Arab Contractors]
13.Goldy (Fayoom)               26  4  4 18  19-43  16  Relegated
14.Aswan                        26  2  3 21  15-68   9  Relegation Playoff

NB: Aswan will play Sohag (best 2nd level team from Upper Egypt) to
    decide the Upper Egypt representative 2003/04.

Round 1 [Sep 23]
Zamalek     3-0 Masry
  [Abdulhalim Ali 43, 47, Mohamed Abdulwahed 88]
Tersana     1-2 Ismaily 
  [Mohamed Abou-Tarikah 49; Mohamed Mohsen Abou-Greyshah 88, 90]
B Mehalla   1-0 Goldy
  [Akram Abdulmajid 57]
ENPPI       1-0 Mokawloon
  [Hamada Shanah 35]
Mansoura    2-0 Ittihad
  [Ashraf Khamis 15, Ahmed Salem 67]
H Hodoud    0-1 Ahly
  [Mohamed Fadhl 8]
Aswan       0-3 G Mehalla 
  [Hossam Abdulal 20, Tamer Abdulhakim 30, Ekrami Abdulaziz 90]

Round 2
[Sep 27]
Ittihad     0-1 Zamalek
  [Hossam Hassan 29]
Ahly        3-0 Mansoura
  [Gilberto 16, Ahmed Bilal 68, 76]
G Mehalla   0-2 B Mehalla
  [Ayman Mashali 70, Bassem Wajdi 87]
Goldy       1-2 ENPPI 
  [Nabil Abou-Zeid 40pen; Magdi Abdul-Ati 32pen, 44]
Mokawloon   0-0 H Hodoud
Masry       1-1 Tersana
  [Mohamed Abdulsattar 43; Mustapha Abdulaziz 55]
[Oct 4]
Ismaily     3-0 Aswan
  [Islam Al-Shater 38pen, Mohamed Barakat 52, Amrou Fahim 60]

Round 3 
[Oct 10]
B Mehalla   1-0 Ismaily
  [Abdulaziz Ragab 90]
Aswan       0-2 Masry
  [Mohamed Shawqi 50, Walid Abou Al-Ila 86]
Tersana     0-2 Zamalek
  [Walid Abdullatif 7, Khaled Al-Ghandour 88]
ENPPI       1-1 G Mehalla
  [Magdi Abdul-Ati 59; Hossam Al-Sharbini 86]
[Oct 11]
H Hodoud    1-0 Goldy
  [Samuel Tera 56]
Mansoura    1-1 Mokawloon
  [Sameh Al-Saqqa 80; Sameh Youssouf 32]
Ahly        1-0 Ittihad
  [Khaled Bibo 70]

Round 4
[Oct 17]
Ismaily     1-0 ENPPI
  [Mohamed Salah Abou-Greyshah 25]
Goldy       1-2 Mansoura
  [Nabil Abou-Zeid 70; Amrou Islam 65, 78]
Ittihad     1-4 Tersana
  [Youssouf Hamdi 9; Ahmed Abdulzaher 15, Hossam Mabrouk 25, 
   Tareq Al-Sayyed 65, Medhat Ramadan 84]
G Mehalla   1-1 H Hodoud
  [Ayman Saeed 33; Samuel Tera 40]
[Oct 28]
Mokawloon   2-6 Ahly
[Oct 29]
Masry       1-0 B Mehalla
  [Hassan Moussa 44]
Zamalek     5-0 Aswan
  [Hossam Hassan 8, 59, Abdulhalim Ali 11, 90, Walid Abdullatif 73]

Round 5
[Oct 22]
Ahly        2-0 Goldy
  [Ala'a Ibrahim 40, Ahmed Bilal 63]
[Oct 24]
B Mehalla   0-1 Zamalek
  [Oussama Nabih 90]
H Hodoud    1-1 Ismaily
  [Samuel Tera 22; Imad Al-Nahhas 35]
[Oct 25]
ENPPI       1-1 Masry
  [Abdulhamid Hassan 90; Amrou Al-Dousouqi 31]
Aswan       2-5 Tersana
  [Jamal Jihad 56pen, Oussama Ragab 66; Ahmed Abdulzaher 2,
   Mohamed Abou-Tarikah 7, 13, 90, Ayman Khalil 86]
Mansoura    0-0 G Mehalla
Mokawloon   0-0 Ittihad

Round 6
[Nov 1]
Ismaily     0-0 Mansoura
Goldy       0-2 Mokawloon
  [Robert Okori 46, 89]
[Nov 2]
Ittihad     1-1 Aswan
  [Youssouf Hamdi 77; Abdou Al-Nasr Al-Deeb 61]
Tersana     1-1 B Mehalla
  [Ahmed Zaghloul 90; Bassem Ragab 41]
Masry       1-1 H Hodoud
  [Yasser Al-Kenani 81; Ramadan Ragab 33]
[Nov 3]
G Mehalla   2-3 Ahly
  [Ekrami Abdulaziz 20, Mahmoud Sobhy 85; Ahmed Bilal 33,
   Gilberto Santos 51, Sayyed Abdulhafiz 88]
[Dec 26]
Zamalek     1-1 ENPPI

Round 7
[Nov 7]
ENPPI       5-1 Tersana
  [Sayyed Abdulnahim 21, Magdi Abdulati 45, 82, Samir Sabry 71, 
   Amrou Abdou 87; Mamdouh Khalil( 77pen]
Goldy       1-0 Ittihad
  [Nabil Abuo-Zeid 13pen]
Mokawloon   0-0 G Mehalla
[Nov 8]
Ahly        1-0 Ismaily 
  [Hossam Ghali 71]
H Hodoud    2-1 Zamalek
  [Al-Hassan Mohamed 15, Ahmed Khalaf 90; Hossam Hassan 23]
B Mehalla   2-0 Aswan
  [Akram Abdulmajid 9, Ahmed Samir 72]
Mansoura    1-2 Masry 
  [Omar Fathi 32; Hassan Moussa 45, Mohamed Shawqi 60]

Round 8
[Nov 12]
Tersana     1-0 H Hodoud
Aswan       1-4 ENPPI
Masry       1-3 Ahly
G Mehalla   2-1 Goldy
Ittihad     1-1 B Mehalla
Ismaily     2-1 Mokawloon
[Jan 25]
Zamalek     3-0 Mansoura

Round 9
[Nov 24]
ENPPI       4-0 B Mehalla
[Nov 28]
Mokawloon   0-0 Masry
[Nov 29]
Goldy       0-3 Ismaily
G Mehalla   3-0 Ittihad
Mansoura    0-1 Tersana
H Hodoud    2-0 Aswan
[Jan 30]
Ahly        2-2 Zamalek

Round 10
[Dec 5]
Tersana     0-4 Ahly
[Dec 6]
Ittihad     0-2 ENPPI
Ismaily     1-0 G Mehalla
B Mehalla   1-0 H Hodoud
Masry       1-0 Goldy
Aswan       0-1 Mansoura
[Feb 24]
Zamalek     2-0 Mokawloon

Round 11
[Dec 30]
Goldy       0-2 Zamalek
[Jan 2]
G Mehalla   1-2 Masry
Mansoura    0-1 B Mehalla
H Hodoud    1-0 ENPPI
Ismaily     2-0 Ittihad
[Jan 3]
Mokawloon   2-0 Tersana
Ahly        1-0 Aswan

Round 12
[Jan 6]
ENPPI       1-1 Mansoura
H Hodoud    2-1 Ittihad
Masry       0-0 Ismaily
[Jan 7]
Zamalek     3-0 G Mehalla
Tersana     3-0 Goldy
Aswan       0-2 Mokawloon
B Mehalla   0-4 Ahly

Round 13
[Jan 10]
Goldy       3-0 Aswan
Ittihad     2-1 Masry
G Mehalla   1-1 Tersana
Mansoura    1-2 H Hodoud
Ahly        2-1 ENPPI
Mokawloon   1-1 B Mehalla
[Jan 11]
Ismaily     1-3 Zamalek

Round 14 [Feb 3]
Goldy       1-1 B Mehalla
Masry       0-1 Zamalek
Ismaily     2-0 Tersana
G Mehalla   1-0 Aswan
Mokawloon   0-1 ENPPI
Ittihad     2-1 Mansoura
Ahly        1-0 H Hodoud

Round 15
[Feb 7]
Tersana     1-0 Masry
B Mehalla   0-1 G Mehalla
Aswan       2-2 Ismaily
ENPPI       0-0 Goldy
H Hodoud    1-1 Mokawloon
Mansoura    0-1 Ahly
[Mar 17]
Zamalek     5-0 Ittihad

Round 16 [Feb 16]
Zamalek     1-0 Tersana
Masry       2-0 Aswan
Ismaily     4-1 B Mehalla
G Mehalla   1-1 ENPPI
Goldy       0-1 H Hodoud
Mokawloon   0-0 Mansoura
Ittihad     0-3 Ahly

Round 17
[Feb 20]
Ahly        0-0 Mokawloon
Aswan       0-3 Zamalek
[Feb 21]
B Mehalla   0-2 Masry
Tersana     3-0 Ittihad
ENPPI       1-2 Ismaily
H Hodoud    1-1 G Mehalla
Mansoura    1-0 Goldy

Round 18
[Feb 27]
Ismaily     2-0 H Hodoud
G Mehalla   1-0 Mansoura
[Feb 28]
Tersana     2-2 Aswan
Zamalek     2-0 B Mehalla
Masry       1-0 ENPPI
Ittihad     0-0 Mokawloon
Goldy       0-2 Ahly

Round 19
[Mar 3]
Mansoura    0-0 Ismaily
[Mar 4]
Ahly        1-1 G Mehalla
Aswan       0-3 Ittihad
B Mehalla   3-0 Tersana
H Hodoud    1-0 Masry
ENPPI       0-0 Zamalek
[Mar 5]
Mokawloon   3-0 Goldy

Round 20
[Mar 8]
Tersana     0-0 ENPPI
Aswan       1-0 B Mehalla
Ismaily     0-1 Ahly
Masry       1-1 Mansoura
Zamalek     1-1 H Hodoud
[Mar 9]
G Mehalla   0-0 Mokawloon
Ittihad     2-0 Goldy

Round 21
[Mar 13]
Mansoura    0-1 Zamalek
B Mehalla   0-2 Ittihad
Mokawloon   0-0 Ismaily
[Mar 14]
ENPPI       2-1 Aswan
Goldy       1-1 G Mehalla
H Hodoud    6-2 Tersana
Ahly        2-0 Masry

Round 22 [Apr 19]
B Mehalla   1-1 ENPPI
Tersana     1-2 Mansoura 
Ismaily     2-2 Goldy 
Aswan       0-3 H Hodoud
Masry       1-0 Mokawloon 
Ittihad     1-0 G Mehalla 
Zamalek     3-1 Ahly 

Round 23 [May 4]
Mokawloon   0-3 Zamalek
Goldy       2-0 Masry
ENPPI       1-0 Ittihad
Mansoura    4-1 Aswan
H Hodoud    0-0 B Mehalla
Ahly        2-0 Tersana
G Mehalla   0-1 Ismaily

Round 24 [May 8]
Masry       0-1 G Mehalla
Zamalek     4-2 Goldy
Tersana     2-2 Mokawloon
B Mehalla   0-0 Mansoura
ENPPI       1-0 H Hodoud
Ittihad     4-1 Ismaily
Aswan       0-5 Ahly

Round 25 [May 12]
Ahly        1-0 B Mehalla
Ismaily     3-2 Masry
G Mehalla   0-3 Zamalek
Goldy       2-1 Tersana
Mokawloon   5-0 Aswan
Mansoura    2-1 ENPPI
Ittihad     3-1 H Hodoud

Round 26 [May 23]
Masry       0-1 Ittihad
Zamalek     1-0 Ismaily
Tersana     1-0 G Mehalla
Aswan       4-2 Goldy
B Mehalla   4-1 Mokawloon
ENPPI       1-0 Ahly
H Hodoud    2-0 Mansoura

Final Table:

 1.Zamalek (Cairo)              26 21  4  1  57-10  67  Champions
 2.Al Ahly (Cairo)              26 21  3  2  53-13  66
 3.Ismaily (Ismailiya)          26 13  7  6  35-22  46
 4.ENPPI (Cairo)                26 11  9  6  33-19  42  [Petroleum]
 5.Haras Al-Hodoud (Alexandria) 26 11  8  7  30-21  41  [aka Border Guards]
 6.Al Masry (Port Said)         26  9  6 11  22-26  33
 7.Ghazl Al-Mehalla             26  7 10  9  22-25  31
 8.Baladiyyat Al-Mehalla        26  8  7 11  21-29  31
 9.Ittihad (Alexandria)         26  9  4 13  24-36  31
10.Al Tersana (Cairo)           26  8  6 12  32-43  30  [aka Arsenal]
11.Mansoura (Mansoura)          26  7  8 11  20-26  29
------------------------------------------------------
12.Mokawloon al-Arab (Cairo)    26  5 13  8  23-25  28  Relegated  [aka Arab Contractors]
13.Goldy (Fayoom)               26  4  4 18  19-43  16  Relegated
14.Aswan                        26  2  3 21  15-68   9  Relegation Playoff

NB: Aswan will play Sohag (best 2nd level team from Upper Egypt) to
    decide the Upper Egypt representative 2003/04.

Relegation Playoff

First Leg
Sohag       0-1 Aswan

Second Leg
Aswan       3-0 Sohag

Aswan remain at 1st level




Authors: Mohamed S. Chbaro
(sp_editor@terra.net.lb)
and Tarek Said
(tsaid3@yahoo.com)

Last updated: 7 Sep 2007

(C) Copyright Mohamed S. Chbaro, Tarek Said and RSSSF 2002/07


  USO DE MEMORIA  
4,274,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.1105
Total Execution Time  0.1134
  CADENA URL  
/egipto2003
  GET DATOS  
$_GET['/egipto2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT type FROM routes WHERE alias = 'egipto2003'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'egipto' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=367
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 = 28680 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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='2003' WHERE c.parentId=64 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 64 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 00:56:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 00:56:14' 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-02 00:56:14' 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-02 00:56:14' 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 = 'egipto' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28680) 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.0018  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 (28680) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28680) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (28680) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28680) AND (e.action IN (3,4) ) 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 (28680) 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 events2003 e WHERE e.league_id IN (28680) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (28680) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0027  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 = 28680 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0021  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 = 28680 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  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=28680 AND rel.round=26
0.0022  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 = 28680 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 28680 AND esl.points > 0
0.0019  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` = 28680 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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` = 28680
0.0020  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 `calendars2003` 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` = 28680 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0020  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 `events2003` e INNER JOIN calendars2003 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 = 26 AND e.real_date IS NOT NULL AND e.league_id = 28680 ORDER BY total DESC LIMIT 40
0.0022  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 `events2003` e INNER JOIN calendars2003 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 = 28680 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28680 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 28680 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 28680 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=64
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 64 AND l.year = 2003 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=64 AND year=2003