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 = '23' AND notas.idAsignaciones = '47'
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] => 4.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[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 = '23' AND notas.idAsignaciones = '48'
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] => 2.80
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 4
[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 = '23' AND notas.idAsignaciones = '39'
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.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '23' AND notas.idAsignaciones = '38'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 4
[nota2] => 2.60
[fallas] => 4
[habilita] => 0
)
)
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 = '23' AND notas.idAsignaciones = '41'
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.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 4
[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 = '23' AND notas.idAsignaciones = '42'
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] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 4
[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 = '23' AND notas.idAsignaciones = '40'
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] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[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 = '23' AND notas.idAsignaciones = '43'
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] => 2.90
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[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 = '23' AND notas.idAsignaciones = '49'
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.60
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[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 = '23' AND notas.idAsignaciones = '46'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[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 = '23' AND notas.idAsignaciones = '45'
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] => 2.80
[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] => 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 = '23' AND notas.idAsignaciones = '50'
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.00
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.00
[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 = '23' AND notas.idAsignaciones = '51'
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.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.00
[fallas] => 0
[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 = '23' AND notas.idAsignaciones = '44'
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.00
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[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 = '23' AND notas.idAsignaciones = '53'
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.00
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.00
[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 = '27' AND notas.idAsignaciones = '47'
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.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '27' AND notas.idAsignaciones = '48'
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.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[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 = '27' AND notas.idAsignaciones = '39'
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.60
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.00
[fallas] => 4
[habilita] => 4
)
)
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 = '27' AND notas.idAsignaciones = '38'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 4.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 = '27' AND notas.idAsignaciones = '41'
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] => 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 = '27' AND notas.idAsignaciones = '42'
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] => 3.10
[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 = '27' AND notas.idAsignaciones = '40'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[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 = '27' AND notas.idAsignaciones = '43'
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] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 4
[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 = '27' AND notas.idAsignaciones = '49'
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.00
[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 = '27' AND notas.idAsignaciones = '46'
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] => 4
[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 = '27' AND notas.idAsignaciones = '45'
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.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '27' AND notas.idAsignaciones = '50'
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] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '27' AND notas.idAsignaciones = '51'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[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] => 4
[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 = '27' AND notas.idAsignaciones = '44'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.90
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[fallas] => 4
[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 = '27' AND notas.idAsignaciones = '53'
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] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[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 = '83' AND notas.idAsignaciones = '47'
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.20
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.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 = '83' AND notas.idAsignaciones = '48'
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] => 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.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 = '83' AND notas.idAsignaciones = '39'
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] => 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 = '83' AND notas.idAsignaciones = '38'
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 = '83' AND notas.idAsignaciones = '41'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.00
[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.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 = '83' AND notas.idAsignaciones = '42'
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.80
[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] => 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 = '83' AND notas.idAsignaciones = '40'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.80
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.20
[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 = '83' AND notas.idAsignaciones = '43'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[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] => 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 = '83' AND notas.idAsignaciones = '49'
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.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 4
[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 = '83' AND notas.idAsignaciones = '46'
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.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.00
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[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 = '83' AND notas.idAsignaciones = '45'
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] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 8
[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 = '83' AND notas.idAsignaciones = '50'
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] => 8
[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 = '83' AND notas.idAsignaciones = '51'
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.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[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 = '83' AND notas.idAsignaciones = '44'
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.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[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 = '83' AND notas.idAsignaciones = '53'
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] => 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 = '31' AND notas.idAsignaciones = '47'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[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 = '31' AND notas.idAsignaciones = '48'
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.30
[fallas] => 8
[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 = '31' AND notas.idAsignaciones = '39'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.00
[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] => 8
[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 = '31' AND notas.idAsignaciones = '38'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 3.80
[fallas] => 1
[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 = '31' AND notas.idAsignaciones = '41'
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.60
[fallas] => 44
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.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 = '31' AND notas.idAsignaciones = '42'
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.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 4
[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 = '31' AND notas.idAsignaciones = '40'
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.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.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 = '31' AND notas.idAsignaciones = '43'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 0
[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 = '31' AND notas.idAsignaciones = '49'
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.50
[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] => 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 = '31' AND notas.idAsignaciones = '46'
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.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] => 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 = '31' AND notas.idAsignaciones = '45'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.30
[fallas] => 20
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 16
[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 = '31' AND notas.idAsignaciones = '50'
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.70
[fallas] => 12
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.60
[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 = '31' AND notas.idAsignaciones = '51'
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.20
[fallas] => 4
[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 = '31' AND notas.idAsignaciones = '44'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[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 = '31' AND notas.idAsignaciones = '53'
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.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[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 = '68' AND notas.idAsignaciones = '47'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.40
[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] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.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 = '68' AND notas.idAsignaciones = '48'
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] => 2.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[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 = '68' AND notas.idAsignaciones = '39'
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.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.10
[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 = '68' AND notas.idAsignaciones = '38'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.70
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.80
[fallas] => 80
[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 = '68' AND notas.idAsignaciones = '41'
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.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.10
[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 = '68' AND notas.idAsignaciones = '42'
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.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[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 = '68' AND notas.idAsignaciones = '40'
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] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.00
[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 = '68' AND notas.idAsignaciones = '43'
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] => 3.30
[fallas] => 4
[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 = '68' AND notas.idAsignaciones = '49'
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.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.10
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.80
[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 = '68' AND notas.idAsignaciones = '46'
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.10
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[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 = '68' AND notas.idAsignaciones = '45'
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.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '68' AND notas.idAsignaciones = '50'
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.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[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 = '68' AND notas.idAsignaciones = '51'
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] => 2.30
[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] => 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 = '68' AND notas.idAsignaciones = '44'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.70
[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 = '68' AND notas.idAsignaciones = '53'
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.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[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 = '84' AND notas.idAsignaciones = '47'
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] => 4.40
[fallas] => 12
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[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 = '84' AND notas.idAsignaciones = '48'
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.90
[fallas] => 16
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.80
[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 = '84' AND notas.idAsignaciones = '39'
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.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 16
[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 = '84' AND notas.idAsignaciones = '38'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 1.70
[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 = '84' AND notas.idAsignaciones = '41'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.00
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.10
[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 = '84' AND notas.idAsignaciones = '42'
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] => 4.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '84' AND notas.idAsignaciones = '40'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 12
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.00
[fallas] => 28
[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 = '84' AND notas.idAsignaciones = '43'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[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 = '84' AND notas.idAsignaciones = '49'
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.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] => 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 = '84' AND notas.idAsignaciones = '46'
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.80
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.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 = '84' AND notas.idAsignaciones = '45'
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.20
[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] => 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 = '84' AND notas.idAsignaciones = '50'
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.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.90
[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 = '84' AND notas.idAsignaciones = '51'
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] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 0
[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 = '84' AND notas.idAsignaciones = '44'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[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] => 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 = '84' AND notas.idAsignaciones = '53'
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.10
[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 = '26' AND notas.idAsignaciones = '47'
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] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 8
[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 = '26' AND notas.idAsignaciones = '48'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[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 = '26' AND notas.idAsignaciones = '39'
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] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[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 = '26' AND notas.idAsignaciones = '38'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 4.80
[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 = '26' AND notas.idAsignaciones = '41'
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.70
[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] => 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 = '26' AND notas.idAsignaciones = '42'
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.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.60
[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 = '26' AND notas.idAsignaciones = '40'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.00
[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 = '26' AND notas.idAsignaciones = '43'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[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 = '26' AND notas.idAsignaciones = '49'
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] => 2.80
[fallas] => 4
[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 = '26' AND notas.idAsignaciones = '46'
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.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] => 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 = '26' AND notas.idAsignaciones = '45'
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.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 12
[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 = '26' AND notas.idAsignaciones = '50'
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.60
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[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 = '26' AND notas.idAsignaciones = '51'
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.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 4
[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 = '26' AND notas.idAsignaciones = '44'
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.60
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 4
[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 = '26' AND notas.idAsignaciones = '53'
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.60
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[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 = '29' AND notas.idAsignaciones = '47'
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] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.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 = '29' AND notas.idAsignaciones = '48'
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.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[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 = '29' AND notas.idAsignaciones = '39'
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.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.90
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.10
[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 = '29' AND notas.idAsignaciones = '38'
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 = '29' AND notas.idAsignaciones = '41'
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] => 12
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.10
[fallas] => 4
[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 = '29' AND notas.idAsignaciones = '42'
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.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.10
[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 = '29' AND notas.idAsignaciones = '40'
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] => 2.90
[fallas] => 4
[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 = '29' AND notas.idAsignaciones = '43'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 6.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 = '29' AND notas.idAsignaciones = '49'
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.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.10
[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 = '29' AND notas.idAsignaciones = '46'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.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 = '29' AND notas.idAsignaciones = '45'
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] => 4.40
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[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 = '29' AND notas.idAsignaciones = '50'
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.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[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 = '29' AND notas.idAsignaciones = '51'
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] => 4.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[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 = '29' AND notas.idAsignaciones = '44'
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] => 2.90
[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 = '29' AND notas.idAsignaciones = '53'
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.10
[fallas] => 0
[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 = '30' AND notas.idAsignaciones = '47'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.80
[fallas] => 16
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 28
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.00
[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 = '30' AND notas.idAsignaciones = '48'
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] => 3.30
[fallas] => 20
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[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 = '30' AND notas.idAsignaciones = '39'
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.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[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 = '30' AND notas.idAsignaciones = '38'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '30' AND notas.idAsignaciones = '41'
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.20
[fallas] => 28
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '30' AND notas.idAsignaciones = '42'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 4
[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] => 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 = '30' AND notas.idAsignaciones = '40'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.90
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.20
[fallas] => 20
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.00
[fallas] => 40
[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 = '30' AND notas.idAsignaciones = '43'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[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] => 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 = '30' AND notas.idAsignaciones = '49'
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.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 8
[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 = '30' AND notas.idAsignaciones = '46'
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.80
[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] => 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 = '30' AND notas.idAsignaciones = '45'
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.50
[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] => 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 = '30' AND notas.idAsignaciones = '50'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.60
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[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 = '30' AND notas.idAsignaciones = '51'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.30
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.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 = '30' AND notas.idAsignaciones = '44'
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] => 4.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[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 = '30' AND notas.idAsignaciones = '53'
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] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.00
[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: UNDECIMO-A |
Nro |
Alumno | | | | | | | | | | | | | | | | | | | |
2 |
Guzman Adriana | | | 3.3 | | | 3.1 | | | | | | | | | | 3.1 | | | SI |
3 |
Limas Araujo Sandra Carolina | | | 3.2 | | | 4.3 | | | | | | | | | | 3.3 | | | SI |
4 |
Pérez González Janeth Patricia | | | 3.4 | | | 3.2 | | | | | | | | | | 3.3 | | | SI |
5 |
Pérez Solano Margarita | | | 3.8 | | | 3.7 | | | | | | | | | | 3.5 | | | SI |
6 |
Rincón Sánchez Daniel Esteban | | | 2.8 | | | 3.2 | | | | | | | | | | 3.0 | | | SI |
7 |
Silva Mora José Dario | | | 3.0 | | | 2.5 | | | | | | | | | | 3.0 | | | SI |
8 |
Tamayo Cerón Fabiola | | | 3.1 | | | 4.2 | | | | | | | | | | 3.5 | | | SI |
9 |
Torres Valbuena Pedro Dario | | | 3.4 | | | 3.1 | | | | | | | | | | 3.3 | | | SI |
10 |
Zabala Becerra Ninza Sofía | | | 4.0 | | | 3.2 | | | | | | | | | | 3.8 | | | SI |
Total Perdidas | 9 | 9 | | 9 | 9 | | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | | 9 | 9 | |
Promedio de Materia | 3.36 | 3.23 | | 3.4 | 3.33 | | 3.46 | 3.36 | 3.57 | 3.62 | 3.38 | 3.41 | 3.42 | 3.26 | 3.43 | | 3.62 | 3.58 | |
Promedio General del Salon | 3.43 |