Yurii Medvedev

SELECT t.*,
       @sum := @sum + effect
FROM (
	SELECT *
	FROM `table`
	ORDER BY effect DESC
      ) AS t
      JOIN (SELECT @sum := 0) var
WHERE @sum < 100;