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

Fichajes

Fichajes Frosinone altas, bajas y rumores

Altas - Frosinone47

Carta Libertad E. Valeri
E. Valeri Bandera Defensa
Cremonese
Cesión Demba Seck
Demba Seck Bandera Delantero
Torino
Cesión Nadir Zortea
Nadir Zortea Bandera Defensa
Atalanta
Cesión Kevin Bonifazi
Kevin Bonifazi Bandera Defensa
Bologna
Traspaso F. Ghedjemis
F. Ghedjemis Bandera Delantero
FC Rouen 1899
Carta Libertad M. Lusuardi
M. Lusuardi Bandera Defensa
Criciúma Sub 20
Agente libre M. Avella
M. Avella Bandera Portero
Agente libre
Cesión Opc. Compra A. Ibrahimovic
A. Ibrahimovic Bandera Delantero
Bayern München
Carta Libertad M. Bourabia
M. Bourabia Bandera Centrocampista
Spezia
Cesión Caleb Okoli
Caleb Okoli Bandera Defensa
Atalanta
Cesión Reinier
Reinier Bandera Centrocampista
Real Madrid
Carta Libertad Andrea Errico
Andrea Errico Bandera Centrocampista
Frosinone Sub 19
Traspaso P. Frattali
P. Frattali Bandera Portero
SSC Bari
Cesión Kaio Jorge
Kaio Jorge Bandera Delantero
Juventus
Cesión Matías Soulé
Matías Soulé Bandera Delantero
Juventus
Cesión Pol Lirola
Pol Lirola Bandera Defensa
Olympique Marseille
Carta Libertad Daniel Macej
Daniel Macej Bandera Defensa
Frosinone Sub 19
Carta Libertad L. Palmisani
L. Palmisani Bandera Portero
Frosinone Sub 19
Carta Libertad M. Pahič
M. Pahič Bandera Defensa
Frosinone Sub 19
Traspaso Justin Ferizaj
Justin Ferizaj Bandera Centrocampista
Shamrock Rovers
Cesión W. Cheddira
W. Cheddira Bandera Delantero
Napoli
Cesión E. Barrenechea
E. Barrenechea Bandera Centrocampista
Juventus
Traspaso M. Cerofolini
M. Cerofolini Bandera Portero
Fiorentina
Fin de cesión Thomas Vettorel
Thomas Vettorel Bandera Portero
Monopoli
Fin de cesión P. Luciani
P. Luciani Bandera Delantero
ACR Messina
Traspaso S. Romagnoli
S. Romagnoli Bandera Defensa
Lecce
Traspaso I. Monterisi
I. Monterisi Bandera Defensa
Lecce
Traspaso Abdou Harroui
Abdou Harroui Bandera Centrocampista
Sassuolo
Traspaso R. Marchizza
R. Marchizza Bandera Defensa
Sassuolo
Cesión S. Turati
S. Turati Bandera Portero
Sassuolo
Carta Libertad Gabriele Bracaglia
Gabriele Bracaglia Bandera Defensa
Frosinone Sub 19
Traspaso M. Brescianini
M. Brescianini Bandera Centrocampista
Milan
Fin de cesión F. Bevilacqua
F. Bevilacqua Bandera Defensa
Pergolettese
Cesión G. Kvernadze
G. Kvernadze Bandera Delantero
Kolkheti Poti
Carta Libertad Marvin Çuni
Marvin Çuni Bandera Delantero
Bayern München II
Fin de cesión L. Canotto
L. Canotto Bandera Delantero
Reggina
Fin de cesión M. Bozic
M. Bozic Bandera Defensa
Maribor
Traspaso Gennaro Borrelli
Gennaro Borrelli Bandera Delantero
Pescara
Traspaso L. Mazzitelli
L. Mazzitelli Bandera Centrocampista
AC Monza
Fin de cesión Milan Kremenovic
Milan Kremenovic Bandera Defensa
Dekani
Fin de cesión M. Volpe
M. Volpe Bandera Delantero
Juve Stabia
Fin de cesión S. Stampete
S. Stampete Bandera Delantero
Recanatese
Fin de cesión G. Manzari
G. Manzari Bandera Delantero
Monopoli
Fin de cesión A. Satariano
A. Satariano Bandera Delantero
Balzan FC
Fin de cesión P. Luciani
P. Luciani Bandera Delantero
Siena
Fin de cesión Lukas Klitten
Lukas Klitten Bandera Defensa
Silkeborg IF
Fin de cesión M. Ricci
M. Ricci Bandera Centrocampista
Fatih Karagümrük

Bajas - Frosinone37

Traspaso M. Bourabia
M. Bourabia Centrocampista
Kayserispor
Fin de cesión Kevin Bonifazi
Kevin Bonifazi Defensa
Bologna
Cesión M. Avella
M. Avella Portero
Brescia
Traspaso K. Lulić
K. Lulić Centrocampista
SSC Bari
Libre Milan Kremenovic
Milan Kremenovic Defensa
Libre
Libre S. Stampete
S. Stampete Delantero
Libre
Cesión Hamza Haoudi
Hamza Haoudi Centrocampista
Pro Vercelli
Cesión Gennaro Borrelli
Gennaro Borrelli Delantero
Brescia
Carta Libertad Lukas Klitten
Lukas Klitten Defensa
Hobro
Cesión Opc. Compra L. Canotto
L. Canotto Delantero
Cosenza
Cesión P. Szyminski
P. Szyminski Defensa
Reggiana
Libre M. Volpe
M. Volpe Delantero
Libre
Cesión L. Palmisani
L. Palmisani Portero
Olbia Calcio
Fin de cesión Gennaro Borrelli
Gennaro Borrelli Delantero
Pescara
Cesión Kalifa Kujabi
Kalifa Kujabi Centrocampista
Sassari Torres
Fin de cesión M. Sampirisi
M. Sampirisi Defensa
AC Monza
Fin de cesión L. Mazzitelli
L. Mazzitelli Centrocampista
AC Monza
Carta Libertad Marcus Rohden
Marcus Rohden Centrocampista
Fatih Karagümrük
Cesión P. Luciani
P. Luciani Delantero
ACR Messina
Fin de cesión B. Kone
B. Kone Centrocampista
Torino
Carta Libertad Thomas Vettorel
Thomas Vettorel Portero
AS Gubbio 1910
Fin de cesión Milos Bocic
Milos Bocic Delantero
Pescara
Traspaso Daniel Boloca
Daniel Boloca Centrocampista
Sassuolo
Fin de cesión S. Turati
S. Turati Portero
Sassuolo
Fin de cesión Andrea Oliveri
Andrea Oliveri Defensa
Atalanta
Traspaso R. Insigne
R. Insigne Delantero
Palermo FC
Carta Libertad M. Ricci
M. Ricci Centrocampista
Sampdoria
Libre A. Satariano
A. Satariano Delantero
Libre
Libre G. Marcianò
G. Marcianò Portero
Libre
Carta Libertad M. Cotali
M. Cotali Defensa
Modena
Traspaso M. Bozic
M. Bozic Defensa
Maribor
Libre L. Matarese
L. Matarese Delantero
Libre
Fin de cesión G. Manzari
G. Manzari Delantero
Sassuolo
Fin de cesión L. Moro
L. Moro Delantero
Sassuolo
Fin de cesión I. Monterisi
I. Monterisi Defensa
Lecce
Fin de cesión F. Lucioni
F. Lucioni Defensa
Lecce
Fin de cesión S. Turati
S. Turati Portero
Sassuolo

Rumores - Frosinone0



  USO DE MEMORIA  
10,220,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Budget / Index )  0.6913
Total Execution Time  0.6930
  CADENA URL  
/fichajes/equipo/frosinone-calcio
  GET DATOS  
$_GET['/fichajes/equipo/frosinone-calcio']  
$_GET['league']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (57)  
0.0096  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 = 'frosinone-calcio' 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.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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 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=1174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024   SELECT dt.id as teamId, t.id as id, dt.nameShow as name, dt.basealias as alias, c.name as category_name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.`id`=t.`teamId` INNER JOIN `leagues` as l ON l.id=t.`league_id` INNER JOIN `categories` as c ON l.`categoryId`=c.`id` WHERE c.`alias` LIKE 'primera' AND l.`year`='2024'
0.0023   SELECT dt.id as teamId, t.id as id, dt.nameShow as name, dt.basealias as alias, c.name as category_name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.`id`=t.`teamId` INNER JOIN `leagues` as l ON l.id=t.`league_id` INNER JOIN `categories` as c ON l.`categoryId`=c.`id` WHERE c.`alias` LIKE 'segunda' AND l.`year`='2024'
0.0996  SELECT c.id, c.name, l.group_code, l.total_group, c.CountryCode, c.alias , c.transfer_market FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId WHERE l.year=c.active_year AND c.troncal=1 GROUP BY c.id ORDER BY c.coefficient DESC, c.name ASC