Liga Uno China 2019
2018/2019

Liga Uno China 2019

  • Qingdao FC
  • Cangzhou Mighty Lions
  • Guizhou Zhicheng
  • Heilongjiang Ice City
  • Changchun Yatai
  • Zhejiang FC
  • Nei Mongol Zhongyou
  • Beijing BSU
  • Shaanxi Chang'an
  • Meizhou Hakka
  • Meizhou Meixian Techand
  • Nantong Zhiyun
  • Xinjiang Tianshan
  • Sichuan Annapurna
  • Liaoning Whowin
  • Shanghai Shenxin

Liga Uno China 2019

La temporada finalizó el Sábado, 02 Noviembre 2019.
 
02 Nov 19
07:30 Finalizado
Beijing BSU Beijing BSU 1-0 Guizhou Zhicheng Guizhou Zhicheng más información Jugadas destacadas ...
27' Zou Zhongting 1-0
 
02 Nov 19
07:30 Finalizado
Heilongjiang Ice City Heilongjiang Ice City 4-1 Changchun Yatai Changchun Yatai más información Jugadas destacadas ...
13' K. Cao 1-0
60' Y. Arquin 2-0
70' Yang Lei 3-0
80' K. Cao 4-0
4-1 90' R. Zivkovic
 
02 Nov 19
07:30 Finalizado
Meizhou Hakka Meizhou Hakka 2-0 Shanghai Shenxin Shanghai Shenxin más información Jugadas destacadas ...
68' Yang Wenji 1-0
70' Guo Yi 2-0
 
02 Nov 19
07:30 Finalizado
Nei Mongol Zhongyou Nei Mongol Zhongyou 1-0 Liaoning Whowin Liaoning Whowin más información Jugadas destacadas ...
73' Gen Li 1-0
 
02 Nov 19
07:30 Finalizado
Qingdao FC Qingdao FC 1-2 Nantong Zhiyun Nantong Zhiyun más información Jugadas destacadas 2
2' Y. Touré
58' Gao Xiang 1-0
1-1 60' Mladen Kovacevic
1-2 90' Mladen Kovacevic
 
02 Nov 19
07:30 Finalizado
Shaanxi Chang'an Shaanxi Chang'an 6-3 Sichuan Annapurna Sichuan Annapurna más información Jugadas destacadas ...
15' J. Owoeri 1-0
1-1 23' A. Olanare
26' O. Maritu 2-1
28' O. Maritu 3-1
38' O. Maritu 4-1
41' O. Maritu 5-1
5-2 54' J. Balotelli
84' J. Owoeri 6-2
90' Xu Wu
6-3 90' A. Olanare
 
02 Nov 19
07:30 Finalizado
Cangzhou Mighty Lions Cangzhou Mighty Lions 2-0 Xinjiang Tianshan Xinjiang Tianshan más información Jugadas destacadas 1
69' Zang Yifeng 1-0
88' Muriqui 2-0
 
02 Nov 19
07:30 Finalizado
Zhejiang FC Zhejiang FC 2-1 Meizhou Meixian Techand Meizhou Meixian Techand más información Jugadas destacadas ...
48' Yang Chao
79' D. Ndlovu 2-0
2-1 84' Wenhe Yu
Equipos Puntos J. G. E. P. F. C. Forma
1 Qingdao FC Qingdao FC 57 30 17 6 7 59 36
  • EMPATE
  • Changchun Yatai 1
  • Qingdao FC 1
  • VICTORIA
  • Qingdao FC 3
  • Liaoning Whowin 1
  • VICTORIA
  • Qingdao FC 1
  • Beijing BSU 0
  • VICTORIA
  • Shanghai Shenxin 0
  • Qingdao FC 2
  • DERROTA
  • Qingdao FC 1
  • Nantong Zhiyun 2
2 Cangzhou Mighty Lions Cangzhou Mighty 56 30 18 2 10 59 42
  • DERROTA
  • Cangzhou Mighty Li. 0
  • Meizhou Meixian Te. 1
  • VICTORIA
  • Cangzhou Mighty Li. 1
  • Meizhou Hakka 0
  • VICTORIA
  • Cangzhou Mighty Li. 2
  • Guizhou Zhicheng 1
  • VICTORIA
  • Sichuan Annapurna 2
  • Cangzhou Mighty Li. 3
  • VICTORIA
  • Cangzhou Mighty Li. 2
  • Xinjiang Tianshan 0
3 Guizhou Zhicheng Guizhou Zhicheng 54 30 17 3 10 46 28
  • DERROTA
  • Shaanxi Chang'an 1
  • Guizhou Zhicheng 0
  • VICTORIA
  • Guizhou Zhicheng 5
  • Xinjiang Tianshan 0
  • DERROTA
  • Cangzhou Mighty Li. 2
  • Guizhou Zhicheng 1
  • VICTORIA
  • Guizhou Zhicheng 2
  • Nei Mongol Zhongyo. 1
  • DERROTA
  • Beijing BSU 1
  • Guizhou Zhicheng 0
4 Heilongjiang Ice City Heilongjiang 54 30 15 9 6 46 34
  • VICTORIA
  • Liaoning Whowin 2
  • Heilongjiang Ice C. 4
  • EMPATE
  • Heilongjiang Ice C. 2
  • Beijing BSU 2
  • VICTORIA
  • Meizhou Hakka 1
  • Heilongjiang Ice C. 2
  • VICTORIA
  • Meizhou Meixian Te. 2
  • Heilongjiang Ice C. 3
  • VICTORIA
  • Heilongjiang Ice C. 4
  • Changchun Yatai 1
5 Changchun Yatai Changchun Yatai 53 30 15 8 7 52 42
  • EMPATE
  • Changchun Yatai 1
  • Qingdao FC 1
  • VICTORIA
  • Changchun Yatai 1
  • Sichuan Annapurna 0
  • VICTORIA
  • Shaanxi Chang'an 1
  • Changchun Yatai 2
  • EMPATE
  • Changchun Yatai 1
  • Zhejiang FC 1
  • DERROTA
  • Heilongjiang Ice C. 4
  • Changchun Yatai 1
6 Zhejiang FC Zhejiang FC 51 30 14 9 7 49 40
  • VICTORIA
  • Zhejiang FC 2
  • Beijing BSU 1
  • VICTORIA
  • Shanghai Shenxin 1
  • Zhejiang FC 2
  • DERROTA
  • Zhejiang FC 1
  • Nantong Zhiyun 2
  • EMPATE
  • Changchun Yatai 1
  • Zhejiang FC 1
  • VICTORIA
  • Zhejiang FC 2
  • Meizhou Meixian Te. 1
7 Nei Mongol Zhongyou Mongol Zhongyou 51 30 15 6 9 35 30
  • EMPATE
  • Nei Mongol Zhongyo. 1
  • Meizhou Hakka 1
  • VICTORIA
  • Nei Mongol Zhongyo. 5
  • Meizhou Meixian Te. 1
  • VICTORIA
  • Nei Mongol Zhongyo. 3
  • Shanghai Shenxin 1
  • DERROTA
  • Guizhou Zhicheng 2
  • Nei Mongol Zhongyo. 1
  • VICTORIA
  • Nei Mongol Zhongyo. 1
  • Liaoning Whowin 0
8 Beijing BSU Beijing BSU 46 30 13 7 10 51 30
  • DERROTA
  • Zhejiang FC 2
  • Beijing BSU 1
  • EMPATE
  • Heilongjiang Ice C. 2
  • Beijing BSU 2
  • DERROTA
  • Qingdao FC 1
  • Beijing BSU 0
  • EMPATE
  • Nantong Zhiyun 0
  • Beijing BSU 0
  • VICTORIA
  • Beijing BSU 1
  • Guizhou Zhicheng 0
9 Shaanxi Chang'an Shaanxi Chang'an 44 30 13 5 12 39 37
  • VICTORIA
  • Shaanxi Chang'an 1
  • Guizhou Zhicheng 0
  • DERROTA
  • Nantong Zhiyun 3
  • Shaanxi Chang'an 0
  • DERROTA
  • Shaanxi Chang'an 1
  • Changchun Yatai 2
  • EMPATE
  • Xinjiang Tianshan 1
  • Shaanxi Chang'an 1
  • VICTORIA
  • Shaanxi Chang'an 6
  • Sichuan Annapurna 3
10 Meizhou Hakka Meizhou Hakka 39 30 11 6 13 44 41
  • EMPATE
  • Nei Mongol Zhongyo. 1
  • Meizhou Hakka 1
  • DERROTA
  • Cangzhou Mighty Li. 1
  • Meizhou Hakka 0
  • DERROTA
  • Meizhou Hakka 1
  • Heilongjiang Ice C. 2
  • VICTORIA
  • Liaoning Whowin 2
  • Meizhou Hakka 3
  • VICTORIA
  • Meizhou Hakka 2
  • Shanghai Shenxin 0
11 Meizhou Meixian Techand Meizhou Meixian 36 30 10 6 14 41 50
  • VICTORIA
  • Cangzhou Mighty Li. 0
  • Meizhou Meixian Te. 1
  • DERROTA
  • Nei Mongol Zhongyo. 5
  • Meizhou Meixian Te. 1
  • VICTORIA
  • Liaoning Whowin 1
  • Meizhou Meixian Te. 3
  • DERROTA
  • Meizhou Meixian Te. 2
  • Heilongjiang Ice C. 3
  • DERROTA
  • Zhejiang FC 2
  • Meizhou Meixian Te. 1
12 Nantong Zhiyun Nantong Zhiyun 33 30 8 9 13 35 38
  • EMPATE
  • Sichuan Annapurna 0
  • Nantong Zhiyun 0
  • VICTORIA
  • Nantong Zhiyun 3
  • Shaanxi Chang'an 0
  • VICTORIA
  • Zhejiang FC 1
  • Nantong Zhiyun 2
  • EMPATE
  • Nantong Zhiyun 0
  • Beijing BSU 0
  • VICTORIA
  • Qingdao FC 1
  • Nantong Zhiyun 2
13 Xinjiang Tianshan Xinjiang 33 30 9 6 15 39 55
  • VICTORIA
  • Xinjiang Tianshan 4
  • Shanghai Shenxin 3
  • DERROTA
  • Guizhou Zhicheng 5
  • Xinjiang Tianshan 0
  • DERROTA
  • Sichuan Annapurna 4
  • Xinjiang Tianshan 2
  • EMPATE
  • Xinjiang Tianshan 1
  • Shaanxi Chang'an 1
  • DERROTA
  • Cangzhou Mighty Li. 2
  • Xinjiang Tianshan 0
14 Sichuan Annapurna Sichuan 31 30 8 7 15 36 52
  • EMPATE
  • Sichuan Annapurna 0
  • Nantong Zhiyun 0
  • DERROTA
  • Changchun Yatai 1
  • Sichuan Annapurna 0
  • VICTORIA
  • Sichuan Annapurna 4
  • Xinjiang Tianshan 2
  • DERROTA
  • Sichuan Annapurna 2
  • Cangzhou Mighty Li. 3
  • DERROTA
  • Shaanxi Chang'an 6
  • Sichuan Annapurna 3
15 Liaoning Whowin Liaoning Whowin 21 30 5 6 19 33 57
  • DERROTA
  • Liaoning Whowin 2
  • Heilongjiang Ice C. 4
  • DERROTA
  • Qingdao FC 3
  • Liaoning Whowin 1
  • DERROTA
  • Liaoning Whowin 1
  • Meizhou Meixian Te. 3
  • DERROTA
  • Liaoning Whowin 2
  • Meizhou Hakka 3
  • DERROTA
  • Nei Mongol Zhongyo. 1
  • Liaoning Whowin 0
16 Shanghai Shenxin Shanghai Shenxin 12 30 3 3 24 30 82
  • DERROTA
  • Xinjiang Tianshan 4
  • Shanghai Shenxin 3
  • DERROTA
  • Shanghai Shenxin 1
  • Zhejiang FC 2
  • DERROTA
  • Nei Mongol Zhongyo. 3
  • Shanghai Shenxin 1
  • DERROTA
  • Shanghai Shenxin 0
  • Qingdao FC 2
  • DERROTA
  • Meizhou Hakka 2
  • Shanghai Shenxin 0
Ascenso : Qingdao FC, Cangzhou Mighty
Playoff Descenso : Sichuan, Liaoning Whowin
Descenso : Shanghai Shenxin
JUGADORES DESTACADOS

INFORMACIÓN
La Liga China One (también conocido como chino Jia League) es el segundo nivel de la liga profesional de los chinos de fútbol los clubes. La liga está bajo los auspicios de la Asociación China de Fútbol . Por encima de la Liga Uno de ellos es Super League china .
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,197,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.4885
Total Execution Time  0.4912
  CADENA URL  
/liga_uno_china2019/grupo1
  GET DATOS  
$_GET['/liga_uno_china2019/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_uno_china2019'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_uno_china' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0111  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 = 49167 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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='2019' WHERE c.parentId=239 GROUP BY c.id ORDER BY c.order_id ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 11:49:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 11:49:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 11:49:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 11:49:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0114  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_uno_china' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0122  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (49167) 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.0114  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 (49167) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (729182,64989,185413,273736,276588,155736,123918,137706,186054,76512,43424,199273,285209,304801,104565,20600,209453,214298,306389,29894) ORDER BY rp.in_squad = 1 DESC
0.0116  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (49167) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0111  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 (49167) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (215898,219551,123918,472623,306293,635480,104565,369276,653312,4886,20600,275395,286511,316138,316268,374670,381690,424629,448604,476338) ORDER BY rp.in_squad = 1 DESC
0.0108  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (49167) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0112  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 (49167) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (216536,365939,635505,4886,8497,110510,137706,139279,182783,212453,214298,219551,221646,249003,260812,267096,276232,277411,277451,279141) ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (49167) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0116  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 (49167) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0201  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 = 49167 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0106  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 = 49167 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0106  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=49167 AND rel.round=30
0.0106  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 = 49167 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 49167 AND esl.points > 0
0.0116  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-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 49167 ORDER BY creation_date DESC LIMIT 0, 10
0.0145  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-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 49167
0.0124  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 `calendars2019` 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` = 49167 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0111  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2019 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2019 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 49167 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (482659,482660,482661,482662,482663,482664,482665,482666) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0118  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 `events2019` e INNER JOIN calendars2019 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 49167 ORDER BY total DESC LIMIT 40
0.0112  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 `tables2019` 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 = 49167 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 49167 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT distinct(shedule), round FROM `calendars2019` as c WHERE c.`league_id` = 49167 AND shedule >= '2019/11/01' AND shedule < '2019/12/01' ORDER BY shedule ASC
0.0108  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-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 49167 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0108  SELECT data1, data2 FROM services_tags WHERE categoryId=239
0.0108  SELECT group_code, extraName from `leagues` WHERE categoryId=239 AND year=2019