SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '21'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.29
[fallas] => 24
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '23'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 8
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.70
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '22'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.35
[fallas] => 24
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '25'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.70
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 12
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '26'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '24'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.93
[fallas] => 4
[habilita] => 4.8
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '27'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.10
[fallas] => 24
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '33'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.70
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 6.80
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '30'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.10
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '29'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 20
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 8
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.90
[fallas] => 12
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '31'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 8
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.20
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '34'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.40
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '35'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 6.80
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.90
[fallas] => 4
[habilita] => 4.5
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '28'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.50
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[fallas] => 16
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '37'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.40
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '18' AND notas.idAsignaciones = '118'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '21'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.30
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 12
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.29
[fallas] => 16
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '23'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 8
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '22'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '25'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '26'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '24'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.70
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.50
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[fallas] => 12
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '27'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.60
[fallas] => 20
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '33'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 16
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '30'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.40
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 12
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.80
[fallas] => 0
[habilita] => 3.8
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '29'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 8
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 20
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '31'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.80
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '34'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.00
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '35'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.00
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '28'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.50
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '37'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '8' AND notas.idAsignaciones = '118'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '21'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.20
[fallas] => 16
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.50
[fallas] => 16
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.29
[fallas] => 32
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '23'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 0.00
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 16
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '22'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 0.00
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 21.32
[fallas] => 12
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '25'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 3
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 3
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '26'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.20
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '24'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.01
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '27'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 16
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 16
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[fallas] => 20
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '33'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.60
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '30'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '29'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.00
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '31'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.90
[fallas] => 24
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '34'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '35'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '28'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 44
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.30
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '37'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '17' AND notas.idAsignaciones = '118'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '21'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 20
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.29
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '23'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.70
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '22'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.35
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '25'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 3
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '26'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.10
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '24'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.30
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.08
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '27'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.10
[fallas] => 20
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '33'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.30
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '30'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '29'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.30
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '31'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.80
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.50
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '34'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.10
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '35'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 8
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.00
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '28'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.10
[fallas] => 12
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '37'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '16' AND notas.idAsignaciones = '118'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '21'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.60
[fallas] => 16
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.50
[fallas] => 16
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 16
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '23'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 0.00
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '22'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 12
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '25'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '26'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.80
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.80
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '24'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.80
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.69
[fallas] => 16
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '27'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[fallas] => 20
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '33'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.80
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.80
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.30
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '30'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 16
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.80
[fallas] => 12
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.40
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '29'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '31'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.80
[fallas] => 4
[habilita] => 3.8
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '34'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.00
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '35'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '28'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '37'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '5' AND notas.idAsignaciones = '118'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '21'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.90
[fallas] => 20
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 20
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 1.50
[fallas] => 12
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 20
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '23'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.60
[fallas] => 25
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '22'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 20
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 5
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 21.32
[fallas] => 10
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '25'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.80
[fallas] => 6
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 6
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '26'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.00
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 6
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 12
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '24'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.61
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '27'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 35
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[fallas] => 35
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '33'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.00
[fallas] => 5
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '30'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 15
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '29'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.70
[fallas] => 16
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 8
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '31'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 5
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.80
[fallas] => 10
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 10
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '34'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.70
[fallas] => 5
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 10
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '35'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 20
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '28'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 7
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 7
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.70
[fallas] => 693
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '37'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 5
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '19' AND notas.idAsignaciones = '118'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '21'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 3
[nota2] => 2.50
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 4
[habilita] => 0
)
)
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '23'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 1.75
[fallas] => 3
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '22'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 2
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '25'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '26'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '24'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.16
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.86
[fallas] => 4
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '27'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '33'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '30'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '29'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '31'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '34'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '35'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '28'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '37'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '87' AND notas.idAsignaciones = '118'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '21'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 24
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 0.00
[fallas] => 12
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '23'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.90
[fallas] => 5
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[fallas] => 15
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 10
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '22'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.80
[fallas] => 5
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[fallas] => 15
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 21.32
[fallas] => 15
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '25'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.20
[fallas] => 18
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.20
[fallas] => 6
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 6
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '26'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.60
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 18
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '24'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.50
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 8
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.80
[fallas] => 24
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '27'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.90
[fallas] => 7
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 21
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[fallas] => 35
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '33'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.10
[fallas] => 20
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.50
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '30'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.40
[fallas] => 10
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 10
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '29'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.00
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 12
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '31'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 5
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[fallas] => 15
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.00
[fallas] => 5
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '34'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 10
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[fallas] => 15
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '35'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 5
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '28'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.50
[fallas] => 14
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.80
[fallas] => 7
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '37'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.60
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.20
[fallas] => 5
[habilita] => 0
)
)
xxxx 20
xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo,
MAX(notas2.nota) AS nota2,
SUM(notas2.fallas) AS fallas,
MAX(notas2.habilita) AS habilita
FROM notas
JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones
WHERE notas.idAlumno = '7' AND notas.idAsignaciones = '118'
GROUP BY periodo
ORDER BY periodo ASC;Array
(
)
|
Colegio de Pruebas y Demostración Para la Plataforma de Notas EduColombia
COLPRUEBAS |
|
Ciencia - Virtud - Disciplina Código Dane: 8000265844 - Resolucion: 987256 del 23 de Febrero de 2010 Calle 15 Nro 10 - 61 Cel: 312 328 97 79 - TelFax: 098 7627306 |
Promovido Final: 4 - Año: 2024 |
Salón: NOVENO-A |
Nro |
Alumno | | | | | | | | | | | | | | | | | | | |
1 |
CASTAÑEDA RINCON ADRIANA IVONEE | | | | 3.5 | | | | | | | | | | | 3.8 | | | | SI |
2 |
Contreras Uscategui Fabiola Esperanza | | | | 3.0 | | | | | | | | | | | 3.3 | | | | SI |
3 |
Duarte Becerra Constanza Ivonne | | | | 5.1 | | | | | | | | | | | 3.2 | | | | SI |
4 |
Fonseca Becerra Rocio Tatiana | | | | 2.7 | | | | | | | | | | | 2.6 | | | | SI |
5 |
González Corredor Zenaida María | | | | 2.7 | | | | | | | | | | | 3.5 | | | | SI |
6 |
Linares Pulido Carlos | | | | 5.3 | | | | | | | | | | | 3.3 | | | | SI |
7 |
Manosalva Ferrer Andrés Mauricio | | | | 2.4 | | | | | | | | | | | 0.0 | | | | SI |
8 |
Solano Vergara Carlos Hernan | | | | 5.6 | | | | | | | | | | | 3.4 | | | | SI |
Total Perdidas | 4 | 5 | 1 | | 1 | 2 | 1 | 0 | 1 | 1 | 0 | 2 | 2 | 2 | | 0 | 1 | 7 | |
Promedio de Materia | 2.73 | 2.94 | 5.18 | | 3 | 3.1 | 3.38 | 3.7 | 3.16 | 3.04 | 3.91 | 2.88 | 2.8 | 3.06 | | 3.89 | 3.29 | 0.44 | |
Promedio General del Salon | 3.16 |