Stuff

		$threads = $site->db->query_read("
			SELECT bannerid, COUNT(bannerid) AS count, userid
			FROM bannerviews_temp
			GROUP BY bannerid
		");
		while ($bviews = $site->db->fetch_array($threads))
		{
			$vbulletin->db->query_write("INSERT IGNORE INTO bannerstats (bannerid, date, views)
				VALUES ('$bviews[bannerid]', CURDATE(), '$bviews[count]') ON DUPLICATE KEY UPDATE views=views+$bviews[count]");
		}