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

Resultados de Fútbol

Marek

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	51	22	63
2	Septemvri	30	41	24	58
3	Marek	30	31	21	54
4	Montana	30	38	28	50
5	Dobrudzha	30	42	28	49
6	Yantra	30	35	32	44
7	Ludogorets	30	35	30	42
8	Spartak	30	27	27	42
9	Dunav Ruse	30	27	31	42
10	Strumska	30	28	28	41
11	Litex Lovech	30	25	29	41
12	CSKA 1948 S.	30	32	34	40
13	Belasitsa	30	33	29	37
14	Chernomorets	30	28	35	34
15	Sportist	30	28	39	33
16	Maritsa	30	28	46	28
17	Chernomorets	30	28	45	27
18	Bdin	30	12	41	18

TEMPORADA 2022/2023

TERCERA BULGARIA V AFG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Marek	10	14	6	43
2	Vihren	10	19	9	33
3	Kyustendil	10	12	12	29
4	Chavdar	10	11	12	28
5	Bansko	9	11	12	21
6	CSKA Sofia	9	15	15	19
7	Slivnishki	10	12	13	19
8	Balkan	10	19	21	19
9	Kostinbrod	10	9	17	18
10	Septemvri	10	9	14	17

TEMPORADA 2021/2022

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Septemvri	36	77	35	70
2	Spartak	36	64	39	70
3	Hebar	36	54	33	70
4	Etar	36	69	42	68
5	Minyor	36	50	35	63
6	Ludogorets	36	70	48	61
7	Montana	36	39	31	58
8	Strumska	36	40	37	54
9	Maritsa	36	51	48	50
10	Sportist	36	38	46	48
11	CSKA 1948 S.	36	53	50	45
12	Dobrudzha	36	39	45	45
13	Litex Lovech	36	41	42	45
14	Yantra	36	30	46	40
15	Sozopol	36	40	56	39
16	Botev	36	34	47	38
17	Marek	36	29	46	36
18	Septemvri	36	41	68	33
19	Levski 2020	36	12	77	8
20	Neftochimik	0	0	0	0

TEMPORADA 2020/2021

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Marek	34	84	24	82
2	Kyustendil	34	63	14	82
3	Belasitsa	34	68	27	78
4	Vihren	34	63	25	75
5	Oborishte	34	55	41	60
6	Balkan	34	62	34	58
7	Chavdar	34	62	46	51
8	Botev	34	53	41	46
9	Pirin Gotse	34	37	32	45
10	Pirin Razlog	34	40	59	41
11	Slivnishki	34	38	44	36
12	Nadezhda	34	40	56	36
13	Rilski	34	30	45	34
14	Bansko	34	28	47	34
15	Levski	34	34	72	34
16	Granit	34	34	65	32
17	Perun	34	25	77	22
18	Velbazhd	34	16	83	16

TEMPORADA 2019/2020

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Minyor	18	34	6	42
2	Septemvri	17	31	11	41
3	Sportist	18	31	21	37
4	Vihren	18	29	14	37
5	Oborishte	18	30	10	34
6	Kyustendil	18	27	17	32
7	Slivnishki	18	27	22	27
8	Bansko	17	26	18	26
9	Chavdar	18	30	26	23
10	Belasitsa	18	21	26	22
11	Botev	18	14	24	22
12	Nadezhda	18	28	35	18
13	Pirin Razlog	18	12	22	17
14	Marek	18	19	39	16
15	Balkan	18	16	33	15
16	Rilski	18	13	33	11
17	Perun	18	9	40	7

TEMPORADA 2018/2019

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hebar	34	73	19	90
2	Oborishte	34	60	27	75
3	Vihren	34	52	35	62
4	Slivnishki	34	60	35	58
5	Minyor	34	57	37	58
6	Bansko	34	56	37	57
7	Pirin Razlog	34	47	35	51
8	Rilski	34	47	42	49
9	Belasitsa	34	43	37	46
10	Marek	34	35	37	41
11	Chavdar	34	54	47	40
12	Septemvri	34	34	36	40
13	Balkan	34	41	57	38
14	Sportist	34	45	61	37
15	Nadezhda	34	40	61	37
16	Botev	34	35	75	32
17	Germaneya	34	36	70	30
18	Velbazhd	34	22	89	8

TEMPORADA 2017/2018

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CSKA 1948 S.	34	95	16	92
2	Hebar	34	72	24	84
3	Vihren	34	70	49	62
4	Minyor	34	53	42	54
5	Bansko	34	48	34	53
6	Chavdar	34	63	49	52
7	Septemvri	34	46	37	50
8	Slivnishki	34	50	41	46
9	Belasitsa	34	40	46	42
10	Balkan	34	49	60	41
11	Botev	34	41	64	40
12	Pirin Razlog	34	40	40	38
13	Svoboda	34	37	59	38
14	Marek	34	35	48	37
15	Rilski	34	40	51	36
16	Germaneya	34	38	63	35
17	Pirin Gotse	34	27	66	32
18	Elin Pelin	34	34	89	21

TEMPORADA 2016/2017

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Strumska	34	76	20	78
2	Septemvri	34	62	28	72
3	Minyor	34	58	37	68
4	Slivnishki	34	69	39	59
5	Belasitsa	34	52	34	59
6	Hebar	34	68	41	58
7	Chavdar	34	60	46	53
8	Marek	34	51	50	52
9	Rilski	34	53	61	43
10	Pirin Gotse	34	45	41	42
11	Pirin Razlog	34	36	55	41
12	Balkan	34	54	55	40
13	Germaneya	34	52	52	38
14	Botev	34	49	72	38
15	Svoboda	34	36	75	37
16	Vihren	34	36	46	37
17	Velbazhd	34	44	63	32
18	Chepinets	34	33	119	18

TEMPORADA 2014/2015

LIGA BULGARIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ludogorets	22	46	14	47
2	CSKA Sofia	22	39	15	44
3	Litex Lovech	22	37	24	39
4	Lokomotiv	22	29	24	39
5	Beroe	22	34	21	38
6	Botev	22	32	26	36
7	Levski Sofia	22	36	25	34
8	Cherno More	22	26	24	31
9	Slavia Sofia	22	24	30	23
10	Lokomotiv	22	13	36	20
11	Marek	22	8	45	14
12	Haskovo 2009	22	12	52	7

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 3
Equipo		PJ	GF	GC	Puntos
1	Marek	30	70	13	72
2	Vitosha	30	52	10	71
3	Pirin	30	69	26	62
4	Slivnishki	30	44	18	57
5	Oborishte	30	49	30	54
6	Strumska	30	41	26	49
7	Perun	30	36	37	41
8	Velbazhd	30	29	32	40
9	Germaneya	30	33	48	38
10	Chepinets	30	37	44	37
11	Mesta	30	32	42	36
12	Botev	30	29	38	32
13	Vitosha	30	25	52	30
14	Septemvri	30	27	60	25
15	Rilski	30	28	71	22
16	Minyor Bobov	30	12	66	11

TEMPORADA 2011/2012

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Pirin Razlog	36	93	20	93
2	Perun	36	83	20	89
3	Rilski	36	66	29	68
4	Oborishte	36	76	35	67
5	Marek	36	62	31	63
6	Vitosha	36	53	36	61
7	Velbazhd	36	57	54	57
8	Germaneya	36	50	51	52
9	Chepinets	36	68	50	49
10	Belasitsa	36	54	47	48
11	Mesta	36	51	51	46
12	Kostinbrod	36	42	50	46
13	Septemvri	36	38	49	44
14	Hebar 2011	71	61	218	43
15	Minyor Bobov	36	45	62	42
16	Vitosha	36	48	68	42
17	Strumska	36	44	63	36
18	Levski Elin	35	28	85	20
19	Balkan	0	0	0	0

TEMPORADA 2009/2010

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vidima-Rakov	30	53	32	60
2	Bansko	30	50	22	59
3	Akademik	30	49	37	59
4	Vihren	30	45	24	56
5	Etar	30	47	38	47
6	Botev Vratsa	30	39	26	45
7	Septemvri	30	40	34	43
8	Chavdar	30	34	32	43
9	Balkan	30	35	28	41
10	Marek	30	36	36	41
11	Pirin Gotse	30	35	38	40
12	Kom-Minyor	30	36	43	38
13	Botev	30	21	40	31
14	Rilski	30	32	49	30
15	Bdin	30	26	48	20
16	Belite Orli	30	20	71	10

TEMPORADA 2008/2009

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Montana	30	63	21	70
2	Sportist	30	54	25	63
3	Bansko	30	52	23	60
4	Chavdar	30	45	30	54
5	Balkan	30	38	34	49
6	Rilski	30	34	39	49
7	Vidima-Rakov	30	31	25	43
8	Akademik	30	39	35	42
9	Pirin Gotse	30	48	39	40
10	Botev	30	32	46	38
11	Kom-Minyor	30	32	47	33
12	Belite Orli	30	27	43	29
13	Etar	30	36	45	28
14	Marek	30	29	48	28
15	Chavdar	30	31	41	26
16	Spartak	30	10	60	14

TEMPORADA 2007/2008

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	30	53	11	78
2	Levski Sofia	30	56	19	62
3	Lokomotiv	30	47	28	57
4	Litex Lovech	30	51	26	56
5	Cherno More	30	39	28	48
6	Slavia Sofia	30	38	28	47
7	Chernomoretz	30	39	32	47
8	Pirin	30	32	29	46
9	Lokomotiv	30	37	28	43
10	Vihren	30	26	29	33
11	Spartak	30	21	33	31
12	Botev	30	36	54	30
13	Beroe	30	23	39	26
14	Belasitsa	30	23	43	26
15	Vidima-Rakov	30	17	61	18
16	Marek	30	16	66	18

TEMPORADA 2006/2007

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	96	13	77
2	CSKA Sofia	30	68	13	72
3	Lokomotiv	30	70	28	72
4	Litex Lovech	30	65	29	62
5	Slavia Sofia	30	47	35	49
6	Cherno More	30	35	29	47
7	Lokomotiv	30	48	43	43
8	Belasitsa	30	38	43	38
9	Botev	30	41	45	37
10	Vihren	30	27	39	37
11	Beroe	30	34	33	36
12	Marek	30	39	57	34
13	Spartak	30	27	52	33
14	Rilski	30	31	53	30
15	Rodopa	30	22	52	19
16	Chernomorets	30	7	131	0

TEMPORADA 2005/2006

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2004/2005

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	30	81	16	79
2	Levski Sofia	30	76	19	76
3	Lokomotiv	30	65	34	58
4	Litex Lovech	30	45	27	52
5	Slavia Sofia	30	43	33	48
6	Lokomotiv	30	43	35	46
7	Beroe	30	32	36	35
8	Cherno More	30	30	38	35
9	Marek	30	34	44	35
10	Neftochimik	30	24	38	35
11	Belasitsa	30	25	47	34
12	Pirin	30	31	40	33
13	Rodopa	30	33	43	33
14	Vidima-Rakov	30	32	51	32
15	Nesebar	30	25	63	20
16	Spartak	30	18	73	18

Competiciones que juega

Segunda Bulgaria B PFG

Pos	Equipos		Pts
1		Spartak Varna	63
2		Septemvri Sofia	58
3		Marek	54
4		Montana	50
5		Dobrudzha Dobrich	49
6		Yantra Gabrovo	44
7		Ludogorets II	42
8		Spartak Pleven	42
9		Dunav Ruse	42
10		Strumska Slava	41
11		Litex Lovech	41
12		CSKA 1948 Sofia II	40
13		Belasitsa	37
14		Chernomorets 1919 Burgas	34
15		Sportist Svoge	33
16		Maritsa Plovdiv	28
17		Chernomorets Balchik	27
18		Bdin	18

	Ascenso : Spartak Varna, Septemvri Sofia
	Playoff Ascenso : Marek
	Descenso : Sportist Svoge, Maritsa Plovdiv, Chernomorets Balchik, Bdin

RIVALES EN Copa Bulgaria

RIVALES EN Segunda Bulgaria.

USO DE MEMORIA

7,425,288 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1336
Total Execution Time	0.1348

CADENA URL

/historico/Marek

GET DATOS

$_GET['/historico/Marek']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11762 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=237 AND type_rel = 3
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 237 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	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 (856187,808709,15539) ORDER BY n.cover_points DESC, update_date DESC
0.0030	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 = '11762' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029	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=11762 AND l.year in (2023,2024,2025) 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 (73790,72088,71432,71263) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 72088 AND teamId = 11762
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 71263 AND teamId = 11762
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 11762
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11762
0.0020	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 = '11762' 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 = '11762' 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 = '11762' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033	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 events2024 e ON e.player_id = p.id AND e.league_id = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 11762 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.0030	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 events2024 e ON e.player_id = p.id AND e.league_id = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 11762 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 events2024 e ON e.player_id = p.id AND e.league_id = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 11762 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 11762 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039	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* `tables2024` 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 = 72088 AND t.round = 31 ORDER BY team.conference ASC,t.position 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* `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 = 68508 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 71263 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 63160 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.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* `tables2021` 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 = 57814 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.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* `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 = 51127 AND t.round = 19 ORDER BY team.conference ASC,t.position 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* `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 = 44690 AND t.round = 34 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* `tables2018` 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 = 39352 AND t.round = 34 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* `tables2017` 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 = 34149 AND t.round = 34 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* `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.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* `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.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* `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.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* `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 = 24564 AND t.round = 30 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* `tables2012` 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 = 24584 AND t.round = 38 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* `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 = 14032 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* `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 = 14031 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* `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 = 8791 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* `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 = 8789 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 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 = 8788 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* `tables2005` 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 = 8786 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Marek

Marek

Selecciona un equipo

Competiciones que juega

Segunda Bulgaria B PFG

RIVALES EN Copa Bulgaria

RIVALES EN Segunda Bulgaria.