Roles y Programación

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.state = 1 AND p.state > 0 GROUP BY p.id_categoria ORDER BY m.nam' at line 10 SQL=SELECT m.id, m.name, COUNT(p.id) AS partidos FROM nkp7c_aa_disciplinas m RIGHT JOIN nkp7c_aa_disciplinas d ON m.parent = d.id RIGHT JOIN nkp7c_aa_partidos p ON p.id_categoria = m.id WHERE m.id_torneo = 1021 AND d.category = AND m.state = 1 AND p.state > 0 GROUP BY p.id_categoria ORDER BY m.name
Warning: Invalid argument supplied for foreach() in /home/juegosbancarios/public_html/cms/views/front/inc.front-calendario.php on line 33
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.jornada < 60 AND m.state > 0 ORDER BY categoria, m.grupo, m.jor' at line 35 SQL=SELECT m.*, c.parent, s.name AS sede, c.name AS categoria, c1.name AS categoria1, c2.name AS categoria2, UPPER(d.name) AS disciplina, UPPER(i1.name) AS institucion1, UPPER(i2.name) AS institucion2, ( SELECT MAX(p.grupo) FROM nkp7c_aa_partidos p WHERE p.id_categoria = m.id_categoria AND p.jornada < 60 AND p.state > 0 ) AS grupos, ( SELECT MAX(p.grupo1) FROM nkp7c_aa_partidos p WHERE p.id_categoria = m.id_categoria AND p.jornada < 60 AND p.state > 0 ) AS grupos_ind FROM nkp7c_aa_partidos m RIGHT JOIN nkp7c_aa_disciplinas c ON m.id_categoria = c.id RIGHT JOIN nkp7c_aa_disciplinas c1 ON m.id_categoria1 = c1.id RIGHT JOIN nkp7c_aa_disciplinas c2 ON m.id_categoria2 = c2.id RIGHT JOIN nkp7c_aa_disciplinas d ON m.id_disciplina = d.id RIGHT JOIN nkp7c_aa_sedes s ON m.id_sede = s.id LEFT JOIN nkp7c_aa_instituciones i1 ON m.id_institucion1 = i1.id LEFT JOIN nkp7c_aa_instituciones i2 ON m.id_institucion2 = i2.id WHERE m.id_torneo = 1021 AND d.category = AND m.jornada < 60 AND m.state > 0 ORDER BY categoria, m.grupo, m.jornada, m.id
Warning: Invalid argument supplied for foreach() in /home/juegosbancarios/public_html/cms/views/front/inc.front-calendario.php on line 87
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.jornada >= 60 AND m.state > 0 ORDER BY categoria, m.grupo, m.jor' at line 35 SQL=SELECT m.*, c.parent, s.name AS sede, c.name AS categoria, c1.name AS categoria1, c2.name AS categoria2, UPPER(d.name) AS disciplina, UPPER(i1.name) AS institucion1, UPPER(i2.name) AS institucion2, ( SELECT MAX(p.grupo) FROM nkp7c_aa_partidos p WHERE p.id_categoria = m.id_categoria AND p.jornada = m.jornada AND p.state > 0 ) AS grupos, ( SELECT MAX(p.grupo1) FROM nkp7c_aa_partidos p WHERE p.id_categoria = m.id_categoria AND p.jornada = m.jornada AND p.state > 0 ) AS grupos_ind FROM nkp7c_aa_partidos m RIGHT JOIN nkp7c_aa_disciplinas c ON m.id_categoria = c.id RIGHT JOIN nkp7c_aa_disciplinas c1 ON m.id_categoria1 = c1.id RIGHT JOIN nkp7c_aa_disciplinas c2 ON m.id_categoria2 = c2.id RIGHT JOIN nkp7c_aa_disciplinas d ON m.id_disciplina = d.id RIGHT JOIN nkp7c_aa_sedes s ON m.id_sede = s.id LEFT JOIN nkp7c_aa_instituciones i1 ON m.id_institucion1 = i1.id LEFT JOIN nkp7c_aa_instituciones i2 ON m.id_institucion2 = i2.id WHERE m.id_torneo = 1021 AND d.category = AND m.jornada >= 60 AND m.state > 0 ORDER BY categoria, m.grupo, m.jornada, m.id
Warning: Invalid argument supplied for foreach() in /home/juegosbancarios/public_html/cms/views/front/inc.front-calendario.php on line 245
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.state > 0 AND m.id_institucion1 > 0 AND m.id_institucion2 > 0 ORDER' at line 35 SQL=SELECT m.*, c.parent, s.name AS sede, c.name AS categoria, c1.name AS categoria1, c2.name AS categoria2, UPPER(d.name) AS disciplina, UPPER(i1.name) AS institucion1, UPPER(i2.name) AS institucion2, ( SELECT MAX(p.grupo) FROM nkp7c_aa_partidos p WHERE p.id_categoria = m.id_categoria AND p.jornada < 60 AND p.state > 0 ) AS grupos, ( SELECT MAX(p.grupo1) FROM nkp7c_aa_partidos p WHERE p.id_categoria = m.id_categoria AND p.jornada < 60 AND p.state > 0 ) AS grupos_ind FROM nkp7c_aa_partidos m RIGHT JOIN nkp7c_aa_disciplinas c ON m.id_categoria = c.id RIGHT JOIN nkp7c_aa_disciplinas c1 ON m.id_categoria1 = c1.id RIGHT JOIN nkp7c_aa_disciplinas c2 ON m.id_categoria2 = c2.id RIGHT JOIN nkp7c_aa_disciplinas d ON m.id_disciplina = d.id RIGHT JOIN nkp7c_aa_sedes s ON m.id_sede = s.id LEFT JOIN nkp7c_aa_instituciones i1 ON m.id_institucion1 = i1.id LEFT JOIN nkp7c_aa_instituciones i2 ON m.id_institucion2 = i2.id WHERE m.id_torneo = 1021 AND d.category = AND m.state > 0 AND m.id_institucion1 > 0 AND m.id_institucion2 > 0 ORDER BY m.fecha, m.hora, m.jornada, categoria, sede, cancha, m.id
Warning: Invalid argument supplied for foreach() in /home/juegosbancarios/public_html/cms/views/front/inc.front-calendario.php on line 408

Selecciona una categoría