select * from group_reviews a JOIN subjects b ON a.subject_id = b.id where b.name = 'Английский язык' delete from group_tests where group_id = 1 select * from student_results a JOIN group_tests b ON a.test_id = b.test_id where group_id = 1 delete from students where student_id = 16 OR student_id = 17 OR student_id = 20 OR student_id = 21 OR student_id = 16 OR student_id = 23 OR student_id = 33