mysql example result

QUERY:
------------
SELECT
	DATE(sq1.ts) AS Date,
	HOUR(sq1.ts) AS Hour,
	sq1.value AS v1,
	sq2.value AS v2
FROM
	(
		SELECT
			ts,value
		FROM tbl
		WHERE
			ts>='2016-06-05 AND
			ptshour+3=tshour
	) AS sq1
LEFT JOIN
	(
		SELECT
			DATE_SUB(ts,INTERVAL 1 HOUR) as nts,
			value
		FROM tbl
		WHERE
			ts>=DATE_ADD('2016-06-05',INTERVAL 1 HOUR) AND
			ptshour+1=tshour
	) AS sq2
ON
	sq1.ts=sq2.nts;

RESULT:
+------------+------+-------+-------+
| Date       | Hour | v1    | v2    |
+------------+------+-------+-------+
| 2016-06-05 |    0 | 11.00 |  6.00 |
| 2016-06-05 |    1 | 10.00 | 22.00 |
| 2016-06-05 |    2 | 12.00 | 10.00 |
| 2016-06-05 |    3 | 18.00 | 27.00 |
| 2016-06-05 |    4 |  3.00 |  5.00 |
| 2016-06-05 |    5 | 19.00 | 24.00 |
| 2016-06-05 |    6 | 17.00 | 28.00 |
| 2016-06-05 |    7 | 15.00 | 16.00 |
| 2016-06-05 |    8 | 29.00 | 23.00 |
| 2016-06-05 |    9 |  2.00 | 15.00 |
| 2016-06-05 |   10 | 12.00 | 27.00 |
| 2016-06-05 |   11 | 12.00 |  3.00 |
| 2016-06-05 |   12 | 13.00 |  9.00 |
| 2016-06-05 |   13 | 25.00 |  4.00 |
| 2016-06-05 |   14 |  1.00 | -4.00 |
| 2016-06-05 |   15 | 10.00 | 26.00 |
| 2016-06-05 |   16 | 26.00 | 18.00 |
| 2016-06-05 |   17 | 28.00 |  7.00 |
| 2016-06-05 |   18 |  9.00 |  5.00 |
| 2016-06-05 |   19 |  7.00 |  5.00 |
| 2016-06-05 |   20 |  0.00 | 16.00 |
| 2016-06-05 |   21 | 13.00 | 25.00 |
| 2016-06-05 |   22 | 16.00 | 24.00 |
| 2016-06-05 |   23 |  3.00 |  NULL |
+------------+------+-------+-------+