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

FK Haskovo 2009

Temporada 2022/2023

TEMPORADA 2022/2023

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nesebar	38	84	32	83
2	Chernomorets	38	82	26	80
3	Gigant	38	69	28	78
4	Zagorets	38	64	19	76
5	Haskovo 2009	38	68	36	69
6	Rozova	38	66	29	68
7	Spartak	38	73	43	65
8	Lokomotiv	38	57	33	64
9	Asenovets	38	69	41	64
10	Yambol 1915	38	57	48	57
11	Rodopa	38	51	48	55
12	Dimitrovgrad	38	52	54	52
13	Sokol	38	54	58	48
14	Levski	38	45	69	42
15	Karnobat	38	37	57	41
16	Beroe Stara	38	45	74	37
17	FK Sliven	38	58	93	36
18	Atletik	38	37	83	36
19	Borislav	38	34	92	21
20	Vereya	38	24	163	6

TEMPORADA 2021/2022

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Levski	34	112	16	86
2	Haskovo 2009	34	65	17	74
3	Zagorets	34	70	30	68
4	Chernomorets	34	53	28	67
5	Asenovets	34	61	45	62
6	Nesebar	34	61	46	55
7	Levski	34	47	41	53
8	Rodopa	34	47	39	50
9	Gigant	34	35	39	46
10	Dimitrovgrad	34	41	47	45
11	Atletik	34	39	55	39
12	Rozova	34	50	68	37
13	Lokomotiv	34	42	54	34
14	Karnobat	34	36	79	32
15	Sokol	34	38	74	30
16	Beroe Stara	34	38	69	29
17	Borislav	34	45	84	29
18	Yambol 1915	34	18	67	26

TEMPORADA 2014/2015

LIGA BULGARIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	10	30	8	56
2	Cherno More	10	16	12	50
3	Slavia Sofia	10	16	8	43
4	Lokomotiv	10	15	16	32
5	Marek	10	6	26	20
6	Haskovo 2009	10	6	19	15

TEMPORADA 2013/2014

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Marek	26	40	17	54
2	Haskovo 2009	26	35	20	46
3	Dobrudzha	26	33	20	46
4	Montana	26	36	24	44
5	Bansko	26	40	24	42
6	Botev Vratsa	26	32	23	38
7	Pirin Razlog	26	30	43	36
8	Spartak	26	24	29	34
9	Rakovski	26	28	35	32
10	Vitosha	26	22	24	28
11	Kaliakra	26	23	34	28
12	Botev	26	20	31	28
13	Dunav Ruse	26	24	32	27
14	Akademik	26	12	43	15

TEMPORADA 2012/2013

TERCERA BULGARIA V AFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Botev	34	56	17	73
2	Haskovo 2009	34	62	25	69
3	Master	34	53	25	67
4	Svilengrad	34	62	34	63
5	Vereya	34	47	29	60
6	Nesebar	34	58	31	58
7	Asenovets	34	58	45	55
8	Spartak	34	45	37	52
9	Sozopol	34	51	32	51
10	Tundzha	34	60	56	50
11	Levski	34	52	53	50
12	Gigant	34	42	39	45
13	Rozova	34	34	51	42
14	Dimitrovgrad	34	36	47	41
15	Zagorets	34	30	41	38
16	Brestnik	34	35	92	27
17	Hebros	34	20	76	16
18	Arda	34	10	81	9

TEMPORADA 2009/2010

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ravda 1954	36	111	20	96
2	Maritsa	36	101	25	96
3	Neftochimik	36	89	28	77
4	Botev	36	58	28	64
5	Levski	36	54	28	62
6	Sozopol	36	58	33	62
7	Stambolovo	36	47	35	56
8	Arda	36	42	38	56
9	Hebros	36	52	41	55
10	Tundzha	36	75	67	54
11	Gigant	36	51	43	54
12	Zagorets	36	50	60	43
13	Rozova	36	54	76	40
14	Dimitrovgrad	36	43	57	38
15	Strandzha-Me	36	39	71	37
16	Metalik	36	46	90	37
17	Gabrovnitsa	36	33	98	24
18	Tundzha	36	20	105	17
19	Haskovo 2009	36	10	90	14

TEMPORADA 2008/2009

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Brestnik	36	82	24	85
2	Tundzha	36	76	39	81
3	Pomorie	35	73	19	73
4	Chernomorec	36	79	27	69
5	Stambolovo	36	68	42	64
6	Rozova	36	64	49	54
7	Botev	36	49	37	53
8	Levski	36	54	58	53
9	Sozopol	36	47	51	51
10	Gigant	36	55	56	50
11	Gorubso	36	46	47	48
12	Arda	36	51	61	45
13	Kosmos	36	51	63	44
14	Asenovets	36	49	61	44
15	Hebros	36	28	39	40
16	Metalik	36	36	87	37
17	Haskovo 2009	35	36	78	35
18	Tundzha	36	38	89	28
19	Strandzha-Me	36	25	80	23

TEMPORADA 2007/2008

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sliven	26	63	23	60
2	Kaliakra	26	49	17	54
3	Rodopa	26	44	18	53
4	Nesebar	26	43	29	50
5	Dunav Ruse	26	35	28	42
6	Spartak	26	28	34	35
7	Maritsa	26	34	41	35
8	Chernomorets	26	40	35	34
9	Panayot	26	23	35	31
10	Svetkavitsa	26	26	46	28
11	Minyor	26	32	50	26
12	Svilengrad	26	30	43	25
13	Benkovski	26	26	41	22
14	Haskovo 2009	26	24	57	21

TEMPORADA 2006/2007

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chernomoretz	26	57	20	63
2	Chernomorets	26	51	10	60
3	Haskovo 2009	26	38	27	43
4	Nesebar	26	40	32	40
5	Dunav Ruse	26	46	35	39
6	Spartak	26	32	28	38
7	Panayot	26	29	36	37
8	Kaliakra	26	25	31	36
9	Svetkavitsa	26	36	41	34
10	Maritsa	26	35	36	32
11	Minyor	26	34	45	25
12	Sliven	26	32	52	23
13	Dobrudzha	26	25	51	20
14	Lokomotiv	26	22	58	13

TEMPORADA 2005/2006

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Spartak	26	34	12	56
2	Maritsa	26	41	21	49
3	Haskovo 2009	26	37	19	48
4	Spartak	26	32	26	43
5	AKB Minyor	26	30	32	39
6	Dunav Ruse	26	27	35	36
7	Dobrudzha	26	27	26	34
8	Nesebar	26	37	37	34
9	Panayot	26	32	33	34
10	Svetkavitsa	26	27	26	33
11	Kaliakra	26	27	36	32
12	Sliven	26	22	30	31
13	Pomorie	26	22	38	24
14	Zagorets	26	21	45	16

TEMPORADA 2000/2001

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Spartak	32	92	25	81
2	Marek	32	54	17	68
3	Pirin	32	48	21	61
4	Lokomotiv	32	55	39	58
5	Dobrudzha	32	52	37	57
6	Nesebar	32	51	36	54
7	Svetkavitsa	32	47	36	54
8	Vidima-Rakov	32	53	36	52
9	Botev Vratsa	32	56	57	46
10	Belasitsa	32	37	31	44
11	Dunav Ruse	32	35	38	41
12	Akademik	32	37	37	38
13	Septemvri	32	39	47	37
14	Metalurg	32	36	51	36
15	Haskovo 2009	32	32	60	33
16	Bdin	31	18	96	10
17	Dorostol	31	10	88	1
18	Panayot	0	0	0	0

TEMPORADA 1992/1993

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	76	27	72
2	CSKA Sofia	30	66	31	59
3	Botev	30	55	33	54
4	Lokomotiv	30	57	29	53
5	Etar	30	37	36	48
6	Lokomotiv	30	52	39	46
7	Pirin	30	33	32	46
8	Chernomoretz	30	33	31	41
9	Gorna	30	31	37	39
10	Beroe	30	29	35	38
11	Yantra	30	38	52	36
12	Spartak	30	30	48	32
13	Dobrudzha	30	32	57	31
14	Slavia Sofia	30	39	56	29
15	Haskovo 2009	30	32	66	23
16	Sliven	30	27	58	19

TEMPORADA 1990/1991

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Etar	30	49	21	62
2	CSKA Sofia	30	51	28	51
3	Slavia Sofia	30	48	29	51
4	Lokomotiv	30	50	36	49
5	Botev	30	49	41	49
6	Levski Sofia	30	51	38	45
7	Gorna	30	42	39	42
8	Chernomoretz	30	41	50	41
9	Pirin	30	38	40	37
10	Beroe	30	38	41	37
11	Minyor	30	36	44	37
12	Lokomotiv	30	34	42	36
13	Sliven	30	39	49	35
14	Yantra	30	31	44	35
15	Dunav Ruse	30	23	42	30
16	Haskovo 2009	30	27	63	24

TEMPORADA 1983/1984

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	64	29	66
2	Haskovo 2009	60	65	109	64
3	CSKA Sofia	30	72	24	63
4	Spartak	30	41	37	44
5	Chernomoretz	30	43	47	43
6	Beroe	30	38	40	42
7	Lokomotiv	30	35	29	41
8	Etar	30	47	48	41
9	Botev	30	64	58	40
10	Botev Vratsa	30	32	31	40
11	Sliven	30	38	38	40
12	Belasitsa	30	25	49	38
13	Slavia Sofia	30	40	38	35
14	Cherno More	30	36	43	35
15	Lokomotiv	30	43	63	34

TEMPORADA 1982/1983

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	30	52	26	63
2	Levski Sofia	30	50	21	60
3	Botev	30	62	40	54
4	Spartak	30	46	40	44
5	Lokomotiv	30	39	40	44
6	Botev Vratsa	30	38	35	43
7	Sliven	30	46	45	43
8	Etar	30	38	41	42
9	Spartak	30	36	38	41
10	Belasitsa	30	43	54	41
11	Chernomoretz	30	41	47	40
12	Slavia Sofia	30	35	37	39
13	Cherno More	30	24	28	38
14	Haskovo 2009	30	34	41	31
15	Rozova	30	30	53	26
16	Pirin	30	26	54	26

TEMPORADA 1981/1982

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	30	73	27	69
2	Levski Sofia	30	71	32	66
3	Slavia Sofia	30	35	33	50
4	Cherno More	30	41	37	47
5	Chernomoretz	30	48	44	46
6	Lokomotiv	30	41	37	45
7	Botev	30	46	42	43
8	Spartak	30	40	40	42
9	Haskovo 2009	30	34	37	42
10	Belasitsa	30	32	43	38
11	Etar	30	46	48	37
12	Sliven	30	38	40	37
13	Marek	30	23	40	35
14	Botev Vratsa	30	23	41	29
15	Beroe	30	33	51	26
16	Akademik	30	23	55	23

TEMPORADA 1978/1979

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	54	29	61
2	CSKA Sofia	30	49	26	54
3	Slavia Sofia	30	52	33	52
4	Lokomotiv	30	35	22	51
5	Chernomoretz	30	45	43	47
6	Beroe	30	45	47	47
7	Marek	30	42	39	46
8	Botev	30	45	45	38
9	Pirin	30	37	39	38
10	Spartak	30	25	27	34
11	Botev Vratsa	30	36	42	34
12	Lokomotiv	30	35	43	34
13	Cherno More	30	29	40	34
14	Sliven	30	35	42	33
15	Akademik	30	27	50	28
16	Haskovo 2009	30	35	59	26

Competiciones que juega

Tercera Bulgaria V AFG Grupo 3

Pos	Equipos		Pts
1		Nesebar	83
2		Chernomorets 1919 Burgas	80
3		Gigant Saedinenie	78
4		Zagorets	76
5		FK Haskovo 2009	69
6		Rozova dolina	68
7		Spartak Plovdiv	65
8		Lokomotiv Plovdiv II	64
9		Asenovets	64
10		Yambol 1915	57
11		Rodopa Smolyan	55
12		Dimitrovgrad	52
13		Sokol Markovo	48
14		Levski Karlovo	42
15		Karnobat	41
16		Beroe Stara Zagora II	37
17		FK Sliven	36
18		Atletik Kuklen	36
19		Borislav 2009	21
20		Vereya	6

	Ascenso : Nesebar
	Playoff Descenso : Beroe Stara Zagora II, FK Sliven, Atletik Kuklen
	Descenso : Borislav 2009, Vereya

RIVALES EN Tercera Bulgaria.

USO DE MEMORIA

6,921,224 bytes

BENCHMARKS

Loading Time Base Classes	0.0017
Controller Execution Time ( Home / Category )	0.2325
Total Execution Time	0.2342

CADENA URL

/historico/Fk-Haskovo-2009

GET DATOS

$_GET['/historico/Fk-Haskovo-2009']

POST DATOS

No hay datos POST existentes

CONSULTAS (68)

0.0026	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Fk-Haskovo-2009' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0043	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Fk-Haskovo-2009' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0034	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0046	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 68509
0.0021	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12275 AND type_rel = 2
0.0021	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=238 AND type_rel = 3
0.0030	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 238 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0042	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 (77796,59747,55420,15539) ORDER BY n.cover_points DESC, update_date DESC
0.0051	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '12275' ORDER BY l.year DESC,cat.coefficient DESC
0.0038	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '12275' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0041	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '12275' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0034	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '12275' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 68509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=12275 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (68509,62807) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68509 AND teamId = 12275
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 12275
0.0031	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2023` 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 = 68509 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12275' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12275' and rp.type = 4
0.0020	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12275' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68509 WHERE rp.league_id = 68509 AND rp.teamId = 12275 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68509 WHERE rp.league_id = 68509 AND rp.teamId = 12275 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68509 WHERE rp.league_id = 68509 AND rp.teamId = 12275 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 12275 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0052	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* `tables2023` 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 = 68509 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.0032	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* `tables2022` 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 = 63579 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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* `tables2015` 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 = 3815 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2015` 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 = 11704 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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* `tables2014` 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 = 2454 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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* `tables2013` 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 = 24555 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables2010` 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 = 24623 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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* `tables2009` 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 = 24631 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `tables2008` 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 = 14023 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2007` 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 = 14022 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `tables2006` 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 = 14028 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables2001` 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 = 14039 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables1993` 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 = 26181 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `tables1991` 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 = 26189 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables1984` 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 = 26244 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables1983` 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 = 26245 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables1982` 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 = 26247 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables1979` 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 = 26259 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 68509 ORDER BY nameShow LIMIT 100

FK Haskovo 2009

FK Haskovo 2009

Selecciona un equipo

Competiciones que juega

Tercera Bulgaria V AFG Grupo 3

RIVALES EN Tercera Bulgaria.