SET @PERIOD_MIN = 141;
SET @PERIOD_MAX = 159;

	
	SELECT
		B.`结算期数` AS 期数,
		B.`会员编号`,
		B.`会员姓名`,
		B.`总奖金`
	FROM
		zr_bonus_vw B
		WHERE B.`结算期数`>= @PERIOD_MIN AND B.`结算期数` <= @PERIOD_MAX AND B.`总奖金` >= 1