La quiniela de resultados-Fútbol.com

Siguiente » Jornada 32 « Anterior
Partidos Resultado   Día   Predicciones LaPorra logo de la porra de resultados-Fútbol.com   Estadísticas LaPorra logo de la porra de resultados-Fútbol.com   Estadísticas Históricas   Pred. RF  
   
1 X 2
 
%1 %X %2
 
%1 %X %2
   
    * comunidad   * en % prob.   * nº partidos    
1. Espanyol - Athletic
1 X 2
  25/01  
1 X 2
 
 
30 40 30
 
X
 
2. Valencia - Barcelona
1 X 2
  25/01  
1 X 2
 
 
40 20 40
 
1
 
3. Alavés - Villarreal
1 X 2
  25/01  
1 X 2
 
 
20 30 50
 
2
 
4. Sevilla - Granada
1 X 2
  25/01  
1 X 2
 
 
32 21 47
 
2
 
 
5. Atlético - Leganés
1 X 2
  26/01  
1 X 2
 
 
53 5 42
 
1
 
6. Celta - Eibar
1 X 2
  26/01  
1 X 2
 
 
30 25 45
 
2
 
7. Getafe - Real Betis
1 X 2
  26/01  
1 X 2
 
 
47 16 37
 
1
 
8. R. Sociedad - Mallorca
1 X 2
  26/01  
1 X 2
 
 
28 17 56
 
2
 
 
9. Real Sporting - Fuenlabrada
1 X 2
  25/01  
1 X 2
 
 
38 33 29
 
1
 
10. Las Palmas - Tenerife
1 X 2
  25/01  
1 X 2
 
 
29 29 42
 
2
 
11. Cádiz - Racing
1 X 2
  24/01  
1 X 2
 
 
52 22 26
 
1
 
 
12. Real Zaragoza - Numancia
1 X 2
  25/01  
1 X 2
 
 
27 23 50
 
2
 
13. Málaga - Mirandés
1 X 2
  26/01  
1 X 2
 
 
43 30 26
 
1
 
14. Almería - Elche
1 X 2
  26/01  
1 X 2
 
 
30 35 35
 
X
 
 
15. Alcorcón - Ponferradina
x - x
  26/01  
1 X 2
 
 
32 32 37
 
2
 
16. Real Valladoli. - Real Madrid
1 X 2
  26/01  
1 X 2
 
 
 
 
Recaudación:
0,00 €
Bote:
Sin bote
Escrutinio:
Aciertos Acertantes Premio
15 0 0,00 €
14 0 0,00 €
13 0 0,00 €
12 0 0,00 €
11 0 0,00 €
10 0 0,00 €
* El escrutinio se publica después de la jornada
18/01/2020 - Jornada 31

Última jornada

1. Levante - Alavés   0-1  
1 X 2
 
2. Real Madrid - Sevilla   2-1  
1 X 2
 
3. Osasuna - Real Vallado.   0-0  
1 X 2
 
4. Eibar - Atlético   2-0  
1 X 2
 
 
5. Mallorca - Valencia   4-1  
1 X 2
 
6. Real Betis - R. Sociedad   3-0  
1 X 2
 
7. Villarreal - Espanyol   1-2  
1 X 2
 
8. Athletic - Celta   1-1  
1 X 2
 
 
9. Elche - Alcorcón   1-1  
1 X 2
 
10. Deportivo - Cádiz   1-0  
1 X 2
 
11. Real Oviedo - Huesca   1-1  
1 X 2
 
 
12. Racing - Las Palmas   1-1  
1 X 2
 
13. Extremadura - Almería   1-2  
1 X 2
 
14. Tenerife - Girona   1-0  
1 X 2
 
 
15. Barcelona - Granada   1-0  
1 - 0
 
Recaudación:
4.034.055,00 €
Bote:
1.100.000,00 €
Otros premios:
Aciertos Acertantes Premio
15 0 0,00 €
14 0 0,00 €
13 12 25.212,84 €
12 123 2.459,79 €
11 1.072 282,23 €
10 6.472 56,10 €
* El escrutinio se publica después de la jornada
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  
5,288,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Quiniela Game / Index )  0.5175
Total Execution Time  0.5202
  CADENA URL  
/quiniela
  GET DATOS  
$_GET['/quiniela']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0028  SELECT * FROM quiniela_r WHERE status = 'enb' AND rewards IS NOT NULL ORDER BY year DESC, round DESC LIMIT 1
0.0060  SELECT t1.nameShow AS team1_name, t2.nameShow AS team2_name, c.r1, c.r2, c.shedule, c.extra, c.league_id, q.`year`,t1.basealias AS basealias1, t2.basealias AS basealias2 FROM quiniela AS q INNER JOIN calendars_all AS c ON q.id_match=c.id AND c.league_id = q.league_id LEFT JOIN datateams AS t1 ON t1.id=c.datateam1 LEFT JOIN datateams AS t2 ON t2.id=c.datateam2 WHERE q.`year`=2020 AND q.round=31 ORDER BY idq ASC
0.0024  SELECT * FROM quiniela_r WHERE status = 'enb' AND ((NOW()>=init_date AND NOW()<=end_date) OR init_date>NOW()) ORDER BY init_date ASC LIMIT 1
0.0054  SELECT t1.nameShow AS team1_name, t2.nameShow AS team2_name, c.r1, c.r2, c.shedule, c.extra, c.league_id, q.`year`,t1.basealias AS basealias1, t2.basealias AS basealias2 FROM quiniela AS q INNER JOIN calendars_all AS c ON q.id_match=c.id AND c.league_id = q.league_id LEFT JOIN datateams AS t1 ON t1.id=c.datateam1 LEFT JOIN datateams AS t2 ON t2.id=c.datateam2 WHERE q.`year`=2020 AND q.round=32 ORDER BY idq ASC
0.0021  SELECT MAX(round) AS max_round FROM quiniela_r WHERE status='enb' AND year=2020
0.0055  SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2020 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '32' AND q.year=2020 ORDER BY q.idq ASC
0.0020  SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2020 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '32' AND q.year=2020 ORDER BY q.idq ASC
0.0020  SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2020 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '32' AND q.year=2020 ORDER BY q.idq ASC
0.0031  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279968 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6279963 AND r1<99 ORDER BY shedule ASC
0.0041  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279977 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6279965 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279962 AND r1<99 ORDER BY shedule ASC
0.0031  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6279978 AND r1<99 ORDER BY shedule ASC
0.0029  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279976 AND r1<99 ORDER BY shedule ASC
0.0029  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6281514 AND r1<99 ORDER BY shedule ASC
0.0027  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279964 AND r1<99 ORDER BY shedule ASC
0.0030  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6279970 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279966 AND r1<99 ORDER BY shedule ASC
0.0027  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6279967 AND r1<99 ORDER BY shedule ASC
0.0029  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279969 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6279973 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279972 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6284662 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team1 = 6283329 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team2 = 6283332 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team1 = 6283324 AND r1<99 ORDER BY shedule ASC
0.0029  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team2 = 6283331 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team1 = 6283321 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team2 = 6283333 AND r1<99 ORDER BY shedule ASC
0.0036  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team1 = 6283330 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team2 = 6283327 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team1 = 6283326 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team2 = 6286461 AND r1<99 ORDER BY shedule ASC
0.0029  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team1 = 6283320 AND r1<99 ORDER BY shedule ASC
0.0029  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team2 = 6283322 AND r1<99 ORDER BY shedule ASC
0.0029  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team1 = 6283319 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 50064 AND team2 = 6286460 AND r1<99 ORDER BY shedule ASC
0.0032  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team1 = 6279975 AND r1<99 ORDER BY shedule ASC
0.0028  SELECT r1,r2 FROM calendars2020 WHERE league_id = 49844 AND team2 = 6279974 AND r1<99 ORDER BY shedule ASC
0.1899  SELECT min(l.year) as min_year,max(l.year) as max_year,c.main,cou.Name,c.top,c.status,c.cat,c.ctype,c.CountryCode, c.class, c.main,c.coefficient, l.year,c.logo, l.id , c.name, c.alias,lp.c_playing,lp.c_recent,lp.c_played,lp.c_pending,lp.c_past,lp.c_future FROM (leagues l INNER JOIN categories c ON l.categoryId = c.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode LEFT JOIN leagues_play lp ON lp.categoryId = c.id AND lp.ini_date = '2020-01-25 03:00:00') WHERE l.group_code = 1 AND l.end_date > NOW() - INTERVAL 2 MONTH AND l.status = 1 group by l.categoryId ORDER BY c.coefficient DESC, c.name DESC LIMIT 200
0.0018  SELECT * FROM totals order by id ASC
0.0020  SELECT l.id,cat.alias,cat.name,l.total_group,l.group_code FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2009 as c ON c.league_id = l.id AND l.current_round = c.round WHERE l.status = 1 AND c.r1 < 95 AND c.r2 < 95 AND c.shedule > '2020/01/24 23:49' AND c.shedule < '2020/01/25 03:09' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 21
0.1333  SELECT l.id,cat.alias,cat.name,l.total_group,l.group_code FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId WHERE l.status = 1 AND l.group_code = 1 ORDER BY l.year DESC,cat.coefficient DESC,l.group_code ASC LIMIT 21