listing of marks for two trimesters, MySQL

Language: Layout:

DROP TABLE if exists evaluations_mark;
DROP TABLE if exists subject;
CREATE TABLE evaluations_mark (
  `mark_id` int(13) NOT NULL default 0,
  `note` varchar(225) NOT NULL,
  `comments` text,
  `subject_id` int(13) NOT NULL,
  `course_id` int(13) NOT NULL default 0,
  `user_id` int(13) NOT NULL default 0,
  `evaluation_id` int(13) NOT NULL default 0,
  `number_exam` int(2) NOT NULL default 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `subject` (
  `subject_id` int(6) auto_increment primary key,
  `name` varchar(50) NOT NULL,
  `course_id` int(6) NOT NULL default 0,
  `teacher_id` int(6) NOT NULL default 0,
  `load_type` varchar(20) NOT NULL default '' ,
  `hours` int(11) NOT NULL default 0,
  `area_id` int(2) NOT NULL default 0,
  `active` tinyint(1) NOT NULL default 0,
  `number_exam` int(6) NOT NULL default 4,
  `parent` int(5) NOT NULL default 0,
  `print_visible` tinyint(1) NOT NULL default 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO subject (name) VALUES 
('Lengua'),('Matematica'),('Ciencias Sociales'),('Ciencias Naturales'),('Italiano'),('Ingles');

INSERT INTO evaluations_mark (subject_id, note,number_exam) VALUES 
(1, 'SA',1),(2, 'SA',1),(3, 'MSA',1),(4, 'MSA',1),(5, 'MSA',1),(6, 'SA',1),
(1, 'SA',2),(2, 'SA',2),(3, 'SA',2),(4, 'MSA',2),(5, 'MSA',2),(6, 'MSA',2);
UPDATE evaluations_mark SET user_id = 28265;

select * from subject;
select * from evaluations_mark;

SELECT subject.name as subject, GROUP_CONCAT(evaluations_mark.note) as mark 
FROM evaluations_mark 
LEFT JOIN subject ON evaluations_mark.subject_id = subject.subject_id
WHERE evaluations_mark.number_exam IN (1,2) AND evaluations_mark.user_id = 28265
AND subject.print_visible='1' 
AND subject.number_exam = '4' 
GROUP BY evaluations_mark.subject_id


absolute service time: 0,38 sec