Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[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 = '3' AND notas.idAsignaciones = '12' 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 = '3' AND notas.idAsignaciones = '11' 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 = '3' AND notas.idAsignaciones = '8' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 4
[nota2] => 2.76
[fallas] => 6
[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 = '3' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 2
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
)
xxxx 20 SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '3' AND notas.idAsignaciones = '13' 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.30
[fallas] => 32
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.60
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.20
[fallas] => 20
[habilita] => 1.9
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '3' AND notas.idAsignaciones = '18' 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 = '3' AND notas.idAsignaciones = '16' 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 = '3' AND notas.idAsignaciones = '15' 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] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[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 = '3' AND notas.idAsignaciones = '17' 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] => 4.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[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 = '3' AND notas.idAsignaciones = '19' 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 = '3' AND notas.idAsignaciones = '14' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '6' AND notas.idAsignaciones = '10' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 16
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.90
[fallas] => 24
[habilita] => 3.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 = '6' AND notas.idAsignaciones = '12' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.60
[fallas] => 20
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.00
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '6' AND notas.idAsignaciones = '11' 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] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.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 = '6' AND notas.idAsignaciones = '8' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.60
[fallas] => 4
[habilita] => 3.6
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.33
[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 = '6' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.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 = '6' AND notas.idAsignaciones = '13' 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] => 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 = '6' AND notas.idAsignaciones = '18' 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.40
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[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 = '6' AND notas.idAsignaciones = '16' 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.40
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.90
[fallas] => 0
[habilita] => 3.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '6' AND notas.idAsignaciones = '15' 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.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 = '6' AND notas.idAsignaciones = '17' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.70
[fallas] => 20
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 20
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[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 = '6' AND notas.idAsignaciones = '19' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.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 = '6' AND notas.idAsignaciones = '14' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.90
[fallas] => 8
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.80
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[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 = '4' AND notas.idAsignaciones = '10' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 3.30
[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 = '4' AND notas.idAsignaciones = '12' 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 = '4' AND notas.idAsignaciones = '11' 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 = '4' AND notas.idAsignaciones = '8' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 3
[nota2] => 0.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 4
[nota2] => 3.02
[fallas] => 2
[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 = '4' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.60
[fallas] => 15
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.47
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[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 = '4' AND notas.idAsignaciones = '13' 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 = '4' AND notas.idAsignaciones = '18' 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 = '4' AND notas.idAsignaciones = '16' 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 = '4' AND notas.idAsignaciones = '15' 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] => 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.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 = '4' AND notas.idAsignaciones = '17' 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] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[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 = '4' AND notas.idAsignaciones = '19' 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 = '4' AND notas.idAsignaciones = '14' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 4
[nota2] => 3.90
[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 = '32' AND notas.idAsignaciones = '10' 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.30
[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] => 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 = '32' AND notas.idAsignaciones = '12' 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.90
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '32' AND notas.idAsignaciones = '11' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.70
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 4
[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 = '32' AND notas.idAsignaciones = '8' 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.50
[fallas] => 40
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.00
[fallas] => 40
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.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 = '32' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 44
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[fallas] => 0
[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 = '32' AND notas.idAsignaciones = '13' 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] => 4.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 = '32' AND notas.idAsignaciones = '18' 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] => 3.70
[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 = '32' AND notas.idAsignaciones = '16' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.30
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 0
[habilita] => 2.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '32' AND notas.idAsignaciones = '15' 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.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[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 = '32' AND notas.idAsignaciones = '17' 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] => 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.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 = '32' AND notas.idAsignaciones = '19' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.80
[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 = '32' AND notas.idAsignaciones = '14' 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.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.10
[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 = '12' AND notas.idAsignaciones = '10' 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.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.80
[fallas] => 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 = '12' AND notas.idAsignaciones = '12' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 16
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.30
[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 = '12' AND notas.idAsignaciones = '11' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.80
[fallas] => 16
[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] => 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 = '12' AND notas.idAsignaciones = '8' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.50
[fallas] => 20
[habilita] => 4
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.40
[fallas] => 32
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.28
[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 = '12' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 16
[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] => 1.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 = '12' AND notas.idAsignaciones = '13' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.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 = '12' AND notas.idAsignaciones = '18' 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.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '12' AND notas.idAsignaciones = '16' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.50
[fallas] => 12
[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] => 5.00
[fallas] => 4
[habilita] => 2.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '12' AND notas.idAsignaciones = '15' 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] => 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 = '12' AND notas.idAsignaciones = '17' 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.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 = '12' AND notas.idAsignaciones = '19' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[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 = '12' AND notas.idAsignaciones = '14' 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.50
[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 = '20' AND notas.idAsignaciones = '10' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.20
[fallas] => 12
[habilita] => 0
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '20' AND notas.idAsignaciones = '12' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.40
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '20' AND notas.idAsignaciones = '11' 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.40
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '20' AND notas.idAsignaciones = '8' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.20
[fallas] => 0
[habilita] => 3.2
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.60
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.19
[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 = '20' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.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 = '20' AND notas.idAsignaciones = '13' 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.30
[fallas] => 20
[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 = '20' AND notas.idAsignaciones = '18' 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.40
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 16
[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 = '20' AND notas.idAsignaciones = '16' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.20
[fallas] => 12
[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] => 5.00
[fallas] => 0
[habilita] => 2.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '20' AND notas.idAsignaciones = '15' 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] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.60
[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 = '20' AND notas.idAsignaciones = '17' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.10
[fallas] => 12
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.40
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[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 = '20' AND notas.idAsignaciones = '19' 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.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[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 = '20' AND notas.idAsignaciones = '14' 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] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.30
[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 = '21' AND notas.idAsignaciones = '10' 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.50
[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 = '21' AND notas.idAsignaciones = '12' 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] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '21' AND notas.idAsignaciones = '11' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.70
[fallas] => 12
[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.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 = '21' AND notas.idAsignaciones = '8' 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.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.75
[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 = '21' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.70
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[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 = '21' AND notas.idAsignaciones = '13' 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.30
[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 = '21' AND notas.idAsignaciones = '18' 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.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[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 = '21' AND notas.idAsignaciones = '16' 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] => 8
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 4
[habilita] => 2.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '21' AND notas.idAsignaciones = '15' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 24
[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.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 = '21' AND notas.idAsignaciones = '17' 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] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.80
[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 = '21' AND notas.idAsignaciones = '19' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.50
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.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 = '21' AND notas.idAsignaciones = '14' 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] => 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 = '22' AND notas.idAsignaciones = '10' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.60
[fallas] => 20
[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] => 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 = '22' AND notas.idAsignaciones = '12' 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.10
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '22' AND notas.idAsignaciones = '11' 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.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.30
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 4.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '22' AND notas.idAsignaciones = '8' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 24
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.30
[fallas] => 16
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 12
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.37
[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 = '22' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 28
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.80
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.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 = '22' AND notas.idAsignaciones = '13' 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.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[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 = '22' AND notas.idAsignaciones = '18' 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] => 12
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 0
[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 = '22' AND notas.idAsignaciones = '16' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.80
[fallas] => 16
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 0
[habilita] => 2.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '22' AND notas.idAsignaciones = '15' 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.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 12
[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 = '22' AND notas.idAsignaciones = '17' 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] => 3.80
[fallas] => 0
[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 = '22' AND notas.idAsignaciones = '19' 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.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.90
[fallas] => 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 = '22' AND notas.idAsignaciones = '14' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.70
[fallas] => 12
[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.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 = '11' AND notas.idAsignaciones = '10' 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.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.20
[fallas] => 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 = '11' AND notas.idAsignaciones = '12' 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] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '11' AND notas.idAsignaciones = '11' 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] => 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.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 = '11' AND notas.idAsignaciones = '8' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.10
[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] => 3.45
[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 = '11' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.60
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.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 = '11' AND notas.idAsignaciones = '13' 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.50
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '11' AND notas.idAsignaciones = '18' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.00
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[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 = '11' AND notas.idAsignaciones = '16' 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.50
[fallas] => 12
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 4
[habilita] => 2.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '11' AND notas.idAsignaciones = '15' 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] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.70
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.80
[fallas] => 20
[habilita] => 0
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '11' AND notas.idAsignaciones = '17' 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.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[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 = '11' AND notas.idAsignaciones = '19' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '11' AND notas.idAsignaciones = '14' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.80
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 2.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.40
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '10' AND notas.idAsignaciones = '10' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.70
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[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] => 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 = '10' AND notas.idAsignaciones = '12' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 3.40
[fallas] => 36
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.10
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.40
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '10' AND notas.idAsignaciones = '11' 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.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 6.80
[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 = '10' AND notas.idAsignaciones = '8' 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] => 6.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.25
[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 = '10' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 1.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 = '10' AND notas.idAsignaciones = '13' 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.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 0
[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 = '10' AND notas.idAsignaciones = '18' 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.00
[fallas] => 28
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 12
[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 = '10' AND notas.idAsignaciones = '16' 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.10
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 0
[habilita] => 2.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '10' AND notas.idAsignaciones = '15' 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.40
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 16
[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 = '10' AND notas.idAsignaciones = '17' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.70
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.00
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 2.90
[fallas] => 8
[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 = '10' AND notas.idAsignaciones = '19' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.50
[fallas] => 0
[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 = '10' AND notas.idAsignaciones = '14' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 4.80
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.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 = '13' AND notas.idAsignaciones = '10' 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.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 = '13' AND notas.idAsignaciones = '12' 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] => 4.20
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.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 = '13' AND notas.idAsignaciones = '11' 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] => 4.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[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 = '13' AND notas.idAsignaciones = '8' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.90
[fallas] => 36
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.00
[fallas] => 8
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 4
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 2.89
[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 = '13' AND notas.idAsignaciones = '9' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 4
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[fallas] => 4
[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 = '13' AND notas.idAsignaciones = '13' 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.20
[fallas] => 4
[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 = '13' AND notas.idAsignaciones = '18' 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.50
[fallas] => 8
[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 = '13' AND notas.idAsignaciones = '16' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 2.70
[fallas] => 32
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 3.80
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 16
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 5.00
[fallas] => 0
[habilita] => 2.9499
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '13' AND notas.idAsignaciones = '15' 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.30
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.20
[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 = '13' AND notas.idAsignaciones = '17' 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] => 4
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 3.50
[fallas] => 12
[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 = '13' AND notas.idAsignaciones = '19' GROUP BY periodo ORDER BY periodo ASC;
Array
(
[0] => stdClass Object
(
[periodo] => 1
[nota2] => 5.00
[fallas] => 0
[habilita] => 0
)
[1] => stdClass Object
(
[periodo] => 2
[nota2] => 4.50
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.20
[fallas] => 0
[habilita] => 0
)
[3] => stdClass Object
(
[periodo] => 4
[nota2] => 3.20
[fallas] => 0
[habilita] => 0
)
)
xxxx 20 xxxx 20
xxxx 30
xxxx 30
SELECT notas2.periodo AS periodo, MAX(notas2.nota) AS nota2, SUM(notas2.fallas) AS fallas, MAX(notas2.habilita) AS habilita FROM notas JOIN notas AS notas2 ON notas.idAlumno = notas2.idAlumno AND notas.idAsignaciones = notas2.idAsignaciones WHERE notas.idAlumno = '13' AND notas.idAsignaciones = '14' 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.90
[fallas] => 0
[habilita] => 0
)
[2] => stdClass Object
(
[periodo] => 3
[nota2] => 4.00
[fallas] => 4
[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
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: QUINTO-A |
| Nro | Alumno | ||||||||||||||||||||||||||
| 1 | ALVARES SUA BERTHA PATRICIA |
|
| 2.5 |
|
|
|
|
|
|
|
|
|
| NO | ||||||||||||
| 2 | Becerra Becerra Carlos Andrés |
|
| 3.2 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 3 | Castaño Moreno Carlos Alberto |
|
| 1.7 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 4 | Corredor García Claudia Patricia |
|
| 3.0 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 5 | Cortes Tamayo Amparo Cecilia |
|
| 3.5 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 6 | Diaz Avendaño Fany del Carmen |
|
| 3.6 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 7 | Figueroa Torres Sofía Tatiana |
|
| 3.1 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 8 | Figueroa Torres Sofía Tatiana |
|
| 3.1 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 9 | García Fonseca María Antonia |
|
| 3.3 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 10 | Gómez Archila Juan Carlos |
|
| 3.5 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| 11 | Muñoz Sandoval José Anibal |
|
| 3.4 |
|
|
|
|
|
|
|
|
|
| SI | ||||||||||||
| Total Perdidas | 0 | 3 | 2 | 1 | 6 | 2 | 2 | 1 | 0 | 1 | 2 | 1 | |||||||||||||||
| Promedio de Materia | 3.48 | 2.63 | 3.09 | 3.25 | 2.73 | 3.24 | 2.78 | 3.78 | 3.33 | 3.36 | 3.04 | 3.52 | |||||||||||||||
| Promedio General del Salon | 3.19 | ||||||||||||||||||||||||||