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. PIACENZA          34   15   2   0    7   6   4    22   8   4    55   28    52
2. PADOVA            34   13   2   2    7   7   3    20   9   5    45   17    49
3. Reggiana          34   10   7   0    5   6   6    15  13   6    32   21    43
4. Spal              34    9   7   1    4   6   7    13  13   8    41   33    39
5. Monza             34    8   7   2    5   3   9    13  10  11    34   25    36
6. Centese           34    7   8   2    2   9   6     9  17   8    29   27    35
7. Fano              34   10   5   2    3   4  10    13   9  12    38   32    35
8. Rimini            34    7   8   2    2   8   7     9  16   9    35   35    34
9. Prato             34    7   8   2    1   9   7     8  17   9    18   20    33
10. Trento           34    8   7   2    1   8   8     9  15  10    29   33    33
11. Virescit Bocc.   34    6   8   3    1  10   6     7  18   9    36   39    32
12. Spezia           34    6   9   2    2   6   9     8  15  11    27   34    31
13. Ancona           34    6   7   4    1   9   7     7  16  11    26   28    30
14. Lucchese         34    7   8   2    1   6  10     8  14  12    20   26    30
15. Mantova          34    7   7   3    1   6  10     8  13  13    28   36    29
16. Carrarese        34    7   4   6    1   7   9     8  11  15    24   43    27
17. R.M. Firenze     34    4   9   4    3   4  10     7  13  14    27   36    27
18. Legnano          34    2   7   8    0   6  11     2  13  19    15   46    17

                    612  139 120  47   47 120 139   186 240 186   559  559   612

PIACENZA and PADOVA promoted in Serie B. Mantova, Carrarese, R.M. Firenze and 
Legnano relegated in Serie C/2.

Top scorers: 13 Cornacchini (Fano), Fermanelli (Spal); 12 Madonna (Piacenza); 
             11 Simonetta (Piacenza), D'Agostino (Reggiana).

Girone B

FINAL TABLE          Home         Away         Total       Goals     Pts
                   Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.
1. CATANZARO         34   14   2   1    4   7   6    18   9   7    46   24    45
2. BARLETTA          34   11   5   1    4   9   4    15  14   5    39   28    44
3. Casertana         34   10   7   0    3   7   7    13  14   7    32   26    40
4. Cosenza           34   12   3   2    1   9   7    13  12   9    31   27    38
5. Monopoli          34   11   5   1    2   6   9    13  11  10    27   19    37
6. Campania Puteolana34   10   6   1    0  10   7    10  16   8    29   26    36
7. Reggina           34    9   7   1    2   7   8    11  14   9    23   24    36
8. Foggia (*)        34   11   4   2    4   6   7    15  10   9    31   23    35
9. Teramo            34   11   5   1    2   4  11    13   9  12    24   25    35
10. Nocerina         34   10   3   4    4   2  11    14   5  15    29   27    33
11. Brindisi         34   10   6   1    1   5  11    11  11  12    28   27    33
12. Livorno          34    7   8   2    1   8   8     8  16  10    17   23    32
13. Licata           34   11   5   1    0   4  13    11   9  14    35   38    31
14. Salernitana      34    9   7   1    1   4  12    10  11  13    24   31    31
15. Martina          34    7   8   2    0   6  11     7  14  13    23   33    28
16. Benevento        34    7   8   2    1   4  12     8  12  14    27   30    28
17. Siena            34    5  10   2    0   4  13     5  14  15    13   27    24
18. Sorrento         34    5   4   8    3   1  13     8   5  21    27   47    21

                    612  170 103  33   33 103 170   203 206 203   505  505   607

CATANZARO and BARLETTA promoted in Serie B. Martina, Benevento, Siena and 
Sorrento relegated in Serie C/2.

(*) 5 pts deducted    

Top scorers: 17 reti Palanca (Catanzaro); 14 D'Ottavio (Barletta); 
             11 Crialesi (Benevento), Bonaldi (Casertana), Baldini (Foggia).


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. TORRES            34   13   4   0    4  10   3    17  14   3    41   17    48
2. DERTHONA          34   11   5   1    5  10   2    16  15   3    36   17    47
3. Novara            34   11   5   1    5   9   3    16  14   4    39   17    46
4. Pistoiese         34    9   6   2    4   9   4    13  15   6    25   11    41
5. Entella Bacezza   34   13   3   1    2   6   9    15   9  10    33   26    39
6. Pro Vercelli      34    7   9   1    2   7   8     9  16   9    30   28    34
7. Olbia             34    7   7   3    3   7   7    10  14  10    27   31    34
8. Civitavecchia     34    6   5   6    4   8   5    10  13  11    29   28    33
9. Cuoio Pelli       34    4  11   2    3   8   6     7  19   8    22   25    33
10. Casale           34    8   7   2    1   8   8     9  15  10    27   33    33
11. Sorso            34    5  10   2    3   6   8     8  16  10    28   26    32
12. Montevarchi      34    6   9   2    4   3  10    10  12  12    26   27    32
13. Pontedera        34    6   7   4    2   9   6     8  16  10    21   24    32
14. Carbonia         34    8   8   1    2   4  11    10  12  12    20   29    32
15. Massese '82      34    6   9   2    1   8   8     7  17  10    22   26    31
16. Alessandria      34    5   7   5    2   7   8     7  14  13    21   23    28
17. Sanremese        34    3  11   3    1   7   9     4  18  12    25   36    26
18. Asti T.S.C.      34    1   5  11    1   2  14     2   7  25    11   59    11

                    612  129 128  49   49 128 129   178 256 178   483  483   612

TORRES and DERTHONA promoted in Serie C/1. Alessandria (later readmitted 
because of withdrawal of Montebelluna), Sanremese and Asti T.S.C. relegated 
in Campionato Interregionale.

Top scorers: 14 Gino (Casale); 11 Bertini (Entella Bacezza), Balacich (Novara); 
             10 Cacciatori (Montevarchi), Solimeno (Pro Vercelli), Ennas (Torres).  

Girone B

FINAL TABLE          Home         Away         Total       Goals     Pts
                   Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.
1. OSPITALETRO       34   12   2   3    6   9   2    18  11   5    40   17    47
2. PAVIA             34   11   6   0    3  11   3    14  17   3    35   14    45
3. Mestre            34    9   7   1    4   6   7    13  13   8    32   28    39
4. Chievo            34    8   7   2    3   9   5    11  16   7    24   23    38
5. Suzzara           34    8   6   3    4   7   6    12  13   9    35   25    37
6. Venezia           34    6   9   2    4   8   5    10  17   7    26   20    37
7. Treviso           34    8   9   0    2   8   7    10  17   7    37   33    37
8. Giorgione         34    8   7   2    3   7   7    11  14   9    26   24    36
9. Pro Patria        34    5  10   2    3   8   6     8  18   8    28   26    34
10. Varese           34    8   6   3    3   6   8    11  12  11    33   34    34
11. Vogherese        34    9   6   2    0   8   9     9  14  11    35   42    32
12. Pergocrema       34   10   4   3    0   7  10    10  11  13    29   28    31
13. Sassuolo         34    8   5   4    2   6   9    10  11  13    25   25    31
14. Pordenone        34    7   8   2    2   5  10     9  13  12    26   31    31
15. Montebelluna     34    6   7   4    4   3  10    10  10  14    28   33    30
16. Pievigina        34    7   7   3    1   6  10     8  13  13    29   40    29
17. Orceana          34    4   9   4    1   4  12     5  13  16    20   43    23
18. Oltrepò          34    4   7   6    1   4  12     5  11  18    20   42    21

                    612  138 122  46   46 122 138   184 244 184   528  528   612

OSPITALETTO and PAVIA promoted in Serie C/1. Pievigina, Orceana and Oltrepò 
relegated in Campionato Interregionale.

Top scorers: 15 Zobbio (Vogherese); 13 Zerbio (Varese); 12 Rambaudi (Pavia).

Girone C

FINAL TABLE          Home         Away         Total       Goals     Pts
                   Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.
1. VIS PESARO        34   14   3   0    4   8   5    18  11   5    39   20    47
2. FRANCAVILLA       34   12   5   0    5   8   4    17  13   4    36   18    47
3. Ternana           34   12   5   0    5   6   6    17  11   6    44   20    45
4. Giulianova        34   12   5   0    2  12   3    14  17   3    42   20    45
5. Fidelis Andria    34   11   5   1    4   6   7    15  11   8    36   21    41
6. Jesi              34    7  10   0    2   8   7     9  18   7    28   25    36
7. Lanciano          34   11   5   1    1   7   9    12  12  10    26   28    36
8. Casarano (**)     34   11   6   0    3   6   8    14  12   8    35   24    35
9. Perugia (*)       34    9   5   3    2   9   6    11  14   9    32   24    34
10. Angizia Luco     34   10   5   2    1   7   9    11  12  11    34   30    34
11. Ravenna          34   11   5   1    1   5  11    12  10  12    28   32    34
12. Forlì            34    5   9   3    3   6   8     8  15  11    23   28    31
13. Civitanovese     34    7   9   1    1   4  12     8  13  13    24   36    29
14. Bisceglie        34    9   5   3    1   2  14    10   7  17    31   46    27
15. Galatina P.I.    34    5  10   2    1   3  13     6  13  15    25   32    25
16. Matera           34    6   6   5    0   7  10     6  13  15    22   41    25
17. Maceratese       34    4   6   7    0   5  12     4  11  19    17   37    19
18. Cesenatico       34    2   8   7    0   3  14     2  11  21    18   58    15

                    612  158 112  36   36 112 158   194 224 194   540  540   605

VIS PESARO and FRANCAVILLA promoted in Serie C/1. Matera (for less points in 
the matches against Galatina Pro Italia), Maceratese and Cesenatico relegated 
in Campionato Interregionale.

 (*) 2 pts deducted    
(**) 5 pts deducted           
                   
Top scorers: 20 Valori (Casarano); 14 Nappi (Vis Pesaro); 13 D'Amico (Ternana).

Girone D

FINAL TABLE          Home         Away         Total       Goals     Pts
                   Pl.   V.  N.  P.   V.  N.  P.    V.  N.  P.    A.   P.
1. FROSINONE         34   13   3   1    4  10   3    17  13   4    39   20    47
2. ISCHIA ISOLAVERDE 34   12   4   1    2  12   3    14  16   4    47   20    44
3. Latina            34   13   3   1    2   9   6    15  12   7    36   28    42
4. Giarre            34   12   5   0    3   5   9    15  10   9    34   23    40
5. Juve Stabia       34   11   6   0    0  10   7    11  16   7    35   30    38
6. Siracusa          34   11   5   1    2   6   9    13  11  10    36   26    37
7. Valdiano '85 (*)  34    9   7   1    5   1  11    14   8  12    36   34    36
8. Lodigiani         34    9   7   1    3   3  11    12  10  12    43   37    34
9. Afragolese        34    7   6   4    3   7   7    10  13  11    31   30    33
10. Nola             34    8   7   2    0  10   7     8  17   9    35   38    33
11. Pro Cisterna     34   12   2   3    0   7  10    12   9  13    37   42    33
12. Trapani          34    7   7   3    3   5   9    10  12  12    34   31    32
13. Cavese (**)      34    8   9   0    2   6   9    10  15   9    36   32    30
14. Ercolanese       34    7   8   2    2   3  12     9  11  14    31   36    29
15. Turris           34    8   5   4    2   4  11    10   9  15    30   43    29
16. Rende            34    6   9   2    1   5  11     7  14  13    30   37    28
17. Nissa            34    6   8   3    0   2  15     6  10  18    16   54    22
18. Paganese         34    4   8   5    0   4  13     4  12  18    12   37    20

                    612  163 109  34   34 109 163   197 218 197   598  598   607 
                   
FROSINONE and ISCHIA ISOLAVERDE promoted in Serie C/1. Rende, Nissa and
Paganese relegated in Campionato Interregionale.             
                   
 (*) Ex Rifo Sud  
(**) 5 pts deducted   

Top scorers: 19 Onorato (Ischia Isolaverde); 18 Silenzi (Lodigiani); 
             17 Spica (Turris).

Promoted from Interregionale:
Saviglianese, Pro Sesto, Intim Helen, Riccione, Sarzanese 1906, Gubbio, Olimpia,
Chieti, Vigor Lamezia, Kroton (ex Crotone), Atletico Catania and Tempio.   


Author: Maurizio Mariani (maurizio.mariani@npo.it)
Last updated: 20 Jan 2004

(C) Copyright Maurizio Mariani and RSSSF 1999/2004


  USO DE MEMORIA  
4,317,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0974
Total Execution Time  0.0994
  CADENA URL  
/serie_c11987
  GET DATOS  
$_GET['/serie_c11987']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0017  SELECT type FROM routes WHERE alias = 'serie_c11987'
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 = 1987 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 90 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1288519,1278023,1273213,1269533,1269201) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=2646
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 = 30901 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='1987' 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-28 03:45:27' 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 03:45:27' 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-28 03:45:27' 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 03:45:27' 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 = 1987 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 events1987 e WHERE e.league_id IN (30901) 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 (30901) 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 events1987 e WHERE e.league_id IN (30901) 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 (30901) 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 events1987 e WHERE e.league_id IN (30901) 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 (30901) 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 events1987 e WHERE e.league_id IN (30901) 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 (30901) 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 = 30901 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  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 = 30901 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0020  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=30901 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 = 30901 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 = 30901 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` = 30901 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 30901
0.0019  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 `calendars1987` 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` = 30901 AND c.`round` = 34 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 `events1987` e INNER JOIN calendars1987 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 = 30901 ORDER BY total DESC LIMIT 40
0.0019  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 `events1987` e INNER JOIN calendars1987 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 = 30901 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0020  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 `tables1987` 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 = 30901 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1987` 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 = 30901 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 30901 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=90
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 90 AND l.year = 1987 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=90 AND year=1987