4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						1965/66

Group 1
                            OFI Fos Pan ApK EAK AtP Cha PGE Thy Kal AOJ Arg OlP Ave Cha Tri
 1. O.F.I. Iraklion         XXX 3:0 2:1 2:0 2:1 2:0 2:0 2:1 1:0 2:1 2:1 3:1 2:0 3:0 1:0 4:1
 2. A.P.O. Fostiras Tavros  0:0 XXX 2:0 2:1 2:2 1:0 2:0 3:0 5:2 5:0 1:0 3:0 4:0 2:1 6:1 2:0
 3. Panetolikos Agrinio     2:0 2:1 XXX 4:1 1:0 3:1 1:0 0:0 4:2 1:0 2:0 5:0 2:1 0:0 3:0 2:0
 4. Apollonas Kalamatas     3:0 2:1 2:1 XXX 1:0 2:0 3:1 2:0 3:2 0:3 1:0 2:0 1:0 2:0 4:2 6:0
 5. Ethnikos Asteras Athina 1:1 1:3 2:1 0:1 XXX 1:1 3:1 1:1 2:0 2:2 3:1 1:1 3:1 2:1 4:0 3:0
 6. Atromitos Peristeri     2:2 1:3 1:0 2:1 2:1 XXX 3:1 1:0 2:0 0:1 4:1 2:1 0:2 2:0 3:2 4:1
 7. A.E. Chalandri Athina   2:2 3:3 1:1 1:0 3:0 4:0 XXX 2:1 0:1 3:1 4:0 2:0 1:1 8:0 6:3 2:0
 8. Panachaiki G.E. Patras  3:3 2:0 2:2 2:0 2:2 1:2 0:0 XXX 3:2 1:0 2:0 1:0 6:1 1:1 5:1 2:0
 9. Thyella Patras          1:2 2:0 0:0 2:1 0:1 2:1 2:2 4:2 XXX 2:1 2:2 4:2 1:0 2:0 2:1 5:2
10. P.A.O. Kalogreza        3:2 1:1 0:0 0:1 2:1 1:2 3:1 0:1 6:1 XXX 5:0 5:1 0:0 3:0 4:0 8:1
11. A.O. Jiannina           0:0 2:1 0:0 1:0 1:2 1:3 4:2 2:0 1:0 1:0 XXX 2:0 4:2 2:0 4:1 2:0
12. Panargiakos Argos       2:2 0:1 5:1 1:0 1:2 1:0 1:0 0:0 2:1 2:2 2:1 XXX 3:1 0:0 3:0 4:0
13. Olympiakos Patras       1:1 0:0 1:1 2:2 0:0 3:0 1:1 1:1 3:1 2:2 0:1 1:1 XXX 2:0 5:1 4:1
14. Averof Jiannina         0:0 2:2 0:0 2:1 1:0 0:0 2:3 1:1 1:1 2:0 2:0 0:0 0:1 XXX 3:1 2:1
15. A.E. Chania Kritis      0:0 5:0 1:0 2:3 3:4 0:0 1:2 2:1 1:1 2:0 3:2 1:1 3:0 2:1 XXX 3:0
16. Panarkadikos Tripolis   1:2 1:3 0:2 0:0 0:2 0:4 0:2 0:5 0:2 1:2 0:2 0:2 2:3 0:2 2:2 XXX

TABLE :
 1.Omilos Filathlon Iraklion Kritis 74  30  17-10- 3  50:28 +22 ~~
------------------------------------------------------------------
 2.A.P.O. Fostiras Tavros Athina    70  30  17- 6- 7  59:34 +25
 3.Panaitolikos Agrinio             67  30  14- 9- 7  42:25 +17
 4.Apollonas Kalamatas              66  30  17- 2-11  46:33 +13
 5.Ethnikos Asteras Kaisariani Ath  64  30  13- 8- 9  47:36 +11
 6.Atromitos Peristeri Athina       64  30  15- 4-11  43:38 + 5
 7.A.E. Chalandri Athinas           63  30  13- 7-11  58:41 +17     (-1 point)
 8.Panachaiki  G.E. Patras          62  30  11-10- 9  47:35 +12
 9.P.A.O. Kalogreza Athina          59  30  12- 6-12  56:38 +18     (-1 point)
10.Thyella Patras                   59  30  12- 5-13  47:51 - 4
11.A.O. Ioannina                    59  30  13- 3-14  38:44 - 6
12.Panargiakos Argos                58  30  10- 8-12  37:43 - 6
13.Olympiakos Patras                57  30   8-11-11  39:45 - 6
------------------------------------------------------------------
14.Averof Ioannina                  53  30   7-10-13  24:42 -18 --  (-1 point)
------------------------------------------------------------------
15.A.E. Chania                      51  30   8- 5-17  44:70 -26
16.Panarkadikos Tripoli             23  30   0- 2-28  14:88 -74     (-9 points)

Group 2
                          Viz Dia Ele Lar Ion Evr OlC AtP Aia Lam Arg Mit Tyr Kor Orc  Dor
 1. Vizas Megara          XXX 2:0 0:0 6:0 3:1 4:0 1:0 2:1 1:1 2:1 1:1 2:1 4:1 4:2 9:1  2:0
 2. G.A.S. Diagoras Rodos 1:0 XXX 2:1 2:2 2:0 2:2 1:0 2:0 4:1 3:1 2:1 3:0 2:0 3:0 5:1  1:0
 3. Panelefsiniakos       1:0 3:1 XXX 1:1 3:0 2:0 1:1 2:0 2:3 2:0 0:1 2:1 3:1 5:1 2:1  4:1
 4. A.E. Larisa           0:0 0:0 2:1 XXX 1:2 2:0 4:2 1:1 2:0 2:0 2:1 1:0 0:0 1:0 3:0  1:0
 5. Ionikos Nikeas        2:0 1:1 2:0 3:0 XXX 1:1 2:0 0:0 1:1 2:5 2:2 1:1 1:0 2:0 3:0  3:0
 6. Evripos Chalkidas     2:2 1:0 3:0 1:1 3:2 XXX 1:0 2:0 3:2 1:0 2:0 2:3 2:1 6:1 2:0 10:0
 7. Olympiakos Chalkidas  2:1 3:1 0:0 2:2 2:0 1:0 XXX 0:1 3:0 1:0 5:2 2:1 2:0 0:0 2:0  7:1
 8. Atromitos Pireas      1:2 0:1 1:1 2:2 1:1 2:2 0:2 XXX 1:1 2:1 3:2 2:1 5:1 1:1 6:1  3:0
 9. Aiantas Salaminas     2:4 1:0 0:0 1:0 0:1 5:4 0:0 1:1 XXX 2:0 1:1 3:0 0:0 4:3 3:2  2:0
10. A.O. Lamias           3:2 1:0 0:1 0:2 2:2 4:1 2:3 1:1 3:0 XXX 2:1 3:1 5:1 1:1 2:0  5:3
11. Argonaftis Pireas     0:4 1:0 0:1 2:1 1:0 0:1 3:1 2:2 1:1 4:0 XXX 2:1 2:0 1:0 3:2  1:0
12. A.E. Mitilinis Lesvos 1:1 0:1 0:1 1:0 1:1 2:0 3:0 4:3 3:1 1:0 1:0 XXX 1:0 2:0 3:0  3:0
13. A.E. Tyrnavos         0:1 1:0 0:0 0:1 1:2 4:0 2:2 1:1 2:1 2:1 1:0 1:1 XXX 3:0 2:0  2:0
14. A.O. Korinthos        0:1 0:2 0:0 0:1 0:2 1:0 2:1 0:1 2:1 0:0 1:0 0:0 1:1 XXX 6:0  3:3
15. A.E. Orchomenos       2:5 0:4 0:1 1:2 1:1 2:3 1:0 1:1 1:2 0:2 2:3 2:1 0:0 2:2 XXX  2:0
16. Dorieas Rodos         1:3 1:3 2:2 1:2 0:2 1:3 1:2 1:2 2:3 2:4 0:2 2:0 0:1 2:1 2:0  XXX

TABLE :
 1.Vizas Megaron                    74  30  19- 6- 5  69:28 +41 ++
------------------------------------------------------------------
 2.G.A.S. Diagoras Rodos            70  30  18- 4- 8  49:24 +25
 3.Panelefsiniakos Elefsina         69  30  15- 9- 6  42:24 +18
 4.A.E. Larisa                      69  30  15- 9- 6  39:30 + 9
 5.Ionikos Nikeas Pireas            65  30  13-10- 7  43:32 +11     (-1 point)
 6.Evripos Chalkidas                65  30  15- 5-10  58:45 +13
 7.Olympiakos Chalkidas             64  30  14- 6-10  46:33 +13
 8.Atromitos Pireas                 61  30   9-13- 8  45:39 + 6
 9.Aiantas Salaminas                61  30  11- 9-10  43:49 - 6
10.Argonaftis Pireas                60  30  13- 5-12  40:39 + 1     (-1 point)
11.A.E. Mytilinis Lesvos            59  30  12- 5-13  40:36 + 4
12.A.O. Lamias                      58  30  12- 4-14  49:45 + 4
13.A.E. Tyrnavos                    56  30   9- 8-13  29:38 - 9
14.A.O. Korinthos                   48  30   5- 9-16  28:50 -22     (-1 point)
15.A.E. Orchomenos                  40  30   3- 4-23  25:80 -55
16.Dorieas Rodos                    38  30   3- 2-25  26:79 -53

Group 3
                            Ver ApK Kas DoD Ede OlV OlK Kav AsX ArP AnJ NiF Kil Mak MEN AnK
 1. A.S. Verias             XXX 1:1 1:0 2:0 1:0 1:0 0:0 2:1 2:0 0:0 1:1 5:0 2:1 2:1 3:0 3:0
 2. Apollonas Kalamarias    4:2 XXX 2:0 1:1 0:0 2:1 0:0 3:0 4:1 0:0 2:0 3:1 2:1 4:1 0:0 6:1
 3. A.E. Kastoria           0:0 0:0 XXX 0:0 1:1 1:0 2:1 3:0 1:0 4:0 1:0 1:0 3:0 4:2 1:1 2:1
 4. A.S. Doxa Dramas        1:0 1:1 1:1 XXX 1:0 1:1 2:1 3:1 3:1 1:0 1:1 1:1 2:1 3:2 2:1 2:0
 5. A.O. Edessaikos Edessa  0:1 1:1 0:1 3:0 XXX 1:1 1:1 3:1 1:1 1:1 0:0 3:1 1:0 2:1 1:0 1:0
 6. Olympiakos Volos        1:0 1:0 4:1 1:0 2:1 XXX 1:1 1:3 2:0 1:0 1:0 2:1 4:0 5:0 2:2 6:0
 7. Olympiakos Kozanis      2:1 2:1 0:1 1:0 0:0 0:0 XXX 2:1 3:0 0:0 1:1 1:0 7:0 2:2 0:0 1:0
 8. A.O. Kavala             0:1 0:0 2:1 1:1 1:1 3:0 1:1 XXX 4:2 2:0 3:1 3:0 5:2 2:1 2:1 1:1
 9. Aspida Xanthis          2:0 0:1 1:1 1:0 2:2 3:1 1:1 1:4 XXX 3:2 2:0 1:0 4:0 6:1 3:2 4:1
10. Aris Ptolemaidas        0:1 3:1 0:1 2:0 1:1 3:1 1:0 1:1 0:0 XXX 2:1 4:0 2:0 2:1 7:2 2:2
11. Anajennisi Jiannitsa    1:2 3:1 2:0 1:1 0:2 4:1 2:1 0:0 3:1 2:0 XXX 1:0 2:1 1:3 2:1 2:0
12. Nikiforos Florinas      0:0 0:0 2:0 1:2 1:2 0:0 1:1 1:0 2:0 2:0 2:0 XXX 2:0 1:0 3:0 3:1
13. A.O. Kilkisiakos        0:1 0:1 3:2 0:2 1:1 2:1 2:1 1:0 0:0 1:1 3:0 1:0 XXX 3:0 3:0 3:0
14. Makedonikos N.E.        0:1 0:2 2:0 1:0 1:1 3:2 1:0 0:0 1:2 2:1 1:3 0:0 1:1 XXX 0:1 2:2
15. M.E.N.T. Toumbas        1:1 2:1 0:2 0:0 1:1 1:2 2:4 0:1 1:2 1:1 2:2 1:0 2:0 1:2 XXX 3:2
16. Anajennisis Karditsas   0:2 0:3 1:2 0:1 1:1 0:3 1:3 1:1 1:1 1:1 2:1 2:1 1:1 4:2 2:1 XXX

TABLE :
 1.A.S. Verias                      73  30  18- 7- 5  39:17 +22 ++
------------------------------------------------------------------
 2.Apollonas Kalamaria Thessaloniki 69  30  14-11- 5  47:23 +24
 3.A.E. Kastoria                    67  30  15- 7- 8  37:27 +10
 4.A.S. Doxa Dramas                 65  30  13-10- 7  33:27 + 6     (-1 point)
 5.Olympiakos Volos                 64  30  14- 6-10  48:34 +14
 6.A.O. Edessaikos Edessa           64  30   9-16- 5  33:24 + 9
 7.Olympiakos Kozanis               63  30  10-13- 7  38:25 +13
 8.A.O. Kavala                      63  30  12- 9- 9  44:35 + 9
 9.Aspida Xanthis                   61  30  12- 7-11  45:44 + 1
10.Aris Ptolemaidas                 59  30   9-11-10  37:33 + 4
11.Anajennisi Jiannitsa             59  30  11- 7-12  37:38 - 1
12.Nikiforos Florinas               54  30   9- 6-15  26:35 - 9
13.A.O. Kilkisiakos Kilkis          53  30   9- 5-16  31:50 -19
14.Makedonikos Neas Efkarpias Thess 50  30   7- 6-17  34:58 -24
15.M.E.N.T. Toumbas Thessaloniki    49  30   5- 9-16  30:52 -22
16.Anajennisis Karditsas            46  30   4- 8-18  28:65 -37

Relegated from First Division :
Panegialios A.S. Egio
G.A.S. Niki Volos
Promoted to First Division :
Vizas Megaron
A.S. Veria
Promoted to Second Division :
A.E. Mpizani
A.E. Levadiakos Livadia
Rodiakos Rodos
Megas Alexandros Iraklias
Ethnikos Alexandroupolis
Relegated to Regional Levels :
Averof Ioanninon


Authors: Dinant Abbink (abbink@iae.nl) and Alexander Mastrogiannopoulos (hellenic_soccer@freesurf.ch) 
Last updated: 18 May 2005

(C) Copyright Dinant Abbink, Alexander Mastrogiannopoulos and RSSSF 2001/05


  USO DE MEMORIA  
4,265,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.6719
Total Execution Time  0.6751
  CADENA URL  
/football_league_grecia1966
  GET DATOS  
$_GET['/football_league_grecia1966']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0144  SELECT type FROM routes WHERE alias = 'football_league_grecia1966'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'football_league_grecia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1966 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0147  SELECT text_es as historical_text FROM leagues_text WHERE id=2925
0.0146  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 = 31158 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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='1966' WHERE c.parentId=343 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT type,rule FROM rules WHERE categoryId = 343 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:02:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0170  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:02:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:02:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:02:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'football_league_grecia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1966 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 events1966 e WHERE e.league_id IN (31158) 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 (31158) 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 events1966 e WHERE e.league_id IN (31158) 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 (31158) 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 events1966 e WHERE e.league_id IN (31158) 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 (31158) 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 events1966 e WHERE e.league_id IN (31158) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0147  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 (31158) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 31158 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0146  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 = 31158 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 343 GROUP BY l.categoryId
0.0144  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=343 GROUP BY l.year ORDER BY l.year DESC
0.0148  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=31158 AND rel.round=30
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 = 31158 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 = 31158 AND esl.points > 0
0.0151  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` = 31158 ORDER BY creation_date DESC LIMIT 0, 10
0.0152  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` = 31158
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 `calendars1966` 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` = 31158 AND c.`round` = 30 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 `events1966` e INNER JOIN calendars1966 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 30 AND e.real_date IS NOT NULL AND e.league_id = 31158 ORDER BY total DESC LIMIT 40
0.0148  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 `events1966` e INNER JOIN calendars1966 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 = 31158 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 `tables1966` 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 = 31158 AND t.round = 28 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 `tables1966` 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 = 31158 AND t.round = 30 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 = 31158 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=343
0.0147  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 343 AND l.year = 1966 ORDER BY l.group_code ASC
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=343 AND year=1966