4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
25 Ene 42 SD CeutaSD Ceuta 2 - 0 Jerez FCJerez FC ...
25 Ene 42 Racing FerrolRacing 3 - 1 Real ValladolidReal ...
25 Ene 42 Club LangreanoClub 2 - 0 RacingRacing ...
25 Ene 42 Cultural LeonesaCultural 3 - 1 EmdenEmden ...
25 Ene 42 Real Unión ClubReal Unión 0 - 2 Arenas de GetxoArenas ...
25 Ene 42 BarakaldoBarakaldo 5 - 2 SD IndautxuIndautxu ...
25 Ene 42 Rayo CantabriaRayo 4 - 1 CD LogroñésLogroñés ...
25 Ene 42 Deportivo AlavésDeportivo 3 - 3 OsasunaOsasuna ...
25 Ene 42 TudelanoTudelano 3 - 2 AD FerroviariaFerroviaria ...
25 Ene 42 Imperio MadridImperio 3 - 1 Atlético ZaragozaAtlético ...
25 Ene 42 LevanteLevante 5 - 1 MartinencMartinenc ...
25 Ene 42 Terrassa FCTerrassa 1 - 1 ConstànciaConstància ...
25 Ene 42 MallorcaMallorca 2 - 1 GironaGirona ...
25 Ene 42 AlcoyanoAlcoyano 0 - 2 CD MálagaCD Málaga ...
25 Ene 42 Cartagena CFCartagena 2 - 0 EldenseEldense ...
25 Ene 42 ElcheElche 2 - 1 RCD CórdobaCórdoba ...
25 Ene 42 RecreativoRecreativo 2 - 0 TetuánTetuán ...
25 Ene 42 CádizCádiz 6 - 0 CD BadajozCD Badajoz ...
Jornada 2
01 Feb 42 RacingRacing 2 - 1 Racing FerrolRacing ...
01 Feb 42 Real ValladolidReal 1 - 0 Cultural LeonesaCultural ...
01 Feb 42 EmdenEmden 8 - 2 Club LangreanoClub ...
01 Feb 42 Arenas de GetxoArenas 3 - 0 Rayo CantabriaRayo ...
01 Feb 42 SD IndautxuIndautxu 1 - 4 Real Unión ClubReal Unión ...
01 Feb 42 CD LogroñésLogroñés 5 - 0 BarakaldoBarakaldo ...
01 Feb 42 OsasunaOsasuna 3 - 1 Imperio MadridImperio ...
01 Feb 42 AD FerroviariaFerroviaria 4 - 1 Deportivo AlavésDeportivo ...
01 Feb 42 Atlético ZaragozaAtlético 2 - 2 TudelanoTudelano ...
01 Feb 42 MartinencMartinenc 2 - 1 MallorcaMallorca ...
01 Feb 42 ConstànciaConstància 3 - 1 LevanteLevante ...
01 Feb 42 GironaGirona 0 - 5 Terrassa FCTerrassa ...
01 Feb 42 CD MálagaCD Málaga 4 - 2 ElcheElche ...
01 Feb 42 EldenseEldense 2 - 0 AlcoyanoAlcoyano ...
01 Feb 42 RCD CórdobaCórdoba 3 - 1 Cartagena CFCartagena ...
01 Feb 42 CD BadajozCD Badajoz 0 - 2 SD CeutaSD Ceuta ...
01 Feb 42 Jerez FCJerez FC 3 - 1 RecreativoRecreativo ...
01 Feb 42 TetuánTetuán 4 - 2 CádizCádiz ...
Jornada 3
08 Feb 42 CD BadajozCD Badajoz 4 - 1 TetuánTetuán ...
08 Feb 42 MartinencMartinenc 0 - 1 ConstànciaConstància ...
08 Feb 42 LevanteLevante 4 - 3 GironaGirona ...
15 Mar 42 AlcoyanoAlcoyano 3 - 0 RCD CórdobaCórdoba ...
08 Feb 42 CD MálagaCD Málaga 4 - 4 EldenseEldense ...
08 Feb 42 Rayo CantabriaRayo 0 - 0 BarakaldoBarakaldo ...
08 Feb 42 Deportivo AlavésDeportivo 5 - 1 Atlético ZaragozaAtlético ...
08 Feb 42 Imperio MadridImperio 4 - 1 TudelanoTudelano ...
08 Feb 42 Arenas de GetxoArenas 7 - 1 SD IndautxuIndautxu ...
08 Feb 42 Cultural LeonesaCultural 6 - 2 Club LangreanoClub ...
08 Feb 42 Real ValladolidReal 1 - 0 RacingRacing ...
08 Feb 42 Racing FerrolRacing 3 - 2 EmdenEmden ...
08 Feb 42 Real Unión ClubReal Unión 0 - 4 CD LogroñésLogroñés ...
08 Feb 42 OsasunaOsasuna 6 - 0 AD FerroviariaFerroviaria ...
08 Feb 42 MallorcaMallorca 1 - 1 Terrassa FCTerrassa ...
08 Feb 42 ElcheElche 8 - 1 Cartagena CFCartagena ...
08 Feb 42 CádizCádiz 3 - 3 Jerez FCJerez FC ...
08 Feb 42 SD CeutaSD Ceuta 4 - 1 RecreativoRecreativo ...
Jornada 4
15 Feb 42 Cultural LeonesaCultural 3 - 2 RacingRacing ...
15 Feb 42 Cartagena CFCartagena 0 - 4 AlcoyanoAlcoyano ...
15 Feb 42 EmdenEmden 5 - 3 Real ValladolidReal ...
15 Feb 42 Club LangreanoClub 1 - 0 Racing FerrolRacing ...
15 Feb 42 Rayo CantabriaRayo 4 - 3 SD IndautxuIndautxu ...
15 Feb 42 CD LogroñésLogroñés 1 - 1 Arenas de GetxoArenas ...
15 Feb 42 BarakaldoBarakaldo 4 - 2 Real Unión ClubReal Unión ...
15 Feb 42 Imperio MadridImperio 0 - 0 AD FerroviariaFerroviaria ...
15 Feb 42 Atlético ZaragozaAtlético 0 - 3 OsasunaOsasuna ...
15 Feb 42 TudelanoTudelano 3 - 1 Deportivo AlavésDeportivo ...
15 Feb 42 MallorcaMallorca 2 - 2 ConstànciaConstància ...
15 Feb 42 GironaGirona 4 - 0 MartinencMartinenc ...
15 Feb 42 Terrassa FCTerrassa 0 - 0 LevanteLevante ...
15 Feb 42 ElcheElche 6 - 0 EldenseEldense ...
15 Feb 42 RCD CórdobaCórdoba 1 - 1 CD MálagaCD Málaga ...
15 Feb 42 SD CeutaSD Ceuta 2 - 1 TetuánTetuán ...
15 Feb 42 Jerez FCJerez FC 4 - 0 CD BadajozCD Badajoz ...
15 Feb 42 RecreativoRecreativo 5 - 0 CádizCádiz ...
Jornada 5
22 Feb 42 CD BadajozCD Badajoz 3 - 3 RecreativoRecreativo ...
24 Feb 42 LevanteLevante 3 - 2 MallorcaMallorca ...
22 Feb 42 TetuánTetuán 1 - 2 Jerez FCJerez FC ...
22 Feb 42 MartinencMartinenc 0 - 6 Terrassa FCTerrassa ...
22 Feb 42 EldenseEldense 5 - 2 RCD CórdobaCórdoba ...
22 Feb 42 ConstànciaConstància 2 - 4 GironaGirona ...
22 Feb 42 Deportivo AlavésDeportivo 4 - 1 Imperio MadridImperio ...
22 Feb 42 AD FerroviariaFerroviaria 3 - 0 Atlético ZaragozaAtlético ...
22 Feb 42 Real Unión ClubReal Unión 1 - 3 Rayo CantabriaRayo ...
22 Feb 42 SD IndautxuIndautxu 2 - 3 CD LogroñésLogroñés ...
22 Feb 42 Arenas de GetxoArenas 3 - 0 BarakaldoBarakaldo ...
22 Feb 42 RacingRacing 3 - 0 EmdenEmden ...
22 Feb 42 Real ValladolidReal 4 - 0 Club LangreanoClub ...
22 Feb 42 Racing FerrolRacing 5 - 3 Cultural LeonesaCultural ...
22 Feb 42 OsasunaOsasuna 6 - 2 TudelanoTudelano ...
22 Feb 42 CD MálagaCD Málaga 3 - 0 Cartagena CFCartagena ...
22 Feb 42 AlcoyanoAlcoyano 0 - 1 ElcheElche ...
22 Feb 42 CádizCádiz 1 - 1 SD CeutaSD Ceuta ...
Jornada 6
01 Mar 42 RCD CórdobaCórdoba 2 - 1 ElcheElche ...
01 Mar 42 RacingRacing 8 - 0 Club LangreanoClub ...
01 Mar 42 EmdenEmden 2 - 0 Cultural LeonesaCultural ...
01 Mar 42 Arenas de GetxoArenas 5 - 0 Real Unión ClubReal Unión ...
01 Mar 42 SD IndautxuIndautxu 1 - 5 BarakaldoBarakaldo ...
01 Mar 42 CD LogroñésLogroñés 2 - 1 Rayo CantabriaRayo ...
01 Mar 42 OsasunaOsasuna 4 - 1 Deportivo AlavésDeportivo ...
01 Mar 42 AD FerroviariaFerroviaria 5 - 0 TudelanoTudelano ...
01 Mar 42 Atlético ZaragozaAtlético 1 - 2 Imperio MadridImperio ...
01 Mar 42 MartinencMartinenc 4 - 1 LevanteLevante ...
01 Mar 42 ConstànciaConstància 1 - 2 Terrassa FCTerrassa ...
01 Mar 42 GironaGirona 2 - 1 MallorcaMallorca ...
01 Mar 42 CD MálagaCD Málaga 3 - 0 AlcoyanoAlcoyano ...
01 Mar 42 EldenseEldense 1 - 0 Cartagena CFCartagena ...
01 Mar 42 CD BadajozCD Badajoz 1 - 2 CádizCádiz ...
01 Mar 42 TetuánTetuán 2 - 1 RecreativoRecreativo ...
01 Mar 42 Jerez FCJerez FC 3 - 2 SD CeutaSD Ceuta ...
01 Mar 42 Real ValladolidReal 3 - 1 Racing FerrolRacing ...
Jornada 7
15 Mar 42 ElcheElche 7 - 0 CD MálagaCD Málaga ...
13 Mar 42 AlcoyanoAlcoyano 4 - 2 EldenseEldense ...
08 Mar 42 SD CeutaSD Ceuta 4 - 0 CD BadajozCD Badajoz ...
08 Mar 42 TudelanoTudelano 2 - 3 Atlético ZaragozaAtlético ...
08 Mar 42 Club LangreanoClub 3 - 0 EmdenEmden ...
08 Mar 42 Cultural LeonesaCultural 3 - 0 Real ValladolidReal ...
08 Mar 42 Racing FerrolRacing 2 - 1 RacingRacing ...
08 Mar 42 Rayo CantabriaRayo 1 - 2 Arenas de GetxoArenas ...
08 Mar 42 Real Unión ClubReal Unión 0 - 5 SD IndautxuIndautxu ...
08 Mar 42 BarakaldoBarakaldo 5 - 2 CD LogroñésLogroñés ...
08 Mar 42 Imperio MadridImperio 1 - 3 OsasunaOsasuna ...
08 Mar 42 Deportivo AlavésDeportivo 0 - 0 AD FerroviariaFerroviaria ...
08 Mar 42 MallorcaMallorca 2 - 1 MartinencMartinenc ...
08 Mar 42 LevanteLevante 4 - 1 ConstànciaConstància ...
08 Mar 42 Terrassa FCTerrassa 4 - 1 GironaGirona ...
08 Mar 42 Cartagena CFCartagena 4 - 2 RCD CórdobaCórdoba ...
08 Mar 42 CádizCádiz 0 - 1 TetuánTetuán ...
08 Mar 42 RecreativoRecreativo 3 - 2 Jerez FCJerez FC ...
Jornada 8
15 Mar 42 EmdenEmden 6 - 0 Racing FerrolRacing ...
15 Mar 42 BarakaldoBarakaldo 2 - 1 Rayo CantabriaRayo ...
15 Mar 42 AD FerroviariaFerroviaria 2 - 1 OsasunaOsasuna ...
15 Mar 42 TetuánTetuán 1 - 2 CD BadajozCD Badajoz ...
22 Mar 42 RacingRacing 3 - 1 Real ValladolidReal ...
22 Mar 42 Club LangreanoClub 3 - 4 Cultural LeonesaCultural ...
22 Mar 42 SD IndautxuIndautxu 0 - 4 Arenas de GetxoArenas ...
22 Mar 42 CD LogroñésLogroñés 5 - 1 Real Unión ClubReal Unión ...
22 Mar 42 Atlético ZaragozaAtlético 2 - 5 Deportivo AlavésDeportivo ...
22 Mar 42 TudelanoTudelano 3 - 2 Imperio MadridImperio ...
22 Mar 42 ConstànciaConstància 5 - 0 MartinencMartinenc ...
22 Mar 42 GironaGirona 2 - 2 LevanteLevante ...
22 Mar 42 Terrassa FCTerrassa 2 - 1 MallorcaMallorca ...
22 Mar 42 EldenseEldense 1 - 2 CD MálagaCD Málaga ...
22 Mar 42 RCD CórdobaCórdoba 1 - 2 AlcoyanoAlcoyano ...
22 Mar 42 Cartagena CFCartagena 0 - 0 ElcheElche ...
22 Mar 42 Jerez FCJerez FC 3 - 0 CádizCádiz 1
22 Mar 42 RecreativoRecreativo 0 - 3 SD CeutaSD Ceuta ...
Jornada 9
29 Mar 42 MartinencMartinenc 2 - 1 GironaGirona ...
29 Mar 42 RacingRacing 2 - 2 Cultural LeonesaCultural ...
29 Mar 42 Real ValladolidReal 4 - 0 EmdenEmden ...
29 Mar 42 Racing FerrolRacing 8 - 0 Club LangreanoClub ...
29 Mar 42 SD IndautxuIndautxu 5 - 3 Rayo CantabriaRayo ...
29 Mar 42 Arenas de GetxoArenas 3 - 0 CD LogroñésLogroñés ...
29 Mar 42 Real Unión ClubReal Unión 2 - 0 BarakaldoBarakaldo ...
29 Mar 42 AD FerroviariaFerroviaria 1 - 1 Imperio MadridImperio ...
29 Mar 42 OsasunaOsasuna 2 - 0 Atlético ZaragozaAtlético ...
29 Mar 42 Deportivo AlavésDeportivo 4 - 0 TudelanoTudelano ...
29 Mar 42 ConstànciaConstància 2 - 5 MallorcaMallorca ...
29 Mar 42 LevanteLevante 2 - 1 Terrassa FCTerrassa ...
29 Mar 42 EldenseEldense 4 - 1 ElcheElche ...
29 Mar 42 CD MálagaCD Málaga 1 - 0 RCD CórdobaCórdoba ...
29 Mar 42 AlcoyanoAlcoyano 3 - 1 Cartagena CFCartagena ...
29 Mar 42 TetuánTetuán 0 - 4 SD CeutaSD Ceuta ...
29 Mar 42 CD BadajozCD Badajoz 1 - 2 Jerez FCJerez FC ...
29 Mar 42 CádizCádiz 5 - 1 RecreativoRecreativo ...
Jornada 10
05 Abr 42 Club LangreanoClub 0 - 1 Real ValladolidReal ...
05 Abr 42 EmdenEmden 1 - 5 RacingRacing ...
05 Abr 42 Cultural LeonesaCultural 0 - 0 Racing FerrolRacing ...
05 Abr 42 Jerez FCJerez FC 5 - 2 TetuánTetuán ...
05 Abr 42 RecreativoRecreativo 4 - 0 CD BadajozCD Badajoz ...
05 Abr 42 SD CeutaSD Ceuta 2 - 1 CádizCádiz ...
05 Abr 42 CD LogroñésLogroñés 1 - 0 SD IndautxuIndautxu ...
05 Abr 42 BarakaldoBarakaldo 1 - 0 Arenas de GetxoArenas ...
05 Abr 42 Rayo CantabriaRayo 3 - 0 Real Unión ClubReal Unión ...
05 Abr 42 TudelanoTudelano 0 - 2 OsasunaOsasuna ...
05 Abr 42 Imperio MadridImperio 3 - 2 Deportivo AlavésDeportivo ...
05 Abr 42 Atlético ZaragozaAtlético 0 - 2 AD FerroviariaFerroviaria ...
05 Abr 42 GironaGirona 0 - 1 ConstànciaConstància ...
05 Abr 42 Terrassa FCTerrassa 2 - 0 MartinencMartinenc ...
05 Abr 42 MallorcaMallorca 3 - 1 LevanteLevante ...
05 Abr 42 RCD CórdobaCórdoba 0 - 4 EldenseEldense ...
05 Abr 42 Cartagena CFCartagena 2 - 2 CD MálagaCD Málaga ...
05 Abr 42 ElcheElche 1 - 1 AlcoyanoAlcoyano ...

Clasificación

Equipo PJ GF GC Puntos
1 Real Valladolid Real 10 19 15 18
2 Cultural Leonesa Cultural 10 24 18 17
3 Racing Racing 10 26 13 16
4 Racing Ferrol Racing 10 23 19 16
5 Emden Emden 10 25 26 12
6 Club Langreano Club 10 13 39 9
7 Arenas de Getxo Arenas Getxo 10 30 4 25
8 CD Logroñés Logroñés 10 24 17 19
9 Barakaldo Barakaldo 10 22 18 19
10 Rayo Cantabria Rayo 10 20 19 13
11 SD Indautxu SD Indautxu 10 20 36 6
12 Real Unión Club Real Unión 10 10 32 6
13 Osasuna Osasuna 10 33 10 25
14 AD Ferroviaria Ferroviaria 10 19 12 18
15 Deportivo Alavés Deportivo 10 26 21 14
16 Imperio Madrid Imperio 10 18 19 14
17 Tudelano Tudelano 10 16 31 10
18 Atlético Zaragoza Atlético 10 10 29 4
19 Terrassa FC Terrassa FC 10 24 7 21
20 Levante Levante 10 23 20 17
21 Mallorca Mallorca 10 20 17 14
22 Constància Constància 10 19 19 14
23 Girona Girona 10 18 23 10
24 Martinenc Martinenc 10 10 28 9
25 CD Málaga CD Málaga 10 22 17 21
26 Elche Elche 10 29 13 17
27 Alcoyano Alcoyano 10 17 13 16
28 Eldense Eldense 10 23 21 16
29 Cartagena CF Cartagena 10 11 26 8
30 RCD Córdoba Córdoba 10 12 24 7
31 SD Ceuta SD Ceuta 10 26 7 25
32 Jerez FC Jerez FC 10 27 15 22
33 Recreativo Recreativo 10 21 22 13
34 Cádiz Cádiz 10 20 21 11
35 Tetuán Tetuán 10 13 24 9
36 CD Badajoz CD Badajoz 10 11 29 7

  USO DE MEMORIA  
6,834,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4146
Total Execution Time  0.4167
  CADENA URL  
/segunda-division-promocion-permanencia1942/grupo1/calendario
  GET DATOS  
$_GET['/segunda-division-promocion-permanencia1942/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0124  SELECT type FROM routes WHERE alias = 'segunda-division-promocion-permanencia1942'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda-division-promocion-permanencia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1942 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2892 AND type_rel = 3
0.0128  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 = 74942 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  SELECT 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, dt1.stadium as stadium_name FROM calendars1942 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 74942 ORDER BY round ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 00:03:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 00:03:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 00:03:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 00:03:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda-division-promocion-permanencia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1942 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2892 AND l.year = 1942
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1942 e WHERE e.league_id IN (74942) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (74942) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (253149,680974,253507,681042,252175,252781,252959,253188,253592,681405) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2892 AND l.year = 1942
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1942 e WHERE e.league_id IN (74942) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2892 AND l.year = 1942
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1942 e WHERE e.league_id IN (74942) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0127  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 (74942) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (681042) ORDER BY rp.in_squad = 1 DESC
0.0144  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1942` 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 = 74942 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC