select * from (
	select *,
	  @num := if(@category = CUSTOMER_ID, @num + 1, 1) as row_number,
	  @category := CUSTOMER_ID as dummy
	from FE_LOYALTY_CUSTOMER_TIER order by CUSTOMER_ID, DT_END
  ) as v
  where row_number <= 2