Log in

		SELECT c.`id_guest`
		FROM `ps_connections` c
		LEFT JOIN `ps_connections_page` cp ON c.`id_connections` = cp.`id_connections`
		WHERE c.`id_guest` = 0
		AND DATE_ADD(cp.`time_start`, INTERVAL 30 MINUTE) > '2012-05-20 06:16:31'
		ORDER BY cp.`time_start` DESC