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. CESENA            34   12   5   0    6   8   3    18  13   3    49   22    67
2. CREMONESE (1)     34    9   6   2    7   5   5    16  11   7    41   31    59
3. Livorno (1)(2)    34   12   2   3    7   3   7    19   5  10    48   34    58
4. Alzano Virescit(1)34   10   6   1    5   7   5    15  13   6    45   29    58
5. Lumezzane (1)     34   12   4   1    3   6   8    15  10   9    43   31    55
6. Modena            34    8   5   4    6   2   9    14   7  13    40   37    49
7. Lecco             34    6   6   5    4   7   6    10  13  11    31   35    43
8. Siena             34    7   7   3    2   7   8     9  14  11    34   41    41
9. Brescello         34    7   5   5    2   7   8     9  12  13    42   43    39
10. Como             34    6   7   4    3   5   9     9  12  13    30   38    39
11. Carpi            34    6   8   3    3   4  10     9  12  13    29   43    39
12. Saronno          34    4   9   4    2  11   4     6  20   8    29   28    38
13. Montevarchi      34    7   6   4    1   8   8     8  14  12    29   34    38
14. Pistoiese (3)    34    5   7   5    3   6   8     8  13  13    21   27    37
15. Carrarese (3)    34    5   6   6    3   6   8     8  12  14    27   39    36
16. Prato (3)        34    4  10   3    4   2  11     8  12  14    24   38    36
17. Alessandria (3)  34    6   8   3    0  10   7     6  18  10    29   35    36
18. Fiorenzuola      34    4   5   8    3   8   6     7  13  14    29   35    34

CESENA and CREMONESE Promoted in Serie B.
Prato, Alessandria and Fiorenzuola relegated in Serie C/2.

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

Playoffs

Andata (31/5/1998)

Lumezzane - Cremonese   1-2  42' Guarneri, 51 ' Botti (LU), 88' Manfredi
Alzano Vir. - Livorno   0-0

Ritorno (7/6/1998)

Cremonese - Lumezzane   0-1  58' Taldo
Livorno - Alzano Vir.   3-2  30' Nardini, 35' aut. Geraldi (AL), 50' aut. De Vincenzo (AL),
                             63' Geraldi, 88' rig. Vincioni

Final (Perugia, 14/6/1998)
Cremonese - Livorno     1-0  a.e.t. 117' Guarneri

Playouts

Andata (31/5/1998)

Carrarese - Prato       2-0  42' rig. Menchetti, 56' Polidori
Alessandria - Pistoiese 1-1  65' Vivani (AL), 90' rig. Mazzucato

Ritorno (7/6/1998)

Prato - Carrarese       0-1  45' Ratti
Pistoiese - Alessandria 2-1  25' aut. Giannoni, 34' Gasparini (AL), 59' Mazzucato

Top scorers: 22 Ferrari (Alzano Virescit); 18 Agostini (Cesena); 17 Mirabelli (Cremonese).

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. COSENZA           34   11   6   0    8   5   4    19  11   4    45   21    68
2. TERNANA (1)       34   11   6   0    5  11   1    16  17   1    38   15    65
3. Nocerina (1)      34    7   8   2    5   7   5    12  15   7    33   26    51
4. Gualdo (1)        34    9   4   4    6   5   6    15   9  10    29   24    54
5. Atl. Catania (1)  34    9   4   4    3   8   6    12  12  10    31   25    48
6. Juve Stabia       34    6  10   1    3  10   4     9  20   5    28   24    47
7. Avellino          34   10   4   3    2   6   9    12  10  12    36   37    46
8. Acireale          34    8   4   5    2  11   4    10  15   9    21   18    45
9. Savoia            34    4   9   4    6   5   6    10  14  10    27   27    44
10. Ascoli           34    5   9   3    3   8   6     8  17   9    32   28    41
11. Giulianova       34   10   4   3    1   4  12    11   8  15    40   38    41
12. Ischia Isolav.   34    5   9   3    4   5   8     9  14  11    27   32    41
13. Fermana          34   10   2   5    1   6  10    11   8  15    35   47    41
14. Lodigiani (2)    34    5   6   6    3   6   8     8  12  14    25   35    36
15. Battipagliese (2)34    3  10   4    2   8   7     5  18  11    25   37    33
16. Palermo (2)      34    7   8   2    1   5  11     8  13  13    32   37    37
17. Turris (2)       34    7   8   2    0   4  13     7  12  15    22   32    33
18. Casarano         34    7   6   4    0   3  14     7   9  18    27   50    30

COSENZA and TERNANA promoted in Serie B.
Palermo, Turris and Casarano relegated in Serie C/2.

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

Playoffs

Andata (31/5/1998)

Atl. Catania - Ternana  0-0
Nocerina - Gualdo       2-0  37' e 56' Arco

Ritorno (7/6/1998)

Ternana - Atl. Catania  1-0  56' Borgobello
Gualdo - Nocerina       3-2  14' Torino, 49' De Palma (NO), 82' e 91' Di Venanzio, 93' Di
                             Rocco (NO)

Final (Ancona, 14/6/1998)
Ternana - Nocerina      1-0  a.e.t. 103' Arcadio

Playouts

Andata (31/5/1998)

Battipagliese - Palermo 1-0  61' Loria
Turris - Lodigiani      1-2  14' Nordi (TU), 21' La Scala, 70' Testa

Ritorno (7/6/1998)

Palermo - Battipagliese 0-0
Lodigiani - Turris      1-0  93' Sorrentino R.

Top scorers: 19 Margiotta (Cosenza); 14 Belmonte (Nocerina); 13 Artico (Giulianova).

In the summer of 1998 Palermo readmitted instead of Ischia Isolaverde 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. VARESE            34   10   6   1    6   9   2    16  15   3    39   20    63
2. CITTADELLA (1)    34   11   2   4    6   7   4    17   9   8    52   29    60
3. Triestina (1)     34    9   7   1    4   9   4    13  16   5    41   27    55
4. Pro Patria Gal.(1)34   10   4   3    6   7   4    16  11   7    33   21    59
5. Albinese (1)      34    9   5   3    4   9   4    13  14   7    34   25    53
6. Voghera           34    5  10   2    7   6   4    12  16   6    43   33    52
7. Biellese          34    9   5   3    4   6   7    13  11  10    30   31    50
8. Mantova           34    7   5   5    5   6   6    12  11  11    35   32    47
9. Mestre            34    6   7   4    4   5   8    10  12  12    30   38    42
10. Sandonà          34    5  11   1    4   3  10     9  14  11    29   34    41
11. Pro Sesto        34    3  12   2    4   7   6     7  19   8    34   36    40
12. Novara           34    5   5   7    4   8   5     9  13  12    29   34    40
13. Pro Vercelli     34    8   7   2    1   5  11     9  12  13    33   36    39
14. Giorgione (2)    34    4   8   5    3   9   5     7  17  10    30   32    38
15. Leffe (2)        34    4   6   7    2   8   7     6  14  14    24   35    32
16. Cremapergo (2)   34    4   8   5    2   5  10     6  13  15    21   34    31
17. Solbiatese (2)   34    2   8   7    3   4  10     5  12  17    20   40    27
18. Ospitaletto      34    4   6   7    0   9   8     4  15  15    25   45    27

VARESE and CITTADELLA promoted in Serie C/1.
Cremapergo, Solbiatese and Ospitaletto relegated in Campionato Nazionale Dilettanti.

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

Playoffs

Andata (31/5/1998)

Triestina - Pro Patria  2-0  29' rig. Zampagna, 90' Canella
Albinese - Cittadella   1-1  71' Scarpa (CI), 89' Del Prato

Ritorno (7/6/1998)

Pro Patria - Triestina  0-2  'a tavolino' match suspended after 97' for troubles
Cittadella - Albinese   1-0  97' Colitti (played 8/6/1998)

Final (Ferrara 14/6/1998)
Cittadella - Triestina  0-0  a.e.t. (Cittadella win for the best ranking in the championship)

Playouts

Andata (31/5/1998)

Cremapergo - Leffe      0-2  10' Gorini, 73' Mignani
Solbiatese - Giorgione  1-1  33' Danesi (SO), 57' aut. Vanoli

Ritorno (7/6/1998)

Leffe - Cremapergo      0-2  46' Fommei, 64' Ragnoli (Cremapergo relegated for the worst ranking)
Giorgione - Solbiatese  1-1  27' Lucarini (SO), 90' Tollardo

Top scorers: 16 Zirafa (Cittadella); 13 Bonavita (Albinese), Baggio II (Giorgione), Provenzano (Pro Patria Gallaratese); 12 Della Giovanna (Mantova).

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. SPAL              34   15   2   0    6   5   6    21   7   6    44   18    70
2. AREZZO (1)        34   10   4   3    7   4   6    17   8   9    37   29    59
3. Spezia (1)        34    9   6   2    2  11   4    11  17   6    31   24    50
4. Rimini (1)        34   11   6   0    8   6   3    19  12   3    47   21    69
5. Teramo (1)        34    9   5   3    6   6   5    15  11   8    40   32    56
6. Viterbese         34   10   5   2    2   6   9    12  11  11    42   43    47
7. Vis Pesaro        34    8   7   2    4   4   9    12  11  11    34   38    47
8. Baracca Lugo      34    9   3   5    2   7   8    11  10  13    36   32    43
9. Castel S. Pietro  34    4  10   3    5   6   6     9  16   9    33   32    43
10. Pisa             34    9   4   4    2   5  10    11   9  14    36   37    42
11. Pontedera        34    7   7   3    2   7   8     9  14  11    31   31    41
12. Maceratese       34    7   6   4    2   8   7     9  14  11    24   26    41
13. Fano             34    5  10   2    3   5   9     8  15  11    30   37    39
14. Sassari Torres(2)34    6   7   4    2   8   7     8  15  11    41   44    39
15. Viareggio (2)    34    6  10   1    0   4  13     6  14  14    35   44    32
16. Tempio (2)       34    5   8   4    1   5  11     6  13  15    30   43    31
17. Iperzola P. (2)  34    3   3  11    3   7   7     6  10  18    28   49    28
18. Tolentino        34    1  10   6    2   9   6     3  19  12    23   42    28

SPAL and AREZZO promoted in Serie C/1.
Tempio, Iperzola Ponteroncariale and Tolentino relegated in Campionato Nazionale Dilettanti.

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

Playoffs

Andata (31/5/1998)

Spezia - Rimini         0-0
Teramo - Arezzo         0-0

Ritorno (7/6/1998)

Rimini - Spezia         0-1  93' Chiappara
Arezzo - Teramo         1-0  80' Signorini

Final (Pistoia, 14/6/1998)
Arezzo - Spezia         2-1  a.e.t. 29' Balducci, 50' rig. Chiappara (SP), 127' rig. Campanile

Playouts

Andata (31/5/1998)

Iperzola - Sas. Torres  2-3  26' Di Natale (IP), 34' rig. Frau, 80' Luceri, 86' Di Natale
                             (IP), 90' Fiori
Tempio - Viareggio      1-0  48' rig. Casu

Ritorno (7/6/1998)

Sas. Torres - Iperzola  3-0  5' Fiori, 48' Frau, 90' Cristofari
Viareggio - Tempio      3-2  14' Varchetta (TE), 55' rig. Carsetti, 56' Bonuccelli, 75'
                             Borrotzu (TE), 79' Doni

Top scorers: 19 Cancellato (Spal); 15 Nicoletti (Teramo); 14 Spagnolli (Baracca Lugo), Tacchi
             (Fano), Tedeschi (Rimini).

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. MARSALA           34   12   3   2    4  10   3    16  13   5    48   25    61
2. CROTONE (1)       34   11   4   2    5   5   7    16   9   9    45   28    57
3. Benevento (1)     34    8   6   3    7   4   6    15  10   9    36   26    55
4. Sora (1)          34   11   6   0    3   9   5    14  15   5    35   25    57
5. Trapani (1)       34    8   6   3    6   5   6    14  11   9    39   25    53
6. Catanzaro         34   10   5   2    2   7   8    12  12  10    32   30    48
7. Castrovillari     34   11   6   0    1   6  10    12  12  10    37   37    48
8. Bisceglie         34    9   6   2    2   6   9    11  12  11    32   31    45
9. Tricase           34    8   5   4    4   3  10    12   8  14    40   43    44
10. Catania          34    7   8   2    2   8   7     9  16   9    31   34    43
11. Avezzano         34    8   6   3    3   4  10    11  10  13    27   32    43
12. Cavese           34    5   9   3    3   8   6     8  17   9    40   44    41
13. Astrea           34    7   7   3    1   8   8     8  15  11    35   45    39
14. Juveterr. Gela(2)34    7   7   3    0   7  10     7  14  13    36   42    35 
15. Frosinone (2)    34    6   7   4    1   5  11     7  12  15    29   48    33
16. Albanova (2)     34    6   9   2    0   7  10     6  16  12    25   36    34
17. Chieti (2)       34    6   5   6    1   7   9     7  12  15    27   35    33
18. Olbia (3)        34    6   8   3    2   4  11     8  12  14    38   46    31

MARSALA and CROTONE promoted in Serie B.
Albanova, Chieti and Olbia relegated in Campionato Nazionale Dilettanti.

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

Playoffs

Andata (31/5/1998)

Benevento - Sora        1-0  46' rig. Passiatore
Trapani - Crotone       1-1  20' Tagliente (CR), 86' rig. Mosca

Ritorno (7/6/1998)

Sora - Benevento        0-1  52' Passiatore
Crotone - Trapani       1-0  21' rig. Grieco

Final (Lecce, 14/6/1998)
Crotone - Benevento     2-1  44' Petitto (BN), 53' rig. Moschella, 72' Balestrieri

Playouts

Andata (31/5/1998)

Chieti - Juveterranova  3-0  14' Laghi, 46' Lapini, 90' Di Matteo
Frosinone - Albanova    4-0  20' Spilli, 32' e 50' Lomonaco, 76' Germoni

Ritorno (7/6/1998)

Juveterranova - Chieti  3-0  25' e 60' Consagra, 85' aut. Paradisi (Chieti relegated for the
                             worst ranking)
Albanova - Frosinone    2-1  7' Buoncammino, 41' Levanti (FR), 81' Castellano

Top scorers: 16 Ambrosi (Cavese); 15 Mosca (Trapani); 14 Molino (Olbia).

In the summer of 1995 Tempio and Chieti readmitted instead of Avezzano and Bisceglie not admitted for money problems. To complete Serie C/2 1998/99 admitted also Riccione.

Promoted from Campionato Nazionale Dilettanti: Sanremese, Borgosesia, Trento, Faenza, Gubbio,
L'Aquila, Giugliano, Nuova Nardò, Messina and after also Riccione.
Campione Nazionale Dilettanti 1997/98 (Italian Amateur Champion 1997/98): Giugliano.




Author: Maurizio Mariani
(mauriziop.mariani@tin.it)

Last updated: 29 Nov 2000

(C) Copyright Maurizio Mariani and RSSSF 2000


  USO DE MEMORIA  
4,289,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0922
Total Execution Time  0.0944
  CADENA URL  
/serie_c11998
  GET DATOS  
$_GET['/serie_c11998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'serie_c11998'
0.0040  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=2657
0.0020  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 = 30912 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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='1998' WHERE c.parentId=90 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:55:19' 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 19:55:19' 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 19:55:19' 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 19:55:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1998 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 events1998 e WHERE e.league_id IN (30912) 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 (30912) 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 events1998 e WHERE e.league_id IN (30912) 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 (30912) 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 events1998 e WHERE e.league_id IN (30912) AND (e.action IN (3,4) ) 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 (30912) 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 events1998 e WHERE e.league_id IN (30912) AND (e.action IN (22) ) 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 (30912) 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 = 30912 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 = 30912 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0022  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=30912 AND rel.round=34
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 = 30912 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 = 30912 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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30912 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` = 30912
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 `calendars1998` 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` = 30912 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 `events1998` e INNER JOIN calendars1998 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 = 30912 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 `events1998` e INNER JOIN calendars1998 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 = 30912 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 `tables1998` 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 = 30912 AND t.round = 32 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 `tables1998` 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 = 30912 AND t.round = 34 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-04-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30912 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=90
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 90 AND l.year = 1998 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=90 AND year=1998