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

SERIE C/1 GIRONE A

FINAL TABLE                  Home          Away        Total        Goals    Pts 
                     Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.
1. BOLOGNA           34   14   3   0   10   6   1    24   9   1    58   17    81 
2. PISTOIESE (1)     34   12   5   0    3   9   5    15  14   5    40   24    59 
3. Fiorenzuola (1)   34    9   6   2    7   4   6    16  10   8    44   27    58 
4. Monza (1)         34    9   5   3    6   7   4    15  12   7    48   28    57 
5. Ravenna (1)(2)    34   10   5   2    5   8   4    15  13   6    39   23    57 
6. Spal              34    8   4   5    8   3   6    16   7  11    48   34    55 
7. Prato             34   10   4   3    3   6   8    13  10  11    29   23    49 
8. Spezia            34    8   6   3    4   7   6    12  13   9    38   40    49  
9. Leffe             34    6   8   3    4   6   7    10  14  10    32   34    44 
10. Carrarese        34    8   5   4    2   6   9    10  11  13    40   40    41 
11. Alessandria      34    6   9   2    2   6   9     8  15  11    40   42    39
12. Carpi            34    7   7   3    2   5  10     9  12  13    28   39    39
13. Crevalcore       34    4   8   5    4   6   7     8  14  12    35   43    38
14. Pro Sesto (3)    34    6   4   7    2   8   7     8  12  14    31   43    36
15. Massese (3)      34    3  12   2    3   5   9     6  17  11    25   34    35
16. Modena (3)       34    7   5   5    0   9   8     7  14  13    24   35    35
17. Ospitaletto (3)  34    4   5   8    2   4  11     6   9  19    27   52    27
18. Palazzolo        34    1   5  11    1   1  15     2   6  26    17   66    12

BOLOGNA and PISTOIESE promoted in Serie B. 
Modena, Ospitaletto and Palazzolo relegated in Serie C/2.

(1)Ranked after playoffs  
(2)1 pt deducted     
(3)Ranked after playouts  

Playoffs

Andata (11 giu 1995) 

Ravenna - Pistoiese     0-0
Monza - Fiorenzuola     1-0  71' Guidoni

Ritorno (18 giu 1995)

Pistoiese - Ravenna     1-0  28' Nardi  
Fiorenzuola - Monza     1-0  78' rig. Serioli (Fiorenzuola win for a best ranking in the
                             final table)

Final (Bologna, 25 giu 1995)
Pistoiese - Fiorenzuola 0-0  a.e.t. (4-3 penalty)

Playouts      

Andata (11 giu 1995)

Modena - Massese        0-2  44' rig. Andreini, 80' Carillo
Ospitaletto - Pro Sesto 2-1  42' Romele, 71' Carbone, 88' Sala (PS)

Ritorno (18 giu 1995)
Massese - Modena        2-2  3' Pelliccia (MS), 9' Mobili, 18' Ghirardello (MS), 47' Toni
Pro Sesto - Ospitaletto 1-0  35' Parise    
                     
Top scorers: 22 Clementi (Fiorenzuola); 21 Bizzarri (Spal); 16 Pietranera (Crevalcore).

SERIE C/1 GIRONE B   
FINAL TABLE                  Home          Away        Total        Goals    Pts 
                     Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.   
1. REGGINA           34   12   4   1    8   6   3    20  10   4    42   16    70 
2. AVELLINO (1)(2)   34    9   6   2    7   8   2    16  14   4    55   31    60 
3. Gualdo (1)        34    9   5   3    5   8   4    14  13   7    44   24    55  
4. Trapani (1)       34    9   5   3    4   5   8    13  10  11    39   37    49 
5. Siracusa (1)      34    9   5   3    2   9   6    11  14   9    35   34    47 
6. Nola              34    8   6   3    3   7   7    11  13  10    29   28    46
7. Sora              34    8   5   4    3   8   6    11  13  10    31   31    46
8. Juve Stabia       34    8   7   2    3   6   8    11  13  10    32   35    46
9. Siena             34    6   8   3    3   7   7     9  15  10    35   30    42
10. Lodigiani        34    8   6   3    1   8   8     9  14  11    28   38    41
11. Empoli           34    5   9   3    3   7   7     8  16  10    32   30    40
12. Atletico Catania 34    9   5   3    1   5  11    10  10  14    34   43    40
13. Barletta         34    4   9   4    4   7   6     8  16  10    30   42    40
14. Casarano (3)     34    9   7   1    0   5  12     9  12  13    42   40    39
15. Ischia Is. (3)   34    4   9   4    1  10   6     5  19  10    17   30    34
16. Chieti (3)       34    8   6   3    2   3  12    10   9  15    38   45    39
17. Turris (3)       34    6   5   6    2   4  11     8   9  17    32   50    33
18. Pontedera        34    4   9   4    3   3  11     7  12  15    27   38    33

REGGINA and AVELLINO promoted in Serie B.
Chieti, Turris and Pontedera relegated in Serie C/2.

(1)Ranked after playoffs
(2)2 pts deducted
(3)Ranked after playouts

Playoffs

Andata (11 giu 1995)

Siracusa - Avellino (1) 2-1  23' Scaringella, 35' Logarzo, 55' Fresta (AV)
Trapani - Gualdo        1-0  10' rig. Barraco 
          
Ritorno (18 giu 1995)
Avellino - Siracusa (1) 1-0  30' Fresta
Gualdo - Trapani        1-0  90' Tomassini (Gualdo win for a best ranking in the final
                             table)
(1)played in Reggio Calabria

Final (Pescara, 24 giu 1995)
Avellino - Gualdo       1-1  a.e.t. (5-4 penalty) 33' Tomassini (AV), 48' rig. Esposito

Playouts

Andata (11 giu 1995)
Ischia Is. - Chieti     3-1  18' rig. Di Baia, 68' Gonano, 70' D'Urso, 89' rig. Ortoli (CH)
Turris - Casarano       1-0  25' Ricci     
                     
Ritorno (18 giu 1995)
Chieti - Ischia Is.     1-1  67' Baglieri (CH), 90' Barrucci
Casarano - Turris       4-0  5' rig. Passoni, 15' Francioso, 21' Lanotte, 49' Cucciari

Top scorers: 20 Aglietti (Reggina); 18 Francioso (Casarano); 17 Montella (Empoli).

In the summer of 1995 Modena, Chieti and Turris readmitted instead of Crevalcore, Barletta
and Siracusa not admitted for money problems.   

SERIE C/2 GIRONE A   
FINAL TABLE                  Home          Away        Total        Goals    Pts
                     Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.   
1. BRESCELLO         34   12   4   1    8   6   3    20  10   4    53   21    70
2. SARONNO (1)       34    6   7   4    8   5   4    14  12   8    48   33    54
3. Lumezzane (1)     34    7   8   2    7   7   3    14  15   5    32   23    57
4. Novara (1)        34    7   8   2    6   8   3    13  16   5    38   24    55
5. Pro Vercelli (1)  34    9   4   4    5   7   5    14  11   9    38   35    53
6. Lecco             34    7   7   3    7   1   9    14   8  12    38   30    50
7. Cremapergo        34    8   5   4    4   6   7    12  11  11    31   27    47
8. Legnano           34    6   5   6    4  10   3    10  15   9    35   30    45
9. Solbiatese        34    8   6   3    2   8   7    10  14  10    24   25    44
10. Tempio           34    9   3   5    3   5   9    12   8  14    25   28    44
11. Varese           34    6   7   4    4   7   6    10  14  10    34   40    44
12. Valdagno         34    5  10   2    4   6   7     9  16   9    38   38    43
13. Sassari Torres   34    6   6   5    4   7   6    10  13  11    32   34    43
14. Centese (2)      34    5   8   4    3   7   7     8  15  11    24   32    39
15. Pavia (2)        34    6   8   3    0   6  11     6  14  14    25   34    32
16. Olbia (2)        34    5   5   7    2   7   8     7  12  15    21   36    33
17. Aosta (2)        34    2   8   7    3   5   9     5  13  16    26   50    28
18. Trento           34    5   4   8    0   5  12     5   9  20    23   45    24

BRESCELLO and SARONNO promoted in Serie C/2.
Olbia, Aosta and Trento relegated in Campionato Nazionale Dilettanti

(1)Ranked after playoffs
(2)Ranked after playouts

Playoffs  

Andata (11 giu 1995)
Pro Vercelli - Lumezzane 1-1  71' D'Onofrio (LU), 77' rig. Provenzano
Saronno - Novara         0-0 

Ritorno (18 giu 1995)
Lumezzane - Pro Vercelli 0-0
Novara - Saronno         1-1  30' Mondoni (SA), 45' Ferretti

Final (Palazzolo Sull'Oglio, 25 giu 1995)
Saronno - Lumezzane      3-2  11' Salvi (LU), 12' e 14' Inverardi aut., 38' Zanin (LU), 54'
                              rig. Marzio

Playout
                     
Andata (11 giu 1995)
Aosta - Centese          1-1  11' Danelutti (AO), 77' rig. Baiesi
Pavia - Olbia            2-0  16' e 64' Folli 

Ritorno (18 giu 1995)
Centese - Aosta          2-1  40' Novelli, 82' Righi, 86' Lenta (AO)
Olbia - Pavia            1-1  45' Sanna (OL), 57' Campistri

Top scorers: 17 Cortesi (Lecco); 16 Provenzano (Pro Vercelli); 13 Pompini (Brescello), Coti
             (Cremapergo).

SERIE C/2 GIRONE B   
FINAL TABLE                  Home          Away        Total        Goals    Pts
                     Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.   
1. MONTEVARCHI       34   12   4   1    5   8   4    17  12   5    55   31    63
2. CASTEL DI S. (1)  34    9   7   1    6   4   7    15  11   8    32   23    56
3. Fano (1)          34    9   7   1    3   9   5    12  16   6    32   27    52
4. Sandonà (1)       34   13   2   2    4   9   4    17  11   6    55   28    62
5. Livorno (1)       34    8   6   3    6   5   6    14  11   9    47   30    53
6. Rimini            34    6   9   2    5   7   5    11  16   7    31   31    49
7. Teramo            34    7   8   2    3  10   4    10  18   6    31   24    48
8. Giulianova        34   10   5   2    2   7   8    12  12  10    34   33    48
9. Vis Pesaro        34    8   6   3    1  10   6     9  16   9    29   29    43
10. Forlì            34    8   4   5    3   5   9    11   9  14    35   32    42
11. Fermana          34    9   7   1    1   5  11    10  12  12    35   44    42
12. Baracca Lugo     34    7   5   5    4   3  10    11   8  15    32   39    41
13. Cittadella       34    8   6   3    1   7   9     9  13  12    29   38    40
14. Cecina (2)       34    7   6   4    1   6  10     8  12  14    36   45    36
15. Mobilieri P. (2) 34    7   8   2    0   4  13     7  12  15    24   49    33
16. Giorgione (2)    34    6   8   3    3   4  10     9  12  13    33   38    39
17. Maceratese (2)   34    4   9   4    3   3  11     7  12  15    29   36    33
18. Poggibonsi       34    4   5   8    1   6  10     5  11  18    18   40    26

MONTEVARCHI and CASTEL DI SANGRO promoted in Serie B.
Giorgione, Maceratese and Poggibonsi relegated in Campionato Nazionale Dilettanti.

(1)Ranked after playoffs
(2)Ranked after playouts

Playoffs

Andata (11 giu 1995)
Fano - Sandonà          2-1  32' Caverzan (SD), 45' Sgherri, 58' Marri
Livorno - Castel di S.  4-2  4' Cordone, 10' Schwoch, 24' De Carolis (CS), 48' Calandra I,
                             49' Schwoch, 85' Mitri (CS)

Ritorno (18 giu 1995)
Sandonà - Fano          0-0
Castel di S. - Livorno  2-0  29' Cei, 69' Carnevale 
                              
Final (Ascoli Piceno, 25 giu 1995)
Castel di Sangro - Fano 3-3  a.e.t. (4-2 penalty) 22' Scarponi (FA), 25' De Carolis, 29'
                             Carnevale, 38' Martino, 41' e 50' Sgherri (FA)

Playouts

Andata (11 giu 1995)
Mobilieri P.- Giorgione 1-1  11' Carboni (GI), 77' Magliano
Maceratese - Cecina     1-0  2' Carillo

Ritorno (18 giu 1995)
Giorgione - Mobilieri P.0-1  70' Tolomei
Cecina - Maceratese     1-0  81' aut. Barcella (Cecina won for best ranking in the final
                             table)

Top scorers: 23 Meacci (Sandonà); 19 Schwoch (Livorno); 16 Bivi (Giorgione), Arcadio
             (Montevarchi).

SERIE C/2 GIRONE C
FINAL TABLE                  Home          Away        Total        Goals    Pts
                     Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.
1. NOCERINA          34   13   1   3    7   8   2    20   9   5    45   17    69
2. SAVOIA (1)        34    8   8   1    6   8   3    14  16   4    38   25    58
3. Matera (1)        34   13   4   0    4   7   6    17  11   6    46   25    62
4. Benevento (1)     34   12   4   1    3   9   5    15  13   6    39   24    58
5. Albanova (1)      34   12   5   0    3   6   8    15  11   8    32   20    56
6. Avezzano          34   10   4   3    4   9   4    14  13   7    41   33    55
7. Vastese           34    8   8   1    4   6   7    12  14   8    27   23    50
8. Battipagliese     34    7   6   4    4   8   5    11  14   9    19   17    47
9. Trani             34    8   5   4    3   5   9    11  10  13    27   26    43
10. Frosinone        34    8   7   2    1   8   8     9  15  10    30   28    42
11. Catanzaro        34    7   9   1    2   6   9     9  15  10    32   33    42
12. Castrovillari    34    8   6   3    2   6   9    10  12  12    29   30    42
13. Fasano           34    7   6   4    4   2  11    11   8  15    36   35    41
14. Astrea (2)       34    6   6   5    2   7   8     8  13  13    29   33    37
15. Bisceglie (2)    34    1  14   2    2   7   8     3  21  10    26   39    30
16. Formia (2)       34    6   4   7    1   4  12     7   8  19    22   44    29
17. Molfetta (2)     34    2  11   4    2   1  14     4  12  18    17   47    24  
18. Sangiuseppese    34    3   4  10    1   5  11     4   9  21    16   52    21

NOCERINA and SAVOIA promoted in Serie B.
Formia, Molfetta and Sangiuseppese relegated in Campionato Nazionale Dilettanti.

(1)Ranked after playoffs
(2)Ranked after playouts

Playoffs
                             
Andata (11 giu 1995)
Albanova - Matera       0-0
Savoia - Benevento      2-0  19' rig. Amura, 24' Tarantino

Ritorno (18 giu 1995)         
Matera - Albanova       1-0  53' Tatti
Benevento - Savoia      3-3  4' D'Ottavio (BN), 11' Donnarumma, 36' Orsini (BN), 65' 
                             Lunerti, 79' Ferrigno (BN), 81' Tarantino 

Final (Foggia, 25 giu 1995)
Savoia - Matera         2-1  2' Lunerti, 33' Bitetto (MT), 66' Donnarumma

Playouts

Andata (11 giu 1995)
Molfetta - Astrea       0-0
Formia - Bisceglie      0-1  64' Caggianelli

Ritorno (18 giu 1995)
Astrea - Molfetta       4-1  2' Ferretti, 14' Pugliese, 40' Paris, 47' rig. Tuttisanti
                             (MO), 55' Castagnari
Bisceglie - Formia      1-1  15' Carli (FO), 25' Di Meo

Top scorers: 16 D'Ottavio (Benevento); 15 Cancellato (Nocerina); 14 Di Nicola (Avezzano),
             Damato (Trani). 
                     
In the summer of 1995 Olbia and Giorgione readmitted instead of Vastese and Grosseto (new
promoted from CND) not admitted for money problems. To complete Serie C/2 1995/96 admitted
also Imola, Triestina and Ternana. 

Promoted from Campionato Nazionale Dilettanti: Grosseto, Gallaratese, Alzano Virescit,
Treviso, Viterbese, Tolentino, Marsala, Taranto, Catania and after also Imola, Triestina
and Ternana.         
Campione Nazionale Dilettanti 1994/95 (Italian Amateur Champion 1994/95): Taranto.


Author: Maurizio Mariani (maurizio.mariani@npo.it)
Last updated: 31 Oct 2000

(C) Copyright Maurizio Mariani and RSSSF 1999/2000


  USO DE MEMORIA  
4,328,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0929
Total Execution Time  0.0949
  CADENA URL  
/serie_c11995
  GET DATOS  
$_GET['/serie_c11995']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'serie_c11995'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_c1' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1995 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=2654
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 = 30909 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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='1995' WHERE c.parentId=90 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:57:09' 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-27 22:57:09' 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-04-27 22:57:09' 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-27 22:57:09' 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 = 'serie_c1' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1995 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 events1995 e WHERE e.league_id IN (30909) 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 (30909) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (30909) 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 (30909) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (30909) 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 (30909) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (30909) 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 (30909) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 30909 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0017  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 = 30909 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0024  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=30909 AND rel.round=34
0.0020  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 = 30909 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 = 30909 AND esl.points > 0
0.0020  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` = 30909 ORDER BY creation_date DESC LIMIT 0, 10
0.0026  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` = 30909
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 `calendars1995` 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` = 30909 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events1995` e INNER JOIN calendars1995 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 30909 ORDER BY total DESC LIMIT 40
0.0024  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 `events1995` e INNER JOIN calendars1995 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 = 30909 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0025  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 `tables1995` 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 = 30909 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1995` 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 = 30909 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 30909 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0025  SELECT data1, data2 FROM services_tags WHERE categoryId=90
0.0025  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 90 AND l.year = 1995 ORDER BY l.group_code ASC
0.0025  SELECT group_code, extraName from `leagues` WHERE categoryId=90 AND year=1995