Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

« Temporada Anterior

Temporada Siguiente »

2019/2020

National League 2020

National League

National League

Conference National

National League 2020

La temporada finalizó el Sábado, 25 Abril 2020.

	21 Mar 20 16:00 Aplazado	Hartlepool United	Hartlepool United - FC Halifax Town 2020-03-21T16:00:00 Victoria Park Apl	FC Halifax Town	más información ...
	21 Mar 20 16:00 Aplazado	Torquay United	Torquay United - Solihull Moors 2020-03-21T16:00:00 Plainmoor Ground Apl	Solihull Moors	más información ...
	21 Mar 20 16:00 Aplazado	Ebbsfleet United	Ebbsfleet United - Bromley 2020-03-21T16:00:00 Stonebridge Road Apl	Bromley	más información ...
	21 Mar 20 16:00 Aplazado	Wrexham AFC	Wrexham AFC - Boreham Wood 2020-03-21T16:00:00 Racecourse Ground Apl	Boreham Wood	más información ...
	21 Mar 20 16:00 Aplazado	Eastleigh	Eastleigh - Yeovil Town 2020-03-21T16:00:00 Silverlake Stadium Apl	Yeovil Town	más información ...
	21 Mar 20 16:00 Aplazado	Dagenham & Redbridge	Dagenham & Redbridge - Dover Athletic 2020-03-21T16:00:00 London Borough of Barking & Dagenham Stadium Apl	Dover Athletic	más información ...
	21 Mar 20 16:00 Aplazado	Aldershot Town	Aldershot Town - Woking 2020-03-21T16:00:00 Recreation Ground Apl	Woking	más información ...
	21 Mar 20 16:00 Aplazado	Barnet	Barnet - Sutton United 2020-03-21T16:00:00 The Hive Stadium Apl	Sutton United	más información ...
	21 Mar 20 16:00 Aplazado	Chesterfield	Chesterfield - Maidenhead United 2020-03-21T16:00:00 Proact Stadium Apl	Maidenhead United	más información ...
	21 Mar 20 16:00 Aplazado	Chorley	Chorley - Fylde 2020-03-21T16:00:00 Victory Park Apl	Fylde	más información ...
	24 Mar 20 20:45 Aplazado	Stockport County	Stockport County - Notts County 2020-03-24T20:45:00 Edgeley Park Apl	Notts County	más información ...
	01 Abr 20 20:45 Aplazado	Harrogate Town	Harrogate Town - Barrow 2020-04-01T20:45:00 CNG Stadium Apl	Barrow	más información ...

Equipos		Coeff	Puntos	J.	G.	E.	P.	F.	C.
1	Barrow	1.892	70	37	21	7	9	68	39	DERROTA Dover Athletic 2 Barrow 1 VICTORIA Barrow 1 Dover Athletic 0 EMPATE Sutton United 2 Barrow 2 VICTORIA Barrow 2 Dagenham & Redbrid. 1 DERROTA Barrow 0 Notts County 2
2	Harrogate Town	1.784	66	37	19	9	9	61	44	EMPATE Aldershot Town 1 Harrogate Town 1 VICTORIA Harrogate Town 3 Yeovil Town 0 VICTORIA Harrogate Town 3 Eastleigh 0 VICTORIA Chesterfield 3 Harrogate Town 4 EMPATE Harrogate Town 1 Bromley 1
3	Notts County	1.658	63	38	17	12	9	61	38	EMPATE Notts County 1 Woking 1 DERROTA Hartlepool United 2 Notts County 0 VICTORIA Barrow 0 Notts County 2 VICTORIA Notts County 3 Aldershot Town 1 VICTORIA Notts County 4 Eastleigh 0
4	Yeovil Town	1.622	60	37	17	9	11	61	44	EMPATE Yeovil Town 1 Chorley 1 DERROTA Harrogate Town 3 Yeovil Town 0 DERROTA Boreham Wood 1 Yeovil Town 0 VICTORIA Yeovil Town 3 Wrexham AFC 0 VICTORIA Dover Athletic 0 Yeovil Town 1
5	Boreham Wood	1.622	60	37	16	12	9	55	40	VICTORIA Boreham Wood 1 Yeovil Town 0 DERROTA Aldershot Town 3 Boreham Wood 2 EMPATE Boreham Wood 1 Hartlepool United 1 EMPATE Barnet 2 Boreham Wood 2 VICTORIA Maidenhead United 0 Boreham Wood 1
6	FC Halifax Town	1.568	58	37	17	7	13	50	49	VICTORIA FC Halifax Town 2 Bromley 1 DERROTA Torquay United 1 FC Halifax Town 0 VICTORIA FC Halifax Town 1 Sutton United 0 DERROTA FC Halifax Town 0 Woking 2 DERROTA FC Halifax Town 0 Ebbsfleet United 1
7	Barnet	1.543	54	35	14	12	9	52	42	DERROTA Solihull Moors 1 Barnet 0 VICTORIA Chorley 0 Barnet 1 EMPATE Barnet 2 Boreham Wood 2 EMPATE Stockport County 1 Barnet 1 VICTORIA Woking 1 Barnet 3
8	Stockport County	1.487	58	39	16	10	13	51	54	VICTORIA Stockport County 1 Bromley 0 EMPATE Woking 1 Stockport County 1 VICTORIA Ebbsfleet United 0 Stockport County 1 EMPATE Stockport County 1 Barnet 1 VICTORIA Maidenhead United 1 Stockport County 2
9	Solihull Moors	1.447	55	38	15	10	13	48	37	VICTORIA Solihull Moors 1 Barnet 0 DERROTA Dagenham & Redbrid. 2 Solihull Moors 0 VICTORIA Solihull Moors 3 Dover Athletic 0 DERROTA Solihull Moors 0 Hartlepool United 1 EMPATE Fylde 0 Solihull Moors 0
10	Woking	1.447	55	38	15	10	13	50	55	EMPATE Notts County 1 Woking 1 EMPATE Woking 1 Stockport County 1 VICTORIA Woking 2 Maidenhead United 0 VICTORIA FC Halifax Town 0 Woking 2 DERROTA Woking 1 Barnet 3
11	Dover Athletic	1.421	54	38	15	9	14	49	49	DERROTA Barrow 1 Dover Athletic 0 VICTORIA Dover Athletic 5 Fylde 1 DERROTA Solihull Moors 3 Dover Athletic 0 DERROTA Dover Athletic 0 Yeovil Town 1 EMPATE Dover Athletic 1 Chesterfield 1
12	Hartlepool	1.410	55	39	14	13	12	56	50	VICTORIA Hartlepool United 2 Notts County 0 EMPATE Boreham Wood 1 Hartlepool United 1 VICTORIA Solihull Moors 0 Hartlepool United 1 DERROTA Hartlepool United 0 Ebbsfleet United 1 EMPATE Sutton United 1 Hartlepool United 1
13	Bromley	1.368	52	38	14	10	14	57	52	EMPATE Bromley 2 Solihull Moors 2 DERROTA Stockport County 1 Bromley 0 DERROTA Bromley 0 Wrexham AFC 2 DERROTA Bromley 0 Sutton United 1 EMPATE Harrogate Town 1 Bromley 1
14	Torquay United	1.333	48	36	14	6	16	56	61	EMPATE Torquay United 0 Ebbsfleet United 0 DERROTA Barrow 2 Torquay United 1 VICTORIA Torquay United 1 FC Halifax Town 0 VICTORIA Torquay United 2 Chorley 0 DERROTA Sutton United 2 Torquay United 0
15	Sutton United	1.316	50	38	12	14	12	47	42	EMPATE Sutton United 2 Barrow 2 VICTORIA Bromley 0 Sutton United 1 DERROTA FC Halifax Town 1 Sutton United 0 VICTORIA Sutton United 2 Torquay United 0 EMPATE Sutton United 1 Hartlepool United 1
16	Eastleigh	1.243	46	37	11	13	13	43	55	EMPATE Eastleigh 2 Fylde 2 DERROTA Harrogate Town 3 Eastleigh 0 VICTORIA Chorley 1 Eastleigh 2 EMPATE Wrexham AFC 0 Eastleigh 0 DERROTA Notts County 4 Eastleigh 0
17	Dagenham	1.189	44	37	11	11	15	40	44	EMPATE Dagenham & Redbrid. 1 Stockport County 1 VICTORIA Dagenham & Redbrid. 2 Solihull Moors 0 DERROTA Barrow 2 Dagenham & Redbrid. 1 VICTORIA Aldershot Town 0 Dagenham & Redbrid. 1 DERROTA Dagenham & Redbrid. 1 Fylde 2
18	Aldershot Town	1.179	46	39	12	10	17	43	55	VICTORIA Maidenhead United 1 Aldershot Town 2 VICTORIA Aldershot Town 3 Boreham Wood 2 DERROTA Aldershot Town 0 Dagenham & Redbrid. 1 DERROTA Notts County 3 Aldershot Town 1 DERROTA Fylde 1 Aldershot Town 0
19	Wrexham AFC	1.162	43	37	11	10	16	46	49	EMPATE Wrexham AFC 0 Dagenham & Redbrid. 0 DERROTA Chesterfield 3 Wrexham AFC 2 VICTORIA Bromley 0 Wrexham AFC 2 DERROTA Yeovil Town 3 Wrexham AFC 0 EMPATE Wrexham AFC 0 Eastleigh 0
20	Chesterfield	1.158	44	38	11	11	16	55	65	VICTORIA Chesterfield 3 Wrexham AFC 2 VICTORIA Chesterfield 4 Ebbsfleet United 0 DERROTA Chesterfield 3 Harrogate Town 4 VICTORIA Chorley 1 Chesterfield 2 EMPATE Dover Athletic 1 Chesterfield 1
21	Maidenhead	1.079	41	38	12	5	21	44	58	DERROTA Maidenhead United 1 Aldershot Town 2 DERROTA Maidenhead United 1 Ebbsfleet United 3 DERROTA Woking 2 Maidenhead United 0 DERROTA Maidenhead United 0 Boreham Wood 1 DERROTA Maidenhead United 1 Stockport County 2
22	Ebbsfleet United	1.077	42	39	10	12	17	47	68	DERROTA Chesterfield 4 Ebbsfleet United 0 VICTORIA Maidenhead United 1 Ebbsfleet United 3 DERROTA Ebbsfleet United 0 Stockport County 1 VICTORIA Hartlepool United 0 Ebbsfleet United 1 VICTORIA FC Halifax Town 0 Ebbsfleet United 1
23	Fylde	1.054	39	37	9	12	16	44	60	EMPATE Eastleigh 2 Fylde 2 DERROTA Dover Athletic 5 Fylde 1 EMPATE Fylde 0 Solihull Moors 0 VICTORIA Dagenham & Redbrid. 1 Fylde 2 VICTORIA Fylde 1 Aldershot Town 0
24	Chorley	0.684	26	38	4	14	20	31	65	DERROTA Ebbsfleet United 1 Chorley 0 DERROTA Chorley 0 Barnet 1 DERROTA Torquay United 2 Chorley 0 DERROTA Chorley 1 Eastleigh 2 DERROTA Chorley 1 Chesterfield 2

	Ascenso : Barrow
	Playoff Ascenso : Harrogate Town, Notts County, Yeovil Town, Boreham Wood, FC Halifax Town, Barnet
	Descenso : Maidenhead, Ebbsfleet United, Fylde, Chorley

JUGADORES DESTACADOS

RK		Nombre	Goles	Posición	Equipo
1		S. Quigley	20	DEL	Barrow
2		K. Tshimanga	19	DEL	Boreham Wood
3		J. Reid	18	DEL	Torquay United
4		J. Rooney	17	MED	Barrow
5		R. Murphy	17	DEL	Yeovil Town
6		J. Hyde	16	DEL	Woking
7		I. Effiong	16	DEL	Dover Athletic
8		H. Beautyman	15	MED	Sutton United
9		S. Akinola	15	DEL	Barnet
10		T. Marsh	14	DEL	Boreham Wood
11		G. Ugwu	13	DEL	Ebbsfleet United
12		J. Muldoon	13	DEL	Harrogate Town
13		Courtney Duffus	13	DEL	Yeovil Town
14		K. Wootton	13	DEL	Notts County
15		P. Mccallum	13	DEL	Solihull Moors
16		D. Whitehall	13	DEL	Maidenhead United
17		M. Cheek	13	DEL	Bromley
18		Kristian Dennis	12	DEL	Notts County
19		G. Toure	12	DEL	Hartlepool United
20		T. Barnett	11	DEL	Eastleigh

Busca la liga de tu equipo

Introduce el nombre de tu equipo y busca rápidamente su competición

NOTICIAS RELACIONADAS

Ver más noticias de la competicion»

Equipos de esta competición

24

INFORMACIÓN

Descripción

La Conference National es la quinta división de la liga inglesa. Son 24 equipos que se disputan una plaza de ascenso directo a la Football League Two y otra por los play-offs de ascenso del 2º al 5º en liga. Descienden cuatro equipos: 2 a Confernece North y otros dos a Confernece South.

USO DE MEMORIA

6,339,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.5837
Total Execution Time	0.5858

CADENA URL

/conference2020/grupo1/jornada40

GET DATOS

$_GET['/conference2020/grupo1/jornada40']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0107	SELECT type FROM routes WHERE alias = 'conference2020'
0.0218	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'conference' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0110	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 = 50119 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109	SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=102 ORDER BY l.group_code ASC
0.0110	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='2024' WHERE c.parentId=102 GROUP BY c.id ORDER BY c.order_id ASC
0.0105	SELECT type,rule FROM rules WHERE categoryId = 102 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-16 06:18:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-16 06:18:00' 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=4 AND last_update > '2024-04-16 06:18:00' 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=3 AND last_update > '2024-04-16 06:18:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'conference' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125	SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50119) 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 (50119) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (279400,280535,192089,101951,139482,209576,363966,70501,241511,205578,214949,240655,244134,246526,247614,524162,742029,57022,222880,114327) ORDER BY rp.in_squad = 1 DESC
0.0140	SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50119) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0121	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 (50119) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (388598,336343,209691,303351,348294,204667,212487,47540,56815,69318,189329,192918,208812,233911,244103,300193,310086,339742,524162,57317) ORDER BY rp.in_squad = 1 DESC
0.0116	SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50119) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0129	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 (50119) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (45507,9492,44025,127771,192918,203879,211448,336343,9578,13175,47175,56821,56828,65797,69315,101951,126627,139482,206219,208769) ORDER BY rp.in_squad = 1 DESC
0.0111	SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50119) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145	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 (50119) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0370	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 = 50119 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0108	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 = 50119 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0107	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=50119 AND rel.round=40
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 = 50119 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0108	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 = 50119 AND esl.points > 0
0.0117	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-17" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 50119 ORDER BY creation_date DESC LIMIT 0, 10
0.0114	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-17" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 50119
0.0186	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 `calendars2020` 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` = 50119 AND c.`round` = 40 ORDER BY shedule ASC LIMIT 200
0.0123	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 events2020 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2020 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 50119 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 (146333,146335,146336,146337,146339,146340,146341,146342,146343,146344,146338,146334) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0111	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 `events2020` e INNER JOIN calendars2020 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 = 40 AND e.real_date IS NOT NULL AND e.league_id = 50119 ORDER BY total DESC LIMIT 40
0.0121	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 `events2020` e INNER JOIN calendars2020 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 = 50119 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0122	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* `tables2020` 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 = 50119 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	SELECT * FROM tables_coeff WHERE `league_id` = '50119' AND `round` = '38'
0.0119	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` 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 = 50119 AND t.round = 40 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	SELECT * FROM tables_coeff WHERE `league_id` = '50119' AND `round` = '40'
0.0107	SELECT distinct(shedule), round FROM `calendars2020` as c WHERE c.`league_id` = 50119 AND shedule >= '2020/03/01' AND shedule < '2020/04/01' ORDER BY shedule ASC
0.0106	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-16 00:00:00' AND c.`shedule` < '2024-04-20 23:59:59' AND l.id = 50119 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0106	SELECT data1, data2 FROM services_tags WHERE categoryId=102
0.0106	SELECT group_code, extraName from `leagues` WHERE categoryId=102 AND year=2020