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

Motema Pembe

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA REPÚBLICA DEL CONGO DR GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Blessing	1	1	0	3
2	Panda 05	0	0	0	0
3	Sanga	0	0	0	0
4	Simba	0	0	0	0
5	Tshinkunku	0	0	0	0
6	Groupe	1	0	1	0
7	Kuya Sport	1	3	1	3
8	Celeste FC	0	0	0	0
9	Etoile Kivu	0	0	0	0
10	Motema Pembe	0	0	0	0
11	Rangers	0	0	0	0
12	Renaissance	1	1	3	0

TEMPORADA 2022/2023

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	Vita Club	11	17	5	31
2	Saint-Eloi	11	24	11	25
3	Maniema	8	13	3	19
4	TP Mazembe	9	15	5	15
5	Motema Pembe	9	10	7	14
6	Celeste FC	9	9	8	14
7	JSK	9	6	5	13
8	Blessing	7	10	6	11
9	Tshinkunku	9	10	13	11
10	Rangers	11	8	13	11
11	Sanga	6	10	6	10
12	Bosco	8	7	12	10
13	Groupe	8	7	11	9
14	Lubumbashi	10	8	15	9
15	Panda 05	10	10	18	8
16	Simba	7	7	11	7
17	Etoile Kivu	7	5	10	7
18	Dauphins	7	3	6	6
19	Kuya Sport	10	11	16	6
20	Renaissance	8	3	12	2

TEMPORADA 2021/2022

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	19	40	3	51
2	Saint-Eloi	20	33	9	49
3	Vita Club	19	44	13	48
4	Maniema	18	28	10	38
5	Groupe	20	24	16	33
6	Bosco	20	21	16	33
7	Motema Pembe	19	23	15	29
8	Rangers	19	18	19	28
9	Panda 05	19	17	19	24
10	Sanga	21	18	26	23
11	Etoile Kivu	19	13	15	22
12	Lubumbashi	19	19	23	22
13	Dauphins	19	15	20	20
14	Blessing	19	13	16	19
15	Kuya Sport	19	18	28	19
16	Renaissance	19	17	27	18
17	Tshinkunku	19	11	26	15
18	Simba	19	10	29	14
19	JSK	19	6	36	8
20	RCK	19	10	32	7

TEMPORADA 2020/2021

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	29	54	14	66
2	Maniema	29	43	16	66
3	Vita Club	29	45	15	61
4	Saint-Eloi	30	31	19	52
5	Sanga	30	30	24	50
6	Motema Pembe	30	31	24	46
7	Blessing	30	25	27	39
8	Rangers	29	23	41	34
9	Bosco	30	28	32	33
10	Dauphins	30	28	34	32
11	Renaissance	30	27	42	31
12	Simba	30	29	45	31
13	JSK	29	22	27	29
14	Groupe	29	19	28	26
15	RCK	30	25	45	24
16	Lubumbashi	28	18	45	19

TEMPORADA 2019/2020

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	20	48	9	53
2	Vita Club	23	40	12	48
3	Maniema	20	41	15	43
4	Motema Pembe	20	37	16	39
5	Renaissance	23	32	26	37
6	Groupe	19	21	11	37
7	Rangers	25	27	28	29
8	Bosco	23	26	23	28
9	RCK	23	25	22	28
10	Lubumbashi	23	18	20	27
11	Saint-Eloi	22	24	25	24
12	Simba	22	15	31	22
13	Sanga	19	17	35	17
14	Dauphins	22	12	35	15
15	Bukavu	22	15	48	14
16	Nyuki	22	15	57	12

TEMPORADA 2018/2019

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	30	82	11	83
2	Vita Club	30	60	15	74
3	Motema Pembe	30	47	25	63
4	Maniema	28	40	20	56
5	Sanga	30	36	30	42
6	Nyuki	31	31	32	41
7	Saint-Eloi	29	25	25	40
8	Dauphins	30	30	40	40
9	Rangers	28	30	30	36
10	Bosco	29	34	36	35
11	Renaissance	28	25	37	35
12	Groupe	30	25	30	34
13	Lubumbashi	30	35	42	32
14	Mont Bleu	28	22	44	24
15	Dragons	29	12	50	14
16	Muungano	30	7	74	4

TEMPORADA 2017/2018

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	Renaissance	7	8	4	15
2	Vita Club	6	8	2	12
3	Motema Pembe	5	7	3	11
4	RCK	6	6	6	7
5	Dragons	5	5	6	6
6	FC MK	4	6	6	4
7	Nord Sport	4	3	5	4
8	Rangers	5	5	9	4
9	Molunge	4	0	7	1
10	Shark XI	0	0	0	0
11	Mont Bleu	6	10	8	11
12	Maniema	4	6	2	8
13	Virunga	5	7	4	8
14	Bukavu	6	3	4	8
15	Dauphins	4	5	3	7
16	Muungano	6	3	7	4
17	CS Makiso	3	3	5	3
18	Etoile Kivu	4	3	7	3
19	TP Mazembe	9	20	3	21
20	Saint-Eloi	7	10	5	14
21	Sanga	7	9	7	10
22	Dibumba	8	6	8	8
23	Ecofoot	6	4	6	8
24	Bosco	5	3	3	6
25	Tshinkunku	6	5	8	6
26	Groupe	4	2	4	4
27	Lubumbashi	5	3	6	4
28	Ocean	7	3	15	2

TEMPORADA 2016/2017

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	18	36	5	42
2	Sanga	18	31	8	42
3	Bosco	18	27	13	37
4	Saint-Eloi	18	18	18	25
5	Groupe	18	13	19	22
6	Lubumbashi	18	13	19	21
7	Simba	18	17	22	19
8	Ocean	18	16	27	19
9	Dibumba	18	13	27	17
10	New Soger	18	8	34	5
11	Dauphins	14	19	9	29
12	Bukavu	12	16	7	26
13	Muungano	10	12	3	20
14	Virunga	11	8	15	10
15	Nkoyi	10	9	14	7
16	CS Makiso	10	8	17	6
17	Nika	0	0	0	0
18	Capaco	3	1	8	0
19	Vita Club	18	37	9	43
20	Motema Pembe	17	34	8	38
21	Renaissance	21	30	17	34
22	RCK	17	27	22	29
23	Dragons	18	16	20	26
24	Shark XI	18	24	17	25
25	FC MK	18	18	23	21
26	Veti Club	17	11	23	18
27	Rojolu	17	11	26	9
28	Ndombe	17	12	55	4

TEMPORADA 2015/2016

LIGA REPÚBLICA DEL CONGO DR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	12	23	4	30
2	Vita Club	13	20	7	25
3	Motema Pembe	15	18	15	24
4	Sanga	14	17	10	21
5	Shark XI	13	15	14	16
6	Dauphins	12	7	15	12
7	Saint-Eloi	15	11	21	12
8	Muungano	14	6	31	5

TEMPORADA 2014/2015

LIGA REPÚBLICA DEL CONGO DR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Motema Pembe	9	12	5	22
2	Vita Club	8	16	2	21
3	Shark XI	9	11	5	15
4	Etanchéité	9	7	4	14
5	Groupe	9	7	6	13
6	RCK	9	7	8	12
7	CS Makiso	8	7	8	8
8	Rojolu	9	6	16	8
9	Elima	9	7	12	7
10	Nika	9	5	19	2

TEMPORADA 2013/2014

LIGA REPÚBLICA DEL CONGO DR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vita Club	14	26	6	37
2	Sanga	14	17	9	29
3	Lubumbashi	14	20	13	23
4	Motema Pembe	14	18	20	19
5	Shark XI	14	13	12	18
6	Rojolu	14	10	18	13
7	Muungano	14	9	18	12
8	Tshinkunku	14	11	28	7

TEMPORADA 2012/2013

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	13	38	4	35
2	Vita Club	13	28	5	32
3	Motema Pembe	13	20	7	24
4	Don Bosco	13	25	14	24
5	Sanga	13	18	11	24
6	Saint-Eloi	13	17	10	24
7	Tshinkunku	13	13	23	16
8	Dauphins	13	16	17	15
9	Rojolu	13	12	22	15
10	Muungano	13	11	13	12
11	CS Makiso	13	7	19	12
12	Molunge	13	14	28	9
13	Virunga	13	11	26	8
14	Elima	13	1	32	0

TEMPORADA 2011/2012

LIGA REPÚBLICA DEL CONGO DR
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	23	65	6	64
2	Vita Club	23	56	12	62
3	Motema Pembe	23	42	6	55
4	Sanga	23	33	17	39
5	Molunge	23	23	25	34
6	Elima	23	25	28	33
7	Muungano	23	26	26	32
8	Saint-Eloi	23	20	15	31
9	Virunga	23	22	35	25
10	Tshinkunku	23	14	39	20
11	CS Makiso	23	16	36	18
12	Vutuka	23	9	42	16
13	Saint Luc	23	17	40	14
14	Nkoy Kindu	23	10	51	12

TEMPORADA 2010/2011

LIGA REPÚBLICA DEL CONGO DR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	TP Mazembe	14	33	6	30
2	Vita Club	14	22	7	29
3	Saint-Eloi	14	14	11	22
4	RCK	14	15	21	22
5	Bosco	14	14	17	20
6	Motema Pembe	14	14	7	19
7	Elima	14	8	25	8
8	Malekesa	14	10	36	4

TEMPORADA 2009/2010

LIGA REPÚBLICA DEL CONGO DR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Malekesa	4	5	2	9
2	Virunga	4	3	3	7
3	Muungano	4	2	5	1
4	Vita Club	6	24	0	16
5	Veti Club	6	12	5	13
6	Molunge	6	5	13	6
7	Matiti Mabe	6	1	24	0
8	Nika	6	20	5	18
9	FC Ajax	5	9	7	7
10	AS Kabasha	6	15	13	6
11	Ndjadi	5	3	22	1
12	Saint-Eloi	4	13	0	12
13	Likasi	4	4	5	4
14	Bantous	4	2	14	1
15	Elima	6	11	2	18
16	Motema Pembe	6	13	6	12
17	Vutuka	6	7	11	6
18	Babeti AS	6	3	15	0
19	Sanga	6	7	3	13
20	New Soger	6	4	3	8
21	Olympic	6	4	5	8
22	Tshinkunku	6	2	6	4

Competiciones que juega

Grupo 1

Liga República del Congo DR Grupo 3

Pos	Equipos		Pts
1		Kuya Sport	3
2		Blessing	3
3		Celeste FC	0
4		Etoile de Kivu	0
5		Motema Pembe	0
6		Panda 05	0
7		Rangers	0
8		Sanga Balende	0
9		Simba	0
10		Tshinkunku	0
11		Groupe Bazano	0
12		Renaissance	0

	Descenso : Etoile de Kivu, Motema Pembe, Panda 05

RIVALES EN Liga República d.

USO DE MEMORIA

6,533,736 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.6757
Total Execution Time	0.6771

CADENA URL

/historico/Motema-Pembe

GET DATOS

$_GET['/historico/Motema-Pembe']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0137	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 = 'Motema-Pembe' 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.0125	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=15710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=15710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=15710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252	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 = 75248
0.0131	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 = 72768
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15710 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 15710 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0126	SELECT /35 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 (51107) ORDER BY n.cover_points DESC, update_date DESC
0.0129	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 = '15710' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 75248 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132	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=15710 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125	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 (75248,70741,70140) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 75248 AND teamId = 15710
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 70741 AND teamId = 15710
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 70140 AND teamId = 15710
0.0140	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 75248 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0138	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 = '15710' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15710' and rp.type = 4
0.0130	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 = '15710' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0130	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 = 75248 WHERE rp.league_id = 75248 AND rp.teamId = 15710 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.0127	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 = 75248 WHERE rp.league_id = 75248 AND rp.teamId = 15710 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 75248 WHERE rp.league_id = 75248 AND rp.teamId = 15710 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 15710 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132	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 = 72768 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 75248 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 70082 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 64302 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.0130	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 = 60011 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 51154 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 46941 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 42099 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 36097 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables2016` 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 = 22959 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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* `tables2016` 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 = 22975 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 10164 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 9495 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 9491 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 3250 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 16169 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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* `tables2011` 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 = 16171 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 16172 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1420 AND l.group_code = 3 ORDER BY l.year DESC

Motema Pembe

Motema Pembe

Selecciona un equipo

Competiciones que juega

Liga República del Congo DR Grupo 3

RIVALES EN Liga República d.