SELECT dtp.`id`, dtp.`datetime`, dtp.`descr`, dtp.`photo`,
				s.`name` "street", s.`typename`, st.`name` "streettype"
				FROM `dtp` dtp
				INNER JOIN `k_street` s ON dtp.`street1` = s.`id` AND s.`town` = 36000001000
				INNER JOIN `streettype` st ON dtp.`streettype` = st.`id`
				WHERE dtp.`datetime` >= "2020-08-08 00:00" AND dtp.`datetime` <= "2020-08-09 23:59" AND dtp.`hour` >= 9 AND dtp.`hour` < 12
				GROUP BY dtp.`id` DESC  limit 10 

---------------------
54.237.183.249 25.09.2020 05:29:33  http://dtp36.ru/search.html?hour=09-12&dateStart=2020-08-08+00%3A00&dateEnd=2020-08-09+23%3A59