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

Group 1
                     Agr Thy Pan Tri Ave Pre Spa Dia Rod  Dor Dox Ast AtA Fos Ili
Panetolikos Agriniu  XXX 1:1 0:2 5:0 3:1 4:2 4:0 3:0 1:1  3:2 2:1 0:0 2:1 2:0 1:0
Thyella Patras       3:0 XXX 0:1 4:1 2:0 4:0 4:0 0:0 2:0  3:2 2:2 7:2 1:1 6:1 0:0
Panachaiki Patras    3:1 1:1 XXX 3:0 1:0 3:1 5:0 1:0 6:2  3:2 0:1 3:2 2:1 0:1 2:0
Panarkadikos Tripoli 0:2 2:2 0:2 XXX 0:1 2:4 1:1 1:6 0:3  1:3 0:1 1:3 0:1 1:6 1:3
Averof Ioannina      2:0 3:2 2:1 6:0 XXX 1:0 6:2 0:0 2:1  2:0 1:1 2:0 1:0 1:0 3:1
PAS Preveza          0:2 2:3 0:0 4:0 1:2 XXX 1:1 1:2 1:0  1:2 3:3 0:2 1:5 1:1 0:2
A.O.Spartis          1:1 0:2 2:6 2:2 1:1 1:2 XXX 1:1 0:2  1:1 1:2 0:0 3:2 1:4 1:1
Diagoras Rodos       3:2 2:1 2:0 6:2 5:1 5:1 1:0 XXX 0:1  2:1 2:2 3:1 2:0 0:0 1:1
Rodiakos Rodos       2:0 3:1 2:1 5:2 1:1 2:2 1:1 2:1 XXX  2:1 3:1 1:0 2:1 3:2 1:1
Dorieas              0:5 0:2 0:1 0:0 2:2 2:2 3:2 1:3 2:0  XXX 4:2 2:4 0:2 2:1 4:2
Doxa Virona Ath      1:0 1:1 0:1 2:1 1:1 2:0 2:0 2:2 1:1  4:0 XXX 2:1 2:3 1:2 2:1
Asteras Athens       1:2 2:4 0:4 4:0 2:1 4:2 2:0 1:2 3:2  2:1 1:0 XXX 0:1 1:4 0:1
Atromitos Athens     2:0 2:1 0:2 6:0 4:1 0:0 2:0 2:0 8:0 11:3 3:0 0:1 XXX 0:2 1:0
Fostiras Athens      0:1 3:1 1:2 6:0 2:0 3:0 4:1 0:2 3:2  3:1 2:1 3:0 1:1 XXX 2:0
Ilisiakos Athens     1:0 1:0 1:1 2:0 1:0 2:0 2:0 2:1 1:1  1:1 0:1 2:1 1:1 1:1 XXX

TABLE:
 1. Panachaiki G.E. Patras     71  28  20- 3- 5  57:22 +35 ~~
-------------------------------------------------------------
 2. G.S. Diagoras Rodos        65  28  20- 3- 5  55:30 +25     (-6 points)
 3. A.P.O. Fostiras Tavros     64  28  15- 7- 6  58:32 +26     (-1 point)
 4. Atromitos Peristeri        62  28  15- 4- 9  61:28 +33
 5. A.O. Thyella Patras        62  28  13- 8- 7  60:34 +26     (-2 points)
 6. Panetolikos Agrinio        62  28  15- 4- 9  47:30 +17
 7. P.A.S. Averof Jiannina     62  28  14- 6- 8  44:34 +10
 8. A.S. Rodiakos Rodos        60  28  14- 6- 8  45:45 =       (-2 points)
 9. Ilisiakos Athinas          59  28  14- 8- 8  31:26 + 5     (-7 points)
10. Doxa Vironas               59  28  12- 7- 9  41:37 + 4
11. Asteras Athinas            51  28  11- 2-17  40:50 -10     (-3 points)
12. Dorieas Dorikou            46  28   7- 5-16  41:67 -26     (-1 point)
13. P.A.S. Preveza             41  28   5- 7-16  32:60 -28     (-2 points)
14. A.O. Sparti                37  28   1-10-17  23:65 -42     (-3 points)
15. Panarkadikos Tripolis      32  28   0- 4-24  18:93 -75

Group 2
                   AEN Pro Ele ArP Eas AtP Arg Viz Kor OlL OFI Ats Naf  Iro AEM Chi Cha
A.E.Nikeas Pireas  XXX 0:0 4:1 2:1 1:0 1:1 1:2 0:0 2:2 5:0 2:3 6:2 1:1  1:0 2:1 3:1 3:0
Proodeftiki Nikeas 1:0 XXX 1:0 5:1 5:0 3:0 2:2 0:0 2:1 7:0 4:2 4:0 6:1  3:0 3:1 7:1 4:0
Panelefsiniakos    2:0 2:2 XXX 1:2 1:0 0:1 1:2 2:2 3:0 6:0 2:0 8:3 2:2  4:0 4:2 2:0 6:0
Aris Pireas        0:1 0:1 1:1 XXX 2:1 0:1 0:2 1:0 1:1 1:0 1:0 3:0 0:0  1:0 3:0 6:1 6:1
Eantas Salaminas   0:0 0:1 2:3 0:0 XXX 1:0 1:1 0:2 1:0 1:0 1:1 4:0 2:2  1:2 0:0 6:0 4:1
Atromitos Pirea    2:0 1:1 2:4 0:1 0:0 XXX 2:0 0:1 0:1 2:1 2:1 4:0 2:2  5:1 2:0 4:1 5:2
Argonaftis Pirea   0:0 0:3 2:0 0:1 0:1 2:1 XXX 1:2 1:0 7:0 3:0 8:0 2:2 12:0 3:2 3:0 6:0
Vizas Megara       0:0 0:0 1:1 2:1 2:1 3:1 3:2 XXX 1:0 6:1 2:1 4:1 2:0  2:0 3:0 8:0 2:0
Pagorinthiakos     0:0 1:1 4:0 1:0 1:0 3:1 0:0 1:0 XXX 5:0 0:1 6:2 0:0  0:0 2:0 5:0 2:0
Olympiakos Lutraki 1:0 0:2 1:1 0:2 1:1 1:1 1:2 4:1 0:1 XXX 1:0 5:2 1:2  0:1 2:2 2:0 2:0
O.F.I. Kritis      3:0 1:1 1:1 1:0 2:1 2:2 5:0 2:1 2:1 2:1 XXX 7:2 4:0  3:0 5:1 7:0 2:0
Atsalenios Kritis  1:6 2:6 0:2 0:2 1:0 1:3 0:2 0:2 2:3 3:0 0:2 XXX 0:2  1:1 0:2 1:2 0:1
Pannafpliakos      3:0 0:1 0:0 3:2 1:0 0:2 3:0 4:1 3:0 3:0 4:0 4:1 XXX  3:0 2:0 2:2 3:0
Irodotos Kritis    2:1 3:1 0:2 0:0 0:1 2:2 2:1 0:0 0:0 3:0 0:0 5:0 3:1  XXX 2:1 6:1 1:2
A.E.Mitilinis      0:2 0:1 0:2 0:0 1:1 1:0 2:1 2:2 2:0 2:0 0:0 4:0 2:1  2:0 XXX 3:3 2:0
Panchiakos Chios   1:1 1:4 0:0 1:4 0:3 1:3 1:1 2:4 0:1 1:0 1:2 2:1 3:2  0:1 1:0 XXX 4:1
Panchaniakos Kriti 0:0 0:0 5:2 0:0 1:1 1:1 1:1 3:3 2:1 0:1 1:1 5:2 2:0  2:2 2:1 3:2 XXX

TABLE :
 1. Proodeftki Pireas          85  32  22- 9- 1  82: 20 +62 ++
--------------------------------------------------------------
 2. A.O. Vizas Megara          77  32  18- 9- 5  62: 31 +31
 3. O.F.I. Iraklion            73  32  17- 7- 8  63: 35 +28
 4. Panelefsiniakos Elefsinas  71  32  15- 9- 8  66: 40 +26
 5. Argonaftis Pireas          69  32  15- 7-10  69: 37 +32
 6. Aris Nikeas Pireas         69  32  15- 7-10  43: 26 +17
 7. Pannafpliakos Nafplio      69  32  14- 9- 9  56: 41 +15
 8. Pagorinthiakos Korinthos   68  32  14- 8-10  43: 27 +16
 9. Atromitos Pireas           68  32  14- 8-10  53: 38 +15
10. A.E. Nikeas                67  32  12-11- 9  45: 31 +14
11. Irodotos Alikarnasos Kriti 62  32  11- 8-13  37: 53 -16
12. Eantas Salaminas           60  32   9-10-13  35: 32 + 2
13. Panchaniakos Chania Kriti  58  32   9- 9-14  38: 68 -30   (-1 point)
14. A.E. Mitilinis Lesvos      57  32   9- 7-16  36: 49 -13   (-3 points)
15. Pachiakos Chios            49  32   6- 5-21  33: 96 -63
16. Olympiakos Loutraki        46  32   6- 4-22  24: 74 -50   (-6 points)
17. P.O. Atsalenios Kritis     33  32   2- 1-29  28:115 -77   (-4 points)

Group 3
                            AnT ArK ArP Ver Ede DiT IrV IrL KaT Lam Lar Lev Nao OlV OlK Tri
 1. Anapalsi Tirnavos       XXX 2:1 0:2 0:3 0:0 2:1 2:0 0:0 0:1 1:1 0:1 5:0 0:0 1:2 2:0 1:3
 2. Aris Kastoria           1:1 XXX 2:2 3:1 4:0 2:0 5:0 1:1 5:0 4:3 0:0 4:2 1:0 0:2 1:0 1:2
 3. Aris Ptolemaidas        1:1 0:0 XXX 2:2 1:1 3:1 3:1 0:0 5:0 1:1 2:0 3:0 0:2 1:0 3:0 3:0
 4. A.S. Veria              1:0 2:2 1:2 XXX 1:1 2:0 7:1 0:1 2:2 1:1 4:0 1:1 1:0 1:3 0:0 0:0
 5. A.O. Edessaikos Edessa  4:0 1:0 3:1 0:0 XXX 1:0 3:0 2:0 3:0 4:0 2:0 3:2 0:1 2:1 5:2 0:0
 6. Dimitra Trikala         0:2 0:1 0:2 1:2 0:0 XXX 1:0 0:2 0:1 0:2 1:1 0:3 2:0 0:0 4:2 0:4
 7. Iraklis Volos           1:1 1:0 2:2 1:2 0:1 1:0 XXX 0:0 0:3 0:3 1:0 0:1 2:0 1:4 1:1 0:0
 8. Iraklis Larisas         2:0 2:5 0:0 1:1 3:1 2:1 4:1 XXX 2:0 2:0 1:0 0:0 2:1 4:5 2:0 0:0
 9. Kadmos Thiva            1:0 1:1 1:0 1:0 1:0 1:1 2:0 2:1 XXX 2:0 3:2 1:4 3:1 2:0 1:3 1:1
10. A.E. Lamiakos           4:0 1:3 3:0 1:0 2:2 0:0 2:0 2:0 2:1 XXX 0:1 2:0 3:1 1:3 1:0 0:0
11. A.O. Larisaikos         0:1 1:2 0:1 4:2 0:0 3:1 1:0 0:0 3:1 2:0 XXX 3:2 2:1 0:0 1:0 1:5
12. A.E. Levadiakos Livadia 1:0 1:1 0:0 1:1 0:0 1:0 2:1 3:1 1:0 2:2 4:1 XXX 1:1 2:1 2:1 3:1
13. A.S. Naoussa            4:1 3:0 1:0 0:1 2:4 5:0 5:2 2:0 2:1 3:1 2:1 3:1 XXX 1:0 0:0 1:1
14. Olympiakos Volos        1:0 4:3 4:0 2:2 1:1 3:0 1:0 3:1 1:0 2:0 1:0 2:1 2:0 XXX 2:0 2:0
15. Olympiakos Kozani       1:0 3:0 3:0 2:1 0:1 3:1 5:0 1:0 2:0 0:0 1:2 2:0 1:0 1:0 XXX 0:0
16. A.O. Trikala            2:0 2:1 1:0 2:0 0:0 6:1 4:0 2:0 4:0 3:1 1:0 1:0 2:1 0:1 1:0 XXX

TABLE :
 1. A.O. Trikala               73  30  17- 9- 4  48:18 +30 ++
-------------------------------------------------------------
 2. Olympiakos Volos           73  30  20- 4- 6  53:25 +28    (-1 point)
 3. A.O. Edessaikos Edessa     71  30  15-11- 4  45:22 +23
 4. A.S. Aris Ptolemaidas      64  30  12-10- 8  40:30 +10
 5. A.O. Aris Kastorias        63  30  13- 8- 9  54:38 +16    (-1 point)
 6. Iraklis Larisas            61  30  11- 9-10  34:33 + 1
 7. A.E. Levadiakos Livadias   61  30  12- 8-10  41:41 =      (-3 points)
 8. G.S. Kadmos Thiva          61  30  14- 3-13  33:45 -12
 9. G.A.S. Veria               60  30   9-12- 9  42:35 + 7
10. A.S. Lamiakos Lamias       60  30  11- 8-11  39:38 + 1
11. F.A.S. Naoussa             59  30  13- 4-13  43:35 + 8    (-1 point)
12. Olympiakos Kozani          58  30  12- 5-13  34:31 + 3    (-1 point)
13. A.S. Larisaikos Larisa     57  30  11- 5-14  30:39 - 9
14. Anaplasi Tirnavos          51  30   7- 7-16  23:39 -16
15. Iraklis Bolos              43  30   4- 5-21  17:65 -48
16. Dimitra Trikala            39  30   3- 4-23  15:67 -52    (-5 points)

Group 4
                               IrK FiK ElD ArD ApS IrS OrX OrK DoN MNE MeA MEN AcT The
 1. Iraklis Kavalas            XXX 1:1 2:1 3:0 5:1 0:1 2:1 2:0 1:2 1:1 5:0 4:0 5:1 0:1
 2. Filippi Kavalas            2:0 XXX 2:1 1:0 1:0 0:0 3:0 8:1 3:0 2:0 8:3 2:1 2:1 1:2
 3. Elpida Dramas              1:0 0:1 XXX 1:1 1:0 0:1 3:1 5:1 3:0 1:1 5:1 1:3 4:2 4:2
 4. Aris Dramas                1:0 1:2 1:0 XXX 0:1 1:1 0:0 2:1 3:1 1:2 1:1 0:0 0:2 0:1
 5. Apollonas Serres           1:0 0:0 2:2 3:1 XXX 0:2 3:0 1:0 3:1 2:1 0:2 2:2 5:2 1:0
 6. Iraklis Serres             1:0 2:1 2:0 4:1 1:1 XXX 4:0 4:1 2:1 1:1 1:0 1:0 2:1 0:0
 7. Orfeas Xanthi              0:2 0:1 0:1 0:1 0:0 1:2 XXX 1:1 4:2 1:0 2:2 0:0 0:2 2:3
 8. Orfeas Komotini            3:2 1:1 1:1 2:1 3:1 0:1 2:0 XXX 1:0 2:2 4:3 3:6 0:0 0:2
 9. Doxa Neapolis Thessaloniki 0:1 1:1 1:1 1:3 0:2 0:2 2:1 2:2 XXX 1:1 2:2 4:3 3:1 0:0
10. Makedonikos Nea Efkarpia   1:1 0:1 2:0 7:1 2:3 2:1 3:0 4:0 1:0 XXX 3:1 2:1 2:2 0:0
11. Megas Alexandros Irak.     1:1 0:0 1:0 1:1 1:0 1:2 2:1 2:0 1:0 4:1 XXX 2:2 1:0 4:0
12. M.E.N.T. Thessaloniki      1:1 1:1 5:3 2:2 2:3 1:1 3:0 3:2 2:1 1:1 6:1 XXX 2:0 6:1
13. Achilleas Triadrias Thess  3:0 2:3 1:1 2:1 3:1 2:1 0:1 0:0 0:0 0:3 1:4 1:3 XXX 1:2
14. Thermaikos Thermis Thess.  1:1 0:0 1:0 2:0 3:1 4:1 3:1 3:1 3:0 3:2 3:3 2:0 5:0 XXX

TABLE :
 1.Filippi Kavalas                  66  26  16- 8- 2  48:18 +30 ~~
------------------------------------------------------------------
 2.Iraklis Serres                   66  26  17- 6- 3  41:19 +30
 3.Thermaikos Thermis Thessaloniki  64  26  16- 6- 4  47:27 +20
 4.Makedonikos Neas Efkarpias Thess 55  26  10- 9- 7  45:31 +14
 5.M.E.N.T. Toumbas Thessaloniki    55  26  10- 9- 7  56:41 +15
 6.Apollonas Serres                 55  26  12- 5- 9  37:35 + 2
 7.Megas Alexandros Iraklias Thessa 54  26  10- 8- 8  42:49 - 7
 8.Iraklis Kavalas                  52  26  10- 6-10  40:26 +14
 9.Elpida Dramas                    50  26   9- 6-11  40:35 + 5
10.Aris Dramas                      46  26   6- 8-12  25:41 -16
11.Orfeas Komotini                  45  26   6- 7-13  32:57 -25
12.Achilleas Trkandrias Thessalon.  42  26   5- 6-15  30:52 -22
13.Doxa Neapolis Thessalonikis      41  26   4- 7-15  25:47 -22
14.Orfeas Xanthi                    37  26   3- 5-16  17:47 -30

Promoted to First Division :
Proodeftiki Pireas
A.O. Trikala
Relegated to Second Division :
Olympiakos Chalkidas
Aigaleo A.O. Athina
Promoted to Second Division :
P.A.O. Kalogrezas Athina    A.O. Korinthos            Panserraikos              Anajennisis Jiannitson
Anajennisis Artas           Ergotelis Iraklio Kriti   Finikas Polichnis Thess.  A.E. Larisas
Samfrapoli                  Aiolikos Mitilini Lesvos  Aspida Xanthi             Anajennisis Karditsas
Patraikos A.O. Patra (Old)  Rethymniakos A.E. Kriti   A.O. Kilkisiakos          Evripos Chalkidas
A.E. Kalamatas              Aris Chios                Atromitos Serres          Nikiforos Florinas
Fivos Kremastis Rodos       Talos Chania Kriti        A.E.K. Kavala             Apollonas Larisas
Omilos Tripolis             A.O. Doxa Pireas          Elpida Nigrita
                            Chalkidona Pireas         P.O. Xilokrinis
Relegated to Regional Divisions :
Ilisiakos Athinas         Irodotos Alikarnasos Kritis  Olympiakos Kozanis   Orfeas Komotinis
A.S. Doxa Vironas Athina  Aiantas Salamainas           Larisaikos A.O.      Achilleas Triandrias Thessaloniki
Asteras Athinas           Panchaniakos Chania          Anaplasis Tyrnavos   Doxa Neapoli Thessaloniki
Dorieas Dorikou           A.E. Mitilinis Lesvos        Iraklis Volos        Orfeas Xanthis
P.A.S. Preveza            Panchiakos Chios             Dimitra Trikala
A.O. Sparti               Olympiakos Loutraki
Panarkadikos Tripolis     P.O. Atsalenios Iraklion

NAME CHANGES & Mergers :
Iraklis Larisas & Larisaikos = A.E. Larisas
Apollonas Serres & Iraklis Serres = Panserraikos A.O.


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,276,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0985
Total Execution Time  0.1003
  CADENA URL  
/football_league_grecia1964
  GET DATOS  
$_GET['/football_league_grecia1964']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT type FROM routes WHERE alias = 'football_league_grecia1964'
0.0040  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 = 1964 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=2927
0.0018  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 = 31160 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='1964' WHERE c.parentId=343 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 343 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-04-28 05:09:31' 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=2 AND last_update > '2024-04-28 05:09:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 05:09:31' 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=3 AND last_update > '2024-04-28 05:09:31' 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 = 'football_league_grecia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1964 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 events1964 e WHERE e.league_id IN (31160) 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 (31160) 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 events1964 e WHERE e.league_id IN (31160) 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 (31160) 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 events1964 e WHERE e.league_id IN (31160) 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 (31160) 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 events1964 e WHERE e.league_id IN (31160) AND (e.action IN (22) ) 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 (31160) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  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 = 31160 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 31160 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=31160 AND rel.round=32
0.0019  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 = 31160 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 31160 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-03-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 31160 ORDER BY creation_date DESC LIMIT 0, 10
0.0028  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 31160
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 `calendars1964` 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` = 31160 AND c.`round` = 32 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events1964` e INNER JOIN calendars1964 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 = 32 AND e.real_date IS NOT NULL AND e.league_id = 31160 ORDER BY total DESC LIMIT 40
0.0020  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 `events1964` e INNER JOIN calendars1964 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 = 31160 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0021  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 `tables1964` 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 = 31160 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1964` 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 = 31160 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 31160 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=343
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 343 AND l.year = 1964 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=343 AND year=1964