SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '21' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.29
            [fallas] => 24
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '23' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.80
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.40
            [fallas] => 8
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.70
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '22' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.80
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.35
            [fallas] => 24
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '25' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.70
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 12
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '26' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.50
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.10
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '24' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.20
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.70
            [fallas] => 8
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.93
            [fallas] => 4
            [habilita] => 4.8
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '27' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.40
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.10
            [fallas] => 24
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '33' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.70
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 6.80
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '30' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.10
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '29' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 20
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 8
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.90
            [fallas] => 12
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '31' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 8
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.20
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '34' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.90
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.40
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '35' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 6.80
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.90
            [fallas] => 4
            [habilita] => 4.5
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '28' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.40
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.50
            [fallas] => 8
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.30
            [fallas] => 16
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '37' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.40
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.40
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.40
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '118' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '21' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.30
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.80
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 12
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.29
            [fallas] => 16
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '23' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.40
            [fallas] => 8
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.40
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '22' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.40
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '25' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '26' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '24' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.70
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.70
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.50
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.90
            [fallas] => 12
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '27' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.00
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.60
            [fallas] => 20
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '33' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.60
            [fallas] => 16
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.40
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '30' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.40
            [fallas] => 8
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.90
            [fallas] => 12
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.80
            [fallas] => 0
            [habilita] => 3.8
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '29' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 8
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.00
            [fallas] => 20
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '31' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 1.80
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '34' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.00
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '35' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.40
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.00
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '28' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.50
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '37' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.00
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '118' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '21' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.60
            [fallas] => 8
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.20
            [fallas] => 16
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.50
            [fallas] => 16
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.29
            [fallas] => 32
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '23' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 0.00
            [fallas] => 12
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.70
            [fallas] => 16
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.30
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '22' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 0.00
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 21.32
            [fallas] => 12
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '25' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.00
            [fallas] => 3
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 3
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '26' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.20
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.30
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '24' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.80
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.01
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '27' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 16
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 16
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.90
            [fallas] => 20
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '33' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.80
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.60
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '30' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.40
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '29' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.00
            [fallas] => 8
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '31' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.90
            [fallas] => 24
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '34' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '35' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.10
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '28' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.40
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.70
            [fallas] => 44
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.30
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '37' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.20
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '118' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '21' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.00
            [fallas] => 12
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 20
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.29
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '23' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.70
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '22' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.35
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '25' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 3
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '26' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.10
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '24' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.30
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.08
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '27' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.10
            [fallas] => 20
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '33' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.30
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '30' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.10
            [fallas] => 8
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.10
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.80
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '29' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.30
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.00
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '31' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.80
            [fallas] => 8
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.50
            [fallas] => 8
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '34' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.10
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '35' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.30
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 8
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 1.00
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '28' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.10
            [fallas] => 12
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '37' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '118' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '21' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.60
            [fallas] => 16
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.50
            [fallas] => 16
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 16
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '23' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 0.00
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '22' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 12
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '25' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.80
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '26' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.80
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.80
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '24' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.80
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.69
            [fallas] => 16
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '27' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.90
            [fallas] => 20
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '33' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.80
            [fallas] => 8
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.80
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.30
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '30' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.90
            [fallas] => 16
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.80
            [fallas] => 12
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.40
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '29' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.70
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.80
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '31' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.00
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.80
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.80
            [fallas] => 4
            [habilita] => 3.8
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '34' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.00
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '35' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.30
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '28' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.40
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.80
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.20
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '37' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '118' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '21' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.90
            [fallas] => 20
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 20
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 1.50
            [fallas] => 12
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 20
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '23' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.10
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.60
            [fallas] => 25
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '22' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.90
            [fallas] => 20
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 5
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 21.32
            [fallas] => 10
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '25' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.80
            [fallas] => 6
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.70
            [fallas] => 6
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '26' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.00
            [fallas] => 12
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 6
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 12
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '24' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.90
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.80
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.70
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.61
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '27' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 5.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.80
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.40
            [fallas] => 35
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.90
            [fallas] => 35
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '33' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.00
            [fallas] => 5
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '30' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.40
            [fallas] => 15
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '29' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.70
            [fallas] => 16
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.00
            [fallas] => 8
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '31' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.10
            [fallas] => 5
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.80
            [fallas] => 10
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.40
            [fallas] => 10
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '34' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.70
            [fallas] => 5
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.70
            [fallas] => 10
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.80
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '35' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.30
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 20
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '28' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 5.00
            [fallas] => 7
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 7
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.70
            [fallas] => 693
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '37' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.20
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.80
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 5
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '118' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '21' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.50
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '23' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 1.75
            [fallas] => 3
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '22' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 2
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '25' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '26' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '24' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.00
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.16
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.00
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.86
            [fallas] => 4
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '27' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '33' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '30' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '29' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '31' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '34' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '35' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '28' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.90
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '37' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '118' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '21' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.50
            [fallas] => 24
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.00
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 4
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 0.00
            [fallas] => 12
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '23' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.90
            [fallas] => 5
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.20
            [fallas] => 15
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.40
            [fallas] => 10
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '22' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.80
            [fallas] => 5
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.00
            [fallas] => 15
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 21.32
            [fallas] => 15
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '25' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.20
            [fallas] => 18
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.20
            [fallas] => 6
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 6
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '26' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.60
            [fallas] => 12
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.20
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 18
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '24' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.50
            [fallas] => 12
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.10
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [fallas] => 8
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.80
            [fallas] => 24
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '27' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.90
            [fallas] => 7
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 21
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.90
            [fallas] => 35
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '33' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.10
            [fallas] => 20
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.70
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.00
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.50
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '30' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.40
            [fallas] => 10
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.60
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.50
            [fallas] => 10
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '29' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.10
            [fallas] => 4
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.00
            [fallas] => 8
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 12
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '31' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.00
            [fallas] => 5
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.00
            [fallas] => 15
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.00
            [fallas] => 5
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '34' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.10
            [fallas] => 10
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.30
            [fallas] => 15
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '35' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.60
            [fallas] => 5
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 3.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.00
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.00
            [fallas] => 0
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '28' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.50
            [fallas] => 14
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.20
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.80
            [fallas] => 7
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '37' GROUP BY periodo ORDER BY periodo ASC;
Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 4.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.20
            [fallas] => 5
            [habilita] => 0
        )

)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '118' GROUP BY periodo ORDER BY periodo ASC;
Array
(
)
Escudo del Colegio

Colegio de Pruebas y Demostración
Para la Plataforma de Notas EduColombia

COLPRUEBAS
Ciencia - Virtud - Disciplina
Código Dane: 8000265844 - Resolucion: 987256 del 23 de Febrero de 2010
Calle 15 Nro 10 - 61
Cel: 312 328 97 79 - TelFax: 098 7627306
Promovido Final: 4 - Año: 2024
Salón: NOVENO-A
Nro Alumno
1 CASTAÑEDA RINCON ADRIANA IVONEE
3.3
3.6
3.4
3.5
3.0
3.8
3.2
3.9
4.2
3.3
3.2
3.2
3.6
4.2
3.8
3.7
4.4
3.5
SI
2 Contreras Uscategui Fabiola Esperanza
3.7
2.7
3.0
3.0
3.5
3.5
3.4
3.4
3.8
3.7
3.9
2.7
3.1
3.8
3.3
3.9
3.5
SI
3 Duarte Becerra Constanza Ivonne
3.9
2.7
8.2
5.1
3.4
3.6
3.4
3.7
3.5
3.5
4.0
3.5
3.0
3.7
3.2
4.0
3.5
SI
4 Fonseca Becerra Rocio Tatiana
3.4
2.5
2.6
2.7
3.2
2.9
4.2
3.6
3.4
3.3
3.9
3.0
2.6
2.5
2.6
3.7
3.7
SI
5 González Corredor Zenaida Marí­a
1.9
2.7
3.0
2.7
3.3
3.3
3.2
3.5
3.6
3.5
3.7
3.8
3.6
3.4
3.5
3.8
3.8
SI
6 Linares Pulido Carlos
1.9
3.6
8.7
5.3
3.8
3.6
3.2
3.8
3.5
3.5
3.7
3.2
3.2
3.4
3.3
3.9
3.4
SI
7 Manosalva Ferrer Andrés Mauricio
1.3
1.8
3.5
2.4
0.0
0.0
3.6
3.9
0.0
0.0
5.0
0.0
0.0
0.0
0.0
3.9
0.0
SI
8 Solano Vergara Carlos Hernan
2.4
3.9
9.0
5.6
3.8
4.1
2.8
3.8
3.3
3.5
3.9
3.6
3.3
3.5
3.4
4.2
4.0
SI
Total Perdidas  451 1210110222 017 
Promedio de Materia  2.732.945.18 33.13.383.73.163.043.912.882.83.06 3.893.290.44 
Promedio General del Salon  3.16
Pagina Procesada y Actualizada en: 0.9 Segs