SELECT e.`id`, e.`type`, e.`top`, e.`name`, e.`intro`, e.`mainphoto`, e.`viewcount`, e.`commentcount`,
						t.`sysname` "typesys", t.`name` "typename", c.`date`, c.`time`
						FROM `calendar` c
						INNER JOIN `event` e ON (c.`event` = e.`id`)
						INNER JOIN `event_type` t ON (e.`type` = t.`id`)
						WHERE e.`place` = 10
							AND c.`date` >= "2020-07-11"
							AND e.`show` = 1 AND e.`type` = 1
						GROUP BY c.`event`
						ORDER BY e.`top` DESC, c.`date` ASC, c.`event` DESC 

---------------------
172.69.63.190 11.07.2020 04:44:42  http://noch.bvf.ru/places/club/10/