INSERT INTO students_dnevnik (student_id, bel, math, physics, informatics, english)
    SELECT students.id,   
      (
          SELECT students_ratings.rating
          FROM students_ratings
		  WHERE students_ratings.student_id = students.id AND students_ratings.subject_id=1
      ),
      (
          SELECT students_ratings.rating
          FROM students_ratings
		  WHERE students_ratings.student_id = students.id AND students_ratings.subject_id=2
      ),
      (
          SELECT students_ratings.rating
          FROM students_ratings
		  WHERE students_ratings.student_id = students.id AND students_ratings.subject_id=3
      ),
      (
          SELECT students_ratings.rating
          FROM students_ratings
		  WHERE students_ratings.student_id = students.id AND students_ratings.subject_id=4
      ),
      (
          SELECT students_ratings.rating
          FROM students_ratings
		  WHERE students_ratings.student_id = students.id AND students_ratings.subject_id=5
      ) 
FROM students
ORDER BY id;