Segunda División B 2002

La temporada finalizó el Domingo, 19 Mayo 2002.
 
17 May 02
Finalizado
Coria CF Coria CF 1-2 Cádiz Cádiz más información Jugadas destacadas ...
0-1 14' Israel
84' Toni 1-1
1-2 88' Víctor García
 
19 May 02
Finalizado
Ciudad de Murcia Ciudad de Murcia 1-0 Granada Granada más información Jugadas destacadas ...
67' Leandro 1-0
 
19 May 02
Finalizado
Motril CF Motril CF 3-2 Dos Hermanas CF Dos Hermanas CF más información Jugadas destacadas ...
0-1 46' Fali
52' Raúl Martín 1-1
1-2 60' Utrilla
77' Nandi
84' Ortiz 2-2
90' Marín 3-2
 
19 May 02
Finalizado
Almería Almería 1-2 Mérida UD Mérida UD más información Jugadas destacadas ...
0-1 12' Edu Espada
0-2 64' Edu Espada
89' Orihuela 1-2
 
19 May 02
Finalizado
CD San Fernando CD San Fernando 2-4 AgD Ceuta AgD Ceuta más información Jugadas destacadas ...
0-1 24' Alexis
28' Orife 1-1
1-2 45' Alain
1-3 52' Pedro Ríos
1-4 58' Pedro Ríos
70' Orife 2-4
 
19 May 02
Finalizado
Algeciras CF Algeciras CF 2-1 Écija Balompié Écija Balompié más información Jugadas destacadas ...
0-1 24' Castillo
32' Armada 1-1
50' Armada 2-1
 
19 May 02
Finalizado
UD Melilla UD Melilla 4-0 FC Cartagena FC Cartagena más información Jugadas destacadas ...
16' Redondo 1-0
37' Nacho Garrido 2-0
46' José Carlos 3-0
54' José Carlos 4-0
 
19 May 02
Finalizado
Mallorca B Mallorca B 1-1 RB Linense RB Linense más información Jugadas destacadas ...
31' Amate
54' Quique Romero 1-0
1-1 77' Reyes
 
19 May 02
Finalizado
Sevilla At. Sevilla At. 3-1 Jerez Jerez más información Jugadas destacadas ...
47' Ordóñez 1-0
1-1 51' Iván
70' Arteaga 2-1
75' Arteaga 3-1
 
19 May 02
Finalizado
Diter Zafra Diter Zafra 1-2 Betis Deportivo Betis Deportivo más información Jugadas destacadas ...
53' Juanma 1-0
1-1 65' Arana
1-2 86' Tati Maldonado
Equipos Puntos J. G. E. P. F. C. Forma
1 Motril CF Motril CF 77 38 23 8 7 55 29
  • DERROTA
  • Motril CF 0
  • Mérida UD 2
  • EMPATE
  • FC Cartagena 0
  • Motril CF 0
  • VICTORIA
  • Motril CF 1
  • RB Linense 0
  • VICTORIA
  • Granada 1
  • Motril CF 2
  • VICTORIA
  • Motril CF 3
  • Dos Hermanas CF 2
2 AgD Ceuta AgD Ceuta 77 38 23 8 7 47 22
  • DERROTA
  • Cádiz 1
  • AgD Ceuta 0
  • EMPATE
  • AgD Ceuta 1
  • Jerez 1
  • VICTORIA
  • Sevilla At. 0
  • AgD Ceuta 1
  • VICTORIA
  • AgD Ceuta 2
  • Coria CF 0
  • VICTORIA
  • CD San Fernando 2
  • AgD Ceuta 4
3 Almería Almería 73 38 22 7 9 56 35
  • VICTORIA
  • Mallorca B 1
  • Almería 2
  • VICTORIA
  • Almería 3
  • UD Melilla 0
  • VICTORIA
  • Almería 2
  • Diter Zafra 0
  • DERROTA
  • Betis Deportivo 2
  • Almería 1
  • DERROTA
  • Almería 1
  • Mérida UD 2
4 Mérida UD Mérida UD 64 38 17 13 8 42 30
  • VICTORIA
  • Motril CF 0
  • Mérida UD 2
  • VICTORIA
  • Mérida UD 3
  • Ciudad de Murcia 2
  • VICTORIA
  • Mallorca B 0
  • Mérida UD 3
  • VICTORIA
  • Mérida UD 1
  • UD Melilla 0
  • VICTORIA
  • Almería 1
  • Mérida UD 2
5 Ciudad de Murcia Ciudad Murcia 60 38 18 6 14 39 38
  • VICTORIA
  • Ciudad de Murcia 1
  • Betis Deportivo 0
  • DERROTA
  • Mérida UD 3
  • Ciudad de Murcia 2
  • VICTORIA
  • Ciudad de Murcia 2
  • FC Cartagena 0
  • DERROTA
  • RB Linense 2
  • Ciudad de Murcia 0
  • VICTORIA
  • Ciudad de Murcia 1
  • Granada 0
6 Jerez Jerez 55 38 13 16 9 46 36
  • VICTORIA
  • Jerez 4
  • Écija Balompié 0
  • EMPATE
  • AgD Ceuta 1
  • Jerez 1
  • DERROTA
  • Jerez 0
  • Cádiz 1
  • DERROTA
  • Jerez 0
  • Diter Zafra 1
  • DERROTA
  • Sevilla At. 3
  • Jerez 1
7 Cádiz Cádiz 54 38 14 12 12 38 33
  • VICTORIA
  • Cádiz 1
  • AgD Ceuta 0
  • VICTORIA
  • Diter Zafra 0
  • Cádiz 1
  • VICTORIA
  • Jerez 0
  • Cádiz 1
  • VICTORIA
  • Cádiz 2
  • Sevilla At. 1
  • VICTORIA
  • Coria CF 1
  • Cádiz 2
8 Betis Deportivo Betis Deportivo 53 38 12 17 9 38 40
  • DERROTA
  • Ciudad de Murcia 1
  • Betis Deportivo 0
  • VICTORIA
  • Betis Deportivo 2
  • Mallorca B 1
  • DERROTA
  • UD Melilla 4
  • Betis Deportivo 0
  • VICTORIA
  • Betis Deportivo 2
  • Almería 1
  • VICTORIA
  • Diter Zafra 1
  • Betis Deportivo 2
9 Écija Balompié Écija Balompié 51 38 13 12 13 33 32
  • DERROTA
  • Jerez 4
  • Écija Balompié 0
  • EMPATE
  • Écija Balompié 1
  • Sevilla At. 1
  • VICTORIA
  • Coria CF 0
  • Écija Balompié 2
  • VICTORIA
  • Écija Balompié 1
  • CD San Fernando 0
  • DERROTA
  • Algeciras CF 2
  • Écija Balompié 1
10 Granada Granada 50 38 14 8 16 40 45
  • VICTORIA
  • Coria CF 1
  • Granada 3
  • EMPATE
  • Granada 1
  • CD San Fernando 1
  • DERROTA
  • Algeciras CF 3
  • Granada 2
  • DERROTA
  • Granada 1
  • Motril CF 2
  • DERROTA
  • Ciudad de Murcia 1
  • Granada 0
11 Sevilla At. Sevilla At. 45 38 10 15 13 29 30
  • EMPATE
  • Sevilla At. 0
  • Dos Hermanas CF 0
  • EMPATE
  • Écija Balompié 1
  • Sevilla At. 1
  • DERROTA
  • Sevilla At. 0
  • AgD Ceuta 1
  • DERROTA
  • Cádiz 2
  • Sevilla At. 1
  • VICTORIA
  • Sevilla At. 3
  • Jerez 1
12 FC Cartagena FC Cartagena 44 38 10 14 14 30 47
  • EMPATE
  • Algeciras CF 1
  • FC Cartagena 1
  • EMPATE
  • FC Cartagena 0
  • Motril CF 0
  • DERROTA
  • Ciudad de Murcia 2
  • FC Cartagena 0
  • DERROTA
  • FC Cartagena 0
  • Mallorca B 1
  • DERROTA
  • UD Melilla 4
  • FC Cartagena 0
13 Diter Zafra Diter Zafra 44 38 10 14 14 35 42
  • EMPATE
  • UD Melilla 0
  • Diter Zafra 0
  • DERROTA
  • Diter Zafra 0
  • Cádiz 1
  • DERROTA
  • Almería 2
  • Diter Zafra 0
  • VICTORIA
  • Jerez 0
  • Diter Zafra 1
  • DERROTA
  • Diter Zafra 1
  • Betis Deportivo 2
14 Algeciras CF Algeciras CF 44 38 10 14 14 26 33
  • EMPATE
  • Algeciras CF 1
  • FC Cartagena 1
  • EMPATE
  • RB Linense 0
  • Algeciras CF 0
  • VICTORIA
  • Algeciras CF 3
  • Granada 2
  • EMPATE
  • Dos Hermanas CF 0
  • Algeciras CF 0
  • VICTORIA
  • Algeciras CF 2
  • Écija Balompié 1
15 Mallorca B Mallorca B 43 38 11 10 17 44 45
  • DERROTA
  • Mallorca B 1
  • Almería 2
  • DERROTA
  • Betis Deportivo 2
  • Mallorca B 1
  • DERROTA
  • Mallorca B 0
  • Mérida UD 3
  • VICTORIA
  • FC Cartagena 0
  • Mallorca B 1
  • EMPATE
  • Mallorca B 1
  • RB Linense 1
16 UD Melilla UD Melilla 43 38 10 13 15 35 39
  • EMPATE
  • UD Melilla 0
  • Diter Zafra 0
  • DERROTA
  • Almería 3
  • UD Melilla 0
  • VICTORIA
  • UD Melilla 4
  • Betis Deportivo 0
  • DERROTA
  • Mérida UD 1
  • UD Melilla 0
  • VICTORIA
  • UD Melilla 4
  • FC Cartagena 0
17 RB Linense RB Linense 42 38 10 12 16 29 36
  • DERROTA
  • CD San Fernando 1
  • RB Linense 0
  • EMPATE
  • RB Linense 0
  • Algeciras CF 0
  • DERROTA
  • Motril CF 1
  • RB Linense 0
  • VICTORIA
  • RB Linense 2
  • Ciudad de Murcia 0
  • EMPATE
  • Mallorca B 1
  • RB Linense 1
18 Dos Hermanas CF Dos Hermanas CF 40 38 9 13 16 34 38
  • EMPATE
  • Sevilla At. 0
  • Dos Hermanas CF 0
  • DERROTA
  • Dos Hermanas CF 2
  • Coria CF 3
  • EMPATE
  • CD San Fernando 1
  • Dos Hermanas CF 1
  • EMPATE
  • Dos Hermanas CF 0
  • Algeciras CF 0
  • DERROTA
  • Motril CF 3
  • Dos Hermanas CF 2
19 CD San Fernando CD San Fernando 35 38 8 11 19 34 51
  • VICTORIA
  • CD San Fernando 1
  • RB Linense 0
  • EMPATE
  • Granada 1
  • CD San Fernando 1
  • EMPATE
  • CD San Fernando 1
  • Dos Hermanas CF 1
  • DERROTA
  • Écija Balompié 1
  • CD San Fernando 0
  • DERROTA
  • CD San Fernando 2
  • AgD Ceuta 4
20 Coria CF Coria CF 30 38 7 9 22 27 56
  • DERROTA
  • Coria CF 1
  • Granada 3
  • VICTORIA
  • Dos Hermanas CF 2
  • Coria CF 3
  • DERROTA
  • Coria CF 0
  • Écija Balompié 2
  • DERROTA
  • AgD Ceuta 2
  • Coria CF 0
  • DERROTA
  • Coria CF 1
  • Cádiz 2
Playoff Ascenso: Motril CF, AgD Ceuta, Almería, Mérida UD
Playoff Descenso: UD Melilla
Descenso: RB Linense, Dos Hermanas CF, CD San Fernando, Coria CF
JUGADORES DESTACADOS
RK Nombre Goles Posición Equipo
1 es Raul Sanchez 22 DEL Almería
2 es Iván 15 DEL Jerez
3 es Huegun 14 DEL Motril CF
4 ar Dezotti 13 DEL Granada
5 ar R. Zárate 12 DEL Ciudad de Murcia
6 es Marcelino 11 DEL AgD Ceuta
7 es Marín 11 DEL Motril CF
8 es Chico 11 DEL Mérida UD
9 es Tati Maldonado 10 DEL Betis Deportivo
10 es Pedro Ríos 10 DEL AgD Ceuta
11 es Honorio 10 MED Diter Zafra
12 es José Ortíz 9 MED Almería
13 es Orife 9 DEL CD San Fernando
14 es D. Güiza 9 DEL Mallorca B
15 es Ortiz 9 MED Motril CF
16 es Marcos 9 DEL FC Cartagena
17 es Ordóñez 9 DEL Sevilla At.
18 es Israel 9 DEL Cádiz
19 es Israel 9 DEL Diter Zafra
20 es Raúl Martín 8 MED Motril CF

La Segunda División B de España es también conocida como "Segunda B" o como "El Pozo" popularmente, se trata de la tercera división en importancia del fútbol español y es inmediatamente inferior a la Segunda División A.

Se celebra de forma anual desde 1977, e históricamente la temporada se desarrolla entre los meses de septiembre y junio.
Reglas de la competición
  • Si al terminar la jornada existe un empate entre dos equipos, se resolverá por la mayor diferencia de goles a favor, sumandos los pro y en contra según el resultados de los dos equipos jugados entre ellos; si así no se dilucidase, se decidirá también por el gol average en la competición, y de ser idéntico, resultará mejor clasificado el que hubiese marcado más tantos. 3)º Si la Igualdad no se resolviese a través de las disposiciones anteriores, se jugará un partido de desempate en la fecha, hora y campo neutral organizado por el órgano competente.
  • Si el empate se da entre más de dos equipos: a) Por la mejor puntuación de la que a cada uno corresponda a tenor de los resultados entre ellos, sin contar al resto de equipos de la liga. b)Por la mayor diferencia de goles a favor y en contra, considerando unicamente los equipos en situación de empate. c)Por el Gol avereage teniendo en cuenta todos los equipos del campeonato, y si sigue siendo identica el club con mayor número de goles marcados. d)En última instancia, En la divisiones Primera, Segunda, Segunda "B" y cualesquiera otras que se determine, si el eventual empate no se resolviese por las reglas anteriores, se decidirá en favor del club mejor clasificado con arreglo de los baremos del "juego limpio".
  • Si la Igualdad no se resolviese a través de las disposiciones anteriores, se jugará un partido de desempate en la fecha, hora y campo neutral organizado por el órgano competente.
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,202,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2405
Total Execution Time  0.2424
  CADENA URL  
/segundab2002/grupo4
  GET DATOS  
$_GET['/segundab2002/grupo4']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0021  SELECT type FROM routes WHERE alias = 'segundab2002'
0.0050  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segundab' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3 AND type_rel = 3
0.0364  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 3 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0041  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 (1307952,1269904,1267798,1247262,1200661) ORDER BY n.cover_points DESC, update_date DESC
0.0020  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 = 5522 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=3 ORDER BY l.group_code ASC
0.0019  SELECT type,rule FROM rules WHERE categoryId = 3 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 10:31:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 10:31:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 10:31:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 10:31:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segundab' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0089  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (5522) 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.0026  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 (5522) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (35674,269208,258444,269202,72062,258408,260659,268526,23504,27272,259617,23445,35356,217020,259625,259834,259836,260195,269219,35051) ORDER BY rp.in_squad = 1 DESC
0.0089  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (5522) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0023  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 (5522) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258444,260177,259300,259644,260342,269214,259697,268409,23499,259450,259623,268954,269723,269747,269787,29748,31211,258351,260504,260558) ORDER BY rp.in_squad = 1 DESC
0.0253  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (5522) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0037  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 (5522) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (269747,84875,257939,258669,259463,260908,268409,23504,34686,59898,79631,111550,257745,258021,258444,259300,259451,259584,259641,260177) ORDER BY rp.in_squad = 1 DESC
0.0116  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (5522) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0022  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 (5522) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  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 = 5522 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0022  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 = 5522 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0019  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=5522 AND rel.round=38
0.0019  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 = 5522 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  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 = 5522 AND esl.points > 0
0.0027  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 5522 ORDER BY creation_date DESC LIMIT 0, 10
0.0040  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 5522
0.0096  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 `calendars2002` 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` = 5522 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0019  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 events2002 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2002 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 5522 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 (13713,13704,13705,13706,13707,13708,13709,13710,13711,13712) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0027  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 `events2002` e INNER JOIN calendars2002 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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 5522 ORDER BY total DESC LIMIT 40
0.0053  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 `events2002` e INNER JOIN calendars2002 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 = 5522 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0038  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 `tables2002` 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 = 5522 AND t.round = 37 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 5522 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  SELECT distinct(shedule), round FROM `calendars2002` as c WHERE c.`league_id` = 5522 AND shedule >= '2002/05/01' AND shedule < '2002/06/01' ORDER BY shedule ASC
0.0022  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 5522 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=3
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=3 AND year=2002