$data = DB::select("
				SELECT * FROM (
				    SELECT * FROM (
				        SELECT M.id as message_id, M.customer_id, M.restaurant_id, M.message, M.created_at, C.name,
				        CASE
							WHEN DATEDIFF(UTC_TIMESTAMP,M.created_at) != 0 THEN CONCAT(DATEDIFF(UTC_TIMESTAMP,M.created_at) ,' d ago')
							WHEN HOUR(TIMEDIFF(UTC_TIMESTAMP,M.created_at)) != 0 THEN CONCAT(HOUR(TIMEDIFF(UTC_TIMESTAMP,M.created_at)) ,' h ago')
							WHEN MINUTE(TIMEDIFF(UTC_TIMESTAMP,M.created_at)) != 0 THEN CONCAT(MINUTE(TIMEDIFF(UTC_TIMESTAMP,M.created_at)) ,' m ago')
						ELSE
							CONCAT(SECOND(TIMEDIFF(UTC_TIMESTAMP,M.created_at)) ,' s ago')
						END as time_since
				   		FROM message M JOIN customer C ON C.id = M.customer_id
				        WHERE M.restaurant_id = $restaurant_id
				        )
				    AS chat ORDER BY chat.created_at DESC
				    )
				AS chat GROUP BY chat.customer_id
			ORDER BY created_at DESC
			");