Cacher is the code snippet organizer for pro developers

interviewee table
+----+---------------------+----+-------+
| id |      dateTime       |  value     |
+----+---------------------+----+-------+
|  1 | 2015-30-21 12:30:20 |   30       |
|  2 | 2015-30-21 12:30:21 |   30       |
|  3 | 2015-30-21 12:30:22 |   50       |
|  4 | 2015-30-21 12:30:23 |   50       |
|  5 | 2015-30-21 12:30:24 |   50       |
|  6 | 2015-30-21 12:30:26 |   50       |
|  7 | 2015-30-21 12:30:27 |   30       |
|  8 | 2015-30-21 12:30:51 |   50       |
+----+---------------------+----+-------+

interviewer table
+----+---------------------+----+-------+
| id |      dateTime       |  value     |
+----+---------------------+----+-------+
|  1 | 2015-30-21 12:30:26 |   30       |
|  2 | 2015-30-21 12:30:27 |   30       |
|  3 | 2015-30-21 12:30:28 |   50       |
|  4 | 2015-30-21 12:30:29 |   50       |
|  5 | 2015-30-21 12:30:30 |   50       |
|  6 | 2015-30-21 12:30:40 |   50       |
|  7 | 2015-30-21 12:30:50 |   30       |
|  8 | 2015-30-21 12:30:51 |   50       |
+----+---------------------+----+-------+

video table
+----+-----------+---------------------+---------------------+
| id |   name    |  start_time         |   end_time          |
+----+-----------+---------------------+---------------------+
|  1 | interview | 2015-30-21 12:30:27 | 2015-30-21 12:30:51 |
+----+-----------+---------------------+---------------------+

Expected results

interviewee table
+----+---------------------+----+-------+
| id |      dateTime       |  value     |
+----+---------------------+----+-------+
|  7 | 2015-30-21 12:30:27 |   30       |
|  8 | 2015-30-21 12:30:51 |   50       |
+----+---------------------+----+-------+

interviewer table
+----+---------------------+----+-------+
| id |      dateTime       |  value     |
+----+---------------------+----+-------+
|  2 | 2015-30-21 12:30:27 |   30       |
|  3 | 2015-30-21 12:30:28 |   50       |
|  4 | 2015-30-21 12:30:29 |   50       |
|  5 | 2015-30-21 12:30:30 |   50       |
|  6 | 2015-30-21 12:30:40 |   50       |
|  7 | 2015-30-21 12:30:50 |   30       |
|  8 | 2015-30-21 12:30:51 |   50       |
+----+---------------------+----+-------+