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

Final Table:

 1. C Nacional dF                27 20  6  1  56-10  46 
  . CA Peñarol                   27 21  4  2  77-18  46 
--------------------------------------------------------
 3. Rampla Juniors FC            27 14  4  9  39-29  32 
 4. Montevideo Wanderers FC      27 11  9  7  39-36  31 
 5. CA Defensor                  27 12  5 10  50-39  29 
 6. IA Sud América               27  9  7 11  30-40  25 
 7. CA River Plate               27  6  6 15  19-45  18 
 8. Racing Club Montevideo       27  4  7 16  29-58  15 
 9. Central FC                   27  4  6 17  33-63  14 
10. CA Bella Vista               27  6  2 19  27-61  14

Round 1
Rampla Juniors       1-0 Peñarol
Nacional             4-0 Bella Vista
River Plate          2-0 Sud América
Racing               3-3 Central
Montevideo Wanderers 1-1 Defensor

Round 2
Nacional             2-0 Central
Peñarol              4-2 Montevideo Wanderers
Bella Vista          4-3 Racing
Rampla Juniors       2-0 River Plate
Defensor             4-2 Sud América

Round 3
Peñarol              7-1 Racing
Nacional             0-0 Sud América
Rampla Juniors       2-1 Central
Montevideo Wanderers 3-2 Bella Vista
Defensor             1-0 River Plate

Round 4
Nacional             2-0 River Plate
Peñarol              2-0 Central
Rampla Juniors       1-1 Sud América
Defensor             1-0 Bella Vista
Montevideo Wanderers 2-0 Racing

Round 5
Peñarol              0-0 River Plate
Nacional             2-0 Rampla Juniors
Sud América          1-0 Bella Vista
Montevideo Wanderers 0-0 Central
Racing               4-2 Defensor

Round 6
Peñarol              2-0 Bella Vista
Montevideo Wanderers 3-1 River Plate
Defensor             2-0 Rampla Juniors
Sud América          2-1 Central
Nacional             2-0 Racing

Round 7
Montevideo Wanderers 1-0 Sud América
Central              1-1 Defensor
Bella Vista          0-0 River Plate
Nacional             2-0 Peñarol
Rampla Juniors       1-1 Racing

Round 8
Nacional             3-0 Defensor
Bella Vista          2-0 Central
Racing               1-0 River Plate
Rampla Juniors       2-0 Montevideo Wanderers
Peñarol              5-1 Sud América

Round 9
Sud América          2-1 Racing
Nacional             3-0 Montevideo Wanderers
Peñarol              2-1 Defensor
Bella Vista          2-1 Rampla Juniors
Central              1-1 River Plate

Round 10
Peñarol              3-0 Rampla Juniors
Nacional             4-2 Bella Vista
River Plate          3-1 Sud América
Central              3-2 Racing
Montevideo Wanderers 3-2 Defensor

Round 11
Nacional             1-0 Central
Peñarol              2-2 Montevideo Wanderers
Bella Vista          2-0 Racing
Rampla Juniors       3-0 River Plate
Defensor             1-1 Sud América

Round 12
Peñarol              5-1 Racing
Nacional             1-0 Sud América
Central              1-0 Rampla Juniors
Montevideo Wanderers 2-0 Bella Vista
Defensor             5-0 River Plate

Round 13
Nacional             7-0 River Plate
Peñarol              5-0 Central
Rampla Juniors       1-0 Sud América
Defensor             4-3 Bella Vista
Montevideo Wanderers 3-1 Racing

Round 14
Peñarol              4-0 River Plate
Nacional             1-0 Rampla Juniors
Sud América          2-0 Bella Vista
Montevideo Wanderers 2-2 Central
Defensor             4-1 Racing

Round 15
Peñarol              3-1 Bella Vista
Montevideo Wanderers 2-2 River Plate
Defensor             1-1 Rampla Juniors
Sud América          3-2 Central
Nacional             3-0 Racing

Round 16
Sud América          2-1 Montevideo Wanderers
Defensor             2-0 Central
River Plate          1-0 Bella Vista
Nacional             2-2 Peñarol
Rampla Juniors       1-0 Racing

Round 17
Nacional             2-0 Defensor
Central              4-0 Bella Vista
Racing               1-1 River Plate
Montevideo Wanderers 2-1 Rampla Juniors
Peñarol              3-0 Sud América

Round 18
Sud América          1-0 Racing
Nacional             1-1 Montevideo Wanderers
Peñarol              3-1 Defensor
Rampla Juniors       2-0 Bella Vista
Central              2-1 River Plate

Round 19
Peñarol              2-0 Rampla Juniors
Nacional             3-0 Bella Vista
Sud América          1-0 River Plate
Racing               1-0 Central
Defensor             3-0 Montevideo Wanderers

Round 20
Nacional             4-0 Central
Peñarol              2-0 Montevideo Wanderers
Racing               3-2 Bella Vista
Rampla Juniors       2-0 River Plate
Defensor             2-1 Sud América

Round 21
Peñarol              1-0 Racing
Nacional             1-1 Sud América
Rampla Juniors       6-3 Central
Montevideo Wanderers 2-0 Bella Vista
River Plate          1-0 Defensor

Round 22
Nacional             1-0 River Plate
Peñarol              8-2 Central
Rampla Juniors       3-1 Sud América
Defensor             4-0 Bella Vista
Montevideo Wanderers 2-1 Racing

Round 23
Peñarol              2-1 River Plate
Nacional             2-0 Rampla Juniors
Bella Vista          2-1 Sud América
Montevideo Wanderers 2-0 Central
Defensor             3-0 Racing

Round 24
Peñarol              4-0 Bella Vista
Montevideo Wanderers 1-1 River Plate
Rampla Juniors       2-1 Defensor
Sud América          4-3 Central
Nacional             1-1 Racing

Round 25
Montevideo Wanderers 1-1 Sud América
Defensor             4-2 Central
Bella Vista          2-1 River Plate
Peñarol              2-0 Nacional
Rampla Juniors       1-1 Racing

Round 26
Nacional             2-1 Defensor
Bella Vista          2-2 Central
Racing               1-1 River Plate
Rampla Juniors       2-1 Montevideo Wanderers
Peñarol              0-0 Sud América

Round 27
Sud América          1-1 Racing
Nacional             0-0 Montevideo Wanderers
Peñarol              4-0 Defensor
Rampla Juniors       4-1 Bella Vista
River Plate          1-0 Central

Final Table:

 1. C Nacional dF                27 20  6  1  56-10  46 
  . CA Peñarol                   27 21  4  2  77-18  46 
--------------------------------------------------------
 3. Rampla Juniors FC            27 14  4  9  39-29  32 
 4. Montevideo Wanderers FC      27 11  9  7  39-36  31 
 5. CA Defensor                  27 12  5 10  50-39  29 
 6. IA Sud América               27  9  7 11  30-40  25 
 7. CA River Plate               27  6  6 15  19-45  18 
 8. Racing Club Montevideo       27  4  7 16  29-58  15 
 9. Central FC                   27  4  6 17  33-63  14 
10. CA Bella Vista               27  6  2 19  27-61  14

Championship Playoff

First Playoff [May 27, 1934, Estadio Centenario; attendance: 42,000]
Nacional             0-0 Peñarol
  [Nacional: Eduardo García; José Nasazzi, Juan Brito; Arsenio Fernández, Ulises Chifflet,
     Marcelino Pérez; Juan Miguel Labraga, Pedro Duhart, Héctor Castro, Enrique Fernández,
     Eduardo Ithurbide. Coach: Américo Szigeti.
   Peñarol: Juan Tea; Lorenzo Fernández, Ernesto Mascheroni; Erebo Zunino, Alvaro Gestido,
     Galileo Chanes; João de Almeida "Bahía", Luis Mata, Juan Pedro Young, Juan Peregrino
     Anselmo, Braulio Castro. Coach: Leonardo De Lucca]
  [Referees: Telésforo Rodríguez, Luis Scandroglio, Aníbal Tejada;
   sent off: 71' Labraga (N), 71' Nasazzi (N), 71' Chifflet (N)]
  [Obs.: in the 70th minute a miss shot by Bahía hit Nacional's kinesiologist medicine cabinet
     and returned to the field. Anselmo took the ball and assisted Castro who scored the goal.
     Chifflet, Labraga and Nasazzi were sent off by the referee after assaulting him, which
     led him to the Stadium's enfermery, being replaced by Scandroglio, who suspended the match
     for lack of light. On July 30th the League Board decided to disallow Castro's goal and
     Chifflet's sending off, and to play the remaining 20' on August 25th, but closing Estadio
     Centenario's doors. Nacional played with Eduardo García; Ulises Chifflet, Juan Ramón
     Cabrera; Arsenio Fernández, Miguel Andriolo, Marcelino Pérez; Francisco Arispe, Aníbal
     Ciocca and Enrique Fernández; Peñarol with Juan Tea; Lorenzo Fernández, Adhemar Canavessi;
     Erebo Zunino, Alvaro Gestido, Nicolás Riccardi; Braulio Castro, Luis Mata, Juan Pedro
     Young, Juan Peregrino Anselmo and Juan Pedro Arremón. Two extra times were played,
     totalising 80' of play, and without opening the score.]

Second Playoff [Sep 2, 1934, Estadio Centenario; attendance: 35,000]
Peñarol              0-0 Nacional              [after two extra times (60')]
  [Peñarol: Juan Tea; Lorenzo Fernández, Adhemar Canavessi; Erebo Zunino, Alvaro Gestido,
     Alberto Berisso; João de Almeida "Bahía", Luis Mata, Juan Pedro Young, Luis Marcelo
     Matozzo "Feitiço", Braulio Castro. Coach: Leonardo De Lucca.
   Nacional: Eduardo García; Ulises Chifflet, Juan Ramón Cabrera; Arsenio Fernández, Miguel
     Andriolo, Marcelino Pérez; Zoilo Saldombide, Francisco Arispe, Aníbal Ciocca, Enrique
     Fernández, Eduardo Ithurbide. Coach: Américo Szigeti]
  [Referees: Domingo Lombardi, Martín Aphesteguy, M. Sobreira]

Third Playoff [Nov 18, 1934, Estadio Centenario; attendance: 35,000]
Nacional             3-2 Peñarol
  [Héctor Castro 53, 61, 77; Braulio Castro 42, Juan Pedro Arremón 58]
  [Nacional: Eduardo García; Ulises Chifflet, Juan Ramón Cabrera; Arsenio Fernández, Miguel
     Andriolo, Marcelino Pérez; Francisco Arispe, Aníbal Ciocca, Héctor Castro, Enrique
     Fernández, Zoilo Saldombide. Coach: Américo Szigeti.
   Peñarol: Juan Tea; Alberto Nogués, Adhemar Canavessi; Erebo Zunino, Alvaro Gestido,
     Alberto Berisso; Braulio Castro, Lorenzo Fernández, Juan Pedro Young, Luis Mata, Juan
     Pedro Arremón. Coach: Leonardo De Lucca]
  [Referees: Juan Carlos Cerón, Juan Capris, M. Sobreira]

Nacional Champions of Uruguay 1933.

Topscorer:

33 - Juan Pedro Young (CA Peñarol)

No promotion/relegation.


Authors:
 Diego Antognazza 
(oguico@hotmail.com)
and Martín Tabeira (martintab@hotmail.com)

Last updated: 1 May 2004


(C) Copyright Diego Antognazza, Martín Tabeira and RSSSF 2004


  USO DE MEMORIA  
4,286,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1121
Total Execution Time  0.1140
  CADENA URL  
/apertura_uruguay1933
  GET DATOS  
$_GET['/apertura_uruguay1933']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0017  SELECT type FROM routes WHERE alias = 'apertura_uruguay1933'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_uruguay' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1933 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=46 AND type_rel = 3
0.0046  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 46 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  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 (1306824,1302659,1299780,1293805,1270096) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=1754
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 = 30016 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='1933' WHERE c.parentId=46 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 46 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-27 14:12:04' 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 14:12:04' 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 14:12:04' 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 14:12:04' 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 = 'apertura_uruguay' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1933 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1933 e WHERE e.league_id IN (30016) 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.0025  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 (30016) 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 events1933 e WHERE e.league_id IN (30016) AND (e.action IN (4,5) ) 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 (30016) 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 events1933 e WHERE e.league_id IN (30016) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0028  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 (30016) 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 events1933 e WHERE e.league_id IN (30016) 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 (30016) 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 = 30016 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 = 30016 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=30016 AND rel.round=27
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 = 30016 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 = 30016 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` = 30016 ORDER BY creation_date DESC LIMIT 0, 10
0.0027  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` = 30016
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 `calendars1933` 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` = 30016 AND c.`round` = 27 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 `events1933` e INNER JOIN calendars1933 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 = 27 AND e.real_date IS NOT NULL AND e.league_id = 30016 ORDER BY total DESC LIMIT 40
0.0021  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 `events1933` e INNER JOIN calendars1933 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 = 30016 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 `tables1933` 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 = 30016 AND t.round = 25 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 `tables1933` 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 = 30016 AND t.round = 27 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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30016 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=46
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 46 AND l.year = 1933 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=46 AND year=1933