Software para Colegios 1290. Sistema Integral para la Gestion educativa

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 = '110' AND notas.idAsignaciones = '2' GROUP BY periodo ORDER BY periodo ASC;

Array
(
)

Array
(
)

Array
(
)

Array
(
)

Array
(
)

Array
(
)

Array
(
)

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 = '14' AND notas.idAsignaciones = '2' 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.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.40
            [fallas] => 0
            [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 = '14' AND notas.idAsignaciones = '3' 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.10
            [fallas] => 0
            [habilita] => 0
        )

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

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

)

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.60
            [fallas] => 0
            [habilita] => 0
        )

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

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

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

)

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.60
            [fallas] => 0
            [habilita] => 0
        )

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

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

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

)

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.60
            [fallas] => 0
            [habilita] => 0
        )

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

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

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

)

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 3.70
            [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] => 4.70
            [fallas] => 4
            [habilita] => 0
        )

)

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 = '14' AND notas.idAsignaciones = '7' 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] => 3.40
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [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 = '24' AND notas.idAsignaciones = '2' 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.00
            [fallas] => 4
            [habilita] => 0
        )

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

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

)

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 = '24' AND notas.idAsignaciones = '3' 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.20
            [fallas] => 4
            [habilita] => 0
        )

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.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 = '24' AND notas.idAsignaciones = '4' GROUP BY periodo ORDER BY periodo ASC;

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

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 4
            [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 = '24' AND notas.idAsignaciones = '5' GROUP BY periodo ORDER BY periodo ASC;

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

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.10
            [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 = '24' AND notas.idAsignaciones = '6' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.60
            [fallas] => 0
            [habilita] => 0
        )

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

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.10
            [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 = '24' AND notas.idAsignaciones = '1' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.00
            [fallas] => 0
            [habilita] => 0
        )

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

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.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 = '24' AND notas.idAsignaciones = '114' 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 = '24' AND notas.idAsignaciones = '7' 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.90
            [fallas] => 0
            [habilita] => 0
        )

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.10
            [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 = '62' AND notas.idAsignaciones = '2' GROUP BY periodo ORDER BY periodo ASC;

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

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

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

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

)

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 = '62' AND notas.idAsignaciones = '3' 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.30
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 4
            [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 = '62' AND notas.idAsignaciones = '4' 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] => 20
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.00
            [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 = '62' AND notas.idAsignaciones = '5' 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.10
            [fallas] => 0
            [habilita] => 0
        )

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.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 = '62' AND notas.idAsignaciones = '6' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.60
            [fallas] => 0
            [habilita] => 0
        )

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.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 = '62' AND notas.idAsignaciones = '1' 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.70
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.20
            [fallas] => 0
            [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 = '62' AND notas.idAsignaciones = '114' 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 = '62' AND notas.idAsignaciones = '7' 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] => 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.20
            [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 = '86' AND notas.idAsignaciones = '2' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.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 = '86' AND notas.idAsignaciones = '3' GROUP BY periodo ORDER BY periodo ASC;

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

)

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 = '86' AND notas.idAsignaciones = '5' 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 = '86' AND notas.idAsignaciones = '6' 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 = '86' AND notas.idAsignaciones = '1' GROUP BY periodo ORDER BY periodo ASC;

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

)

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 = '86' AND notas.idAsignaciones = '7' 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 = '73' AND notas.idAsignaciones = '2' 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.40
            [fallas] => 0
            [habilita] => 0
        )

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

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

)

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 = '73' AND notas.idAsignaciones = '3' 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] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.70
            [fallas] => 0
            [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 = '73' AND notas.idAsignaciones = '4' 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.40
            [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 = '73' AND notas.idAsignaciones = '5' 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] => 2.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 8
            [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 = '73' AND notas.idAsignaciones = '6' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.60
            [fallas] => 0
            [habilita] => 0
        )

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 4
            [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 = '73' AND notas.idAsignaciones = '1' 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.10
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [fallas] => 4
            [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 = '73' AND notas.idAsignaciones = '114' 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 = '73' AND notas.idAsignaciones = '7' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.80
            [fallas] => 0
            [habilita] => 0
        )

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [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 = '28' AND notas.idAsignaciones = '2' 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.90
            [fallas] => 0
            [habilita] => 0
        )

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

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

)

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 = '28' AND notas.idAsignaciones = '3' 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.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 = '28' AND notas.idAsignaciones = '4' GROUP BY periodo ORDER BY periodo ASC;

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

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

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.10
            [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 = '28' AND notas.idAsignaciones = '5' GROUP BY periodo ORDER BY periodo ASC;

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

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.30
            [fallas] => 16
            [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 = '28' AND notas.idAsignaciones = '6' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.60
            [fallas] => 0
            [habilita] => 0
        )

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

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

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

)

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 = '28' AND notas.idAsignaciones = '1' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.70
            [fallas] => 0
            [habilita] => 0
        )

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

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 5.00
            [fallas] => 36
            [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 = '28' AND notas.idAsignaciones = '114' 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 = '28' AND notas.idAsignaciones = '7' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.80
            [fallas] => 0
            [habilita] => 0
        )

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

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.10
            [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 = '2' AND notas.idAsignaciones = '2' 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] => 4.00
            [fallas] => 0
            [habilita] => 0
        )

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

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

)

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 = '2' AND notas.idAsignaciones = '3' 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] => 2.80
            [fallas] => 4
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.10
            [fallas] => 4
            [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 = '2' AND notas.idAsignaciones = '4' 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] => 28
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.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 = '2' AND notas.idAsignaciones = '5' 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.20
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.90
            [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 = '2' AND notas.idAsignaciones = '6' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.60
            [fallas] => 0
            [habilita] => 0
        )

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.30
            [fallas] => 8
            [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 = '2' AND notas.idAsignaciones = '1' 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.10
            [fallas] => 0
            [habilita] => 0
        )

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.90
            [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 = '2' AND notas.idAsignaciones = '114' 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 = '2' AND notas.idAsignaciones = '7' 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.80
            [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] => 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 = '25' AND notas.idAsignaciones = '2' GROUP BY periodo ORDER BY periodo ASC;

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

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

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

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

)

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 = '25' AND notas.idAsignaciones = '3' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 4.80
            [fallas] => 0
            [habilita] => 0
        )

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.60
            [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 = '25' AND notas.idAsignaciones = '4' 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.50
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 2.80
            [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 = '25' AND notas.idAsignaciones = '5' 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.00
            [fallas] => 4
            [habilita] => 0
        )

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 3.20
            [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 = '25' AND notas.idAsignaciones = '6' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.60
            [fallas] => 0
            [habilita] => 0
        )

    [1] => stdClass Object
        (
            [periodo] => 2
            [nota2] => 2.60
            [fallas] => 0
            [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 = '25' AND notas.idAsignaciones = '1' 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.90
            [fallas] => 0
            [habilita] => 0
        )

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.40
            [fallas] => 0
            [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 = '25' AND notas.idAsignaciones = '114' 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 = '25' AND notas.idAsignaciones = '7' 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.70
            [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 = '35' AND notas.idAsignaciones = '2' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 2.60
            [fallas] => 8
            [habilita] => 0
        )

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

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

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

)

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 = '35' AND notas.idAsignaciones = '3' 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] => 4.20
            [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] => 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 = '35' AND notas.idAsignaciones = '4' GROUP BY periodo ORDER BY periodo ASC;

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

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 3.40
            [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 = '35' AND notas.idAsignaciones = '5' GROUP BY periodo ORDER BY periodo ASC;

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

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

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 2.80
            [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 = '35' AND notas.idAsignaciones = '6' GROUP BY periodo ORDER BY periodo ASC;

Array
(
    [0] => stdClass Object
        (
            [periodo] => 1
            [nota2] => 1.60
            [fallas] => 0
            [habilita] => 0
        )

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

    [2] => stdClass Object
        (
            [periodo] => 3
            [nota2] => 4.00
            [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 = '35' AND notas.idAsignaciones = '1' 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] => 4
            [habilita] => 0
        )

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

    [3] => stdClass Object
        (
            [periodo] => 4
            [nota2] => 4.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 = '35' AND notas.idAsignaciones = '114' 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 = '35' AND notas.idAsignaciones = '7' 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.80
            [fallas] => 0
            [habilita] => 0
        )

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

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

)

xxxx 20
xxxx 20
xxxx 30
xxxx 30

	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: TRANSICION-A

Nro

Alumno

perez pepe perea

0.0

Barrera Castro Johana Nidia

4.0

3.7

3.6

3.3

2.9

3.6

0.0

3.6

Becerra Becerra Dayana Catalina

3.6

3.4

3.5

3.8

3.2

0.0

3.9

Cruz Ferrero Carolina Stefanía

3.6

3.5

3.4

3.3

3.2

3.6

0.0

3.7

Ferrer Galeano Paula Andrea

2.9

0.0

Joven Luis Eduardo

3.6

3.7

3.6

3.5

3.1

3.6

0.0

3.7

Mojica Camargo José Luis

3.7

3.5

3.2

3.6

2.9

4.1

0.0

3.0

Pérez Combariza Juan Carlos

3.9

3.7

3.9

3.6

3.3

3.1

0.0

3.8

Sanabria moreno Javier Steven

3.2

3.8

3.5

2.9

3.9

0.0

3.8

Zambrano Becerra Cecilia María

3.5

4.2

3.9

3.6

3.5

4.1

0.0

3.6

Total Perdidas

Promedio de Materia

3.2

2.97

2.85

2.79

2.56

2.92

2.91

Promedio General del Salon

2.53

Colegio de Pruebas y DemostraciónPara la Plataforma de Notas EduColombia

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